Home » RDBMS Server » Performance Tuning » what are the various steps of query processing (Oracle 9i)
icon4.gif  what are the various steps of query processing [message #333047] Thu, 10 July 2008 06:42 Go to next message
manish.verma@sify.com
Messages: 3
Registered: July 2008
Junior Member
Cool

hi all,

i want to know some question in oracle:

1. what are the various steps of query processing?
2. what do mean by execution,parse_calls in v$sqlarea?

thanx
Maneesh
Re: what are the various steps of query processing [message #333061 is a reply to message #333047] Thu, 10 July 2008 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As almost this is explained in Database Concepts.
Chapter 24 SQL, PL/SQL, and Java
Section Overview of SQL
Subsection SQL Processing

Regards
Michel
Re: what are the various steps of query processing [message #334098 is a reply to message #333047] Tue, 15 July 2008 07:43 Go to previous messageGo to next message
manish.verma@sify.com
Messages: 3
Registered: July 2008
Junior Member
hi Michel

thanks for your answer, it's really helpfull to me.

i want to ask one more question:

there is equal value for parse_calls and executions column in v$sqlarea view. are these values always equal or might be different.

i have read that parse_calls should be less than executions, how could i put down the parse_calls value. i have changes the shared_pool_size to 40MB

i am trying out this with emp table of scott schema.

thanx and regards
Maneesh
Re: what are the various steps of query processing [message #334170 is a reply to message #334098] Tue, 15 July 2008 11:36 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
there is equal value for parse_calls and executions column in v$sqlarea view. are these values always equal or might be different.

This is very bad.
There should 1 parse and multiple executions.

Quote:
how could i put down the parse_calls value.

Oracle parses each YOU ask it to parse. You have to change the application.

Regards
Michel
Previous Topic: Index Partitioning
Next Topic: table caching
Goto Forum:
  


Current Time: Fri Dec 09 15:18:49 CST 2016

Total time taken to generate the page: 0.34427 seconds