So here are two takes at the problem, one takes a look at costly (in regards
to amount of redo) tables and the other indexes. Note this is only a way to
guestimate this information.
select owner,
table_name,
round((ratio_to_report(ttl) over ()) * 100, 1) as percent_ratio
from (
select (m.inserts+m.deletes+m.updates)*t.avg_row_len ttl,
t.owner,
t.table_name
from dba_tables t,
all_tab_modifications m
where t.table_name=m.table_name
and t.owner=m.table_owner
)
order
by 3 desc;
select owner,
table_name,
round((ratio_to_report(ttl) over ()) * 100, 1) as percent_ratio
from (
select count(*)*sum((m.inserts+m.deletes+m.updates)) ttl,
i.owner,
i.table_name
from all_indexes i,
all_ind_columns c,
all_tab_modifications m
where i.index_name=c.index_name
and i.table_name=c.table_name
and i.owner=m.table_owner
and i.table_name=m.table_name
group
by i.owner,
i.table_name
)
order
by 3 desc;
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Post, Ethan
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
