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¨

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.

Listing the last 2 days of Completed Snapshots

Snap

Instance DB Name Snap Id Snap Started Level

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

test08 TEST08 7330 20 10 月 2009 00:00 1

7331 20 10 月 2009 01:00 1

7332 20 10 月 2009 02:00 1

7333 20 10 月 2009 03:00 1

7334 20 10 月 2009 04:00 1

7335 20 10 月 2009 05:01 1

7336 20 10 月 2009 06:00 1

7337 20 10 月 2009 07:01 1

7338 20 10 月 2009 08:00 1

7339 20 10 月 2009 09:00 1

7340 20 10 月 2009 10:00 1

7341 20 10 月 2009 11:00 1

7342 20 10 月 2009 12:00 1

7343 20 10 月 2009 13:00 1

7344 20 10 月 2009 14:00 1

7345 20 10 月 2009 15:00 1

7346 20 10 月 2009 16:00 1

7347 20 10 月 2009 17:00 1

7348 20 10 月 2009 18:00 1

7349 20 10 月 2009 19:00 1

7350 20 10 月 2009 20:00 1

7351 20 10 月 2009 21:00 1

7352 20 10 月 2009 22:00 1

7353 20 10 月 2009 23:00 1

7354 21 10 月 2009 00:00 1

7355 21 10 月 2009 01:00 1

7356 21 10 月 2009 02:00 1

7357 21 10 月 2009 03:00 1

7358 21 10 月 2009 04:00 1

7359 21 10 月 2009 05:00 1

7360 21 10 月 2009 06:00 1

7361 21 10 月 2009 07:00 1

7362 21 10 月 2009 08:00 1

7363 21 10 月 2009 09:00 1

7364 21 10 月 2009 10:00 1

7365 21 10 月 2009 11:00 1

7366 21 10 月 2009 12:00 1

7367 21 10 月 2009 13:00 1

7368 21 10 月 2009 14:00 1

Specify the Begin and End Snapshot Ids

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

Enter value for begin_snap: 7331

Begin Snapshot Id specified: 7331

Enter value for end_snap: 7355

End Snapshot Id specified: 7355

Specify the Report Name

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

The default report file name is awrrpt_1_7331_7355.html. To use this name,

press to continue, otherwise enter an alternative.

Using the report name awrrpt_1_7331_7355.html

..................

.......................

End of Report

提示：

问：前面提示输入snaps时哪来的这么多snapshots啊？

答：这都是ORACLE偷偷摸摸一点一点(每小时一次)收集的啊！

问：它究竟收集了多久的啊？

答：从当前的记录看，至少有7天了！

问：究竟啥是snapshot啊？