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


General Files Storage Rbs/Undo Bckp/reco Problems Tables Jobs/AQ Memory Security Networking Various DBFeatures

General Database Information top

Important parameters
Parameter Value
Database name TRU817
Instance name TRU817
Hostname trudba.iconos.be
Service names: TRU817
Db domain:
Db Created 08-Dec-2003
Startup time 28-sep-2005, 13:53
Uptime (Technologies) 1 Dys 7 Hrs 58 Min
Version 8.1.7.4.0
Banner version 8.1.7.4.0
Compatible: 8.1.0
nls_language AMERICAN
nls_territory AMERICA
nls_characterset WE8ISO8859P1
nls_date_format dd-Mon, hh24:mi:ss
Block size: 4096
Sga target: Unexistant
Shared pool size: 24.0M
Shared pool reserved: 1.2M
Large pool size: 600.0K
Buffer cache 7.8M
Db cache size (9i): Unexistant
Redo log buffer: 160.0K
Java pool size: 32.0K
Sort area size: 64.0K
Sort area retained: 64.0K
Hash area size: 128.0K
Pga aggr target (9i): Unexistant
Workarea size policy: Unexistant
Optimizer mode: CHOOSE
Restricted logins ALLOWED
User dump dest: /u03/admin/TRU817/udump
Backgr dump dest: /u03/admin/TRU817/bdump
Utl file dir:
Spfile: Unexistant
Archivelog mode ARCHIVELOG


SGA Distribution
Pool Size Pct
Total SGA
36.1M 100%
Shared pool
27.5M 76.1%
Buffer cache
7.8M 21.6%
Large pool
600.0K 1.6%
Log buffer
160.0K .4%
Fixed SGA
81.1K .2%
Java pool
32.0K .1%

Database Statistics
Name Value
Library Cache Hit Ratio (%) 99.71
Rowcache Hit Ratio (%) 3.56
Buffer Cache Hit Ratio (%) 90.84
Redo log space requests 58
Buffer gets (logical) since startup 487753
Buffer gets (logical) (avg/sec) 4.2
Physical IO (rds+wrts) since startup 54662
Physical IO (rds+wrts) (avg/sec) .4

System statistics
Name Value
table scans (short tables) 886
table scans (long tables) 312
table scan rows gotten 312672
table scan rows gotten (avg/sec) 2.71
table scan blocks gotten 79108
table fetch by rowid 31015
table fetch by rowid (avg/sec) .26
table fetch continued row 188
sorts (memory) 2453
sorts (disk) 5
sorts (rows) 56054
sort_area_size 65536
sort_area_retained_size 65536
enqueue waits 10
enqueue deadlocks 0
enqueue requests 5076
timed_statistics FALSE
timed_os_statistics 0
sql_trace FALSE
cursor_sharing EXACT

Instance overview
Id Nr Name Host Startup Status Par Thread Logins
1 1 TRU817 trudba.iconos.be 28-Sep 13:53:13 OPEN NO 1 ALLOWED


File Information top

Redolog files
File name Thread Group Size Status
/u03/oradata/TRU817/redo01.log Thr 1 Grp 1 1000.0K
/u03/oradata/TRU817/redo02.log Thr 1 Grp 2 1000.0K
/u03/oradata/TRU817/redo03.log Thr 1 Grp 3 1000.0K


Control Files
/u03/oradata/TRU817/control01.ctl
/u03/oradata/TRU817/control02.ctl
/u03/oradata/TRU817/control03.ctl

