Friday, 23 June 2017

SQL Query Processing steps

SQL Query Processing steps:-Below are the SQL Query processing steps

Hard Parse :- If hash value of query is not available in shared SQL Area then process will execute hard parsing


1) SQL Parsing
    a) Syntax Check
    b) Semantic Check
    c) Shared Pool Check
2) Optimization  (Generation of Multiple Execution Plan)
3) Row Source Generation (Generation of Query Plan)
4) Execution

Soft Parse :-If hash value of query is available in shared SQL Area  then process will execute soft parsing


1) SQL Parsing
    a) Syntax Check
    b) Semantic Check
    c) Shared Pool Check
2) Execution

1) Syntax Check:- In this check SQL Parser check the Query syntax.
2) Semantic Check:-In this check SQL Parser check that Object and columns existence. Also check the priviledges on those objects
3) Shared Pool Check :- In this check SQL Parser check for hash value of query in shared SQL Area
4) Optimization :-In this step SQL Parser generate multiple execution plan.
5) Row Source Generation :-In this step Row source generator (Software) receive optimal execution plan from optimizer and produce a iterative execution plan which is used to produce result set.           
6) Execution :-In this step SQL engine execute each row source of Tree ,produced by Row source generator.                    

1 comment:

  1. Thanks for the given information you are providing content very usefull to users.
    Learn How to Work With Ref Cursor in ORACLE 12C For Beginner Actual cost of this course is 9,999/- But now Kuncham Software Solutions Pvt ltd is giving you Free access. Limited period offer Hurry-up Enroll Now at Udemy.


    Hurry-Up Enroll Now and get Free Access to the Entire Course


    ReplyDelete

Cloning database with RMAN

Below are the steps to clone production database(primedb) to UAT database(clonedb)   STEP1 :- Check the both servers are able to connect ...