Hello all,
I am running the following query :-
SELECT a.username, sql_text, executions ,
a.user_id,machine,terminal,program,
a.username,osuser, sid, process,
ROUND(((disk_reads * 100) / DECODE(executions, 0, 1,
executions)))
FROM sys.dba_users a, v$session, v$sqlarea
WHERE parsing_user_id=user_id AND address=sql_address(+)
ORDER BY executions desc
But when I run this query, I dont get the username, user_id, machine, terminal,
program, osuser, sid, process of all records.
Why is this, that is why I get these fields populated in some records and others I
dont get?
Also I am running another query:-
SELECT a.username,osuser, sid, process, serial#,length(sql_text),
sql_text,
executions,
FLOOR(buffer_gets / DECODE(executions, 0, 1, executions))
FROM sys.dba_users a, v$session, v$sqlarea
WHERE parsing_user_id=user_id AND address=sql_address(+)
ORDER BY executions desc
Here also I dont get the username, osuser, sid, process, serial# populated all the
time, Why?
Please help.
Thanks and Regards,
Raja
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Viraj Luthra
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
