Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql_text from v$sqlarea

sql_text from v$sqlarea

From: May <sunxushi_at_yahoo.com>
Date: 6 Sep 2001 08:39:39 -0700
Message-ID: <8c0f1a9e.0109060739.30c981f4@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. Received on Thu Sep 06 2001 - 10:39:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US