/*
create or replace view DBA_ALL_OBJECT_USAGE
(OWNER
,INDEX_NAME
,TABLE_NAME
,MONITORING
,USED
,START_MONITORING
,END_MONITORING
)
as
select u.name
, io.name
, t.name
, decode(bitand(i.flags, 65536), 0, 'NO', 'YES')
, decode(bitand(ou.flags, 1), 0, 'NO', 'YES')
, ou.start_monitoring
, ou.end_monitoring
from
sys.user$ u
, sys.obj$ io
, sys.obj$ t
, sys.ind$ i
, sys.object_usage ou
where
i.obj# = ou.obj#
and io.obj# = ou.obj#
and t.obj# = i.bo#
and u.user# = io.owner#;

GRANT SELECT ON DBA_ALL_OBJECT_USAGE TO PUBLIC;


*/

BREAK ON OWNER ON TABLE_NAME NODUP

select rownum num,tab.* from
(
select OWNER,TABLE_NAME,INDEX_NAME,MONITORING,USED,START_MONITORING,END_MONITORING
from sys.DBA_ALL_OBJECT_USAGE
WHERE OWNER LIKE upper('&1') AND TABLE_NAME LIKE upper('&2')
order by OWNER,TABLE_NAME,INDEX_NAME
) tab;


