OraFAQ Forum: Server Administration » Frequently accessed objects

Home » RDBMS Server » Server Administration » Frequently accessed objects

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

Frequently accessed objects [message #170071]

Mon, 01 May 2006 23:57

anandhi
Messages: 31
Registered: April 2006
Location: Chennai

Member

Hi

The objects are frequently accessed by the users. For example if i have a index object and it is accessed frequently.

I have to place the frequently accessed objects in the memory itself for faster transaction.

Can anyone suggest how should i do it?

Anandhi

Report message to a moderator

Re: Frequently accessed objects [message #170097 is a reply to message #170071]

Tue, 02 May 2006 02:16

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

http://www.oracle-training.cc/s44.htm

the above link will give you an idea about the "Keep pool" of buffer cache and you can dig into documentation to know more.

Quote:

Memory is allocated to the KEEP buffer pool by setting the parameter DB_KEEP_CACHE_SIZE to the required size. The memory for the KEEP pool is not a subset of the default pool.

[Updated on: Tue, 02 May 2006 02:16]

Report message to a moderator

Re: Frequently accessed objects [message #170118 is a reply to message #170071]

Tue, 02 May 2006 03:27

dhar_kiran
Messages: 7
Registered: November 2005
Location: Delhi

Junior Member

if u want to keep that object in shared pool then use

dbms_shared_pool.keep(object_name,object_type) procedure

if u want to keep that object in buffer pool then use

buffer_pool in alter or create statement, or use CACHE

Report message to a moderator

Previous Topic:	'NOT TO BE DISPLAYED' PARAMETER DOES DISPLAY DURING SUBMISSION
Next Topic:	accessing remote database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:21:55 CDT 2024