查V$SQLTEXT表 假定:用户是YourName :语句状态是运行状态 Select Sid From v$session Where STATUS =Upper('active') and OSUSER=YourName ================================================ Select SQL_TEXT From V$SQLTEXT Where ADDRESS = (Select SQL_ADDRESS From V$SESSION Where sid=&1) Order By PIECE
假定:用户是YourName
:语句状态是运行状态
Select Sid
From v$session
Where STATUS =Upper('active')
and OSUSER=YourName
================================================
Select SQL_TEXT
From V$SQLTEXT
Where ADDRESS = (Select SQL_ADDRESS From V$SESSION Where sid=&1)
Order By PIECE
使用SQLEXPLORE查看表