Oracle

Tkprof is an executable tool used to analyze Oracle trace files and generate clearer and more reasonable output results. This article describes the use of Tkprof from the following aspects.1. Set the parameter fileSet the three parameters

  Installation Process 1. hardware resources: Brief description: The system memory should be larger than 1 GB, And the swap space should be at least GB, which is twice the physical memory, and the temporary space should be larger than MB. (The

  1. Preparation Our first step is preparing the box for our test replication. I am using a VMWare virtual server for my tests. Install linux x64 on your box. I used Linux Centos 5.3. The hostname for our source box will be db1. Install the Oracle

  Oracle RMAN-based backup methods can be divided into catalog and nocatalog Backup management. The catalog method requires a catalog directory database, which runs on another server. This method can be used in environments where you have multiple

This section describes common Oracle Database Constraint restrictions and Exception Handling. Next, let's take a look at this part.1. Report constraints exceptionIf an exception exists during validation constraints, an error is returned and the

The db_buffer_pool of oracle consists of three parts:Buffer_pool_defualtBuffer_pool_keepBuffer_pool_recycleIf you want to pin the table to the memory, that is, pin the table to the keep area.Related commands:Alter table... storage (buffer_pool keep )

1. view the maximum number of Oracle cursorsC: \ Documents ents and Settings \ Administrator> sqlplus "sys/admin @ test151 as sysdba" (sys logs on to the test151 service as dba)SQL * Plus: Release 9.2.0.1.0-Production on Thursday November 5 09:08:04

Emca-repos create creates an EM Database Emca-repos recreate re-creates an EM Database Emca-repos drop delete an EM Database Emca-config dbcontrol db ConfigurationDatabaseDatabase Control Emca-deconfig dbcontrol db deletes the Database Control

The ORACLE database is divided into logical regions called tablespaces-forming the logical structure of the ORACLE database. One ORACLE database can have one or more tablespaces, while one tablespace corresponds to one or more physical database

Oracle-Incomplete recovery steps Incomplete recovery can be divided into user Incomplete recovery and RMAN Incomplete recovery. If online redo log files or archived log files are lost, incomplete restoration is allowed. 1. Incomplete recovery

How to Improve SQL Execution efficiency in Oracle --> when the FROM clause contains multiple tables, select the table with the least number of records as the base table --> the WHERE clause is parsed to have a bottom-up filtering condition in order -

ORA-00600: [kck_rls_check must use (11,0, 0) or lower] A friend asked me on QQ, said his database pfile and spfile are gone. I asked him whether the database was 10 Gb or 11 GB. He said 11 GB, so I asked him to use this syntax to create spfile: SQL>

Data Tables move from one tablespace to another. Data Tables move from one tablespace to another. 1) alter table [table_name] move tablespace [new tablespace]; move the LOB Field 2) alter table [table_name] move lob ([lobsegment_name]) store as

Perform full backup for recovery of the dg slave database: RMAN> run{ allocate channel a1 type disk; backup full database include current controlfile for standby plus archivelog ; release channel a1; } rman target sys/oracle@orcl auxiliary /

Small error caused by careless ORA-16179 ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE Oracle many parameters are in the form of parameter = 'value' while the value of log_archive_dest_1 is inside with 'location =

The reason why oracle job is not executed is that it wants to execute a stored procedure in the package in the test environment that day, so a job was created, but the job was not executed for half a day. The final reason is a bit low, but some

[Oracle] Data Guard series (5)-create a logical standby database 1. stop the log application service [SQL] SYS @ jkka> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; Database altered on the physical STANDBY DATABASE. 2. reset the master

Use the Oracle regular expression to select the sequence number in data entries. Abstract: Use the Oracle regular expression to select the sequence number in data entries for the latest project. In the seven-digit string, select the sequence number

ORACLE simple function (TWO) 1) date function: 1) sysdate function: This function uses the time zone of the database and returns the date value: eg: [SQL] SYS @ orcl # select sysdate from dual; SYSDATE -------------- 08-4 month-13 SYS @ orcl #2)

Query, create, and expand the tablespace & impdp ---- the key to the successful import of the tablespace by schemas is: the size of the tablespace In the imported environment and the source data environment, and the tablespace name, which must be