crate a stats table.sql

on June 23, 2008 at 12:20 pm
Posted In: Oracle DB and SQL performance analysis (Cat)

— cre_stats_tab.sql
— create it owned by oradba in the dbaadmin_dat TS for now.
drop public synonym stattab;
EXEC dbms_stats.create_stat_table(‘SYSTEM’,’CMC_STATS’,’DBAADMIN_DAT’);
create public synonym cmc_stats for system.cmc_stats;
grant all on system.cmc_stats to oradba;
grant all on system.cmc_stats to orasup;