Difference between utlchain.sql and utlchn1.sql

A very small thought The difference between utlchain.sql and utlchn1.sql is the column head_rowid data type: :::::::::::::: utlchain.sql :::::::::::::: create table CHAINED_ROWS ( owner_name varchar2(30), table_name varchar2(30), cluster_name varchar2(30), partition_name varchar2(30), subpartition_name varchar2(30), head_rowid rowid, analyze_timestamp date ); and :::::::::::::: utlchn1.sql :::::::::::::: create table CHAINED_ROWS ( owner_name varchar2(30), table_name varchar2(30), cluster_name varchar2(30), partition_name varchar2(30), subpartition_name varchar2(30), head_rowid urowid, analyze_timestamp date …

Using Oracle AMM (Automatic Memeory Managment) 11g

The basic memory structures associated with Oracle Database include: System Global Area (SGA) The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Program Global Area (PGA) A PGA is a memory region that contains data …

Enable Tracing Oracle Listener

Just in case if you need to generate trace of Listener Do the following: vi /u01/oracle/11.2/network/admin/listener.ora And add the Following: TRACE_LEVEL_listener=support TRACE_TIMESTAMP_listener=true valid values for trace level can be from following depending upon the information required. user or 4 for user trace information admin or 10 for administration trace information support or 16 for Oracle Support Services trace information Bounce …

Requirements for Installing Oracle 11gR2 RDBMS on RHEL Quick Review

This procedure is meant for those planning/trying to install Oracle Server 11.2.0.1.0 (or above) on Red Hat Server 5.2 (or greater) on the 64-bit (x86-64) platform. Since it is the expressed goal to keep Oracle Enterprise Linux functionally IDENTICAL to RHEL, this NOTE is also completely applicable to 64-bit (x86-64) OEL 5.2 or greater. Requirements for Installing 64-bit Oracle 11gR2 …

Recover Objects from Oracle Recyclebin 11g/10g

Using my previous example SQL> select object_name, original_name, type, can_undrop, can_purge, droptime from recyclebin; OBJECT_NAME    ORIGINAL_NAME    TYPE    UND    PUR    DROPTIME ————-    ————–    —-    —-    —    ——— BIN$GI74VOhyTp29f91G/w1VOg==$0    T1    TABLE    YES    YES    2011-02-08:04:23:01 BIN$LPbnFGYmST+6vTnvrdb9WQ==$0    T1    TABLE    YES    YES    2011-02-08:04:22:26 SQL> flashback table t1 to before drop; Flashback complete. SQL> select object_name, original_name, type, can_undrop, can_purge, droptime from recyclebin; OBJECT_NAME    ORIGINAL_NAME    TYPE   …

Use Oracle Recyclebin in 10g/11g

Starting from 10g, The recyclebin is enabled by default and there are two recyclebin views a) USER_RECYCLEBIN and b)DBA_RECYCLEBIN. The synonym RECYCLEBIN points to session USER_RECYCLEBIN. To turn it on or off you need to change the RECYCLEBIN initialization parameter, at the session or system level. When the recyclebin is enabled, any table that you drop is not actually gets …

Turn Off Recyclebin in Oracle 10g/11g

One of the coolest feature in Oracle starting from 10g is recyclebin but sometimes it is annoying to scroll down and see a long list objects dropped, especially in development environment  where you drop more tables than you create. SQL> SHOW PARAMETER RECYCLEBIN NAME                                 TYPE        VALUE ———————————— ———– —————————— recyclebin                           string      on SQL> To turn the feature ON or OFF …

Rename or Move Oracle datafiles

One of my juinor dba created the files without extension and I really dont like that, also I wanted to blog about this from quite sometime so here it goes: Start Sqlplus and logon as sysdba [oracle@**** ****]$ sqlplus /nolog SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 26 13:20:34 2011 Copyright (c) 1982, 2009, Oracle.  All rights reserved. SQL> conn …