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 …