OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Pinning

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

Pinning [message #58433]

Tue, 26 August 2003 09:25

Marks
Messages: 11
Registered: February 2002

Junior Member

Oracle 8.1.7.3

How can I tell what is routinely pinned into the SQL area of the SGA ?

Report message to a moderator

Re: Pinning [message #58434 is a reply to message #58433]

Tue, 26 August 2003 10:01

Navneet
Messages: 12
Registered: August 2003

Junior Member

Hi Mark,
May be you are looking for V$DB_OBJECT_CACHE.
regards
navneet

Report message to a moderator

Re: Pinning [message #58435 is a reply to message #58434]

Tue, 26 August 2003 10:28

Mark
Messages: 284
Registered: July 1998

Senior Member

Thanks Navneet, that's a good starting point.
I am now able to see that code is executed a lot more times than it is loaded even if it's not pinned. This must be because it's not been flushed from memory before the next invocation of the syntax?

Does anyone know how to automatically pin code at instance startup time ?

Report message to a moderator

Re: Pinning [message #58438 is a reply to message #58435]

Tue, 26 August 2003 12:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

please refer this posting
http://www.orafaq.net/msgboard/server/messages/13493.htm

this may help you~

Report message to a moderator

Previous Topic:	CLOB Index
Next Topic:	can someone please help me?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:44:57 CDT 2024