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