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.
Tuesday, October 30, 2012
How to Tune Shared Pool Cache ?
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 11.2.0.1.0 Production on Thu Oct 4 16:38:15 2012 Copyright (c) 1982, 2009, Oracle. All rights reserved.
Subscribe to:
Posts (Atom)