Home » Other » General » About Execution Plan (Oracle 9i.2, Windows. )
About Execution Plan [message #476751] Sat, 25 September 2010 06:45 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi,

Share Your Thoughts.

1) All the new Sql statement to the shared pool needs to have a exclusive 'Execution Plan'?

2) With the execution Plan, Hard parsing will perform.

3) For Soft Parsing, we no need to have the Execution Plan?

4) If the Sql statement found some Data from the Buffer and some Data need to be fetched from the Disk (Hard Parsing), will this case Execution Plan has to be made again?
If yes, will the existing execution Plan be modified or totally a new execution Plan will be generated?.

Thanks in advance

Report message to a moderator

Re: About Execution Plan [message #476757 is a reply to message #476751] Sat, 25 September 2010 08:40 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1) What does this mean? Explain.
2) Meaningless
3) Meaningless
4) You didn't understand anything.

Once again, don't try to guess but read Database Concepts from cover to cover.

Regards
Michel

Report message to a moderator

Previous Topic: General Architecture Info.
Next Topic: Please help me understand a basic concept.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 27 04:00:45 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.