Home » RDBMS Server » Performance Tuning » table caching (oracle, 9i R1, Win XP)
table caching [message #334085] Tue, 15 July 2008 07:15 Go to next message
manish.verma@sify.com
Messages: 3
Registered: July 2008
Junior Member
hi all ,

i am a new user in oracle performance tuning.

i have changed the buffer_pool clause of emp table to "KEEP", how will i determine that the table has been kept in the buffer

here is my databases's parameters
db_cache_size= 40MB
db_keep_cache_size =4MB

i have checked the column "KEPT" of v$db_object_cache table which is showing "NO".

please help

thanx
Maneesh
Re: table caching [message #334101 is a reply to message #334085] Tue, 15 July 2008 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i have changed the buffer_pool clause of emp table to "KEEP",

Why? This is likely a bad idea if you are new in performance tuning.

from doc
V$DB_OBJECT_CACHE: This view displays database objects that are cached in the library cache.

No relation with buffer cache.

Regards
Michel

Re: table caching [message #334419 is a reply to message #334085] Wed, 16 July 2008 07:32 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
i am a new user in oracle performance tuning.


Then don't change any of the server parameters.

Parameter based tuning is for the last 5% of performance tuning.
The vast bulk of your performance improvements will come from tuning your SQL, and your application code.
Previous Topic: what are the various steps of query processing
Next Topic: Oracle runs SLOWER on XEON than Pentium Dual
Goto Forum:
  


Current Time: Sun Dec 04 02:43:31 CST 2016

Total time taken to generate the page: 0.10204 seconds