Tablespaces and datafiles
TsName TS size Used AutoExt MaxSize %AutoMax TsStat Filename Tp Filesize Aut Ext FileMax
DICT_FULL 5.0M
3.8M (76%)
5.0M
76
OFFL /u03/oradata/TRU817/dict_full.dbf D 5.0M NO
LMS_AUTO_FULL 6.0M
4.8M (81%)
6.0M
81
ONL /u03/oradata/TRU817/lms_auto_full.dbf D 6.0M NO
LMS_FULL 10.0M
9.2M (93%)
10.0M
93
ONL /u03/oradata/TRU817/lms_full.dbf D 10.0M NO
RBS 145.0M
12.0M (8%)
15.9G
0
ONL /u03/oradata/TRU817/rbs01.dbf D 145.0M YES 15.9G
SYSTEM 260.0M
49.5M (19%)
15.9G
0
ONL /u03/oradata/TRU817/system01.dbf D 260.0M YES 15.9G
TEMP 15.0M
256.0K (2%)
15.9G
0
ONL /u03/oradata/TRU817/temp01.dbf D 15.0M YES 15.9G
TEMP2 6.0M
6.0M (100%)
10.0M
60
ONL /u03/oradata/TRU817/temp201.dbf T 6.0M YES 10.0M
TSOFFLINE 100.0K
4.0K (4%)
100.0K
4
ONL /u03/oradata/TRU817/tsoffline.dbf D 100.0K NO
TSRECOVER 200.0K
8.0K (4%)
200.0K
4
ONL /u03/oradata/TRU817/tsrecover.dbf D 100.0K NO
/u03/oradata/TRU817/tsrecover2.dbf D 100.0K NO
USERS 150.0M
107.5M (72%)
150.0M
72
ONL /u03/oradata/TRU817/users01.dbf D 150.0M NO

Segment size
Segment type Size
TABLE
112.2M
INDEX
57.2M
ROLLBACK
12.8M
CLUSTER
2.8M
LOBINDEX
752.0K
LOBSEGMENT
752.0K
TEMPORARY
256.0K
TEMPORARY
256.0K
DEFERRED ROLLBACK
64.0K
CACHE
4.0K
Total 187.2M


File size
File type Size
Datafiles 586.2M
Tempfiles 6.0M
Redolog files 2.9M
Total 595.2M


Offline datafiles
Filename Status
/u03/oradata/TRU817/dict_full.dbf OFFLINE
/u03/oradata/TRU817/tsrecover2.dbf RECOVER

Files in hot backup
Filename
No files are in hot backup


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


Storage parameters and file statistics top

Tablespace storage parameters
TablespaceName Init Next Min Max Pct MinExtLen Stat Cont Mgmt AllocType Log
DICT_FULL 256.0K 256.0K 1 249 0 0 PERM DICT USER LOG
LMS_AUTO_FULL 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG
LMS_FULL 256.0K 256.0K 1 Unlim 0 256.0K ONL PERM LOCA UNIFORM LOG
RBS 512.0K 512.0K 8 4096 50 512.0K ONL PERM DICT USER LOG
SYSTEM 64.0K 64.0K 1 Unlim 50 64.0K ONL PERM DICT USER LOG
TEMP 64.0K 64.0K 1 Unlim 0 64.0K ONL TEMP DICT USER LOG
TEMP2 1.0M 1.0M 1 Unlim 0 1.0M ONL TEMP LOCA UNIFORM NOL
TSOFFLINE 20.0K 20.0K 1 249 50 0 ONL PERM DICT USER LOG
TSRECOVER 20.0K 20.0K 1 249 50 0 ONL PERM DICT USER LOG
USERS 128.0K 128.0K 1 4096 0 4.0K ONL PERM DICT USER LOG

Datafile IO since startup (top 25)
Filename PhyRds PhyWrts PhyBlkrd PhyBlkWrt Blks/Rd R+W/sec
/u03/oradata/TRU817/system01.dbf
9229
4735
44153 4735 4.78 .12
/u03/oradata/TRU817/rbs01.dbf
46
4827
46 4827 1 .04
/u03/oradata/TRU817/temp01.dbf
89
249
251 249 2.82 0
/u03/oradata/TRU817/lms_full.dbf
49
37
49 37 1 0
/u03/oradata/TRU817/lms_auto_full.dbf
47
37
47 37 1 0
/u03/oradata/TRU817/users01.dbf
39
37
39 37 1 0
/u03/oradata/TRU817/tsrecover.dbf
39
37
39 37 1 0
/u03/oradata/TRU817/tsoffline.dbf
39
37
39 37 1 0
/u03/oradata/TRU817/temp201.dbf
4
0
4 0 1 0
/u03/oradata/TRU817/dict_full.dbf
0
0
0 0 0 0
/u03/oradata/TRU817/tsrecover2.dbf
0
0
0 0 0 0

