Re: Help: what is the difference between v$sql and v$sqlarea

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 01 May 2002 21:45:20 GMT
Message-ID: <QlZz8.75410$zN.40055407@twister.socal.rr.com>

Compare some rows where v$sql.child_number > 1 and you'll see where the summing is coming from.

Richard

Joe Bayer wrote:
>
> V$sql and v$sqlarea seems very similar, when I look into v$fixed_view_de
> finition, I found that v$sqlarea use a lot of sum, it gives me the
> impression that v$sqlarea is a sum of v$sql, but when I select against
> those two views, it gives me the same results in terms of executions,
> loads, etc.
>
> I am very confused here.
>
> Any suggestions?
>
>
>
> --
> Sent by joebayerii from hotmail subdomain of com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Wed May 01 2002 - 16:45:20 CDT