Recent site activity

Oracle IO by Object Advanced



CNT AAS EVENT           OBJ                P1 TABLESPACE_NAME
--- --- --------------- ----------------- --- ---------------
  1 .02 db file sequent ORDER_ITEMS_PK      7 SOEINDEX
  1 .02 db file sequent 0                   3 SYSAUX
  2 .03 db file scatter WAIT_OBJECTS        1 SYSTEM
  2 .03 db file sequent ORDER_ITEMS         6 SOE
  3 .05 db file sequent CUST_EMAIL_IX       7 SOEINDEX
  4 .07 db file sequent CUST_LNAME_IX       7 SOEINDEX
  6 .10 db file sequent ORD_ORDER_DATE_IX   7 SOEINDEX
 13 .22 db file sequent ITEM_ORDER_IX       7 SOEINDEX
 25 .42 db file sequent 0                   2 UNDOTBS1



col block_type for a18
col obj for a20
col otype for a15
col event for a15
col blockn for 999999
col f_minutes new_value v_minutes
col p1 for 9999
col tablespace_name for a15
select &minutes f_minutes from dual;
select
       io.cnt cnt,
       io.aas aas,
       io.event event,
       substr(io.obj,1,20) obj,
       io.p1 p1,
       f.tablespace_name tablespace_name
from 
(
  select
        count(*) cnt,
        round(count(*)/(&v_minutes*60),2) aas,
        substr(event,0,15) event, 
        nvl(o.object_name,decode(CURRENT_OBJ#,-1,0,CURRENT_OBJ#)) obj,
        ash.p1, 
        o.object_type otype
   from v$active_session_history ash,
        all_objects o
   where ( event like 'db file s%' or event like 'direct%' )
      and o.object_id (+)= ash.CURRENT_OBJ#
      and sample_time > sysdate - &v_minutes/(60*24)
   group by 
       substr(event,0,15) , 
       CURRENT_OBJ#, o.object_name ,
       o.object_type ,
       ash.p1
) io,
  dba_data_files f
where
   f.file_id = io.p1
Order by io.cnt
/



Comments