Database Administrator

When a table needs to be flashed back to a long time ago, the following error is reported (the black font is a variable, which may be different each time) ORA-0155: Snapshot old: rollback field number10(Name: "_ SYSSMU10$ ")Too small Solution:

Oracle processes can be divided into three types. User Process, Server Process, and Background Process. User Process runs on the client and is not on the database server. Of course, if you run the client on the server, it runs on the server. For

Card refers to the number of rows processed in this step in the plan; cost refers to the resources consumed by this step in cbo, and this value is relative value; bytes refers to the number of bytes of all records processed in this step in cbo. It

1. master database check and settings Assume that the new service is named ORCL_TAF.LK. SQL> exec dbms_service.create_service (service_name => 'orcl _ TAF. LK ', network_name => 'orcl _ TAF. LK ');SQL> exec dbms_service.start_service (service_name =>

, A, B, and C collections are correlated. The number is the value of document. For more information about DBref, see this article. Create A collection first. > Var a = {value:"1"} > Var B = {value:"2"} > Var c = {value:"9"} > Var d = {value:"10

Outgoing cursor process: Create or replace procedure pub_mes2erpauto_cur_kt (I _flag in varchar2,Res out varchar2,O_cur out sys_refcursor) IsV_class varchar2 (20 );V_classstr varchar2 (100 );V_mmark varchar2 (20 );V_mmarkstr varchar2 (100 );V_mtype

There are two methods to create a database in Oracle. The first is to use Oracle database builder and DBCA, which is a graphical interface and easy to understand because of its friendly and beautiful interface and complete prompts. In Windows, this

1. Create a crontab for an Oracle userSu-root Crontab-u oracle-l*/5 */home/oracle/oracle_backup.sh(This shell file is executed every five minutes. This is a convenient test. You can modify the time for the test .) 2. Create a shell

When the database instance is too large, the Oracle_SID displayed every time the export is not frequently used. It would be nice to make the default customization. Now I will explain how to define it in the Linux environment: 1. su-oracle 2.

The database is Oracle 9i 1. Export a csv file This is very simple. You can use the pl/SQL tool. First, select the table to be exported, right-click Query data, and in the window that appears on the left, select Export Query Restls and select the

Join query category in SQL2 (1) Cartesian product | cross join: unconditional join. The result is the product of the number of two link element groups. [From] cross join (2) Natural join: equivalent join based on all public attributes. The result

[1] Remove the statements in the script including commit, "setserverout off", "set serverout on", "set escape on", and "exec ". [2] Remove "/" [3] it is best to use "separator" + "line feed" for statement separators, for example: ALTER

The test Department reported that the Intranet 1.105Oracle database service could not be started, or opened the alter _ . log file in a regular manner to view the log Content: Fri Nov 11 11:46:09 2011Errors in

Oracle 10 Gb provides a new performance collection and analysis tool awr (automaticworkload repository ). Awr exists in the sysaux tablespace and is one of the main users of sysaux. Snapshot, a set of performance statistics captured at a specific

During application development, it is common to sort data according to certain rules and then retrieve the first few data records. In Oracle, order by is commonly used to obtain data smaller than rownum. However, if you are not familiar with Oracle,

The imp command is executed at the dos prompt.Run the command directly after cmd instead of in SQL. Data export:1. Export the database TEST completely, and the username system Password manager is exported to D: daochu. dmp.Exp system/manager @

I. system environment: CentOS 1, 5.5 Host (MASTER): 192.168.0.10 SLAVE (SLAVE): 192.168.0.20 Install Mysql in yum on slave # Yum install-y mysql-server Do not enable the mysql service. Copy the/etc/my. cnf file on the master to the/etc directory on

Question: Today, I receive a set of Database JOB exception alerts on the monitoring system. Here I will record the solution process and share it with you! Alert Log: Tue Dec 13 04:00:03 2011Errors in file/opt/Oracle/diag/rdbms/ndmcb/trace/ndmcb_j000_

1. Download tuxedo software tuxedo81_linux.bin. This software was initially installed on CentOS 5.5. Click here to enter the registration required for download. 1. Create a tuxedo user as the root user and log in as the tuxedo user. This user will

// Create a temporary tablespace Create TemporaryTablespace test_temp Tempfile'E:/Oracle/product/10.2.0/oradata/testserver/test_temp01.dbf' Size32 m AutoextendOn Next32 m maxsize 2048 m Extent managementLocal; // Create a data table