Revision [3616]

Last edited on 2010-01-14 06:11:43 by WikiAdmin
Additions:
A bash script to gather inputs and then run the awr report function.
%%(bash)
#!/bin/bash
if [ $# -lt 1 ]; then
echo "Usage:gen-awr.sh "
exit 1
fi
export PATH=/u01/app/oracle/product/10.2.0/db_1/bin:$PATH
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=$3
reportBegin=$1
reportEnd=$2
reportName=AWR-$ORACLE_SID-$reportBegin-$reportEnd.html
reportInst=${ORACLE_SID:6:1}
if [ ${ORACLE_SID:0:6} == "SAFARI" ]; then
reportDbid="3827977577"
dbPwd="xxx"
else
reportDbid="1910233441"
dbPwd="yyy"
fi
sqlplus -S system/$dbPwd@$ORACLE_SID << EOF
set veri off;
set feedback off;
set heading off;
set linesize 1500;
set termout on;
spool $reportName;
select output from table(dbms_workload_repository.AWR_REPORT_HTML( $reportDbid, $reportInst, $reportBegin, $reportEnd, 0));
spool off;
<
Deletions:
%%(sql)
SELECT
output
FROM
TABLE
(dbms_workload_repository.awr_report_text
(1910233441,1,5562,5564 )
);

Revision [3610]

Edited on 2010-01-07 20:41:31 by WikiAdmin
Additions:
===Generate AWR report===
%%(sql)
SELECT
output
FROM
TABLE
(dbms_workload_repository.awr_report_text
(1910233441,1,5562,5564 )
);

Revision [3609]

Edited on 2010-01-07 20:32:47 by WikiAdmin
Additions:
set pagesize 120
set linesize 120
select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "Current Time" from dual;
select 'Last SNAP_ID: ' || max(snap_id) from dba_hist_snapshot;
select 'Last SNAP_ID: ' || max(snap_id) from dba_hist_snapshot;
Deletions:
select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "NOW" from dual;

Revision [3608]

Edited on 2010-01-07 19:25:52 by WikiAdmin
Additions:
If you happens to need to generate AWR snapshots from a script, here's what I did -
export ORACLE_SID=foo
sqlplus -s system/cheap as sysdba << EOF
exit;
EOF

Revision [3607]

Edited on 2010-01-07 19:22:35 by WikiAdmin
Additions:
===Create AWR snapshot===
select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS') as "NOW" from dual;
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;

Revision [139]

Edited on 2007-04-14 21:31:34 by WikiAdmin
Additions:
{{parent page="Oracle"}}

Revision [86]

Edited on 2007-04-14 09:30:12 by WikiAdmin
Additions:
=== Viewing analyze results ===
Deletions:
++ Viewing analyze results

Revision [85]

The oldest known version of this page was created on 2007-04-14 09:30:01 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki