SQL> exec plato.Footprint('HTM');
UDEV Database report (Footprint)
The PLATO Package, version 45, build 1046
Report generated on 29-Sep-05 02:29:02
Geert De Paep, http://www.dba-village.com


General Files Storage Rbs/Undo Bckp/reco Problems Tables Jobs/AQ Memory Security Networking Various DBFeatures
v$version
Banner
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Prod
PL/SQL Release 10.1.0.4.0 - Production
CORE 10.1.0.4.0 Production
TNS for Linux: Version 10.1.0.4.0 - Production
NLSRTL Version 10.1.0.4.0 - Production


Instance overview
Id Nr Name Host Startup Status Par Thread Logins
1 1 UDEV dbavdev 27-Sep 17:31:56 OPEN NO 1 ALLOWED

Key parameters
Parameter Value
Database name UDEV
Hostname dbavdev
Version 10.1.0.4.0
nls_characterset AL32UTF8
Block size: 8192


Memory parameters
Parameter Value
Block size: 8192
Shared pool size: 0
Shared pool reserved: 2.5M
Redo log buffer: 256.0K
Large pool size: 0
Java pool size: 0
Sort area size: 64.0K
Sort area retained: 0
Hash area size: 128.0K
Pga aggr target (9i): 16.0M


Various settings
Parameter Value
Service names: UDEV
Db domain:
Uptime (Technologies) 1 Dys 8 Hrs 57 Min
Compatible: 10.1.0.4.0
Optimizer mode: ALL_ROWS
User dump dest: /opt/oracle/admin/UDEV/udump
Backgr dump dest: /opt/oracle/admin/UDEV/bdump
Utl file dir:
Spfile: /opt/oracle/product/10.1.0/db/dbs/spfileUDEV.ora
Undo management: AUTO
Cluster database: FALSE
OS Authent prefix: ops$
DG Broker start: FALSE
Archivelog mode NOARCHIVELOG
Non broken jobs 0
Broken jobs 0

Redolog files
File name Thread Group Size Status
/opt/oracle/oradata/UDEV/redo01.log Thr 1 Grp 1 10.0M
/opt/oracle/oradata/UDEV/redo02.log Thr 1 Grp 2 10.0M
/opt/oracle/oradata/UDEV/redo03.log Thr 1 Grp 3 10.0M


Control Files
/opt/oracle/oradata/UDEV/control01.ctl
/opt/oracle/oradata/UDEV/control02.ctl
/opt/oracle/oradata/UDEV/control03.ctl

Segment size
Segment type Size
TABLE
749.6M
INDEX
453.2M
LOBSEGMENT
380.6M
TEMPORARY
250.0M
LOBINDEX
32.9M
CLUSTER
26.5M
TYPE2 UNDO
14.5M
TABLE PARTITION
9.4M
INDEX PARTITION
9.0M
NESTED TABLE
512.0K
ROLLBACK
384.0K
LOB PARTITION
192.0K
Total 1.8G


File size
File type Size
Datafiles 2.0G
Tempfiles 251.0M
Redolog files 30.0M
Total 2.3G


Number of datafiles
Name Value
Max datafiles in controlfile 100
db_files in init.ora 200
Current nr of data+temp files 7


(c) Geert De Paep, Uptime Technologies, Belgium - http://www.dba-village.com

[This report took 1 seconds]
[Usage: SQL*Plus: "exec plato.help" after "set serveroutput on format wrapped"]

SQL> spool off