buffer cache

[steeve123]

How can i know wich tables are in the buffer cache?

How can i know how many block that those tables occupy in the buffer cache?

If a do the following: alter a table 'table_name' cache;

Will it get out of the buffer cache if the database needs the space for other objects?

[Halo]

1. select table_name from dba_tables where cache='Y'
2. the size of the table
3. AFAIK no. Maybe the buffer hit ratio will decrease. Confirm this.

[padmam]

Hi, 24th April 2001 21:56 hrs chennai

No for your 3 Question.According to the

cache_size_threshold parameter mentioned in the init.ora the number of blocks will be held in buffer cache.

Execute the script catparr.sql to create the table v$cache to query.

I think this is used for OPServer also i am not sure still this is supported 8.1.6 above

Cheers

Padmam