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

Tablespaces

Tablespace
Name
Contents Logging Extent
Management
Allocation
Type
Segment
Management
Retention Big
File
Auto-
extensible
Size, MB Free, MB Free Files
TXDATA PERMANENT LOGGING LOCAL SYSTEM AUTO NOT APPLY NO NO 700000 82585 12% 70
TXHIST PERMANENT LOGGING LOCAL SYSTEM AUTO NOT APPLY NO NO 600000 285699 48% 60
TXHISTIDX PERMANENT LOGGING LOCAL SYSTEM AUTO NOT APPLY NO NO 6000 6000 100% 3
TXINDX PERMANENT LOGGING LOCAL SYSTEM AUTO NOT APPLY NO NO 270000 58152 22% 27
TXMSG PERMANENT LOGGING LOCAL SYSTEM AUTO NOT APPLY NO NO 2000 2000 100% 1
SYSAUX PERMANENT LOGGING LOCAL SYSTEM AUTO NOT APPLY NO NO 2000 568 28% 1
SYSTEM PERMANENT LOGGING LOCAL SYSTEM MANUAL NOT APPLY NO NO 2000 1415 71% 1
TEMP TEMPORARY NOLOGGING LOCAL UNIFORM MANUAL NOT APPLY NO NO 10000 0 0% 5
UNDOTBS01 UNDO LOGGING LOCAL SYSTEM MANUAL NOGUARANTEE NO NO 36000 11345 32% 10
UNDOTBS02 UNDO LOGGING LOCAL SYSTEM MANUAL NOGUARANTEE NO NO 20000 0 0% 10
Total Allocated Size (GB) 1609.38
Total Used (GB) 1172.11
Total Free Space (GB) 437.27




[an error occurred while processing this directive]