oracle报表文件,Oracle生成标准统计报表

2.1生成标准统计报表

过程并不复杂，下列操作中加粗的部分，是需要指定值的位置(注意，执行报表生成的 用户必须拥有DBA角色)：

JSSWEB> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

Current

Instance

~~~~~~~~~~~~~~~~

DB Id

DB Name

Inst Num Instance

----------- ------------ -------- ------------

3812548755 TEST08

1 test08

Specify

the Report Type

~~~~~~~~~~~~~~~~~~~~~~~

Would you

like an HTML report, or a plain text report?

Enter

'html' for an HTML report, or 'text' for plain text

Defaults

to 'html'

Enter

value for report_type: html

此处需指定生成的报表格式，有txt和html两种选择，默认情况下为html格式，这里 为演示起见，输入html。

Type Specified:html

Instances

in this Workload Repository schema

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

DB Id

Inst Num DB Name

Instance

Host

------------ -------- ------------ ------------

------------

* 3812548755

1 TEST08

test08

yans1

Using 3812548755 for database Id

Using

1 for instance number

Specify

the number of days of snapshots to choose from

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Entering

the number of days (n) will result in the most recent

(n) days of snapshots being listed. Pressing

without specifying a number lists all completed snapshots.