我在ＴＰＵＢ上发现的，我感觉这个脚本确实不错，按一个连接以后能用得着．http://www.itpub.net/thread-1020404-1-2.html

具体做法演示：

[oracle@rac1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 11 15:57:34 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/oracle as sysdba
Connected.
SQL> @dba_snapshot_database_10g.sql

+------------------------------------------------------------------------------- ----------+
|                             Snapshot Database 10g Release 2  |
|------------------------------------------------------------------------------- ----------+
| Copyright (c) 1998-2008 Jeffrey M. Hunter. All rights reserved. (www.idevelopm ent.info) |
+------------------------------------------------------------------------------- ----------+

Creating database report.
This script. must be run as a user with SYSDBA privileges.
This process can take several minutes to complete.

Output written to: dba_snapshot_database_10g_ORCL_20080711.html
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options