Oracle DBA Blog

when we try to explan plan, we get the below error, this is becauae the plan table is corrupted drop and recreate the plan table. SQL...

Solution: 1. For few leaks size: Ignore this ORA-600 [723] as it is more of a housekeeping message and is not really a cause for concern....

PURPOSE: This article discusses the internal error "ORA-600 [723]", what it means and possible actions. The information here ...

http://www.orafaq.com/node/1936 "dbms_redefinition" SQL> create table TABLE1 ( 2 no number, 3 name varchar2(20) default ...

The listener.log file grows and it’s not possible to just move the file whilst the listener is up.    The tnslsnr process always holds thi...

create user adlfga identified by adlfga; grant resource,connect to adlfga; BEGIN DBMS_FGA.ADD_POLICY(      object_schema => 'AE0...

Checking the opatch utility version: $ cd $ORACLE_HOME/OPatch $ opatch lsinventory Invoking OPatch 10.2.0.4.3 Oracle Interim Patch I...

http://www.oracle.com/technetwork/database/upgrade/best-practices-for-upgrading-11gr2-174946.pdf

Oracle Parser It performs syntax analysis as well as semantic analysis of SQL statements for execution, expands views referenced in the...

ORA-38029 "Object Statistics Are Locked" - Possible Causes [ID 433240.1] Cause: Using import (imp) or data pump import (i...

  One of the difference I noticed about analyze index command and gather_index_stats procedure is that when we use analyze index command...

alter table ae1t3.ID_TICKET_STOCK_MASTER enable row movement; alter table ae1t3.ID_TICKET_STOCK_MASTER shrink space compact cascade; alt...

SQL> startup mount; SQL> alter system enable restricted session; $ rman target sys/dupdb@dupdb catalog rman/rman@catdb ...

1.  create parameter file. SQL> create pfile from spfile; $ cp initdrprod.ora initadil.ora 2. edit parameter file and replac...

SOURCE:   http://oracleinsider.wordpress.com/2009/05/09/encrypting-data-in-oracle-10g-transparent-data-encryption-ted/ Encrypting D...