Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Buffer Cache Contents

KeenOnOracleFeb 6 2008 — edited Feb 6 2008

Hello everyone,

I have a doubt that I could not find any anwer over the metalink.

I'm running 10.2.0.1.0 on a Windows2003EE using VLM (PAE). I've allocated to DB_CACHE_BUFFER about 7GB.

My questions is:
DO I need to do something to fill up that area of the most recent used data ?
Can I see tha data blocks or something that indicates which data are placed in there ? to see if its entire filled up of data.

Also, when using PAE you cannot use multiple buffers, as RECYCLE or KEEP. Can I place a table in momery on the default buffer using this feature ?

Tks for any help, tips or links.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2008

Added on Feb 6 2008

#general-database-discussions

3 comments

544 views