SIMBA Database report (Audit)
The PLATO Package, version 45, build 1046
Report generated on 29-Sep-05 20:55:00
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 SIMBA
Instance name SIMBA1
Hostname btrac1
Service names: SIMBA, simbasrv
Db domain:
Db Created 16-Sep-2005
Startup time 22-sep-2005, 21:14
Uptime (Technologies) 6 Dys 23 Hrs 40 Min
Version 10.1.0.4.0
Banner version 10.1.0.4.0
Compatible: 10.1.0.4.0
nls_language AMERICAN
nls_territory AMERICA
nls_characterset WE8ISO8859P15
nls_date_format dd-Mon, hh24:mi:ss
Block size: 8192
Sga target: 160.0M
Shared pool size: 0
Shared pool reserved: 2.1M
Large pool size: 0
Buffer cache 0
Db cache size (9i): 0
Redo log buffer: 256.0K
Java pool size: 0
Sort area size: 64.0K
Sort area retained: 0
Hash area size: 128.0K
Pga aggr target (9i): 32.0M
Workarea size policy: AUTO
Optimizer mode: ALL_ROWS
Restricted logins ALLOWED
User dump dest: /opt/oracle/admin/SIMBA/udump
Backgr dump dest: /opt/oracle/admin/SIMBA/bdump
Utl file dir:
Spfile: +ASM1/simba/spfilesimba.ora
Archivelog mode NOARCHIVELOG


SGA Distribution
Pool Size Pct
Total SGA
156.9M 100%
Buffer cache
96.0M 61.1%
Shared pool
52.0M 33.1%
Java pool
4.0M 2.5%
Large pool
4.0M 2.5%
Fixed SGA
760.0K .5%
Log buffer
256.0K .2%

Database Statistics
Name Value
Library Cache Hit Ratio (%) 91.10
Rowcache Hit Ratio (%) 19.77
Buffer Cache Hit Ratio (%) 99.79
Redo log space requests 71
Buffer gets (logical) since startup 6365030
Buffer gets (logical) (avg/sec) 10.5
Physical IO (rds+wrts) since startup 88980
Physical IO (rds+wrts) (avg/sec) .1

System statistics
Name Value
table scans (short tables) 22311
table scans (long tables) 12
table scan rows gotten 3756500
table scan rows gotten (avg/sec) 6.22
table scan blocks gotten 274676
table fetch by rowid 1351315
table fetch by rowid (avg/sec) 2.23
table fetch continued row 29544
sorts (memory) 324869
sorts (disk) 2
sorts (rows) 9505732
sort_area_size 65536
sort_area_retained_size 0
enqueue waits 42997
enqueue deadlocks 0
enqueue requests 13023013
timed_statistics TRUE
timed_os_statistics 0
cursor_sharing EXACT
sql_trace FALSE
statistics_level TYPICAL

Instance overview
Id Nr Name Host Startup Status Par Thread Logins
2 2 SIMBA2 btrac2 27-Sep 15:02:19 OPEN YES 2 ALLOWED
1 1 SIMBA1 btrac1 22-Sep 21:14:48 OPEN YES 1 ALLOWED


File Information top

Redolog files
File name Thread Group Size Status
+ASM1/simba/onlinelog/group_1.257.569175843 Thr 1 Grp 1 10.0M
+ASM1/simba/onlinelog/group_2.258.569175847 Thr 1 Grp 2 10.0M
+ASM1/simba/onlinelog/group_3.265.569178969 Thr 2 Grp 3 10.0M
+ASM1/simba/onlinelog/group_4.266.569178973 Thr 2 Grp 4 10.0M


Control Files
+ASM1/simba/controlfile/current.256.569175835

