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: Keep Pool

Re: Keep Pool

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Wed, 21 Jun 2006 19:46:06 GMT
Message-ID: <2mhmg.26505$YI2.16729@trnddc01> 





art_at_chicagorsvp.com wrote:


> Hi Everyone!

> 

> We are running Oracle 9.2.0.7.   Is there a way to query what objects

> are pinned in the keep pool???

> 

> Regards.

> 




SELECT owner, segment_name, segment_type
  FROM dba_segments


 WHERE BUFFER_POOL = 'KEEP'

Received on Wed Jun 21 2006 - 14:46:06 CDT












Original text of this message













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