Segment size by owner and tablespace
Owner\TsName DICT_FULL LMS_AUTO_FULL LMS_FULL RBS SYSTEM TEMP USERS
LOBOVERLINK 0 0 0 0 0 0 128.0K
NAGIOS 0 0 0 0 0 0 640.0K
ORAPROBE 0 0 0 0 0 0 128.0K
OUTLN 0 0 0 0 60.0K 0 0
PANDORA 0 0 0 0 0 0 3.7M
PERFSTAT 0 0 0 0 0 0 90.8M
SCOTT 0 1.8M 5.2M 0 0 0 12.1M
SYS 3.8M 3.0M 3.7M 12.0M 46.3M 256.0K 0
SYSTEM 0 0 0 0 3.1M 0 0
Note: values bigger than 10% of total are highlighted

Users's temporary tablespaces
TsName Size Init Next Min Nr Ext Min_ext Max_ext Pct_inc Mgmt AllocType Max poss ext Cont
TEMP 15.0M 64.0K 64.0K 64.0K 1 Unlim 0 DICT USER 240 TEMP
Excluding users SYS, SYSTEM, DRSYS, DBSNMP and OUTLN


Rollback segment information top

Rollback Segments
RbsName TsName Size Owner Init Next MinExt MaxExt OptSize Stat
SYSTEM SYSTEM 716.0K SYS 52.0K 52.0K 2 249 ONL
R00 SYSTEM SYS 64.0K 64.0K 2 32765 OFF
RBS0 RBS 3.9M PUBLIC 512.0K 512.0K 8 4096 4.0M ONL
RBS1 RBS 3.9M PUBLIC 512.0K 512.0K 8 4096 4.0M ONL
RBS2 RBS 3.9M PUBLIC 512.0K 512.0K 8 4096 4.0M ONL


Rollback Segment statistics
RbsName Size OptSize HwmSize Extnt Extnd Shrnk Wraps Wait%
SYSTEM 716.0K 716.0K 12 0 0 0 0
RBS0 3.9M 4.0M 3.9M 8 0 0 29 0
RBS1 3.9M 4.0M 3.9M 8 0 0 0 0
RBS2 3.9M 4.0M 3.9M 8 0 0 8 0
Note: online rollback segments only

Related init.ora
Parameter Value
rollback_segments:
undo_management: Unexistant
undo_tablespace: Unexistant
undo_retention: Unexistant



Backup and recovery top

Recent redolog activity
Time Thr MinSeq# MaxSeq# #LogSwitches ArchivedSize
Wed 28-sep-2005 1 1970 2001 32
31.2M
Thu 29-sep-2005 1 2002 2008 7
6.8M


Redolog information
Group Members Size Status
Group 1 1 1000.0K ACTIVE
Group 2 1 1000.0K CURRENT
Group 3 1 1000.0K INACTIVE

Archivelog settings
Parameter Value
Archivelog mode ARCHIVELOG
log_archive_start TRUE
log_archive_dest_1 location=/u03/oradata/TRU817/archive
log_archive_max_processes 1
log_archive_min_succeed_dest 1
log_archive_trace 0
log_archive_format arc_%s.log

Standby related init.ora
Parameter Value
standby_archive_dest: ?/dbs/arch


Possible storage problems top