Tablespaces and datafiles
TsName TS size Used AutoExt MaxSize %AutoMax TsStat Filename Tp Filesize Aut Ext FileMax
SYSAUX 180.0M
178.1M (99%)
31.9G
1
ONL +ASM1/simba/datafile/sysaux.261.569175945 D 180.0M YES 31.9G
SYSTEM 240.0M
231.3M (96%)
31.9G
1
ONL +ASM1/simba/datafile/system.259.569175853 D 240.0M YES 31.9G
TEMP 20.0M
12.0M (60%)
31.9G
0
ONL +ASM1/simba/tempfile/temp.262.569175973 T 20.0M YES 31.9G
TEST 90.0M
64.0K (0%)
90.0M
0
ONL +ASM1/simba/datafile/test.268.569712365 D 90.0M NO
TEST2 90.0M
64.0K (0%)
90.0M
0
ONL +ASM1/simba/datafile/test2.269.569712421 D 90.0M NO
TEST3 90.0M
64.0K (0%)
90.0M
0
ONL +ASM1/simba/datafile/test3.270.569712451 D 90.0M NO
TEST4 90.0M
64.0K (0%)
90.0M
0
ONL +ASM1/simba/datafile/test4.271.569712475 D 90.0M NO
TEST5 10.0M
64.0K (1%)
10.0M
1
ONL +ASM1/simba/datafile/test5.272.569712515 D 10.0M NO
UNDOTBS1 50.0M
5.3M (11%)
31.9G
0
ONL +ASM1/simba/datafile/undotbs1.260.569175933 D 50.0M YES 31.9G
UNDOTBS2 50.0M
9.3M (19%)
31.9G
0
ONL +ASM1/simba/datafile/undotbs2.263.569175997 D 50.0M YES 31.9G
USERS 5.0M
64.0K (1%)
31.9G
0
ONL +ASM1/simba/datafile/users.264.569176011 D 5.0M YES 31.9G

Segment size
Segment type Size
TABLE
135.1M
INDEX
126.5M
TABLE PARTITION
55.6M
INDEX PARTITION
51.3M
CLUSTER
23.2M
TYPE2 UNDO
14.6M
TEMPORARY
12.0M
LOBSEGMENT
9.4M
LOBINDEX
6.8M
LOB PARTITION
512.0K
ROLLBACK
384.0K
NESTED TABLE
320.0K
Total 436.0M


File size
File type Size
Datafiles 895.0M
Tempfiles 20.0M
Redolog files 40.0M
Total 955.0M


Offline datafiles
Filename Status
All datafiles are online

Files in hot backup
Filename
No files are in hot backup


Number of datafiles
Name Value
Max datafiles in controlfile 1024
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 ASSM
SYSAUX 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG AUTO
SYSTEM 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL
TEMP 1.0M 1.0M 1 Unlim 0 1.0M ONL TEMP LOCA UNIFORM NOL MANUAL
TEST 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL
TEST2 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL
TEST3 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL
TEST4 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL
TEST5 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL
UNDOTBS1 64.0K 1 Unlim 64.0K ONL UNDO LOCA AUTO LOG MANUAL
UNDOTBS2 64.0K 1 Unlim 64.0K ONL UNDO LOCA AUTO LOG MANUAL
USERS 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG AUTO

Datafile IO since startup (top 25)
Filename PhyRds PhyWrts PhyBlkrd PhyBlkWrt Blks/Rd R+W/sec
+ASM1/simba/datafile/sysaux.261.569175945
2525
34038
6513 44570 2.57 .06
+ASM1/simba/datafile/undotbs1.260.569175933
56
14422
56 24065 1 .02
+ASM1/simba/datafile/system.259.569175853
4045
4431
5828 6329 1.44 .01
+ASM1/simba/tempfile/temp.262.569175973
48
74
627 624 13.06 0
+ASM1/simba/datafile/undotbs2.263.569175997
54
39
54 40 1 0
+ASM1/simba/datafile/test.268.569712365
22
27
22 27 1 0
+ASM1/simba/datafile/test5.272.569712515
22
27
22 27 1 0
+ASM1/simba/datafile/test4.271.569712475
22
27
22 27 1 0
+ASM1/simba/datafile/test2.269.569712421
22
27
22 27 1 0
+ASM1/simba/datafile/test3.270.569712451
22
27
22 27 1 0
+ASM1/simba/datafile/users.264.569176011
24
20
24 20 1 0

