Re: sql_text from v$sqlarea

"May" <sunxushi_at_yahoo.com> wrote in message news:8c0f1a9e.0109060739.30c981f4_at_posting.google.com...
> does the sql_text selected from v$sqlarea include all of the sql that
> database executed? does it include the sql both run through the
> sqlplus and middle tier(application server)
>
> but when i run the a sql select from v$sqlarea in sqlplus, the result
> is diffirent from the result when run it from web page application.(
> i think i run the same sql, because not many sql in v$sqlarea). so i
> am very puzzled.
> i guess may be more sql not in v$sqlarea.
> then where and how i can see them.

*ALL* sql is in v$sqlarea
sql_text in v$sqlarea however is truncated, for obvious reasons. v$sqltext_with_newlines contains the full sql text including all the original formatting.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Sep 06 2001 - 10:50:27 CDT