Tables where 4 next extents will not fit
Owner Segment SegSize Can allocate... TsName Allocation Initial Next PctInc Next1 Next2 Next3 Next4
SYS TAB_LMS_AUTO_FULL 3.0M no more extents!!! LMS_AUTO_FULL Local system 1.0M 1.0M 1.0M 1.0M 1.0M
SCOTT TESTALLOC4 960.0K 1 more extent LMS_AUTO_FULL Local system 952.0K 64.0K 1.0M 1.0M 1.0M
SCOTT TESTALLOC6 896.0K 2 more extents LMS_AUTO_FULL Local system 852.0K 64.0K 64.0K 1.0M 1.0M
SYS TAB_LMS_FULL 3.7M 3 more extents LMS_FULL Local uniform 3.7M 256.0K 0 256.0K 256.0K 256.0K 256.0K
SCOTT TESTALLOC2 256.0K 3 more extents LMS_FULL Local uniform 100.0K 256.0K 0 256.0K 256.0K 256.0K 256.0K
SCOTT TESTALLOC5 4.0M 3 more extents LMS_FULL Local uniform 4.0M 256.0K 0 256.0K 256.0K 256.0K 256.0K
SCOTT TESTALLOC3 1.0M 3 more extents LMS_FULL Local uniform 952.0K 256.0K 0 256.0K 256.0K 256.0K 256.0K

Tables within 5 of their max extents
Owner Name Type TsName Xtnts MaxXtnts Size Init Next Pct
SCOTT VEEL_EXTENTS TABLE USERS 1234 1236 5.4M 8.0K 4.0K 0

Segments of SYS, top 10 by nr of extents
Name Type TsName Xtnts Size Init Next Pct
SOURCE$ TABLE SYSTEM 63 15.4M 12.0K 200.0K 0
IDL_UB1$ TABLE SYSTEM 34 4.1M 12.0K 100.0K 0
IDL_UB2$ TABLE SYSTEM 27 3.1M 12.0K 100.0K 0
TAB_DICT_FULL TABLE DICT_FULL 15 3.8M 256.0K 256.0K 0
SYSTEM ROLLBACK SYSTEM 12 720.0K 52.0K 52.0K 0
VIEW$ TABLE SYSTEM 11 1.0M 12.0K 100.0K 0
ARGUMENT$ TABLE SYSTEM 10 1.1M 12.0K 100.0K 0
C_OBJ# CLUSTER SYSTEM 9 1.8M 132.0K 200.0K 0
I_COL1 INDEX SYSTEM 8 768.0K 32.0K 100.0K 0
I_ARGUMENT1 INDEX SYSTEM 8 880.0K 12.0K 100.0K 0
Note: top10, dictionary managed tablespaces only

Segments non-SYS, top 10 by nr of extents
Owner Name Type TsName Xtnts Size Init Next MaxExt Pct
SCOTT VEEL_EXTENTS TABLE USERS 1234 5.4M 8.0K 4.0K 1.2K 0
PERFSTAT STATS$SQL_SUMMARY_PK INDEX USERS 162 21.1M 1.0M 128.0K 4.0K 0
PERFSTAT STATS$SQL_SUMMARY TABLE USERS 157 20.5M 1.0M 128.0K 4.0K 0
PERFSTAT STATS$PARAMETER_PK INDEX USERS 18 2.1M 64.0K 128.0K 4.0K 0
PERFSTAT STATS$SYSSTAT_PK INDEX USERS 16 2.8M 1.0M 128.0K 4.0K 0
PERFSTAT STATS$LATCH_MISSES_SUMMARY_PK INDEX USERS 13 1.5M 64.0K 128.0K 4.0K 0
PERFSTAT STATS$SQLTEXT_PK INDEX USERS 10 1.1M 64.0K 128.0K 4.0K 0
PERFSTAT STATS$LATCH_PK INDEX USERS 7 1.7M 1.0M 128.0K 4.0K 0
SCOTT TESTALLOC12 TABLE USERS 3 1.5M 500.0K 500.0K 4.0K 0
SCOTT TESTALLOC11 TABLE USERS 2 2.0M 1.0M 1.0M 4.0K 0
Note: top 10, dictionary managed tablespaces only

Invalid objects
Owner\ObjType
Note: User SYS is excluded

Overview index types
Owner\IndType LOB NORMAL
DBSNMP 0 2
NAGIOS 0 2
OUTLN 0 3
PANDORA 1 13
PERFSTAT 0 31
SCOTT 0 1
Note: users SYS and SYSTEM are excluded

