Please Help - user details of the sql statement being run not being found

From: Viraj Luthra <viraj999_at_lycos.com>
Date: Wed, 28 Nov 2001 21:54:49 -0800
Message-ID: <F001.003CFF00.20011128201522@fatcity.com>

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: viraj999_at_lycos.com

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: ListGuru_at_fatcity.com (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). Received on Wed Nov 28 2001 - 23:54:49 CST