Re: sql_text from v$sqlarea

A couple of things. Depending on the size of the shared pool and whether or not the sql you are issuing is reusable (i.e. uses bind variables), the statement you executed from the web could have been aged out before you queried v$sqlarea. Assuming that is not the case then make sure the web app and your sqlplus session are accessing the DB as the same user. Otherwise, you could get different results because of views and or row level security.

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.

Posted via www.orafocus.com - Focusing on the World of Oracle Received on Thu Sep 06 2001 - 17:23:53 CDT