Segment size by owner and tablespace
Owner\TsName SYSAUX SYSTEM UNDOTBS1 UNDOTBS2
CTXSYS 4.6M 0 0 0
DBSNMP 256.0K 0 0 0
DMSYS 5.6M 0 0 0
OUTLN 0 384.0K 0 0
SYS 155.3M 215.2M 5.3M 9.3M
SYSTEM 5.8M 15.6M 0 0
WMSYS 6.5M 0 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 20.0M 1.0M 1.0M 1.0M 1 Unlim 0 LOCA UNIFORM 20 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 376.0K SYS 112.0K 1 32765 ONL


Rollback Segment statistics
RbsName Size OptSize HwmSize Extnt Extnd Shrnk Wraps Wait%
SYSTEM 376.0K 376.0K 6 0 0 0 0
Note: online rollback segments only

Related init.ora
Parameter Value
rollback_segments:
undo_management: AUTO
undo_tablespace: UNDOTBS1
undo_retention: 900

Undo statistics per day
From Until Undo size Transactions
25-Sep, 00:00:00 26-Sep, 00:00:00
1.4M
894
26-Sep, 00:00:00 27-Sep, 00:00:00
12.4M
7.9K
27-Sep, 00:00:00 28-Sep, 00:00:00
11.8M
7.7K
28-Sep, 00:00:00 29-Sep, 00:00:00
12.7M
6.7K
29-Sep, 00:00:00
12.9M
5.9K


Avg undo per hour
Range Bytes Transactions
00-01
766.0K
460
01-02
364.0K
288
02-03
346.0K
240
03-04
354.0K
276
04-05
416.0K
231
05-06
464.0K
262
06-07
418.0K
291
07-08
424.0K
381
08-09
434.0K
204
09-10
468.0K
299
10-11
428.0K
285
11-12
452.0K
377
12-13
610.0K
288
13-14
490.0K
278
14-15
482.0K
286
15-16
530.0K
290
16-17
502.0K
287
17-18
478.0K
303
18-19
478.0K
315
19-20
514.0K
311
20-21
978.0K
253
21-22
1.4M
657
22-23
812.0K
334
23-00
462.0K
312


Backup and recovery top

Recent redolog activity
Time Thr MinSeq# MaxSeq# #LogSwitches ArchivedSize
Fri 16-sep-2005 1 1 43 43
Sat 17-sep-2005 1 44 45 2
Thu 22-sep-2005 1 46 46 1
Fri 23-sep-2005 1 47 49 3
Sat 24-sep-2005 1 50 52 3
Sun 25-sep-2005 1 53 55 3
Mon 26-sep-2005 1 56 59 4
Tue 27-sep-2005 1 60 62 3
Wed 28-sep-2005 1 63 65 3
Thu 29-sep-2005 1 66 67 2
Fri 16-sep-2005 2 1 1 1
Sat 17-sep-2005 2 2 4 3
Thu 22-sep-2005 2 5 5 1
Fri 23-sep-2005 2 6 9 4
Sat 24-sep-2005 2 10 13 4
Sun 25-sep-2005 2 14 15 2
Mon 26-sep-2005 2 16 16 1
Tue 27-sep-2005 2 17 18 2
Wed 28-sep-2005 2 19 21 3
Thu 29-sep-2005 2 22 24 3


Redolog information
Group Members Size Status
Group 1 1 10.0M INACTIVE
Group 2 1 10.0M CURRENT
Group 3 1 10.0M CURRENT
Group 4 1 10.0M INACTIVE

