Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a view that i can use to check if alter table ...(buffer_pool keep) is working ?

Re: Is there a view that i can use to check if alter table ...(buffer_pool keep) is working ?

From: Mark D Powell <mark.powell_at_eds.com>
Date: 14 Sep 2001 06:30:59 -0700
Message-ID: <178d2795.0109140530.3cdf229b@posting.google.com>


brandonfair_at_hotmail.com (Owen) wrote in message news:<20e5d4a1.0109131253.3ba0ea5c_at_posting.google.com>...
> Is there a view that I can check to see if a table has been
> cached to the KEEP?
> V$SHARED_POOL_RESERVED does not seem to work.

See the data dictionary view dba_tables columns cache and buffer_pool depending on exactly which of the two items you are actually interested in.

Received on Fri Sep 14 2001 - 08:30:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US