Performance Questions

How do I create the PLUSTRACE role for use with AUTOTRACE?
How do I interpret the output from Explain Plan?

RDBMS Patch Lab -

Oracle RDBMS patching is one of the DBAs regular tasks. Here I would like to discuss very broadly how we do the rdbms patching. The database and the listener must be down while applying the patch.

We apply the rdbms patches by using Opatch utility. Please ceck the correct version of your optach which you will be using to apply a particular rdbms patch.

Here are the steps -

connect as oracle user.

set environment of the instance

1) Download the patch from oracle suuport to $ORACLE_HOME/patch
unzip the patch.
During uzipping please note down the directory it is creating.
cd to that directory. copy the directory path.
Example : 3852108

2)
export PATH=/$ORACLE_HOME/OPatch:$PATH
export PATH=/opt/perl/bin:$PATH

3)
cd /$ORACLE_HOME/OPatch
4)Apply the patch by this command
opatch apply -invPtrLoc $ORACLE_HOME/oraInventory/oraInst.loc /3852108

opatch apply -no_inventory /3852108
optach lsinventory -invPtrLoc $ORACLE_HOME/oraInventory/oraInst.loc