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

Oracle Database Installation Error highlights: ◆ 1. If you cannot run./runInstaller and the error x11 is prompted, use root to enter the following command # xhost + ◆ 2. If you enter the dbca command, the interface disappears inexplicably In the

1. If no backup is available: In this case, data may be lost. In this case, you should export the data and review the data in the table for import to restore the damaged data in the data block as much as possible, however, export is not allowed when

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

MSC + FailSafe dual-host cluster HA SummaryI have recently implemented an Oracle HA application solution. I will summarize it for your reference.　　Hardware configuration:Two Lenovo 82550-wide T630 servers (standard, each server has two intel

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

Java code1. NVL FunctionThe NVL function format is as follows: NVL (expr1, expr2)If the first oracle parameter is null, the value of the second parameter is displayed. If the value of the first parameter is not empty, the original value of the first

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 are two methods to transfer the backup set on ASM to the file system. Method 1: Using rman and rman is a good tool. It is not only a backup function, but also a waste if you only use rman for backup. You can use the backup backupset in rman to

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

Oracle audit table AUD $ processing method Oracle version: 11.2.0, other versions should test whether DBMS_AUDIT_MGMT is successful 1. query the table, and then truncate select count(*) from aud$; truncate table aud$; select count(*)

ORA-01033: ORACLE initialization or shutdown in progress two solutions symptom 1: sysdba can log on, but in use it appears "database not open, allow queries only in a fixed table/view, while normal users cannot log on to use, an error occurs in ORA-0

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

In the Oracle RAC environment, the v $ log v $ logfile can query the information of the connected instance in the Oracle RAC environment, the gv $ view contains information about all instances. However, in the RAC environment, when we query the v $

To quickly find the trc files generated by tracking other sessions, the most fundamental technology is to understand the path where the session tracking files are stored and the naming rules for generating the tracking files. Otherwise, in a

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

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

Company requirement knowledge self-taught-functions and usage of Oracle Package simplify application design, improve application performance, implement information hiding, and overload subroutines. 1. Does Oracle Package play a role (benefit) in

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