Saturday, December 21, 2013

Table Fragmentation

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

Empty Oracle Listener.log files

›
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...
Tuesday, May 28, 2013

Auditing FGA:

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

How to Check the version of and Update opatch utility

›
Checking the opatch utility version: $ cd $ORACLE_HOME/OPatch $ opatch lsinventory Invoking OPatch 10.2.0.4.3 Oracle Interim Patch I...
Monday, May 27, 2013

Best Practices for Upgrading to Oracle Database 11g Release 2

›
http://www.oracle.com/technetwork/database/upgrade/best-practices-for-upgrading-11gr2-174946.pdf
1 comment:
Thursday, May 2, 2013

Oracle terms and Ideas you need to know before beginning

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

Object Statistics Are Locked

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

Oracle Database 10g: Analyze Index Vs. Gather_Index_Stats

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

Reclaiming Segment Space

›
alter table ae1t3.ID_TICKET_STOCK_MASTER enable row movement; alter table ae1t3.ID_TICKET_STOCK_MASTER shrink space compact cascade; alt...
Monday, April 22, 2013

Drop 10g Database using RMAN

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

Clone / Duplicate a database with RMAN

›
1.  create parameter file. SQL> create pfile from spfile; $ cp initdrprod.ora initadil.ora 2. edit parameter file and replac...
Thursday, April 18, 2013

Encrypting Data in Oracle 10g: Transparent Data Encryption (TDE)

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