Archivelog settings
Parameter Value
Archivelog mode NOARCHIVELOG
log_archive_start FALSE
log_archive_max_processes 2
log_archive_min_succeed_dest 1
log_archive_trace 0
log_archive_local_first TRUE
log_archive_format %t_%s_%r.dbf
archive_lag_target 0

Standby/Dataguard info
DG Broker Status Force Log Sup Log MIN Sup Log PK Sup Log UI
DISABLED NONE NO NO NO NO


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

Tables within 5 of their max extents
Owner Name Type TsName Xtnts MaxXtnts Size Init Next Pct
There are no tables within 5 of their max extents

Segments of SYS, top 10 by nr of extents
Name Type TsName Xtnts Size Init Next Pct
Note: top10, dictionary managed tablespaces only
There are no segments in dictionary managed tablespaces.

Segments non-SYS, top 10 by nr of extents
Owner Name Type TsName Xtnts Size Init Next MaxExt Pct
Note: top 10, dictionary managed tablespaces only
There are no segments in dictionary managed tablespaces.

Invalid objects
Owner\ObjType
Note: User SYS is excluded

Overview index types
Owner\IndType IOT - TOP LOB NORMAL
CTXSYS 11 1 35
DBSNMP 0 0 2
DMSYS 0 2 43
OUTLN 0 0 3
WMSYS 4 7 51
Note: users SYS and SYSTEM are excluded

Init.ora
Query rewrite enabled?: TRUE

Non-SYS objects in SYSTEM tablespace
Owner Name Type Size
There are no non-SYS objects in the SYSTEM tablespace.

System tablespace fragmentation
Start BlockNr Size
29705 7.9M
29361 704.0K
Note: Listing top 10 biggest free extents
Nr free extents in SYSTEM tablespace: 2
Avg size of free extent in SYSTEM tablespace: 4.3M

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


Table properties top

Init.ora
Optimizer mode: ALL_ROWS

Analyzed objects general
Class Nr Tables
Analyzed 80


Analyzed: owner vs month
Owner\Month 2005-09
CTXSYS 37 0
DBSNMP 4 3
DMSYS 43 0
OUTLN 3 0
SYS 576 35
SYSTEM 131 4
WMSYS 37 1
Note: empty month means: not analyzed


Analyzed: owner vs week
Owner\Week 15-Sep 22-Sep 29-Sep
CTXSYS 37 0 0
DBSNMP 4 0 0
DMSYS 43 0 0
OUTLN 3 0 0
SYS 473 24 79
SYSTEM 131 0 0
WMSYS 37 0 0
Note: only analyzed tables
Last 10 weeks only

Analyzed and monitored tables by owner
Owner Analyzed Non Anal. Monitoring Non Monit.
CTXSYS 37 0 37 0
DBSNMP 0 0 4 3
DMSYS 43 0 43 0
OUTLN 0 0 3 0
SYS 0 0 577 34
SYSTEM 0 0 131 4
WMSYS 0 0 37 1


Non analyzed tables
Owner Name Created

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
No tables found with too many chained rows.


Largest segments
Owner Segment Type TsName Size
SYS SOURCE$ TABLE SYSTEM 25.0M
SYS IDL_UB1$ TABLE SYSTEM 20.0M
SYS IDL_UB2$ TABLE SYSTEM 10.0M
SYS PK_C0 INDEX SYSTEM 10.0M
SYS PK_O INDEX SYSTEM 10.0M
SYS PK_CT INDEX SYSTEM 10.0M
SYS PK_CS INDEX SYSTEM 10.0M
SYS C_TOID_VERSION# CLUSTER SYSTEM 9.0M
SYS C_OBJ# CLUSTER SYSTEM 5.0M
SYS ARGUMENT$ TABLE SYSTEM 5.0M
SYS C_OBJ#_INTCOL# CLUSTER SYSTEM 5.0M
SYS VIEW$ TABLE SYSTEM 3.0M
SYS WRH$_SYSMETRIC_SUMMARY TABLE SYSAUX 3.0M
SYS _SYSSMU2$ TYPE2 UNDO UNDOTBS1 3.0M
SYS I_ARGUMENT1 INDEX SYSTEM 3.0M



Largest tables
Owner Table TsName Rows UsedBlocks Size Last Anal
SYS WRH$_LATCH [partitioned] 121424 914 7.1M 29-Sep-2005
SYS WRH$_SYSSTAT [partitioned] 116539 455 3.5M 29-Sep-2005
SYS SOURCE$ SYSTEM 106256 2905 22.6M 16-Sep-2005
SYS WRH$_PARAMETER [partitioned] 88506 601 4.6M 29-Sep-2005
SYS WRH$_SEG_STAT [partitioned] 51106 762 5.9M 29-Sep-2005
SYS ARGUMENT$ SYSTEM 48909 521 4.0M 16-Sep-2005
SYS WRH$_SYSTEM_EVENT [partitioned] 46157 268 2.0M 29-Sep-2005
SYS COL$ SYSTEM 39537 546 4.2M 27-Sep-2005
SYS WRH$_SERVICE_STAT [partitioned] 37497 210 1.6M 29-Sep-2005
SYS WRH$_SYSMETRIC_SUMMARY SYSAUX 35992 306 2.3M 29-Sep-2005
SYS WRH$_BG_EVENT_SUMMARY SYSAUX 32346 244 1.9M 29-Sep-2005
SYS WRH$_SQLSTAT [partitioned] 25523 702 5.4M 29-Sep-2005
SYS WRH$_DLM_MISC [partitioned] 25393 224 1.7M 29-Sep-2005
SYS WRI$_OPTSTAT_HISTGRM_HISTORY SYSAUX 24075 110 880.0K 29-Sep-2005
SYS WRI$_OPTSTAT_HISTHEAD_HISTORY SYSAUX 23863 180 1.4M 29-Sep-2005
Note: based on num_rows of analyze statistics

Unused space
Owner Table TsName EffData TotAlloc AboveHwm Unused %Unused PctFree Extnts Analyzed
SYSTEM MVIEW$_ADV_PARAMETERS SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM AQ$_QUEUE_TABLES SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM AQ$_QUEUES SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM AQ$_INTERNET_AGENTS SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM AQ$_INTERNET_AGENT_PRIVS SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM REPCAT$_TEMPLATE_TYPES SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM LOGSTDBY$SKIP_SUPPORT SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM REPCAT$_RESOLUTION_METHOD SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
SYSTEM REPCAT$_AUDIT_ATTRIBUTE SYSTEM 0 64.0K 0 64.0K
100
10 1 16-sep-05
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 SYS SYSTEM
RANGE 23 27

Temporary tables
Owner TableName TsName Duration
SYSTEM OL$ SYS$SESSION
SYSTEM OL$HINTS SYS$SESSION
SYSTEM OL$NODES SYS$SESSION
SYSTEM LOGMNRT_MDDL$ SYS$TRANSACTION
DBSNMP MGMT_RESPONSE_TEMPT SYS$TRANSACTION
DBSNMP MGMT_DB_FILE_GTT SYS$TRANSACTION
DBSNMP MGMT_DB_SIZE_GTT SYS$TRANSACTION
WMSYS WM$MW_TABLE SYS$SESSION
Note: excluding user SYS


Tables with CACHE
Owner TableName

Tables by degree
Degree NrTables
1 874

Related init.ora
Parameter Value
parallel_max_servers: 20
parallel_min_servers: 0
parallel_threads_per_cpu: 2
parallel_adaptive_multi_user: TRUE
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

Job queue parameters
Security parameters Value
job_queue_processes: 10
job_queue_interval: Unexistant

Advanced queues
Owner Queue QueueTable Comment
WMSYS WM$EVENT_QUEUE WM$EVENT_QUEUE_TABLE OWM Events Queue

AQ parameters
Parameter Value
aq_tm_processes: 0


Memory information top

SGA Memory
Parameter shared_pool_size: 0
Parameter shared_pool_reserved_size: 2.1M
Parameter large_pool_size: 0
Parameter java_pool_size: 0

SGA Statistics
Pool Name Value Bytes
fixed_sga 760.0K 778292
buffer_cache 96.0M 100663296
log_buffer 256.0K 262144
shared pool sql area 4.2M 4489548
shared pool free memory 3.4M 3618860
shared pool PL/SQL MPCODE 584.7K 598740
shared pool library cache 3.6M 3782836
large pool free memory 3.3M 3461952
java pool free memory 4.0M 4194304


PGA Memory
Parameter sort_area_size: 65536
Parameter sort_area_retained_size: 0
Parameter hash_area_size: 131072
Parameter pga_aggregate_target: 33554432
Parameter workarea_size_policy: AUTO

PGA Statistics
Name Value
aggregate PGA target parameter 33554432
aggregate PGA auto target 4194304
global memory bound 1677312
total PGA inuse 47669248
total PGA allocated 144547840
maximum PGA allocated 163487744
total freeable PGA memory 20709376
PGA memory freed back to OS 242745344
total PGA used for auto workareas 0
maximum PGA used for auto workareas 1458176
total PGA used for manual workareas 0
maximum PGA used for manual workareas 0
over allocation count 201264
bytes processed 1813495808
extra bytes read/written 1239040
cache hit percentage 99.93


Buffer cache contents
Owner Name Size
SYS C_OBJ# 4.3M
SYS WRH$_LATCH 3.4M
SYS WRH$_SEG_STAT 3.2M
SYS WRH$_SQLSTAT 3.0M
SYS SMON_SCN_TO_TIME 2.4M
SYS WRH$_PARAMETER 2.2M
SYS WRH$_SYSSTAT 2.1M
SYS SOURCE$ 1.8M
SYS C_OBJ#_INTCOL# 1.5M
SYS WRH$_SYSTEM_EVENT 1.4M
SYS IDL_UB1$ 1.3M
SYS WRH$_ENQUEUE_STAT_PK 1.1M
SYS WRH$_BG_EVENT_SUMMARY_PK 1.1M
SYS WRH$_LATCH_MISSES_SUMMARY 1.1M
SYS WRH$_ENQUEUE_STAT 1.0M
SYS WRH$_BG_EVENT_SUMMARY 1.0M
SYS IDL_UB2$ 1008.0K
SYS OBJ$ 968.0K
SYS WRH$_DLM_MISC 840.0K
SYS WRI$_ADV_PARAMETERS_PK 816.0K
SYS WRH$_SERVICE_STAT 808.0K
SYS WRH$_SYSMETRIC_SUMMARY 792.0K
SYS C_FILE#_BLOCK# 744.0K
SYS WRH$_LATCH_PK 696.0K
SYS WRH$_SYSSTAT_PK 696.0K
Note: top 25 only

Cache sizes
Name Value
Block size 8192
db_cache_size: 0
db_block_buffers: 0
db_2k_cache_size 0
db_4k_cache_size 0
db_8k_cache_size 0
db_16k_cache_size 0
db_32k_cache_size 0
db_keep_cache_size 0
db_recycle_cache_size 0


Buffer pool usage
Buffer pool NrObj
DEFAULT 2168

Workarea histogram
Low High Optimal OnePass MultiPass
2048 4095 125838 0 0
65536 131071 32 1 0
131072 262143 21 0 0
262144 524287 112 0 0
524288 1048575 1824 0 0
1048576 2097151 18 1 0

Parameter Value
pga_aggregate_target: 33554432


Security top

