This is not a real database snapshot but set of demo screenshots. Please allow some inaccuracy in numbers and dates.

[02/17/12 05:37:27pm]    Database: rdemo16    Instance: #2 rdemo162    rrac16b.obzora.prv    10.2.0.4.0    Uptime: 10 days 18 hours 20 minutes

Database Info (details)
DB Name rdemo16
DB Unique Name rdemo16
Host rrac16b.obzora.prv
Oracle Version 10.2.0.4.0
 
Database Size (details)
Total 5990G
Data Files 1600G
Temp Files 10G
Archive Logs 1299G
Backups 3051G
Flashback 1G
 
Sessions (details)
Instancerdemo161rdemo162
Total41876
Active3545
User's Active14
On CPU16
Waiting I/O03
Waiting Others02
OS Load 0.3 10.1
CPU Count1616

Instances

## Name Thread# Host Name Version Status RAC
1 rdemo161 1 rrac16a.obzora.prv 10.2.0.4.0 OPEN YES
2 rdemo162 2 rrac16b.obzora.prv 10.2.0.4.0 OPEN YES

Problem Tablespaces

Tablespace Used, MB Allocated, MB Max Extendable, MB % of Max Size # of Files
UNDOTBS02 20000 20000 20000 100.0 10
TXDATA 617415 700000 700000 88.2 70
TXINDX 211847 270000 270000 78.5 27
SYSAUX 1432 2000 2000 71.6 1
UNDOTBS01 24655 36000 36000 68.5 10

Outstanding Alerts

Time Type Group Reason Suggested Action
02/16/2012 05:50:21 am Warning Performance Metrics "Database Time Spent Waiting (%)" is at 49.68856 for event class "Network" Run ADDM to get more performance analysis about your system.
02/15/2012 10:29:21 am Warning Performance Metrics "Current Open Cursors Count" is at 1238 Run ADDM to get more performance analysis about your system.
02/14/2012 01:11:24 pm Warning Space Tablespace [UNDOTBS02] is [98 percent] full Add space to the tablespace
01/29/2012 09:07:47 am Warning Space Tablespace [TXDATA] is [85 percent] full Add space to the tablespace

[an error occurred while processing this directive]