Re: sql_text from v$sqlarea

"May" <sunxushi_at_yahoo.com> wrote in
<snipped>
> 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.

To add to what the others said.. another reason why the SQL could look different is because of parallel query. In this case your SQL statement is changed in order to run it in parallel. Oracle will add some hints to it and a ROWID range scan in the WHERE clause.

Also, as you are using a web application, be careful of using ODBC to access Oracle. Certain ODBC drivers have a nasty habit of interfering with your SQL in an stupid attempt to "fine tune" it. Always used ODBC PASS THRU option to ensure that the SQL you specified, is the SQL that the database engine receives.

--
Billy