Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2012
    Posts
    6

    Unanswered: Variables V$SQLAREA

    Hi!! I'm doing a search about variables of V$SQLArea.However, I don't found detailed information about Disk_Reads, Buffer_Gets and CPU_Time. Especially CPU_Time. Can you help me??
    Thank you!!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    V$SQLAREA


    DISK_READS NUMBER Sum of the number of disk reads over all child cursors
    BUFFER_GETS NUMBER Sum of buffer gets over all child cursors
    CPU_TIME NUMBER CPU time (in microseconds) used by this cursor for parsing, executing, and fetching
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2012
    Posts
    6
    Thank you for your help, but I need more specific information about those variables. For example,performance indicators about the SQL statement.
    Thank you!!!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I need more specific information about those variables.
    Such as what exactly?

    >For example,performance indicators about the SQL statement.
    I do not understand.
    please provide examples
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Apr 2012
    Posts
    6
    Well, I need to know how these informations (Disk_Reads, Buffer Gets and CPU_Time) can be important to optimization SQL.
    Thank you!!!

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I need to know how these informations (Disk_Reads, Buffer Gets and CPU_Time) can be important to optimization SQL.

    They are not important

    instead of guessing how to optimize SQL, consider Reading The Fine Manual, Performance & Tuning Guide

    http://docs.oracle.com/cd/B19306_01/...b14211/toc.htm
    Last edited by anacedent; 04-26-12 at 21:22.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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