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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: No data in the sql_address column of v$session

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

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 4 Oct 2005 18:43:43 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF1344E5@MSXVS04.trivadis.com>


Hi

>Not true.
>
>SQL>select hash_value, sql_text from v$sql where upper(sql_text) in ('COMMIT','ROLLBACK');
>
>HASH_VALUE SQL_TEXT
>---------- --------
>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 :-(

Chris

HTH
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com

Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Hamburg (13-Oct), München (20-Oct), Basel (25-Oct), Frankfurt (27-Oct), 
         Zürich (29-Nov), Bern (8-Nov), Düsseldorf (23-Nov), Stuttgart (13-Dec)
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 04 2005 - 11:46:33 CDT

Original text of this message

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