Home » RDBMS Server » Server Administration » knowing parse code
knowing parse code [message #240961] Mon, 28 May 2007 01:28 Go to next message
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.
Re: knowing parse code [message #240962 is a reply to message #240961] Mon, 28 May 2007 01:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ V$SQLAREA
2/ Avoid new hard parses for same query with different values

Regards
Michel
Re: knowing parse code [message #240965 is a reply to message #240962] Mon, 28 May 2007 01:52 Go to previous messageGo to next message
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.
Re: knowing parse code [message #240969 is a reply to message #240965] Mon, 28 May 2007 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: knowing parse code [message #241137 is a reply to message #240969] Mon, 28 May 2007 08:01 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks again

Is it any area where execution plan will kept?

Thanks.
Re: knowing parse code [message #241146 is a reply to message #241137] Mon, 28 May 2007 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They are in the SQL Area.

Regards
Michel
Re: knowing parse code [message #241235 is a reply to message #241146] Mon, 28 May 2007 23:41 Go to previous messageGo to next message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
Thanks for that.
Do we have any data dictionary view to see the execution plans?

Thanks.
Re: knowing parse code [message #241247 is a reply to message #241235] Mon, 28 May 2007 23:57 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
v$sql_plan

Regards
Michel
Previous Topic: renaming database name
Next Topic: How do I create an ASM?
Goto Forum:
  


Current Time: Sun Dec 04 18:38:11 CST 2016

Total time taken to generate the page: 0.10755 seconds