Oracle

Oracle Archive Log configuration query Archive Log is a non-active redo Log backup. archive logs can be used to keep all redo history records. When the database is in ARCHIVELOG mode and the log is switched, the background process ARCH will save the

When the following prompt appears in Oracle: A ora-01034: oracle not available Ora-27101: shared mermory realm does not exist It can be solved in this way; Method 1: 1. Input: connect/as sysdba; 2. restart the computer; Method 2: Enter C:>

201./* + NOCACHE (TABLE )*/When a full table scan is performed, the CACHE prompts that the retrieval block of the table can be placed in the nearest least recently used LRU list in the buffer CACHE.For example:SELECT/* + FULL (BSEMPMS) NOCAHE

Many of my friends only use oracle to delete the system. However, in many cases, he may find that the next installation page disappears when the system is re-installed, and he may have to reinstall the system, in fact, this is not the case if your

  Oracle MapViewer runs as a JavaEE application in the JavaEE container. There are multiple ways to install and deploy Oracle MapViewer In The Complete Oracle Fusion middleware environment or an independent version of the Solaris. The deployment of

  The content of this lecture mainly includes: 1. segment shrinkage and table space usage monitoring 2. Perform segment contraction and roll back the high-water line 3. Set session suspension due to space problems 4. Transfer tablespace I. segment

In oracle, Number is divided into two types: 1. Number 2. Number)The first type corresponds to the integer int long short byte in java.The second method corresponds to the floating point float double in java.The date in oracle corresponds to java.

There is a new feature in 11G. When the table has no data, no segment is allocated to save space. Solution: 1. insert a row and then roll back to generate a segment. This method inserts data into an empty table and then deletes it, resulting in a

The error in the previous requirement document resulted in the fact that the originally three-digit number was not fixed, and later it was found that the requirement document had mistaken the requirement. The pure number in this field must be three

In ORACLE, the context sys_context is used for the creation of sys_context and the system on which the application is recently used. Therefore, I searched the internet and wrote it down for emergency purposes. First, what is context? I think it is a

Physical Standby Database Failover1. When physical standby failover switches to failover, the production database must be moved to the DR site for unplanned events that occur when some bad events occur. Interestingly, at this time people are usually

Oracle Basic Data Query SELECT * FROM MERs WHERE customer_id not in (2, 3, 4, NULL); SELECT * FROM customers WHERE customer_id BETWEEN 1 AND 4; SELECT * FROM customers WHERE customer_id not between 1 AND 4; -- NAN indicates that it is not a number

Use AWR to view the SQL Execution Plan. Find the problematic SQL statement in AWR and want to know the specific execution plan of the SQL statement, so I used the SQL id obtained in the AWR report to query several dynamic performance views such as V

Rman catalog configuration brief note Server Configuration: [sql] SQL> create tablespace tbs_rman datafile 'H:\oradata\test\tbs_rman.dbf' size 20m autoextend on; Tablespace created SQL> create user rman identified by oracle default

Oracle SQL advanced programming learning notes (I) SQL Execution theory 1. Shared Pool SGA1, each SQL statement executed contains parsed content in the shared pool, these statements are stored in the library cache ). no matter how many users want to

USING Auotomatic Shared Memory Management has learned about amm some time ago. Today I want to learn about ASMM. When asmm is started, it is very simple to set the sga_target parameter. If asmm is set, the sga, such as buffer cache, large pool, java

Terminate the running of imp/exp and expdp/impdp processes method 1. Stop the EXP/IMP optimization speed to directly KILL the process, but first KILL the parent process and then KILL the child process, only KILL sub-processes, EXP/IMP will also

Oracle bad block repairs: one or more data blocks in the Oracle database (the capacity of a data block is specified by the db_block_size parameter when the database is created, the default value is 8 KB. Because normal data blocks have fixed valid

How to restore the damaged undo tablespace (1) when the database is running in non-archive mode, it is normally disabled when the database is shut down. The undo tablespace is corrupted when the database is opened. The information is as

ORA-01555 Principle Analysis SQL> create undo tablespace undotbs1 datafile '/opt/app/oracle/RHYS/undotbs1.dbf' size 30 M; Tablespace created. SQL> alter system set undo_tablespace = undotbs1; System altered. SQL> select. usn,. status, B. name from v