ORACLE
오라클 awr 리포트 뽑기
구름너머
2013. 3. 13. 21:50
AWR 구동되도록 하는 명령:
select count(*)
from scott.emp;
select *
from dba_tables
where table_name = 'EMP';
exec
dbms_stats.gather_table_stats(ownname=>'SCOTT',
tabname=>'EMP', estimate_percent=>100,
cascade=>true, degree=>1);
truncate table scott.emp;
select count(*)
from scott.emp;
select *
from dba_tables
where table_name = 'EMP';
------------------------------------------------------
cd $ORACLE_HOME/rdbms/admin/
pwd ==>
/u01/app/oracle/product/10.2.0/db_1/rdbms/admin
sqlplus '/as sysdba'
SQL>@ awrrpt.sql