Regarding the Tuning of Oracle
8i
If the Cache Hit Ratio is less then 90%then Increase the
DB_BLOCK_BUFFERS.
This parameter is the Number of theDB_BLOCKS.
So if theDB_BLOCK_SIZE = 8192 and DB_BLOCK_BUFFERS
= 50000
then, Since the DB_BLOCK_BUFFERS
is in Units of the DB_BLOCK_SIZE
these 2 effects the actual size(in Number of Bytes)
allocated . In Our case the
actual size will be 8192*50000 = 406,600,000 (400
MB Only).
Depending on the Resources Available u can grant upto
40% of the Physical
Memory available to this Parameter.
In Oracle9i Onward its Possible to have multiple DB_blockSize
within a Single Database. This is a Powerful Feature
Particularly When U are Running a Hybrid
System( DSS/OLTP Mixed in a Single Database Instance).
Memory Tuning Aspects
First try to get the size of the Sharable memoryFrom V$sqlareaWhere
the Executions are very Frequent. Let’s assume that any Code that is executed
more than five times can be considered as frequently used.
Select Sum (Sharable_mem)
From
V$sqlarea where executions
> 5
Again this 5 is just for example, based on your application
One has to judge by when something can be classified as frequently used.
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle Certification,
Database Administration, SQL, Application, Programming Reference Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|