|
[oracle-l]
||
[Date Prev]
[10-2005 Date Index]
[Date Next]
||
[Thread Prev]
[10-2005 Thread Index]
[Thread Next]
RE: No data in the sql_address column of v$session
- To: <Christian.Antognini@xxxxxxxxxxxx>, "arun chakrapani rao" <arunrao_oradba@xxxxxxxxxxx>
- Date: Tue, 4 Oct 2005 09:31:07 -0700
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
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Christian Antognini
Even a COMMIT or ROLLBACK has no entry in V$SQL...
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l
|
|