Overview users
Username DefTs TempTs Created NrSeg TotSize OPS$ ? Account DBA ?
SYS SYSTEM TEMP 16-Sep-2005 1621 385.1M No open Yes
SYSTEM SYSTEM TEMP 16-Sep-2005 344 21.5M No open Yes
OUTLN SYSTEM TEMP 16-Sep-2005 6 384.0K No expired & locked No
DIP USERS TEMP 16-Sep-2005 0 0 No expired & locked No
DBSNMP SYSAUX TEMP 16-Sep-2005 4 256.0K No expired & locked No
WMSYS SYSAUX TEMP 16-Sep-2005 104 6.5M No expired & locked No
DMSYS SYSAUX TEMP 16-Sep-2005 90 5.6M No expired & locked No
CTXSYS SYSAUX TEMP 16-Sep-2005 74 4.6M No expired & locked No

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


Networking top

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


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
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


DBA Registry
Id Name Version Status
CONTEXT Oracle Text 10.1.0.4.0 VALID
OWM Oracle Workspace Manager 10.1.0.2.0 VALID
ODM Oracle Data Mining LOADING
CATALOG Oracle Database Catalog Views 10.1.0.4.0 VALID
CATPROC Oracle Database Packages and Types 10.1.0.4.0 VALID
RAC Oracle Real Application Clusters 10.1.0.4.0 VALID

Featured init.ora parameters
Parameter Dflt? Value
__db_cache_size FALSE 100663296
__java_pool_size FALSE 4194304
__large_pool_size FALSE 4194304
__shared_pool_size FALSE 54525952
background_dump_dest FALSE /opt/oracle/admin/SIMBA/bdump
cluster_database FALSE TRUE
cluster_database_instances FALSE 2
compatible FALSE 10.1.0.4.0
control_files FALSE +ASM1/simba/controlfile/current.256.569175835
core_dump_dest FALSE /opt/oracle/admin/SIMBA/cdump
db_block_buffers TRUE 0
db_block_size FALSE 8192
db_create_file_dest FALSE +ASM1
db_domain FALSE
db_file_multiblock_read_count FALSE 16
db_name FALSE SIMBA
instance_number FALSE 1
java_pool_size TRUE 0
job_queue_processes FALSE 10
large_pool_size TRUE 0
log_archive_start TRUE FALSE
log_buffer TRUE 262144
open_cursors FALSE 300
pga_aggregate_target FALSE 33554432
processes FALSE 150
remote_listener FALSE LISTENERS_SIMBA
remote_login_passwordfile FALSE EXCLUSIVE
sga_target FALSE 167772160
shared_pool_size TRUE 0
spfile FALSE +ASM1/simba/spfilesimba.ora
sql_trace TRUE FALSE
thread FALSE 1
timed_os_statistics TRUE 0
timed_statistics TRUE TRUE
undo_management FALSE AUTO
undo_tablespace FALSE UNDOTBS1
user_dump_dest FALSE /opt/oracle/admin/SIMBA/udump
utl_file_dir TRUE
Note: taking all non default parameters + some important ones

Hidden parameters
Name Description Instance value
__shared_pool_size Actual size in bytes of shared pool 54525952
__large_pool_size Actual size in bytes of large pool 4194304
__java_pool_size Actual size in bytes of java pool 4194304
__db_cache_size Actual size of DEFAULT buffer pool for standard block size
buffers
100663296

RAC Parameters
Parameter btrac1:SIMBA1 btrac2:SIMBA2
__db_cache_size 100663296 96468992
__shared_pool_size 54525952 58720256
cluster_interconnects
dg_broker_config_file1 /opt/oracle/product/10.1.0/db/dbs/dr1SIMBA1.dat /opt/oracle/product/10.1.0/db/dbs/dr1SIMBA2.dat
dg_broker_config_file2 /opt/oracle/product/10.1.0/db/dbs/dr2SIMBA1.dat /opt/oracle/product/10.1.0/db/dbs/dr2SIMBA2.dat
instance_name SIMBA1 SIMBA2
instance_number 1 2
local_listener
max_commit_propagation_delay 700 700
remote_listener LISTENERS_SIMBA LISTENERS_SIMBA
shared_pool_reserved_size 2306867 2726297
thread 1 2
undo_tablespace UNDOTBS1 UNDOTBS2

