================================================================================= = PLATO Database report 45, build 1046, generated on 29-Sep-05 21:58:43 = = www.dba-village.com = ================================================================================= General Database Information ============================ Important parameters ------------------------------------------------------------------------- Parameter Value Database name TRURRD Instance name TRURRD Hostname trudba.iconos.be Service names: TRURRD.iconos.be Db domain: iconos.be Db Created 15-Apr-2004 Startup time 25-jul-2005, 14:45 Uptime (Technologies) 66 Dys 7 Hrs 13 Min Version 9.2.0.4.0 Banner version 9.2.0.4.0 Compatible: 9.2.0.0.0 nls_language AMERICAN nls_territory AMERICA nls_characterset WE8ISO8859P1 nls_date_format dd-Mon, hh24:mi:ss Block size: 8192 Sga target: Unexistant Shared pool size: 112.0M Shared pool reserved: 5.5M Large pool size: 16.0M Buffer cache 0 Db cache size (9i): 32.0M Redo log buffer: 512.0K Java pool size: 0 Sort area size: 5.0M Sort area retained: 0 Hash area size: 10.0M Pga aggr target (9i): 24.0M Workarea size policy: AUTO Optimizer mode: CHOOSE Restricted logins ALLOWED User dump dest: /u03/admin/TRURRD/udump Backgr dump dest: /u03/admin/TRURRD/bdump Utl file dir: Spfile: ?/dbs/spfile@.ora Archivelog mode NOARCHIVELOG SGA Distribution --------------------------------- Pool Size Pct --------------- ------- -------- Total SGA 193.4M 100% Shared pool 144.0M 74.4% Buffer cache 32.0M 16.5% Large pool 16.0M 8.3% Log buffer 770.0K .4% Fixed SGA 716.5K .4% Database Statistics ------------------------------------------------------ Name Value ---------------------------------------- ------------ Library Cache Hit Ratio (%) 100.00 Rowcache Hit Ratio (%) 0.00 Buffer Cache Hit Ratio (%) 98.49 Redo log space requests 3161 Buffer gets (logical) since startup 5575498097 Buffer gets (logical) (avg/sec) 973.3 Physical IO (rds+wrts) since startup 91387891 Physical IO (rds+wrts) (avg/sec) 15.9 System statistics ---------------------------------------------------- Name Value ----------------------------------- --------------- table scans (short tables) 11805111 table scans (long tables) 15820 table scan rows gotten 806170569 table scan rows gotten (avg/sec) 140.73 table scan blocks gotten 47759875 table fetch by rowid 5628378676 table fetch by rowid (avg/sec) 982.53 table fetch continued row 217285501 sorts (memory) 2993862 sorts (disk) 6 sorts (rows) 139977284 sort_area_size 5242880 sort_area_retained_size 0 enqueue waits 26150 enqueue deadlocks 0 enqueue requests 13218739 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 -- -- -------- ---------------- ---------------- -------- --- ------ ---------- 1 1 TRURRD trudba.iconos.be 25-Jul 14:45:11 OPEN NO 1 ALLOWED File Information ================ Redolog files -------------------------------------------------------------- File name Thread Group Size Status ------------------------------ ------ ------ ------- -------- /u03/oradata/TRURRD/redo01.log Thr 1 Grp 1 24.8M /u03/oradata/TRURRD/redo02.log Thr 1 Grp 2 24.8M Control Files ---------------------------------- --------------------------------- /u03/oradata/TRURRD/control01.ctl /u03/oradata/TRURRD/control02.ctl /u03/oradata/TRURRD/control03.ctl Tablespaces and datafiles -------------------------------------------------------------------------------------------------------------------------------- TsName Curr CurrUsed AutoExt Used TsStat Filename Tp File Aut File Size Maxsize MaxS size Ext max -------- ------- --------------- ------- ---- ---- --------------------------------------------------- - ------- --- ------- DRSYS 20.0M 4.8M (24%) 31.9G 0 ONL /u03/oradata/TRURRD/drsys01.dbf D 20.0M YES 31.9G RRD 6.5G 6.5G (100%) 32.9G 20 ONL /u03/oradata/TRURRD/rrd01.dbf D 5.5G YES 31.9G /u02/oradata/TRURRD/rrd02.dbf D 1.0G NO RRDQ 3.7G 3.2G (87%) 31.9G 10 ONL /u01/oradata/TRURRD/rrdq01.dbf D 3.7G YES 31.9G SYSTEM 230.0M 228.9M (100%) 31.9G 1 ONL /u03/oradata/TRURRD/system01.dbf D 230.0M YES 31.9G TEMP 482.0M 481.0M (100%) 31.9G 1 ONL /u03/oradata/TRURRD/temp01.dbf T 482.0M YES 31.9G UNDOTBS1 2.3G 27.3M (1%) 31.9G 0 ONL /u02/oradata/TRURRD/undotbs01.dbf D 2.3G YES 31.9G USERS 1.9G 1.8G (100%) 31.9G 6 ONL /u03/oradata/TRURRD/users01.dbf D 1.9G YES 31.9G XDB 45.0M 44.7M (99%) 31.9G 0 ONL /u01/oracle/product/ora920/oradata/TRURRD/xdb01.dbf D 45.0M YES 31.9G Segment size ------------------------ Segment type Size --------------- ------- INDEX PARTITION 3.9G TABLE 2.7G INDEX 2.7G TABLE PARTITION 2.5G TEMPORARY 481.0M TYPE2 UNDO 27.1M CLUSTER 26.4M LOBSEGMENT 25.5M LOBINDEX 24.6M ROLLBACK 448.0K CACHE 64.0K NESTED TABLE 64.0K Total 12.4G File size ------------------------ File type Size --------------- ------- Datafiles 14.8G Tempfiles 482.0M Redolog files 49.6M Total 15.3G 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 100 db_files in init.ora 200 Current nr of data+temp files 9 Storage parameters and file statistics ====================================== Tablespace storage parameters ------------------------------------------------------------------------------------------- TablespaceName Init Next Min Max Pct MinExtLen Stat Cont Mgmt AllocType Log ASSM -------------- ------- ------- --- ----- --- --------- ---- ---- ---- --------- --- ------ DRSYS 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG AUTO RRD 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL RRDQ 64.0K 1 Unlim 64.0K ONL PERM LOCA AUTO LOG MANUAL 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 UNDOTBS1 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 XDB 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 --------------------------------------------------- ---------- ---------- ---------- ---------- ------- ------------ /u02/oradata/TRURRD/rrd02.dbf 59274782 1437986 59274782 1437986 1 10.59 /u03/oradata/TRURRD/rrd01.dbf 9154538 723683 9154653 723683 1 1.72 /u03/oradata/TRURRD/users01.dbf 3806636 1801571 4418618 1880954 1.16 .97 /u03/oradata/TRURRD/system01.dbf 3161260 80205 6947292 80205 2.19 .56 /u02/oradata/TRURRD/undotbs01.dbf 736465 1783127 736465 1783127 1 .43 /u01/oradata/TRURRD/rrdq01.dbf 590926 824276 590926 824276 1 .24 /u03/oradata/TRURRD/temp01.dbf 813582 485361 1245022 992182 1.53 .22 /u01/oracle/product/ora920/oradata/TRURRD/xdb01.dbf 1160831 930 1160831 930 1 .2 /u03/oradata/TRURRD/drsys01.dbf 142980 956 142984 956 1 .02 Segment size by owner and tablespace Skipping because this query would take too long Users's temporary tablespaces --------------------------------------------------------------------------------------------------- TsName Size Init Next Min Nr Ext Min_ext Max_ext Pct_inc Mgmt AllocType Max poss ext Cont ------ ------- ------- ------- ---------- ------- ------- ------- ---- --------- ------------ ---- TEMP 482.0M 1.0M 1.0M 1.0M 1 Unlim 0 LOCA UNIFORM 482 TEMP Excluding users SYS, SYSTEM, DRSYS, DBSNMP and OUTLN Rollback segment information ============================ Rollback Segments ------------------------------------------------------------------------------- RbsName TsName Size Owner Init Next MinExt MaxExt OptSize Stat ---------- -------- ------- ------- ------- ------- ------ ------ ------- ---- SYSTEM SYSTEM 440.0K SYS 112.0K 1 32765 ONL Rollback Segment statistics ----------------------------------------------------------------- RbsName Size OptSize HwmSize Extnt Extnd Shrnk Wraps Wait% ---------- ------- ------- ------- ----- ----- ----- ----- ----- SYSTEM 440.0K 440.0K 7 0 0 6 0 Note: online rollback segments only Related init.ora ---------------------------------------------------- Parameter Value rollback_segments: undo_management: AUTO undo_tablespace: UNDOTBS1 undo_retention: 10800 Undo statistics per day --------------------------------------------------------- From Until Undo size Transactions ---------------- ---------------- --------- ------------ 22-Sep, 00:00:00 23-Sep, 00:00:00 7.3M 21.0M 23-Sep, 00:00:00 24-Sep, 00:00:00 87.6M 254.1M 24-Sep, 00:00:00 25-Sep, 00:00:00 83.8M 257.3M 25-Sep, 00:00:00 26-Sep, 00:00:00 89.2M 260.6M 26-Sep, 00:00:00 27-Sep, 00:00:00 88.2M 263.9M 27-Sep, 00:00:00 28-Sep, 00:00:00 89.1M 267.2M 28-Sep, 00:00:00 29-Sep, 00:00:00 90.6M 270.6M 29-Sep, 00:00:00 80.9M 250.9M Avg undo per hour --------------------------------- Hours Bytes Transactions ----------- ------- ------------ 00-01 3.6M 1005 01-02 3.7M 1008 02-03 3.6M 1006 03-04 3.6M 1001 04-05 3.6M 1006 05-06 3.6M 1010 06-07 3.6M 1006 07-08 3.6M 1004 08-09 3.5M 982 09-10 3.5M 976 10-11 3.4M 963 11-12 3.6M 999 12-13 3.5M 989 13-14 3.6M 1001 14-15 3.5M 983 15-16 3.6M 996 16-17 3.6M 1006 17-18 3.6M 999 18-19 3.7M 1008 19-20 3.7M 1011 20-21 3.7M 1016 21-22 4.0M 998 22-23 3.7M 986 23-00 3.7M 1007 Backup and recovery =================== Recent redolog activity -------------------------------------------------------------- Time Thr MinSeq# MaxSeq# #LogSwitches ArchivedSize --------------- --- ------- ------- ------------ ------------ Tue 30-aug-2005 1 19726 19734 9 Wed 31-aug-2005 1 19735 19744 10 Thu 01-sep-2005 1 19745 19753 9 Fri 02-sep-2005 1 19754 19762 9 Sat 03-sep-2005 1 19763 19772 10 Sun 04-sep-2005 1 19773 19781 9 Mon 05-sep-2005 1 19782 19790 9 Tue 06-sep-2005 1 19791 19800 10 Wed 07-sep-2005 1 19801 19809 9 Thu 08-sep-2005 1 19810 19818 9 Fri 09-sep-2005 1 19819 19828 10 Sat 10-sep-2005 1 19829 19837 9 Sun 11-sep-2005 1 19838 19846 9 Mon 12-sep-2005 1 19847 19856 10 Tue 13-sep-2005 1 19857 19865 9 Wed 14-sep-2005 1 19866 19874 9 Thu 15-sep-2005 1 19875 19884 10 Fri 16-sep-2005 1 19885 19893 9 Sat 17-sep-2005 1 19894 19903 10 Sun 18-sep-2005 1 19904 19912 9 Mon 19-sep-2005 1 19913 19921 9 Tue 20-sep-2005 1 19922 19931 10 Wed 21-sep-2005 1 19932 19940 9 Thu 22-sep-2005 1 19941 19949 9 Fri 23-sep-2005 1 19950 19959 10 Sat 24-sep-2005 1 19960 19967 8 Sun 25-sep-2005 1 19968 19977 10 Mon 26-sep-2005 1 19978 19986 9 Tue 27-sep-2005 1 19987 19995 9 Wed 28-sep-2005 1 19996 20005 10 Thu 29-sep-2005 1 20006 20013 8 Redolog information ---------------------------------- Group Members Size Status -------- ------- ------- -------- Group 1 1 24.8M ACTIVE Group 2 1 24.8M CURRENT 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_format %t_%s.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 ========================= 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 PACKAGE PACKAGE BODY PROCEDURE ------------- ------- ------------ --------- CTXSYS 0 1 0 RRD 1 5 2 Note: User SYS is excluded Overview index types -------------------------------------------------------------- Owner\IndType FUNCTION-BASED DOMAIN IOT - TOP LOB NORMAL ------------- --------------------- --------- ------- ------- CTXSYS 0 10 2 36 DBSNMP 0 0 0 2 NAGIOS 0 0 0 2 OUTLN 0 0 0 3 PANDORA 0 0 1 12 PERFSTAT 0 0 0 42 RRD 0 0 0 36 TESTXML 0 0 15 5 WMSYS 0 0 2 33 XDB 1 1 325 33 Note: users SYS and SYSTEM are excluded Init.ora --------------------------------------------------------------------------- ----------------------- -------------------------------------------------- Query rewrite enabled?: FALSE 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 -------------- ------- 29321 960.0K 28153 128.0K Note: Listing top 10 biggest free extents Nr free extents in SYSTEM tablespace: 2 Avg size of free extent in SYSTEM tablespace: 544.0K Permanent objects in temporary tablespace ----------------------------------------- TsName Owner SegType NrSeg -------- -------- -------- ----- There are no permanent objects in temporay tablespaces Table properties ================ Init.ora ------------------------------------------------------------------- --------------- -------------------------------------------------- Optimizer mode: CHOOSE Analyzed objects general ------------------------ Class Nr Tables ------------ --------- Non Analyzed 150 Analyzed: owner vs month ---------------------------- Owner\Month 2005-08 ----------- ------- ------- CTXSYS 0 36 DBSNMP 0 7 NAGIOS 0 4 OUTLN 0 3 PANDORA 0 13 PERFSTAT 0 41 RRD 0 49 SCOTT 0 1 SYS 0 329 SYSTEM 1 130 WMSYS 0 22 XDB 0 6 Note: empty month means: not analyzed Analyzed: owner vs week ----------------------- Owner\Week 08-Aug ---------- ------- SYSTEM 1 Note: only analyzed tables Last 10 weeks only Analyzed and monitored tables by owner -------------------------------------------------- Owner Analyzed Non Anal. Monitoring Non Monit. -------- -------- --------- ---------- ---------- CTXSYS 0 36 0 36 DBSNMP 0 0 0 7 NAGIOS 0 4 0 4 OUTLN 0 0 0 3 PANDORA 0 13 0 13 PERFSTAT 0 41 0 41 RRD 0 49 4 45 SCOTT 0 1 0 1 SYS 0 0 0 329 SYSTEM 0 0 0 131 WMSYS 0 0 0 22 XDB 0 6 0 6 Non analyzed tables ---------------------------------------------------------- Owner Name Created -------- ---------------------------- ------------------- Skipping, too many tables (150) 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 -------- ----------------------- --------------- ------ ------- RRD RRT_OPERATION TABLE RRDQ 1.7G RRD AQ$_RRT_OPERATION_I INDEX RRDQ 936.0M RRD SYS_C001677 INDEX RRDQ 608.0M SYSTEM IU_BENNY_ALL INDEX USERS 264.0M SYSTEM BENNY TABLE USERS 199.0M SYSTEM I_BENNY_STAMNUMMER INDEX USERS 199.0M PERFSTAT STATS$SQL_SUMMARY TABLE USERS 160.0M PERFSTAT STATS$SQL_SUMMARY_PK INDEX USERS 120.0M PERFSTAT STATS$SQL_PLAN_USAGE_PK INDEX USERS 120.0M RRD IND_DATA_RRD_COMP_TIME INDEX PARTITION RRD 103.0M RRD IND_DATA_RRD_COMP_TIME INDEX PARTITION RRD 96.0M PERFSTAT STATS$SQL_PLAN_USAGE TABLE USERS 88.0M PERFSTAT STATS$SYSSTAT_PK INDEX USERS 88.0M RRD IND_DATA_RRD_COMP_TIME INDEX PARTITION RRD 88.0M PERFSTAT STATS$PARAMETER_PK INDEX USERS 88.0M Largest tables -------------------------------------------------------------- Owner Table TsName Rows UsedBlocks Size Last Anal ------ ----- ------ ---------- ---------- ------- ----------- SYSTEM BENNY USERS 11881376 24757 193.4M 10-Aug-2005 Note: based on num_rows of analyze statistics Unused space -------------------------------------------------------------------------------------------- Owner Table TsName EffData TotAlloc AboveHwm Unused %Unused PctFree Extnts Analyzed ------- --------- ------ ------- -------- -------- ------- ------- ------- ------ --------- SYSTEM BENNY USERS 167.1M 199.0M 5.5M 31.8M 16 10 96 10-aug-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 RRD SYSTEM ---------- ------- ------- LIST 1 0 RANGE 0 27 Temporary tables -------------------------------------------------- Owner TableName TsName Duration ------ ------------------- ------ --------------- WMSYS WM$MW_TABLE SYS$SESSION DBSNMP MGMT_DB_SIZE_GTT SYS$TRANSACTION DBSNMP MGMT_DB_FILE_GTT SYS$TRANSACTION DBSNMP MGMT_RESPONSE_TEMPT SYS$TRANSACTION Note: excluding user SYS Tables with CACHE ----------------- Owner TableName ----- --------- Tables by degree -------------------- Degree NrTables ---------- -------- 1 642 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 ======================= DBMS Job information ------------------------------------------------------------------------------------------------------ Job Schema Last date This date Next date Brkn Fail What --- ------- ------------------- ------------------- ------------------- ---- ---- ------------------- 56 PANDORA 29-09-2005 21:58:47 29-09-2005 22:03:47 N 0 pandora_DBMON(300); Job queue parameters ------------------------------------------------------------------------------------------------------------------------------------ Security parameters Value job_queue_processes: 4 job_queue_interval: Unexistant Advanced queues --------------------------------------------------- Owner Queue QueueTable Comment ----- ------------- ------------- ---------------- RRD RRQ_OPERATION RRT_OPERATION Queue operations AQ parameters ---------------------------- Parameter Value aq_tm_processes: 0 Memory information ================== SGA Memory ------------------------------------------------------------------------ Parameter shared_pool_size: 112.0M Parameter shared_pool_reserved_size: 5.5M Parameter large_pool_size: 16.0M Parameter java_pool_size: 0 SGA Statistics ------------------------------------------------------------------------- Pool Name Value Bytes -------------------- ------------------------------ ------- ------------ fixed_sga 716.5K 733728 buffer_cache 32.0M 33554432 log_buffer 770.0K 788480 shared pool sql area 43.9M 46079824 shared pool free memory 54.0M 56696344 shared pool PL/SQL MPCODE 2.9M 3076160 shared pool library cache 12.2M 12872424 shared pool dictionary cache 3.0M 3229952 large pool free memory 16.0M 16777216 PGA Memory ---------------------------------------------------------------------------------- Parameter sort_area_size: 5242880 Parameter sort_area_retained_size: 0 Parameter hash_area_size: 10485760 Parameter pga_aggregate_target: 25165824 Parameter workarea_size_policy: AUTO PGA Statistics ---------------------------------------------------------------------------------------------------------------------------------- Name Value ---------------------------------------------------------------- ---------------------------------------------------------------- aggregate PGA target parameter 25165824 aggregate PGA auto target 19454976 global memory bound 1257472 total PGA inuse 3544064 total PGA allocated 14308352 maximum PGA allocated 298118144 total freeable PGA memory 0 PGA memory freed back to OS 756847083520 total PGA used for auto workareas 0 maximum PGA used for auto workareas 2414592 total PGA used for manual workareas 0 maximum PGA used for manual workareas 0 over allocation count 2328 bytes processed 43029307392 extra bytes read/written 12792229888 cache hit percentage 77.08 Buffer cache contents ----------------------------------------------------------------- Owner Name Size ------------------------ ------------------------------ -------- RRD SVT_DATA 9.6M RRD IND_DATA_RRD_COMP_TIME 7.3M SYS C_OBJ# 3.2M SYS OBJ$ 872.0K SYS C_FILE#_BLOCK# 744.0K SYS I_OBJ2 560.0K SYS I_OBJ1 216.0K SYS I_FILE#_BLOCK# 136.0K SYS I_OBJ# 120.0K SYS INDPART$ 104.0K SYS C_TS# 56.0K RRD UN_GRLVL_GRAPH_LEVEL 40.0K RRD UN_DATA 32.0K SYS I_IND1 32.0K RRD SVT_GRAPHS 24.0K SYS C_USER# 24.0K RRD PK_AGLEVELS 24.0K RRD PK_CSTMR 16.0K RRD PK_MEASURES 16.0K RRD SYS_C002609 16.0K RRD SVT_MEASURES 16.0K RRD UN_SAMPLE_WIDTH 16.0K SYS UNDO$ 16.0K SYS FILE$ 16.0K SYS JOB$ 16.0K Note: top 25 only Cache sizes ----------------------------------- Name Value --------------------- ------------ Block size 8192 db_cache_size: 32.0M 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 2654 Workarea histogram -------------------------------------------------- Low High Optimal OnePass MultiPass --------- --------- --------- --------- --------- 8192 16383 3482741 0 0 16384 32767 70609 0 0 32768 65535 203 0 0 65536 131071 75 0 0 131072 262143 141 0 0 262144 524287 34 0 0 524288 1048575 2807 0 0 1048576 2097151 43 0 0 134217728 268435455 0 0 3 268435456 536870911 0 0 7 Parameter Value pga_aggregate_target: 25165824 Security ======== Overview users ------------------------------------------------------------------------------------ Username DefTs TempTs Created NrSeg TotSize OPS$ ? Account DBA ? --------- -------- -------- ----------- ----- ------- ------ ---------------- ----- SYS SYSTEM TEMP 15-Apr-2004 660 231.1M No open Yes SYSTEM USERS TEMP 15-Apr-2004 335 682.7M No open Yes OUTLN SYSTEM TEMP 15-Apr-2004 6 384.0K No expired & locked No DBSNMP SYSTEM TEMP 15-Apr-2004 4 256.0K No open No WMSYS SYSTEM TEMP 15-Apr-2004 59 3.6M No expired & locked No CTXSYS DRSYS TEMP 15-Apr-2004 76 4.7M No expired & locked Yes RRD RRD TEMP 15-Apr-2004 1025 9.8G No open No XDB XDB TEMP 17-Apr-2004 712 44.6M No open No ANONYMOUS XDB TEMP 17-Apr-2004 0 0 No locked No NAGIOS USERS TEMP 26-Apr-2004 6 384.0K No open Yes PERFSTAT USERS TEMP 19-Jun-2004 83 1.2G No open No TESTXML USERS TEMP 19-Jan-2005 40 2.5M No open No SCOTT USERS TEMP 25-Feb-2005 1 64.0K No open No PANDORA USERS TEMP 20-Jul-2005 27 42.5M No open No Security parameters ------------------------------------------------------------------------------------------------------------------------------------ Security parameters Value remote_login_passwordfile: EXCLUSIVE remote_os_authent: FALSE os_authent_prefix: ops$ Networking ========== Multi Threaded Server info ------------------------------------------------------------------------------------------------------------------------------------ Parameter mts_dispatchers: Parameter dispatchers: Parameter mts_servers: 0 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 ======= v$version ----------------------------------------------------------------- Banner ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production CORE 9.2.0.3.0 Production TNS for Compaq Tru64 UNIX: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production DBA Registry ----------------------------------------------------- Id Name Version Status ------- --------------------------- --------- ------ CATALOG Oracle9i Catalog Views 9.2.0.4.0 VALID CATPROC Oracle9i Packages and Types 9.2.0.4.0 VALID OWM Oracle Workspace Manager 9.2.0.1.0 VALID CONTEXT Oracle Text 9.2.0.4.0 VALID XDB Oracle XML Database 9.2.0.4.0 VALID Featured init.ora parameters ------------------------------------------------------------------------------------------------------------------------- Parameter Dflt? Value --------------------------------- ----- -------------------------------------------------------------------------------- aq_tm_processes FALSE 0 audit_trail FALSE DB background_dump_dest FALSE /u03/admin/TRURRD/bdump compatible FALSE 9.2.0.0.0 control_files FALSE /u03/oradata/TRURRD/control01.ctl, /u03/oradata/TRURRD/control02.ctl, /u03/orada ta/TRURRD/control03.ctl core_dump_dest FALSE /u03/admin/TRURRD/cdump db_block_buffers TRUE 0 db_block_size FALSE 8192 db_cache_size FALSE 33554432 db_domain FALSE iconos.be db_file_multiblock_read_count FALSE 16 db_name FALSE TRURRD fast_start_mttr_target FALSE 300 hash_join_enabled FALSE TRUE instance_name FALSE TRURRD java_pool_size FALSE 0 job_queue_processes FALSE 4 large_pool_size FALSE 16777216 log_archive_start TRUE FALSE log_buffer TRUE 524288 open_cursors FALSE 300 pga_aggregate_target FALSE 25165824 processes FALSE 150 query_rewrite_enabled FALSE FALSE remote_login_passwordfile FALSE EXCLUSIVE shared_pool_size FALSE 117440512 sort_area_size FALSE 5242880 sql_trace TRUE FALSE star_transformation_enabled FALSE FALSE timed_os_statistics TRUE 0 timed_statistics FALSE TRUE undo_management FALSE AUTO undo_retention FALSE 10800 undo_tablespace FALSE UNDOTBS1 user_dump_dest FALSE /u03/admin/TRURRD/udump utl_file_dir TRUE Note: taking all non default parameters + some important ones Hidden parameters ------------------------------------------------------------------------------------------------------------ Name Description Instance value ------------------------------ ------------------------------------------------------------ --------------- Database Features ================= Java stored procedures --------------------------------------- Username Nr ------------------------------ ------- Materialized views --------------------------------------- Username Nr ------------------------------ ------- Refresh groups ----------------- Owner Nr -------- ------- Advanced queues --------------------------------------- Username Nr ------------------------------ ------- RRD 2 SYS 4 SYSTEM 4 Clusters (non SYS) --------------------------------------- Username Nr ------------------------------ ------- Domain indexes --------------------------------------- Username Nr ------------------------------ ------- Dimensions --------------------------------------- Username Nr ------------------------------ ------- Partitioned tables ------------------------------------------------ Username Nr Type ------------------------------ ------- -------- RRD 1 LIST SYSTEM 27 RANGE Database links --------------------------------------- Username Nr ------------------------------ ------- RRD 1 Directories --------------------------------------- Username Nr ------------------------------ ------- Libraries --------------------------------------- Username Nr ------------------------------ ------- CTXSYS 2 SYS 63 SYSTEM 1 XDB 10 Stored outlines --------------------------------------- Username Nr ------------------------------ ------- FGAC / VPD --------------------- Object owner Nr ------------ ------- TESTXML 15 XDB 18 Object types (non-SYS) --------------------------------------- Owner Nr ------------------------------ ------- CTXSYS 10 PANDORA 7 RRD 12 SYSTEM 1 TESTXML 10 WMSYS 5 XDB 132 Resource plans ------------------------------- Plan ------------------------------ SYSTEM_PLAN INTERNAL_QUIESCE INTERNAL_PLAN Database event triggers -------------------------------------------------------------- Username Nr Event ------------------------------ ------- ---------------------- Audit options ------------------------------------------------------------ Type Username Nr -------------------- ------------------------------ ------- Script to recreate the controlfile ================================== CREATE CONTROLFILE script ----------------------------------------------------------------------------------------------------------------------------------------------------------------- CREATE CONTROLFILE REUSE DATABASE "TRURRD" RESETLOGS NOARCHIVELOG -- CREATE CONTROLFILE REUSE SET DATABASE "NEW_DB_NAME" RESETLOGS NOARCHIVELOG MAXLOGFILES 5 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 1815 LOGFILE GROUP 1 ('/u03/oradata/TRURRD/redo01.log') SIZE 25400K, GROUP 2 ('/u03/oradata/TRURRD/redo02.log') SIZE 25400K DATAFILE '/u03/oradata/TRURRD/system01.dbf', '/u02/oradata/TRURRD/undotbs01.dbf', '/u03/oradata/TRURRD/drsys01.dbf', '/u03/oradata/TRURRD/users01.dbf', '/u03/oradata/TRURRD/rrd01.dbf', '/u01/oradata/TRURRD/rrdq01.dbf', '/u01/oracle/product/ora920/oradata/TRURRD/xdb01.dbf', '/u02/oradata/TRURRD/rrd02.dbf' CHARACTER SET WE8ISO8859P1 ; -- 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 '/u03/oradata/TRURRD/temp01.dbf' SIZE 482M REUSE AUTOEXTEND ON NEXT 80 MAXSIZE 33554416K; 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 199 seconds] [Usage: SQL*Plus: "exec plato.help" after "set serveroutput on format wrapped"]