Re: sql_text from v$sqlarea

May wrote:
>
> 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.

As well as Sybrand's post, some "intelligent" tools try to do things like uppercase all SQL's etc etc to increase the likelihood of getting sharing.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."