Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Generating AWR Report


SYS>execute dbms_workload_repository.create_snapshot;
SYS>conn scott/tiger
scott>insert into salgrade select * from salgrade;
scott>commit;
SYS>execute dbms_workload_repository.create_snapshot;
SYS>desc dba_hist_snapshot;
SYS>select snap_id,dbid,instance_number from dba_hist_snapshot;
SYS>@$ORACLE_HOME/rdbms/admin/awrrpt.sql
enter value for report_type :
enter value for num_days :
enter value for begin_snap :
enter value for end_snap :
enter value for report_name : awr.html
SYS>exit
oracle@venu1>ls
oracle@venu1>cd /home/oracle
oracle@venu1 oracle>cp awr.html /root/Desktop
oracle@venu1>mozilla

Related Posts Plugin for WordPress, Blogger...

Flag Counter