Init.ora
Query rewrite enabled?: FALSE

Non-SYS objects in SYSTEM tablespace
Owner Name Type Size
SYS R00 ROLLBACK 128.0K

System tablespace fragmentation
Start BlockNr Size
12687 210.4M
Note: Listing top 10 biggest free extents
Nr free extents in SYSTEM tablespace: 1
Avg size of free extent in SYSTEM tablespace: 210.4M

Permanent objects in temporary tablespace
TsName Owner SegType NrSeg
There are no permanent objects in temporay tablespaces


Table properties top

Init.ora
Optimizer mode: CHOOSE

Analyzed objects general
Class Nr Tables
Analyzed 6
Non Analyzed 64


Analyzed: owner vs month
Owner\Month 2004-06 2004-09
DBSNMP 0 0 2
LOBOVERLINK 0 0 1
NAGIOS 1 0 2
ORAPROBE 0 0 1
OUTLN 2 0 0
PANDORA 0 0 15
PERFSTAT 0 0 31
SCOTT 5 0 14
SYS 167 0 25
SYSTEM 14 1 1
Note: empty month means: not analyzed


Analyzed: owner vs week
Owner\Week
Note: only analyzed tables
Last 10 weeks only

Analyzed and monitored tables by owner
Owner Analyzed Non Anal. Monitoring Non Monit.
DBSNMP 0 0 0 2
LOBOVERLINK 0 1 0 1
NAGIOS 1 2 0 3
ORAPROBE 0 1 0 1
OUTLN 0 0 0 2
PANDORA 0 15 0 15
PERFSTAT 0 31 0 31
SCOTT 5 14 0 19
SYS 0 0 0 192
SYSTEM 0 0 0 16


Non analyzed tables
Owner Name Created
Skipping, too many tables (64)

Analyzed tables with non-analyzed indexes
Owner Tablename Nr indexes

More than 5% chained rows
Owner Tablename Num rows Chained Pct LastAnalzd AvgRowLen Rows*Len
SYS IDL_UB1$ 1052 214 20 23-jun-04 2386 2.3M
SYS IDL_UB2$ 1103 145 13 23-jun-04 1809 1.9M


Largest segments
Owner Segment Type TsName Size
PERFSTAT STATS$SQL_SUMMARY_PK INDEX USERS 21.1M
PERFSTAT STATS$SQL_SUMMARY TABLE USERS 20.5M
SYS SOURCE$ TABLE SYSTEM 15.4M
SCOTT VEEL_EXTENTS TABLE USERS 5.4M
PERFSTAT STATS$SQLTEXT TABLE USERS 5.0M
SYS IDL_UB1$ TABLE SYSTEM 4.1M
SCOTT TESTALLOC5 TABLE LMS_FULL 4.0M
SYS RBS0 ROLLBACK RBS 4.0M
SYS RBS1 ROLLBACK RBS 4.0M
SYS RBS2 ROLLBACK RBS 4.0M
SYS TAB_DICT_FULL TABLE DICT_FULL 3.8M
SYS TAB_LMS_FULL TABLE LMS_FULL 3.7M
SYS IDL_UB2$ TABLE SYSTEM 3.1M
SYS TAB_LMS_AUTO_FULL TABLE LMS_AUTO_FULL 3.0M
PERFSTAT STATS$SYSSTAT_PK INDEX USERS 2.8M



Largest tables
Owner Table TsName Rows UsedBlocks Size Last Anal
SYS SOURCE$ SYSTEM 41267 3686 14.3M 23-Jun-2004
SYS COL$ SYSTEM 14534 394 1.5M 23-Jun-2004
SYS ARGUMENT$ SYSTEM 12925 244 976.0K 23-Jun-2004
SYS DEPENDENCY$ SYSTEM 5006 57 228.0K 23-Jun-2004
SYS ACCESS$ SYSTEM 4459 72 288.0K 23-Jun-2004
SYS COM$ SYSTEM 3629 57 228.0K 23-Jun-2004
SYS OBJ$ SYSTEM 3104 62 248.0K 23-Jun-2004
SYS OBJAUTH$ SYSTEM 1438 10 40.0K 23-Jun-2004
SYS IDL_SB4$ SYSTEM 1374 123 492.0K 23-Jun-2004
SYS IDL_UB2$ SYSTEM 1103 651 2.5M 23-Jun-2004
SYS IDL_UB1$ SYSTEM 1052 906 3.5M 23-Jun-2004
SYS SYN$ SYSTEM 964 10 40.0K 23-Jun-2004
SYS CCOL$ SYSTEM 901 22 88.0K 23-Jun-2004
SYS CON$ SYSTEM 871 10 40.0K 23-Jun-2004
SYS CDEF$ SYSTEM 870 22 88.0K 23-Jun-2004
Note: based on num_rows of analyze statistics

Unused space
Owner Table TsName EffData TotAlloc AboveHwm Unused %Unused PctFree Extnts Analyzed
SCOTT EMP USERS 4.0K 128.0K 120.0K 124.0K
97
10 1 23-jun-04
SCOTT DEPT USERS 4.0K 128.0K 120.0K 124.0K
97
10 1 23-jun-04
SCOTT DUMMY USERS 20.0K 128.0K 120.0K 108.0K
84
10 1 23-jun-04
SYSTEM AQ$_QUEUE_TABLES SYSTEM 4.0K 64.0K 56.0K 60.0K
94
10 1 23-jun-04
SYSTEM AQ$_QUEUES SYSTEM 4.0K 64.0K 56.0K 60.0K
94
10 1 23-jun-04
Note: based on results of analyze statistics
EffData = num_rows * avg_row_len
TotAlloc = total allocated in tablespace (i.e. segment size)
AboveHwm = empty_blocks (blocks that never contained data)
Unused = TotAlloc-EffData
%Unused = (TotAlloc-EffData)/TotAlloc * 100

Nr partitioned tables by owner and type
Type\Owner

Temporary tables
Owner TableName TsName Duration
SCOTT ABCDEFGHIJKLMNOPQRSTUVWXYZ SYS$TRANSACTION
DBSNMP MGMT_DB_FILE_GTT SYS$TRANSACTION
DBSNMP MGMT_DB_SIZE_GTT SYS$TRANSACTION
Note: excluding user SYS


Tables with CACHE
Owner TableName

Tables by degree
Degree NrTables
1 282

Related init.ora
Parameter Value
parallel_max_servers: 5
parallel_min_servers: 0
parallel_threads_per_cpu: 2
parallel_adaptive_multi_user: FALSE
parallel_automatic_tuning: FALSE
cpu_count: 1

Index organized tables
Owner TableName TsName Type IndexName
Note: excluding users SYS,SYSMAN,CTXSYS,WMSYS

Nested tables
Owner TableName Type Owner Type Name Parent table Parent column
Note: excluding users SYS,SYSMAN,CTXSYS,WMSYS

Materialized views
Owner Name Mode Method Built Master link Upd? Rewr? Last refr Stale State


Jobs and AQ information top

DBMS Job information
Job Schema Last date This date Next date Brkn Fail What
1 SCOTT 20-07-2004 15:56:31 N begin null; end;

Job queue parameters
Security parameters Value
job_queue_processes: 0
job_queue_interval: 60

Advanced queues
Owner Queue QueueTable Comment

AQ parameters
Parameter Value
aq_tm_processes: 0


Memory information top

SGA Memory
Parameter shared_pool_size: 24.0M
Parameter shared_pool_reserved_size: 1.2M
Parameter large_pool_size: 600.0K
Parameter java_pool_size: 32.0K

SGA Statistics
Pool Name Value Bytes
fixed_sga 81.1K 83076
db_block_buffers 7.8M 8192000
log_buffer 160.0K 163840
shared pool free memory 5.7M 5987936
shared pool PL/SQL MPCODE 707.0K 724008
shared pool dictionary cache 766.6K 785072
shared pool library cache 2.7M 2888368
shared pool sql area 11.0M 11536560
large pool free memory 600.0K 614400
java pool free memory 32.0K 32768


