Q: How can I find out the SQL statement being issued at the front end?
A:The procedure is as follows:
Software environment:
1. Windows 2000 + ORACLE 8.1.6
2. ORACLE installation path: C: \ ORANT
Implementation Method:
You can use the following statement:
select user_name,sql_text
from v$open_cursor
where sid in (select sid from
(select sid,serial
from v$session
where status=''''ACTIVE'''')) |
Subquery:
select sid,serial from v$session
where status=''''ACTIVE'''' |
This is the sid of the non-active session.
SQL> desc v $ open_cursor
Name null type
------------------------------------
Saddr raw (4)
SID NUMBER
USER_NAME VARCHAR2 (30)
Address raw (4)
HASH_VALUE NUMBER
SQL _TEXT VARCHAR2 (60)
|
Related Articles]
- How to share the identity space of an Oracle Database
- Understand Oracle database structure components from the inside
- Oracle basic syntax collection
