Cannot tell for sure. Maybe - but there are lots of
other queries with FTS executed thoughout the week.
There appears to be no change to x$bh for these table
blocks (including buf#) .
-Ravi.
--- AK <[EMAIL PROTECTED]> wrote:
> Did u do a full scan of table again after nocache
> setting ?
>
> -ak
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, July 01, 2003 12:20 PM
>
>
> > 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.
> >
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Ravi Kulkarni
> > INET: [EMAIL PROTECTED]
> >
> > 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).
> >
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: AK
> INET: [EMAIL PROTECTED]
>
> 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).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ravi Kulkarni
INET: [EMAIL PROTECTED]
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 Wed Jul 02 2003 - 09:17:49 CDT
