Oracle

Since last week, a problem occurred in the Oracle database on the server. In less than half a day, the maxsession (150) problem will be reported. It must be because the maximum number of database sessions has exceeded.Because the server runs a file

Migrate the OCR and VOTEDISK environments in 11g Rac: OEL + oracle rac 11.2.0.3 migration Description: migrate ocr and votedisk from + DATE to + OCR_VOTE. The operation is as follows: [root@ora2 ~]$ /u01/app/11.2.0/grid/bin/ocrcheckStatus of Oracle

Oracle PLSQL uses the while LOOP instance program in the cursor Oracle PLSQL uses the while LOOP instance program in the cursor DeclareCursor emp_cur is select * from emp;V_emp emp % rowType;BeginOpen emp_cur;While emp_cur % notfound -- while

How to transfer the ORACLE database tutorial file to another machine Due to insufficient space caused by video data restoration, some data files need to be transferred to other hard disks. In reference Network Information, combined with their own

Oracle Auto-increment column creation method favorites Oracle does not have the auto-increment field function, but it can be implemented through trigger and sequence. Create a test table first: Create table userlogin( Id number (6) not null, Name

This article introduces the usage of different subquery brackets in oracle for 9i and 10g and 11g. if you need this, refer to the following. There is such a view, probably as follows: This view can only be compiled successfully in 10g and 11g

This article analyzes the ORA-01031 error caused by SYS Local login or remote login, but also provides a ORA-01031 error solution, have encountered the same problem of friends can refer to the solution. if the database instance is installed on

In the help of imp: SHOW just list file contents (N). The default value is N. The Code is as follows: Copy code In the help of imp: SHOW just list file contents (N). The default value is N.The following experiment explains

For more information about the ASM disk data loss caused by fdisk in oracle, see. 11.2.0.3 the database crashed due to damage to the asm disk header block and encountered an incorrect ORA-15196.More detailed error: ORA-15196: invalid ASM block

If you grant DBA permissions directly when creating A user, you can directly query user A's table in user B. However, when creating A view, no permissions are reported, in this case, you need to authorize user B to access the table in user. When

Using a cursor in Oracle, I think this method is absolutely safe. -- first, set a cursor to store some data that needs to be used in the cursor, and then use the traversal cursor to update it. Use name of cascading update: The Code is as

The data warehouse has encountered several problems recently, which are summarized as follows. 1. Migration from mysql to oracle. This is a complicated problem, because we have no plans to invest in an ETL tool such as datastage, so at first I

Check the awr report and record the index failure caused by implicit conversion. In awr, statements consume more than 40 million logical reads. Variables are tested quickly. SQL a.order_prod_amount, b.prod_cost_price user_sess a, PR_DO_T b a.prod_

The project requires special handling of military ID card, as long as the digit. I wanted to use a regular expression, but oracle9i does not support regular expressions. Later, we found that translate can implement functions. Translate (string,

SQL _TRACE/10046 events are a method provided by Oracle for SQL tracking. It is a very common method in daily database problem diagnosis and solution. However, the trace file generated by tkprof requires the tkprof tool to generate a format that can

  [Terry Note] backup http://www.cnblogs.com/kkterry/p/3308405.html for RMAN Integrated Learning [Terry Notes] recovery http://www.cnblogs.com/kkterry/p/3308407.html for RMAN Integrated Learning [Terry Note] configuration

An alarm is reported in the RMAN backup log. The log file directory is as follows: [Root @ erpdbs rmanback] # llTotal 88-Rw-r -- 1 oraprod dba 81011 Sep 7 rmanback. log-Rwxr -- r -- 1 oraprod dba 2581 Jun 24 2011 rmanback. sh[Root @ erpdbs rmanback]

1. UPDATE nowait: query a piece of data and enable database transactions for it. If no lock is applied to the current data, the system returns the correct result and locks the current data. If the queried data is already in the transaction, the

Uninstalling an Oracle database is not as simple as deleting other software. Especially for new employees, when the database is deleted and re-installed, it is often re-installed, some inexplicable errors will be reported, or the installation will

In Oracle, multiple databases can be configured, and only one listener can be enabled. for multiple databases, you only need to configure the corresponding service name to connect. I use Oracle 8.1.7 Enterprise Edition and the OS is a Windows 2000