Home » RDBMS Server » Performance Tuning » KEEP POOL (Oacle 11g on Solaris10)
KEEP POOL [message #395241] Tue, 31 March 2009 20:50 Go to next message
AlinaC
Messages: 45
Registered: November 2005
Location: India
Member

How to identify objects currently present in kool pool?


Thanks,

Alina
Re: KEEP POOL [message #395242 is a reply to message #395241] Tue, 31 March 2009 20:53 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>How to identify objects currently present in kool pool?
Use kool SQL

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

[Updated on: Tue, 31 March 2009 20:53]

Report message to a moderator

Re: KEEP POOL [message #395243 is a reply to message #395242] Tue, 31 March 2009 20:56 Go to previous messageGo to next message
AlinaC
Messages: 45
Registered: November 2005
Location: India
Member

sorry, how to identify objects currently present in KEEP buffer pool?
Re: KEEP POOL [message #395244 is a reply to message #395241] Tue, 31 March 2009 21:06 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
select distinct segment_name from dba_segments where buffer_pool='KEEP';

GOOGLE is your friend, but only when you actually use it.
Previous Topic: What if not give any ext in datafile........
Next Topic: bad index choose when using rownum < 9 or less
Goto Forum:
  


Current Time: Sat Dec 03 12:22:15 CST 2016

Total time taken to generate the page: 0.14214 seconds