PGA Memory
Parameter sort_area_size: 65536
Parameter sort_area_retained_size: 65536
Parameter hash_area_size: 131072
Parameter pga_aggregate_target: Unexistant
Parameter workarea_size_policy: Unexistant

Buffer cache contents
Owner Name Size
SYS C_OBJ# 1.6M
SYS SOURCE$ 1.3M
SYS IDL_UB1$ 596.0K
SYS OBJ$ 272.0K
SYS I_OBJ2 192.0K
SYS C_FILE#_BLOCK# 176.0K
SYS I_SOURCE1 176.0K
SYS VIEW$ 156.0K
SYS I_DEPENDENCY2 132.0K
SYS I_DEPENDENCY1 100.0K
SYS HIST_HEAD$ 88.0K
SYS IDL_SB4$ 72.0K
SYS DEPENDENCY$ 64.0K
SYS C_COBJ# 60.0K
SYS I_ACCESS1 56.0K
SYS C_TS# 52.0K
SYS I_OBJ1 52.0K
SYS I_HH_OBJ#_INTCOL# 48.0K
SYS IDL_CHAR$ 44.0K
SYS I_IDL_CHAR1 40.0K
SYS I_IDL_UB11 40.0K
SYS I_IDL_SB41 40.0K
SYS C_USER# 32.0K
SYS I_OBJ# 32.0K
SYS IDL_UB2$ 32.0K
Note: top 25 only

Cache sizes
Name Value
Block size 4096
db_cache_size: Unexistant
db_block_buffers: 1.9K


Buffer pool usage
Buffer pool NrObj
DEFAULT 580

Parameter Value
pga_aggregate_target: Unexistant


Security top

Overview users
Username DefTs TempTs Created NrSeg TotSize OPS$ ? Account DBA ?
SYS SYSTEM TEMP 08-Dec-2003 400 69.1M No open Yes
SYSTEM SYSTEM TEMP 08-Dec-2003 51 3.1M No open Yes
OUTLN SYSTEM SYSTEM 08-Dec-2003 5 60.0K No open No
DBSNMP SYSTEM SYSTEM 08-Dec-2003 0 0 No open No
TRACESVR SYSTEM SYSTEM 08-Dec-2003 0 0 No open No
NAGIOS USERS SYSTEM 20-Jan-2004 5 640.0K No open No
SCOTT USERS TEMP 19-Apr-2004 19 19.1M No open No
ORACLE SYSTEM SYSTEM 11-Jun-2004 0 0 Yes open No
PERFSTAT USERS TEMP 12-Oct-2004 62 90.8M No open No
ORAPROBE USERS TEMP 14-Nov-2004 1 128.0K No open No
PANDORA USERS TEMP 25-Nov-2004 30 3.7M No open No
LOBOVERLINK USERS TEMP 27-Jul-2005 1 128.0K No open No

Security parameters
Security parameters Value
remote_login_passwordfile: EXCLUSIVE
remote_os_authent: FALSE
os_authent_prefix:


Networking top

Multi Threaded Server info
Parameter mts_dispatchers:
Parameter dispatchers: Unexistant
Parameter mts_servers: 0
Parameter shared_servers: Unexistant


MTS Connections (v$circuit)
Nr connections 0

Dispatchers
Name Network Status Accept Messages Bytes Idle Busy

Shared servers
Name Status Messages Bytes Idle Busy

Queues
Name Wait TotalQ Pct wait Queued
Note: Expressed in hundreths of a second


Various top

v$version
Banner
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for DEC OSF/1 AXP: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production


