=================================================================================
Below query can be
used to view currently connected sessions in a Oracle DB.
It is useful in
situations where your DB is slow to response and you need to find out what
sessions are exactly causing it.
SELECT
USERNAME,SID,SERIAL#,TERMINAL,LOGON_TIME,STATUS,(SELECT DISTINCT
SQL_TEXT
FROM
SYS.V_$SQL_SHARED_MEMORY WHERE
HASH_VALUE=SQL_HASH_VALUE)
FROM V$SESSION
WHERE STATUS='ACTIVE'
AND
USERNAME IS NOT NULL
************************************************************************
Do you like this post? Please share this article.
HTML Link Code:
1 comments:
excellent work brother.
ReplyPost a Comment