Home » RDBMS Server » Performance Tuning » DIFF B/W V$SQL AND V$SQLAREA (Oracle Database 10g Release 10.2.0.3.0 )
DIFF B/W V$SQL AND V$SQLAREA [message #405819] Fri, 29 May 2009 13:17 Go to next message
scaria.grg
Messages: 3
Registered: May 2009
Location: Kuwait
Junior Member
HI
CAN ANYBODY please TELL ME WHAT IS THE DIFFERENCE BETWEEN V$SQL AND V$SQLAREA .I AM UNDER THE IMPRESSION THAT V$SQLAREA IS A GROUP BY OF V$SQL AND V$SQL WOULD CONTAIN MULTIPLE COPIES OF SAME SQL.AM I RITE OR IS IT SMETHING ELSE.
Re: DIFF B/W V$SQL AND V$SQLAREA [message #405821 is a reply to message #405819] Fri, 29 May 2009 13:30 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't post in UPPER case.
Read OraFAQ Forum Guide.

V$SQLAREA
V$SQL
Quote:
V$SQL lists statistics on shared SQL area without the GROUP BY clause and contains one row for each child of the original SQL text entered.

Just simple as reading the documentation.

Regards
Michel
Previous Topic: import sql profile with opt_param hnt
Next Topic: JDBC connection performance
Goto Forum:
  


Current Time: Sun Dec 11 08:30:20 CST 2016

Total time taken to generate the page: 0.15322 seconds