OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » table caching (oracle, 9i R1, Win XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

table caching [message #334085]

Tue, 15 July 2008 07:15

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

Report message to a moderator

Re: table caching [message #334101 is a reply to message #334085]

Tue, 15 July 2008 07:46

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: table caching [message #334419 is a reply to message #334085]

Wed, 16 July 2008 07:32

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.

Report message to a moderator

Previous Topic:	what are the various steps of query processing
Next Topic:	Oracle runs SLOWER on XEON than Pentium Dual

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 16:06:37 CST 2025