Each of the AWR table names is prefixed with wrm$ (Metadata tables), wrh$ (History tables), or wri$ (Advisory tables).
DBA_HIST_*
select table_name from dba_tables where owner = 'SYS' and table_name like 'WR%';
select view_name from dba_views where owner = 'SYS' and view_name like 'DBA\_HIST\_%' escape '\';
Thursday, November 20, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment