Processes running on the bench

[bride]

How do you know which processes turning on the bank in the bank?

[Flavio.Moreira]

Select all

SELECT NVL(s.username, '(oracle)') AS username, 
       s.osuser, 
       s.sid, 
       s.serial#, 
       p.spid, 
       s.lockwait, 
       s.status, 
       s.module, 
       s.machine, 
       s.program, 
       TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time 
FROM   v$session s, 
       v$process p 
WHERE  s.paddr  = p.addr 
AND    s.status = 'ACTIVE' 
ORDER BY s.username, s.osuser;

[madmax]

Hello Chara.

has this script that you are covering see the select, update, delete etc ... Running at the very moment.

Select all

select sql_text, object_status, first_load_time, username, sid, lockwait  
  from v$session ses, v$sql sql  
 where ses.sql_id = sql.sql_id 

I hope I have helped.

[Itimura]

There is one that I use to know the processes that are active and taking a little to be completed

Select all

SELECT SID, 
       SERIAL#, 
       START_TIME, 
       ((SOFAR/TOTALWORK)*100),'%', 
       MESSAGE  
  FROM V$SESSION_LONGOPS  
  where TIME_REMAINING > 0 ORDER BY start_time;

[gleisoncandido]

Ola,
also has this script below to know which tables are being used:

Select all

SELECT b.session_id AS sid, 
       NVL(b.oracle_username, '(oracle)') AS username, 
       a.owner AS object_owner, 
       a.object_name, 
       Decode(b.locked_mode, 0, 'None', 
                             1, 'Null (NULL)', 
                             2, 'Row-S (SS)', 
                             3, 'Row-X (SX)', 
                             4, 'Share (S)', 
                             5, 'S/Row-X (SSX)', 
                             6, 'Exclusive (X)', 
                             b.locked_mode) locked_mode, 
       b.os_user_name 
FROM   dba_objects a, 
       v$locked_object b 
WHERE  a.object_id = b.object_id 
ORDER BY 1, 2, 3, 4;