Featured init.ora parameters
Parameter Dflt? Value
background_dump_dest FALSE /u03/admin/TRU817/bdump
compatible FALSE 8.1.0
control_files FALSE /u03/oradata/TRU817/control01.ctl, /u03/oradata/TRU817/control02.ctl,
/u03/oradata/TRU817/control03.ctl
core_dump_dest FALSE /u03/admin/TRU817/cdump
db_block_buffers FALSE 2000
db_block_size FALSE 4096
db_name FALSE TRU817
instance_name FALSE TRU817
java_pool_size FALSE 32768
large_pool_size FALSE 614400
local_listener FALSE listener_TRU817.iconos.be
log_archive_dest_1 FALSE location=/u03/oradata/TRU817/archive
log_archive_format FALSE arc_%s.log
log_archive_start FALSE TRUE
log_buffer FALSE 163840
log_checkpoint_interval FALSE 10000
log_checkpoint_timeout FALSE 1800
max_enabled_roles FALSE 30
open_cursors FALSE 300
os_authent_prefix FALSE
processes FALSE 150
remote_login_passwordfile FALSE EXCLUSIVE
service_names FALSE TRU817
shared_pool_size FALSE 25217574
sort_area_retained_size FALSE 65536
sort_area_size FALSE 65536
sql_trace TRUE FALSE
timed_os_statistics TRUE 0
timed_statistics TRUE FALSE
user_dump_dest FALSE /u03/admin/TRU817/udump
utl_file_dir TRUE
Note: taking all non default parameters + some important ones

Hidden parameters
Name Description Instance value


Database Features top

Java stored procedures
Username Nr

Materialized views
Username Nr

Refresh groups
Owner Nr

Advanced queues
Username Nr
SYSTEM 4

Clusters (non SYS)
Username Nr

Domain indexes
Username Nr

Dimensions
Username Nr

Partitioned tables
Username Nr Type


Database links
Username Nr
LOBOVERLINK 1

Directories
Username Nr

Libraries
Username Nr
SYS 20

Stored outlines
Username Nr

FGAC / VPD
Object owner Nr

Object types (non-SYS)
Owner Nr
PANDORA 7


Resource plans
Plan
SYSTEM_PLAN

Database event triggers
Username Nr Event

Audit options
Type Username Nr

Contexts
Nr created 0


Script to recreate the controlfile top

CREATE CONTROLFILE script
CREATE CONTROLFILE REUSE DATABASE "TRU817" RESETLOGS ARCHIVELOG
-- CREATE CONTROLFILE REUSE SET DATABASE "NEW_DB_NAME" RESETLOGS ARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 904
LOGFILE
GROUP 1 ('/u03/oradata/TRU817/redo01.log') SIZE 1000K,
GROUP 2 ('/u03/oradata/TRU817/redo02.log') SIZE 1000K,
GROUP 3 ('/u03/oradata/TRU817/redo03.log') SIZE 1000K
DATAFILE
'/u03/oradata/TRU817/system01.dbf',
'/u03/oradata/TRU817/rbs01.dbf',
'/u03/oradata/TRU817/temp01.dbf',
'/u03/oradata/TRU817/users01.dbf',
'/u03/oradata/TRU817/lms_full.dbf',
'/u03/oradata/TRU817/lms_auto_full.dbf',
'/u03/oradata/TRU817/tsoffline.dbf',
'/u03/oradata/TRU817/tsrecover.dbf',
'/u03/oradata/TRU817/tsrecover2.dbf'
CHARACTER SET WE8ISO8859P1
;
-- Take files offline to match current control file:
ALTER DATABASE DATAFILE '/u03/oradata/TRU817/tsrecover2.dbf' OFFLINE;
-- Files in normal offline tablespaces are now named:
ALTER DATABASE RENAME FILE 'MISSING00005' TO '/u03/oradata/TRU817/dict_full.dbf';
-- Commands to add tempfiles to temporary tablespaces:
ALTER TABLESPACE TEMP2 ADD TEMPFILE '/u03/oradata/TRU817/temp201.dbf'
SIZE 6M REUSE
AUTOEXTEND ON NEXT 256 MAXSIZE 10M;
Note: the author of PLATO is not responsible for the correctness of this script

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

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

SQL> spool off