OraFAQ Forum: Performance Tuning » DIFF B/W V$SQL AND V$SQLAREA

Home » RDBMS Server » Performance Tuning » DIFF B/W V$SQL AND V$SQLAREA (Oracle Database 10g Release 10.2.0.3.0 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DIFF B/W V$SQL AND V$SQLAREA [message #405819]

Fri, 29 May 2009 13:17

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.

Report message to a moderator

Re: DIFF B/W V$SQL AND V$SQLAREA [message #405821 is a reply to message #405819]

Fri, 29 May 2009 13:30

Michel Cadot
Messages: 68664
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

Report message to a moderator

Previous Topic:	import sql profile with opt_param hnt
Next Topic:	JDBC connection performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 23 13:53:04 CDT 2024