Database properties
Name Value
DICT.BASE 2
DEFAULT_TEMP_TABLESPACE TEMP
DEFAULT_PERMANENT_TABLESPACE USERS
DBTIMEZONE +02:00
DEFAULT_TBS_TYPE SMALLFILE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P15
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.1.0.4.0
GLOBAL_DB_NAME SIMBA
EXPORT_VIEWS_VERSION 8



Database Features top

Java stored procedures
Username Nr

Materialized views
Username Nr

Refresh groups
Owner Nr

Advanced queues
Username Nr
SYS 15
SYSTEM 4
WMSYS 2

Clusters (non SYS)
Username Nr

Domain indexes
Username Nr

Dimensions
Username Nr

Partitioned tables
Username Nr Type
SYS 23 RANGE
SYSTEM 27 RANGE


Database links
Username Nr

Directories
Username Nr
SYS 1

Libraries
Username Nr
CTXSYS 1
DMSYS 7
SYS 98

Stored outlines
Username Nr

FGAC / VPD
Object owner Nr

Object types (non-SYS)
Owner Nr
CTXSYS 42
DMSYS 140
SYSTEM 1
WMSYS 14


Resource plans
Plan
SYSTEM_PLAN
INTERNAL_QUIESCE
INTERNAL_PLAN

Database event triggers
Username Nr Event

Audit options
Type Username Nr

Streams processes
Username Nr Type

Applications contexts
SYS ACCESSED LOCALLY 2
CTXSYS ACCESSED LOCALLY 1

FGA policies
Towner Nr

Analytic workspaces
Username Nr

External tables
Username Nr

Scheduler jobs
Username Nr
SYS 2

Recycle bin contents
Owner Nr


Script to recreate the controlfile top

CREATE CONTROLFILE script
CREATE CONTROLFILE REUSE DATABASE "SIMBA" RESETLOGS NOARCHIVELOG
-- CREATE CONTROLFILE REUSE SET DATABASE "NEW_DB_NAME" RESETLOGS NOARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 1
MAXLOGHISTORY 454
LOGFILE
GROUP 1 ('+ASM1/simba/onlinelog/group_1.257.569175843') SIZE 10M,
GROUP 2 ('+ASM1/simba/onlinelog/group_2.258.569175847') SIZE 10M,
GROUP 3 ('+ASM1/simba/onlinelog/group_3.265.569178969') SIZE 10M,
GROUP 4 ('+ASM1/simba/onlinelog/group_4.266.569178973') SIZE 10M
DATAFILE
'+ASM1/simba/datafile/system.259.569175853',
'+ASM1/simba/datafile/undotbs1.260.569175933',
'+ASM1/simba/datafile/sysaux.261.569175945',
'+ASM1/simba/datafile/undotbs2.263.569175997',
'+ASM1/simba/datafile/users.264.569176011',
'+ASM1/simba/datafile/test.268.569712365',
'+ASM1/simba/datafile/test2.269.569712421',
'+ASM1/simba/datafile/test3.270.569712451',
'+ASM1/simba/datafile/test4.271.569712475',
'+ASM1/simba/datafile/test5.272.569712515'
CHARACTER SET WE8ISO8859P15
;
-- Take files offline to match current control file:
-- Files in normal offline tablespaces are now named:
-- Commands to add tempfiles to temporary tablespaces:
ALTER TABLESPACE TEMP ADD TEMPFILE '+ASM1/simba/tempfile/temp.262.569175973'
SIZE 20M REUSE
AUTOEXTEND ON NEXT 80 MAXSIZE 33554416K;
For the other instances, you should "ALTER DATABASE ENABLE PUBLIC THREAD ...;"
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 84 seconds]
[Usage: SQL*Plus: "exec plato.help" after "set serveroutput on format wrapped"]