Explain Plan
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Explain Plan

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    Explain Plan

    Can some explain in brief wht each step is all abt?

    Statistics
    ---------------------------------------------------
    recursive calls
    db block gets
    consistent gets
    physical reads
    redo size
    bytes sent via SQL*Net to client
    bytes received via SQL*Net from client
    SQL*Net roundtrips to/from client
    sorts (memory)
    sorts (disk)
    rows processed
    Cheers!
    OraKid.

  2. #2
    Join Date
    Oct 2003
    Location
    Faridabad
    Posts
    2
    db block gets - server process to retreive the datablock from datafiles.
    Consistent gets - If process gets the datablock it needed from data buffer cache it is consistent get.
    Physical read - If process read the block from the datafile not from buffer.
    Redo size - it refer to redolog buffer size.
    sorts (memory) - If the sorting is done in memory that is allocated for user
    .
    sorts (disk)- If memory is not available for user that sorting is done in physical media i.e (disk) it degrade the system performance.


  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439

    Re: Explain Plan

    Originally posted by balajiyes
    Can some explain in brief wht each step is all abt?

    Statistics
    ---------------------------------------------------
    recursive calls
    db block gets
    consistent gets
    physical reads
    redo size
    bytes sent via SQL*Net to client
    bytes received via SQL*Net from client
    SQL*Net roundtrips to/from client
    sorts (memory)
    sorts (disk)
    rows processed
    Very confusing subject title - I don't see any EXPLAIN PLAN (EXECUTION PLAN) at all. Those are statistics, not execution plan elements!
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width