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.

Mark D Powell --

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

This message: [ Message body ]
Next message: Alan: "Re: DBMS_JOB hourly interval"
Previous message: Walter Stucki: "Re: Stop service will not shutdown the db on W2K"
In reply to: Owen: "Is there a view that i can use to check if alter table ...(buffer_pool keep) is working ?"
Next in thread: Howard J. Rogers: "Re: Is there a view that i can use to check if alter table ...(buffer_pool keep) is working ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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