RE: No data in the sql_address column of v$session

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Oct 2005 18:43:43 +0200


>Not true.
>SQL>select hash_value, sql_text from v$sql where upper(sql_text) in 
>---------- --------
>1470906206 ROLLBACK
>3615375148 COMMIT
>3615375148 COMMIT
> 242587281 commit

Thanks to Allen that rectified my post. I just retested it, and only in 10.2 
the commits are no longer in V$SQL. Unfortunately, in the last 2 months, I'm 
using 10.2 only and I extended an observation I did a couple of weeks ago to 
older versions as well :-( 



New Features Oracle Database 10g Release 2 seminars @
Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Hamburg (13-Oct), München (20-Oct), Basel (25-Oct), Frankfurt 
         Zürich (29-Nov), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec)

Other related posts: