What is the difference between v$sqlarea and v$sql?
My understanding is that v$SQLAREA shows only one row per statement whereas v$SQL contains multiple copies of the statement
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.
[Edited by jovery on 07-03-2002 at 10:03 AM]
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!
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
Click Here to Expand Forum to Full Width