Search This Blog

Tuesday, October 30, 2012

How to Tune Shared Pool Cache ?

The one basic rule for tuning the shared pool is to
avoid or minimize parses of any kind, whether they be
soft parses or hard parses.

Parses can only be avoided by your developers by efficiently coding
the application.

As a DBA you can only minimize parses.

Friday, October 5, 2012

Oracle 11gR2 RAC Enable Archive log Mode.

In the cluster log in from anyone of the instances.

In my case it is DELL1

[oracle@rac1 ~]$ export ORACLE_SID=dell1
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release Production on Thu Oct 4 16:38:15 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.