OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » knowing parse code

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

knowing parse code [message #240961]

Mon, 28 May 2007 01:28

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi,
Is there any possibility to know how much parse codes are present in shared pool?

what is the advantage of using bind variables?

Thanks.

Report message to a moderator

Re: knowing parse code [message #240962 is a reply to message #240961]

Mon, 28 May 2007 01:37

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ V$SQLAREA
2/ Avoid new hard parses for same query with different values

Regards
Michel

Report message to a moderator

Re: knowing parse code [message #240965 is a reply to message #240962]

Mon, 28 May 2007 01:52

shahnazurs
Messages: 240
Registered: June 2005
Location: India

Senior Member

Hi Michel,
Thanks for that info.
Is it possible to clear parse codes? Is there any LRU algorithm implemented in shared pool?
Hope this parse codes are present in library cache

Thanks.

Report message to a moderator

Re: knowing parse code [message #240969 is a reply to message #240965]

Mon, 28 May 2007 02:04

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1/ No specific clear possible. "alter system flush shared pool" clears all
2/ Yes there is something like a LRU algorithm
3/ SQL area is in the library cache.

Regards
Michel

Report message to a moderator