v$sql vs v$sqlarea difference ??

Hi experts,

Today , my colleague ask me what is the difference between v$sql and v$sqlarea, which made me blue...

I get some hints from *http://www.adp-gmbh.ch/* <http://www.adp-gmbh.ch/> it says that

v$sql * v$sql is similar to
v$sqlarea<http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html#sqlarea>, the main difference being that v$sql drills down to select * from x$kglob<http://www.adp-gmbh.ch/ora/misc/x.html#kglob>whereas v$sqlarea drills down to select sum from x$kglob. See also here <http://www.adp-gmbh.ch/ora/admin/dynamic_views/diff_sql_sql_area.html> .*

x$kglob *Library Cache Object

*

*The table v_$sql and v_$sqlarea have columns with the same name but differ:

OUTLINE_SID                    NUMBER                        22
OUTLINE_SID                    VARCHAR2                      40

LAST_LOAD_TIME                 VARCHAR2                      19
LAST_LOAD_TIME                 DATE                           7

**columns in v_$sql but not in v_$sqlarea

CHILD_ADDRESS
CHILD_NUMBER
SERVICE
SERVICE_HASH
SQLTYPE
TYPE_CHK_HEAP 6 rows selected.

**columns in v_$sqlarea but not in v_$sql

LAST_ACTIVE_CHILD_ADDRESS
VERSION_COUNT*
*
*But i am still not clear, someone told me v$sql may contains objects not
exists in Shared pool, which i am also not clear,

Can any one give me a clear answer ?*
*

Thanks a lot.

-- 

("'-''-/").___..--''"'-._
 '7_ 7  )   '_.  (     ).'-.__.')
 (_Y_.)   ._   )  '._ '. ''-..-'
_.'--'_..-_/  /--'_.' ,'
(il),-''  (li),'  ((!.-'

Best regards，
Yours sincerely House
baojiejie_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l