OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » KEEP POOL (Oacle 11g on Solaris10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

KEEP POOL [message #395241]

Tue, 31 March 2009 20:50

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

How to identify objects currently present in kool pool?

Thanks,

Alina

Report message to a moderator

Re: KEEP POOL [message #395242 is a reply to message #395241]

Tue, 31 March 2009 20:53

BlackSwan
Messages: 26766
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

AlinaC
Messages: 45
Registered: November 2005
Location: India

Member

sorry, how to identify objects currently present in KEEP buffer pool?

Report message to a moderator

Re: KEEP POOL [message #395244 is a reply to message #395241]

Tue, 31 March 2009 21:06

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	What if not give any ext in datafile........
Next Topic:	bad index choose when using rownum < 9 or less

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 03 05:55:09 CDT 2024