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 -> Re: v$sqlarea does not give latest SQL statements!

Re: v$sqlarea does not give latest SQL statements!

From: <RogBaker_at_gmail.com>
Date: 24 Jan 2007 07:49:17 -0800
Message-ID: <1169653757.160216.189770@k78g2000cwa.googlegroups.com> 





On Jan 23, 8:55 am, qazmlp1..._at_rediffmail.com wrote:


> How exactly we can find the last 'N' number of SQL statements that were

> executed in the Oracle 9i(9.2.0.4.0)?



 But, the above query did not show these SQL


> statements at all. Wherelse I can check this?




v$sqltext_with_newlines will show the complete sql statement.
Received on Wed Jan 24 2007 - 09:49:17 CST












Original text of this message













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