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

Thread: difference between v$sqlarea and v$sql

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    What is the difference between v$sqlarea and v$sql?


  2. #2
    Join Date
    Sep 2000
    Posts
    305
    any idea??????

  3. #3
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    My understanding is that v$SQLAREA shows only one row per statement whereas v$SQL contains multiple copies of the statement

    Example:

    Two users have a table called sample_table, both issue an identical select:

    select col1 from sample_table

    V$SQL stores 1 row per query, hence if you have two users each issuing the same statement but from different tables but with the same name V$SQL will store 2 rows.

    V$SQLAREA shows distinct sql statements so only one row is returned.


    Regards

    [Edited by jovery on 07-03-2002 at 10:03 AM]
    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
    Apr 2001
    Location
    London
    Posts
    725
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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