Oracle

Oracle automatic backup method:   @ Echo offSetlocalSet SID =? // Modify the SID value based on the actual situationSet username =? // Assign values based on actual conditionsSet Password =? // Assign values based on actual conditionsSet bakdir =?

1. A large number of redo records are generated for the insert operation of the Permanent Table, but almost no redo is generated for the temporary table. This makes sense. insert on a temporary table will only generate a small amount of Undo data,

Before Oracle 10 Gb, we ignored the order by clause by using the implicit sorting required in some special SQL statements, so we should be careful in 10 Gb. For example, in earlier versions, when distinct, union, and group by were used, Oracle had

Myeclipse 6.0 and Oracle 10g have the following problems during connection. Java. SQL. sqlexception: ORA-00604: Error occurred at recursive SQL Level 1ORA-12705: cannot access NLS data files or invalid environment specified At first, I thought it

This article starts with the definitionOracleDatabaseHow to fully understand character sets. What is the Oracle character set? The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different

1,StartDatabase: Oracle @ Suse92: ~> Sqlplus/nolog SQL * Plus: Release 9.2.0.4.0-production on Fri Jan 20 02:29:37 2006 copyright (c) 1982,200 2, Oracle Corporation. All Rights Reserved. SQL> connect/As sysdbaconnected to an idle instance. SQL>

8. Use the decode function to reduce processing timeYou can use the decode function to avoid repeated scan of the same record or join the same table.For example:Select count (*), sum (SAL) from EMP where dept_no = 0020 and ename like 'Smith %

13. Calculate the number of recordsIn contrast, count (*) is slightly faster than count (1). Of course, if you can search by index, the index column count is still the fastest. For example, count (empno)According to the author's suggestion: In the

To install Oracle 11g in Ubuntu 10.04, follow these steps:1. Install JDK. For the installation method, see setting up a Sun Java Development Environment under Ubuntu 10.04.To solve Chinese garbled characters, create the "fallback" directory in the

After I upgrade a 9206 to 1020, I cannot connect to the client using the OEM, but sqlplus can be used to connect. Why? The error message is: You must have select any dictionary permission to run this application. Ask the DBA to grant this permission

SQL> select * from users; NAME value ID-------------------T1 A 1T2 B 2T3 C 3T4 D 4   -- Implement the combination of values in the value column   SQL> select Replace (sys_connect_by_path (value, '#'), '#') combo2 from users3 where level = 24 connect

Blocking often occurs in Oracle. In this case, we need to quickly find out the cause of blocking and eliminate it as soon as possible so that the system can run normally again. The following uses a deadlock as an example to find out how to locate

Today I went to the Development Forum and turned around. I saw a post where everyone was discussing multiplication enthusiastically. Remember that when I learned C ++, the most basic question was to output a penalty phrase on the screen. It was

SQL> conn system/OracleConnected.SQL> Create Table Scott. T1 (ID number primary key, name varchar2 (10); -- create a test table Table created. SQL> select constraint_name, table_name, constraint_type, -- view the status of the corresponding

Rollup is an extension of the Group by clause. It can return subtotal records for each group and total records for all groups. Cube is an extension of the Group by clause. It returns the subtotal record of each column combination and adds a total

If you cannot use a function in DBA, you can use sys. Public Virtual User: Permission 1 and permission 2 are available to the public in the test environment, but copying the entire environment to the real environment means that the program cannot

When analyzing application performance problems, we need to pay more attention to the execution of SQL statements, because the performance bottleneck of applications is usually on the database side, therefore, Database SQL statements are the focus

This is the SQL solution of zookeeper. Http://blog.csdn.net/happyflystone/archive/2009/01/17/3819863.aspx   Reference requirements   Today, I chatted with Liang Weng in the group. The little guy suddenly threw out an interesting question, that is,

1. Start the listener: LSNRCTL start2. Start a database instance:Sqlplus/nologConn/As sysdbaStartup -- followed by the database instance name ---------- Use dbstart and dbshut to start and close database instances ------------1. Enter the bin in

DatabaseIt stores a large amount of data, and uses like when querying, the speed is obviously slow. When I was working on a project, I found that I could use the instr function to replace the like function. 1.% A % method:Select * From pub_yh_bm