| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Table CACHE/NOCACHE
Guys,
Help me figure this one out. Was helping a colleague
diagnose slow response time (8.1.7/Solaris running
Peoplesoft ). x$bh showed 102,248 out of 170,000
buffers belonged to a single table, which he said he
cached explicitly. He did "NOCACHE" (on my suggestion)
on the large table.
I still find that the table is in buffer cache (even
Buff# haven't changed - starts with buf#=1 - not sure
if this means LRU end) even after a week. DB cannot be
bounced since it is production.
Do you know of any reason why it is not flushed out of
cache when table is altered to NoCache?
Thanks,
Ravi.
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 01 2003 - 13:34:14 CDT
 |
 |