www.slite.cz

select owner,object,type,con_id from V$ACCESS 

where owner not in ('SYS','DBSNMP','GSMADMIN_INTERNAL','PUBLIC','SYSTEM','XDB')

group by owner,object,type,con_id 

order by owner, object

select 
 COUNT(*)AS POCET, sss.sid, blk.used_ublk, s.OSUSER, s.MACHINE, s.USERNAME, s.MODULE, s.ACTION, s.SQL_ID, MIN(s.LOGON_TIME), MAX(s.LOGON_TIME)
 from v$session s
 LEFT JOIN
         (
         SELECT ss.SID, ss.SQL_ID
         from v$session SS
         where ss.username IS not NULL
         AND   ss.STATUS = 'ACTIVE'
         AND   ss.PROGRAM IN ('osh.exe', 'uvsh.exe') -- win_server
         ) sss
         ON s.SQL_ID = sss.sql_id
 LEFT JOIN (select p.sid, s.used_ublk from v$transaction s, v$session p where s.addr=p.taddr) blk
 ON blk.sid = sss.sid

where username is not NULL
 AND   s.STATUS = 'ACTIVE'
 GROUP BY sss.sid, blk.used_ublk, s.USERNAME, s.OSUSER, s.MACHINE,s.MODULE, s.ACTION, s.SQL_ID
 order by COUNT(*) DESC, MAX(s.LOGON_TIME) 

select * from ALL_TAB_STATS_HISTORY where table_name='TABLE_NAME'
 order by stats_update_time desc

SELECT b.tablespace,

       ROUND(((b.blocks*p.value)/1024/1024),2)||'M' AS temp_size,

       a.inst_id as Instance,

       a.sid||','||a.serial# AS sid_serial,

       NVL(a.username, '(oracle)') AS username,

       a.OSUSER,

       a.program,

       a.status,

       a.sql_id

FROM   gv$session a,

       gv$sort_usage b,

       gv$parameter p

WHERE  p.name  = 'db_block_size'

AND    a.saddr = b.session_addr

AND    a.inst_id=b.inst_id

AND    a.inst_id=p.inst_id

ORDER BY a.sid||','||a.serial#,b.tablespace, b.blocks

select  nvl(s.username,s.program) username
 ,s.OSUSER
 ,   s.sid sid
 ,   s.serial# serial
 ,   s.sql_hash_value sql_hash_value
 ,   substr(decode(w.wait_time, 0, w.event, 'ON CPU'),1,40) event
 ,   w.P1TEXT,w.p1 p1
 ,   w.P2TEXT,w.p2 p2
 ,   w.P3TEXT,w.p3 p3
 ,   w.WAIT_CLASS
 ,   w.STATE 
from    v$session s
 ,   v$session_wait w
 where   w.sid=s.sid
 and s.status='ACTIVE'
 and s.type='USER'

select
    substr(a.os_user_name,1,15) "OS User",
    substr(a.oracle_username,1,8) "DB User",
    substr(b.owner,1,8) "Schema",
    substr(b.object_name,1,20) "Object Name",
    substr(b.object_type,1,10) "Type",
    substr(c.segment_name,1,15) "RBS",
    substr(d.used_urec,1,12) "# of Records",
    e.sid,
    e.serial#,
    case when a.locked_mode='1' then 'Null'
   when a.locked_mode='2' then 'Concurrent Read'
     when a.locked_mode='3' then 'Concurrent Write'
       when a.locked_mode='4' then 'Protected Read'
         when a.locked_mode='5' then 'Protected Write'
           when a.locked_mode='6' then 'Exclusive'
             else ' '
     end as locked_desc
     ,v.type ,vt.DESCRIPTION as LOCK_INFO /* pro lock info */
    from v$locked_object a,    dba_objects b,    dba_rollback_segs c,    v$transaction d,    v$session e    ,v$lock v, V$LOCK_TYPE vt  /* pro lock info */ 
where
    a.object_id = b.object_id
 and
    a.xidusn = c.segment_id
 and
    a.xidusn = d.xidusn
 and
    a.xidslot = d.xidslot
 and
    d.addr = e.taddr 
and v.sid=e.sid and v.type=vt.type /* pro lock info */ 
group by a.os_user_name,a.oracle_username,b.owner,b.object_name,b.object_type,c.segment_name,d.used_urec,e.sid,
    e.serial#,a.locked_mode,v.type ,vt.DESCRIPTION
    order by object_name