ࡱ>   \p vovchenko Ba==3{*8X@"1"R Arial Cyr1"R Arial Cyr1"R Arial Cyr1"R Arial Cyr1"R Arial Cyr1" R Arial Cyr1"$R Arial Cyr/#,##0"@.";\-#,##0"@."9#,##0"@.";[Red]\-#,##0"@.";#,##0.00"@.";\-#,##0.00"@."E #,##0.00"@.";[Red]\-#,##0.00"@."k*3_-* #,##0"@."_-;\-* #,##0"@."_-;_-* "-""@."_-;_-@_-k)3_-* #,##0_@_._-;\-* #,##0_@_._-;_-* "-"_@_._-;_-@_-{,;_-* #,##0.00"@."_-;\-* #,##0.00"@."_-;_-* "-"??"@."_-;_-@_-{+;_-* #,##0.00_@_._-;\-* #,##0.00_@_._-;_-* "-"??_@_._-;_-@_-#"0";"0";"5B"5"AB8=0";"AB8=0";">6L")":;";":;";"K:;"Y*[$ -2]\ ###,000_);[Red]\([$ -2]\ ###,000\)                 , *   + )    `8AB1^8AB2_8AB3" #08.06.14 11:02:21 -- SYS TRUE TRUE [08.06.14 11:02:21 -- ************************* Locked objects *************************608.06.14 11:02:22 -- TYPENAME|USERNAME|MACHINE|OSUSER|[08.06.14 11:02:22 -- ************************** Transactions **************************08.06.14 11:02:22 -- SID|SERIAL#|NAME|STATUS|START_TIME|USED_UBLK|LOG_IO|PHY_IO|USERNAME|LOCKWAIT|OSUSER|MACHINE|SQL_ADDRESS|SQL_TEXT|PREV_SQL_TXT|\08.06.14 11:02:22 -- ************************* Long operations *************************08.06.14 11:02:23 -- SID|SERIAL#|OPNAME|TARGET|TARGET_DESC|SOFAR|TOTALWORK|UNITS|START_TIME|LAST_UPDATE_TIME|TIMESTAMP|TIME_REMAINING|ELAPSED_SECONDS|CONTEXT|MESSAGE|USERNAME|SQL_ADDRESS|SQL_HASH_VALUE|SQL_ID|QCSID|[08.06.14 11:02:23 -- ************************** Incarnations **************************08.06.14 11:02:23 -- RESOURCE_TYPE|RESOURCE_ID|RESOURCE_NAME|DB_UNIQUE_NAME|DB_DOMAIN|INSTANCE_NAME|HOST_NAME|LOCATION|INCARNATION|STARTUP_TIME |SHUTDOWN_TIME|DESCRIPTION|08.06.14 11:02:23 -- INSTANCE |1 |ocean |ocean |==N/A== |ocean |OCEAN2 |OCEAN2 |==N/A== |2014-6-8.3.57. 0. 0|null |null |[08.06.14 11:02:23 -- ********************** Database properties **********************B08.06.14 11:02:24 -- DICT.BASE 2 dictionary base tables version # W08.06.14 11:02:24 -- DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace ]08.06.14 11:02:24 -- DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace 408.06.14 11:02:24 -- DBTIMEZONE +07:00 DB time zone H08.06.14 11:02:24 -- DEFAULT_TBS_TYPE SMALLFILE Default tablespace type 308.06.14 11:02:24 -- NLS_LANGUAGE RUSSIAN Language 408.06.14 11:02:24 -- NLS_TERRITORY RUSSIA Territory 408.06.14 11:02:24 -- NLS_CURRENCY ?. Local currency :08.06.14 11:02:24 -- NLS_ISO_CURRENCY RUSSIA ISO currency B08.06.14 11:02:24 -- NLS_NUMERIC_CHARACTERS , Numeric characters A08.06.14 11:02:24 -- NLS_CHARACTERSET CL8MSWIN1251 Character set <08.06.14 11:02:25 -- NLS_CALENDAR GREGORIAN Calendar system :08.06.14 11:02:25 -- NLS_DATE_FORMAT DD.MM.RR Date format =08.06.14 11:02:25 -- NLS_DATE_LANGUAGE RUSSIAN Date language <08.06.14 11:02:25 -- NLS_SORT RUSSIAN Linguistic definition ?08.06.14 11:02:25 -- NLS_TIME_FORMAT HH24:MI:SSXFF Time format S08.06.14 11:02:25 -- NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF Time stamp format T08.06.14 11:02:25 -- NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR Time with timezone format g08.06.14 11:02:25 -- NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR Timestamp with timezone format ?08.06.14 11:02:25 -- NLS_DUAL_CURRENCY ?. Dual currency symbol 408.06.14 11:02:25 -- NLS_COMP BINARY NLS comparison D08.06.14 11:02:25 -- NLS_LENGTH_SEMANTICS BYTE NLS length semantics H08.06.14 11:02:25 -- NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception J08.06.14 11:02:25 -- NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set S08.06.14 11:02:25 -- NLS_RDBMS_VERSION 10.2.0.4.0 RDBMS version for NLS parameters ?08.06.14 11:02:25 -- GLOBAL_DB_NAME OCEAN Global database name D08.06.14 11:02:26 -- EXPORT_VIEWS_VERSION 8 Export views revision # `08.06.14 11:02:26 -- WORKLOAD_CAPTURE_MODE null CAPTURE implies workload capture is in progress \08.06.14 11:02:26 -- *********************** Current SQL queries ***********************J08.06.14 11:02:26 -- BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; A08.06.14 11:02:26 -- Unregistered version. Session list disabled.\08.06.14 11:02:26 -- ****************************** Waits ******************************A08.06.14 11:02:27 -- User I/O : db file sequential read 3666 .59 H08.06.14 11:02:27 -- System I/O : control file sequential read 3143 .38 G08.06.14 11:02:27 -- System I/O : control file parallel write 1366 .52 =08.06.14 11:02:27 -- Concurrency : os thread startup 140 4.1 C08.06.14 11:02:27 -- System I/O : log file parallel write 1492 .07 ?08.06.14 11:02:27 -- User I/O : db file scattered read 137 .75 B08.06.14 11:02:27 -- System I/O : db file parallel write 1481 .06 908.06.14 11:02:27 -- System I/O : Log archive I/O 7 5.45 B08.06.14 11:02:27 -- System I/O : log file sequential read 21 .49 I08.06.14 11:02:27 -- Application : SQL*Net break/reset to client 254 .02 908.06.14 11:02:27 -- User I/O : direct path write 22 .04 808.06.14 11:02:27 -- User I/O : direct path read 44 .02 >08.06.14 11:02:27 -- System I/O : log file single write 8 .01 <08.06.14 11:02:27 -- Concurrency : latch: shared pool 1 .08 708.06.14 11:02:27 -- Concurrency : cursor: mutex S 3 0 :08.06.14 11:02:28 -- User I/O : direct path read temp 3 0 @08.06.14 11:02:28 -- Network : SQL*Net message to client 2798 0 [08.06.14 11:02:28 -- ************************* Waits by class *************************"08.06.14 11:02:28 -- Other 197.05 %08.06.14 11:02:28 -- System I/O 6.98 &08.06.14 11:02:28 -- Concurrency 4.18 "08.06.14 11:02:28 -- User I/O 1.4 %08.06.14 11:02:28 -- Application .02 08.06.14 11:02:28 -- Network 0 \08.06.14 11:02:28 -- ************************* Wait statistics *************************308.06.14 11:02:29 -- CLASS |COUNT|TIME|308.06.14 11:02:29 -- data block |988 |37 |308.06.14 11:02:29 -- save undo block |0 |0 |308.06.14 11:02:29 -- segment header |0 |0 |308.06.14 11:02:29 -- save undo header |0 |0 |308.06.14 11:02:29 -- free list |0 |0 |308.06.14 11:02:29 -- extent map |0 |0 |308.06.14 11:02:29 -- 1st level bmb |0 |0 |308.06.14 11:02:29 -- 2nd level bmb |0 |0 |308.06.14 11:02:29 -- 3rd level bmb |0 |0 |308.06.14 11:02:29 -- bitmap block |0 |0 |308.06.14 11:02:29 -- bitmap index block|0 |0 |308.06.14 11:02:29 -- file header block |0 |0 |308.06.14 11:02:29 -- unused |0 |0 |308.06.14 11:02:29 -- system undo header|0 |0 |308.06.14 11:02:29 -- system undo block |0 |0 |308.06.14 11:02:29 -- undo header |1 |0 |308.06.14 11:02:30 -- undo block |5 |0 |308.06.14 11:02:30 -- sort block |0 |0 |\08.06.14 11:02:30 -- ************************** Top 15 events **************************X08.06.14 11:02:30 -- EVENT |TOTAL_WAITS|TIME_WAITED|AVERAGE_WAIT|X08.06.14 11:02:30 -- db file sequential read |45069 |1136 |.03 |X08.06.14 11:02:30 -- db file scattered read |3950 |959 |.24 |X08.06.14 11:02:30 -- control file heartbeat |1 |399 |399.29 |X08.06.14 11:02:30 -- control file sequential read |4926 |340 |.07 |X08.06.14 11:02:30 -- os thread startup |158 |337 |2.13 |X08.06.14 11:02:30 -- control file parallel write |1415 |256 |.18 |X08.06.14 11:02:31 -- enq: CF - contention |3 |238 |79.33 |X08.06.14 11:02:31 -- rdbms ipc reply |18 |213 |11.81 |X08.06.14 11:02:31 -- enq: TX - row lock contention|104 |205 |1.97 |X08.06.14 11:02:31 -- log file parallel write |1493 |105 |.07 |X08.06.14 11:02:31 -- db file parallel write |1481 |96 |.06 |X08.06.14 11:02:31 -- cursor: pin S wait on X |76 |96 |1.26 |X08.06.14 11:02:31 -- switch logfile command |3 |61 |20.26 |X08.06.14 11:02:31 -- kksfbc child completion |11 |58 |5.29 |X08.06.14 11:02:31 -- SQL*Net break/reset to client|2616 |48 |.02 |\08.06.14 11:02:31 -- ************************* Resource limits *************************n08.06.14 11:02:31 -- RESOURCE_NAME |CURRENT_UTILIZATION|MAX_UTILIZATION|INITIAL_ALLOCATION|LIMIT_VALUE|n08.06.14 11:02:32 -- branches |0 |0 | 187 | UNLIMITED |n08.06.14 11:02:32 -- cmtcallbk |0 |1 | 187 | UNLIMITED |n08.06.14 11:02:32 -- d< ml_locks |0 |47 | 748 | UNLIMITED |n08.06.14 11:02:32 -- enqueue_locks |18 |34 | 2380 | 2380 |n08.06.14 11:02:32 -- enqueue_resources |18 |45 | 968 | UNLIMITED |n08.06.14 11:02:32 -- gcs_resources |0 |0 | 0 | 0 |n08.06.14 11:02:32 -- gcs_shadows |0 |0 | 0 | 0 |n08.06.14 11:02:32 -- ges_big_msgs |0 |0 | 0 | UNLIMITED |n08.06.14 11:02:32 -- ges_cache_ress |0 |0 | 0 | UNLIMITED |n08.06.14 11:02:32 -- ges_locks |0 |0 | 0 | UNLIMITED |n08.06.14 11:02:32 -- ges_procs |0 |0 | 0 | 0 |n08.06.14 11:02:32 -- ges_reg_msgs |0 |0 | 0 | UNLIMITED |n08.06.14 11:02:32 -- ges_ress |0 |0 | 0 | UNLIMITED |n08.06.14 11:02:33 -- ges_rsv_msgs |0 |0 | 0 | 0 |n08.06.14 11:02:33 -- max_rollback_segments|11 |11 | 187 | 65535 |n08.06.14 11:02:33 -- max_shared_servers |1 |1 | UNLIMITED | UNLIMITED |n08.06.14 11:02:33 -- parallel_max_servers |1 |3 | 80 | 3600 |n08.06.14 11:02:33 -- processes |29 |37 | 150 | 150 |n08.06.14 11:02:33 -- sessions |35 |40 | 170 | 170 |n08.06.14 11:02:33 -- sort_segment_locks |0 |1 | UNLIMITED | UNLIMITED |n08.06.14 11:02:33 -- temporary_table_locks|0 |0 | UNLIMITED | UNLIMITED |n08.06.14 11:02:33 -- transactions |1 |5 | 187 | UNLIMITED |[08.06.14 11:02:33 -- ************************* Resource usage *************************d08.06.14 11:02:34 -- METRIC |VALUE |UNIT |d08.06.14 11:02:34 -- Buffer Cache Hit Ratio |97.4512743628186|% (LogRead - PhyRead)/LogRead |d08.06.14 11:02:34 -- Consistent Read Changes Per Se|0 |Blocks Per Second |d08.06.14 11:02:34 -- c | | |d08.06.14 11:02:34 -- Consistent Read Changes Per Tx|0 |Blocks Per Txn |d08.06.14 11:02:34 -- n | | |d08.06.14 11:02:34 -- Consistent Read Gets Per Sec |288.333333333333|Blocks Per Second |d08.06.14 11:02:34 -- Consistent Read Gets Per Txn |288.333333333333|Blocks Per Txn |d08.06.14 11:02:34 -- DB Block Changes Per Sec |20.7333333333333|Blocks Per Second |d08.06.14 11:02:34 -- DB Block Changes Per Txn |20.7333333333333|Blocks Per Txn |d08.06.14 11:02:34 -- DB Block Gets Per Sec |22.9333333333333|Blocks Per Second |d08.06.14 11:02:34 -- DB Block Gets Per Txn |22.9333333333333|Blocks Per Txn |d08.06.14 11:02:35 -- Database CPU Time Ratio |58.9646328085166|% Cpu/DB_Time |d08.06.14 11:02:35 -- Database Time Per Sec |6.90357333333333|CentiSeconds Per Second |d08.06.14 11:02:35 -- Execute Without Parse Ratio |11.1922141119221|% (ExecWOParse/TotalExec) |d08.06.14 11:02:35 -- Executions Per Sec |27.4 |Executes Per Second |d08.06.14 11:02:35 -- Executions Per Txn |27.4 |Executes Per Txn |d08.06.14 11:02:35 -- Full Index Scans Per Sec |0 |Scans Per Second |d08.06.14 11:02:35 -- Full Index Scans Per Txn |0 |Scans Per Txn |d08.06.14 11:02:35 -- Host CPU Utilization (%) |39.1833333333333|% Busy/(Idle+Busy) |d08.06.14 11:02:35 -- Library Cache Hit Ratio |99.1021324354658|% Hits/Pins |d08.06.14 11:02:35 -- Logical Reads Per Sec |311.266666666667|Reads Per Second |d08.06.14 11:02:35 -- Logical Reads Per Txn |311.266666666667|Reads Per Txn |d08.06.14 11:02:35 -- Logons Per Sec |1.8 |Logons Per Second |d08.06.14 11:02:35 -- Logons Per Txn |1.8 |Logons Per Txn |d08.06.14 11:02:35 -- Memory Sorts Ratio |100 |% MemSort/(MemSort + DiskSort)|d08.06.14 11:02:36 -- Physical Reads Direct Per Sec |0 |Reads Per Second |d08.06.14 11:02:36 -- Physical Reads Direct Per Txn |0 |Reads Per Txn |d08.06.14 11:02:36 -- Physical Reads Per Sec |7.93333333333333|Reads Per Second |d08.06.14 11:02:36 -- Physical Reads Per Txn |7.93333333333333|Reads Per Txn |d08.06.14 11:02:36 -- Physical Writes Per Sec |0 |Writes Per Second |d08.06.14 11:02:36 -- Physical Writes Per Txn |0 |Writes Per Txn |d08.06.14 11:02:36 -- Redo Generated Per Sec |2571.73333333333|Bytes Per Second |d08.06.14 11:02:36 -- Redo Generated Per Txn |2571.73333333333|Bytes Per Txn |d08.06.14 11:02:36 -- Redo Writes Per Sec |.266666666666667|Writes Per Second |d08.06.14 11:02:36 -- Redo Writes Per Txn |.266666666666667|Writes Per Txn |d08.06.14 11:02:36 -- Shared Pool Free % |48.722307604566 |% Free/Total |d08.06.14 11:02:36 -- Soft Parse Ratio |99.4520547945205|% SoftParses/TotalParses |d08.06.14 11:02:37 -- Total Table Scans Per Sec |3.8 |Scans Per Second |d08.06.14 11:02:37 -- Total Table Scans Per Txn |3.8 |Scans Per Txn |d08.06.14 11:02:37 -- Txns Per Logon |.555555555555556|Txns Per Logon |d08.06.14 11:02:37 -- User Calls Per Sec |23.5333333333333|Calls Per Second |d08.06.14 11:02:37 -- User Calls Per Txn |23.5333333333333|Calls Per Txn |d08.06.14 11:02:37 -- User Transaction Per Sec |1 |Transactions Per Second |\08.06.14 11:02:37 -- ************************** OS statistics ************************** 08.06.14 11:02:37 -- NUM_CPUS 4 '08.06.14 11:02:37 -- IDLE_TIME 1471251 &08.06.14 11:02:37 -- BUSY_TIME 110106 %08.06.14 11:02:37 -- USER_TIME 56328 $08.06.14 11:02:37 -- SYS_TIME 53778 *08.06.14 11:02:37 -- AVG_IDLE_TIME 367713 )08.06.14 11:02:38 -- AVG_BUSY_TIME 27425 )08.06.14 11:02:38 -- AVG_USER_TIME 13975 (08.06.14 11:02:38 -- AVG_SYS_TIME 13341 .08.06.14 11:02:38 -- RSRC_MGR_CPU_WAIT_TIME 0 %08.06.14 11:02:38 -- NUM_CPU_CORES 2 608.06.14 11:02:38 -- PHYSICAL_MEMORY_BYTES 4126662656 +08.06.14 11:02:38 -- VM_IN_BYTES 601571328 +08.06.14 11:02:38 -- VM_OUT_BYTES 31588352 \08.06.14 11:02:38 -- ****************** Index usage (SEQ/SCATT reads) ******************08.06.14 11:02:38 -- .03 .24 \08.06.14 11:02:38 -- ****************************** Sorts *******************************08.06.14 11:02:39 -- sorts (memory) 23864 $08.06.14 11:02:39 -- sorts (disk) 0 *08.06.14 11:02:39 -- sorts (rows) 1782941 [08.06.14 11:02:39 -- ********************* SGA dynamic components *********************08.06.14 11:02:39 -- COMPONENT |CURRENT_SIZE|MIN_SIZE |MAX_SIZE|USER_SPECIFIED_SIZE|OPER_COUNT|LAST_OPER_TYPE|LAST_OPER_MODE|LAST_OPER_TIME|GRANULE_SIZE|08.06.14 11:02:39 -- shared pool < |524288000 |524288000|0 |100663296 |0 |STATIC |null |null |4194304 |08.06.14 11:02:39 -- large pool |12582912 |12582912 |0 |12582912 |0 |STATIC |null |null |4194304 |08.06.14 11:02:39 -- java pool |4194304 |4194304 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- streams pool |0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- DEFAULT buffer cache |29360128 |29360128 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- KEEP buffer cache |0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- RECYCLE buffer cache |33554432 |33554432 |0 |33554432 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- DEFAULT 2K buffer cache |0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- DEFAULT 4K buffer cache |0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- DEFAULT 8K buffer cache |0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- DEFAULT 16K buffer cache|0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- DEFAULT 32K buffer cache|0 |0 |0 |0 |0 |STATIC |null |null |4194304 |08.06.14 11:02:40 -- ASM Buffer Cache |0 |0 |0 |0 |0 |STATIC |null |null |4194304 |\08.06.14 11:02:41 -- ************************* SGA information *************************/08.06.14 11:02:41 -- Fixed SGA Size 1299412 No -08.06.14 11:02:41 -- Redo Buffers 7086080 No 408.06.14 11:02:41 -- Buffer Cache Size 62914560 Yes 408.06.14 11:02:41 -- Shared Pool Size 524288000 Yes 208.06.14 11:02:41 -- Large Pool Size 12582912 Yes 008.06.14 11:02:41 -- Java Pool Size 4194304 Yes -08.06.14 11:02:41 -- Streams Pool Size 0 Yes -08.06.14 11:02:41 -- Granule Size 4194304 No 308.06.14 11:02:41 -- Maximum SGA Size 822083584 No A08.06.14 11:02:41 -- Startup overhead in Shared Pool 41943040 No >08.06.14 11:02:41 -- Free SGA Memory Available 209715200 null \08.06.14 11:02:41 -- ************************* PGA information *************************D08.06.14 11:02:42 -- aggregate PGA target parameter 765460480 bytes ?08.06.14 11:02:42 -- aggregate PGA auto target 667745280 bytes 508.06.14 11:02:42 -- bytes processed 452690944 bytes 908.06.14 11:02:42 -- global memory bound 104857600 bytes :08.06.14 11:02:42 -- maximum PGA allocated 55460864 bytes 808.06.14 11:02:42 -- total PGA allocated 48144384 bytes 408.06.14 11:02:42 -- total PGA inuse 24168448 bytes G08.06.14 11:02:42 -- maximum PGA used for auto workareas 4979712 bytes 708.06.14 11:02:42 -- recompute count (total) 1306 null 608.06.14 11:02:42 -- cache hit percentage 100 percent 108.06.14 11:02:42 -- max processes count 35 null +08.06.14 11:02:42 -- process count 31 null C08.06.14 11:02:42 -- maximum PGA used for manual workareas 0 bytes 908.06.14 11:02:42 -- PGA memory freed back to OS 0 bytes 608.06.14 11:02:42 -- extra bytes read/written 0 bytes 708.06.14 11:02:42 -- total freeable PGA memory 0 bytes A08.06.14 11:02:42 -- total PGA used for manual workareas 0 bytes ?08.06.14 11:02:43 -- total PGA used for auto workareas 0 bytes 208.06.14 11:02:43 -- over allocation count 0 null \08.06.14 11:02:43 -- *************************** SGA history ***************************08.06.14 11:02:43 -- COMPONENT |OPER_TYPE|OPER_MODE|PARAMETER |INITIAL_SIZE|TARGET_SIZE|FINAL_SIZE|STATUS |START_TIME |END_TIME |08.06.14 11:02:43 -- shared pool |STATIC |null |shared_pool_size |0 |524288000 |524288000 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:43 -- large pool |STATIC |null |large_pool_size |0 |12582912 |12582912 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:43 -- java pool |STATIC |null |java_pool_size |0 |4194304 |4194304 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:43 -- streams pool |STATIC |null |streams_pool_size |0 |0 |0 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:43 -- DEFAULT 4K buffer cache|STATIC |null |db_4k_cache_size |0 |0 |0 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:44 -- KEEP buffer cache |STATIC |null |db_keep_cache_size |0 |0 |0 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:44 -- RECYCLE buffer cache |STATIC |null |db_recycle_cache_size|0 |33554432 |33554432 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:44 -- DEFAULT 2K buffer cache|STATIC |null |db_2k_cache_size |0 |0 |0 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|08.06.14 11:02:44 -- DEFAULT buffer cache |STATIC |null |db_cache_size |0 |29360128 |29360128 |COMPLETE|2014-06-08 09:57:13.0|2014-06-08 09:57:13.0|[08.06.14 11:02:44 -- ************************ SGA distribution ************************708.06.14 11:02:44 -- shared pool free memory 356062168 508.06.14 11:02:44 -- large pool free memory 11508912 308.06.14 11:02:45 -- java pool free memory 4194304 \08.06.14 11:02:45 -- ********************* Library cache hit ratio *********************B08.06.14 11:02:45 -- 9.98086129532039907147796904569164705441E-01 \08.06.14 11:02:45 -- **************************** Row cache ****************************$08.06.14 11:02:45 -- dc_users 58897 *08.06.14 11:02:45 -- dc_tablespaces 32800 )08.06.14 11:02:46 -- dc_object_ids 23243 -08.06.14 11:02:46 -- dc_histogram_defs 19625 -08.06.14 11:02:46 -- dc_histogram_data 11709 -08.06.14 11:02:46 -- dc_histogram_data 11678 %08.06.14 11:02:46 -- dc_objects 9042 #08.06.14 11:02:46 -- dc_users 8838 '08.06.14 11:02:46 -- dc_usernames 7049 \08.06.14 11:02:46 -- ************************ Shared pool usage ************************208.06.14 11:02:46 -- 524292696-all 356071116-free ^08.06.14 11:02:47 -- SHARED_POOL_SIZE|SUM_OBJ_SIZE|SUM_SQL_SIZE|SUM_USER_SIZE|MIN_SHARED_POOL|^08.06.14 11:02:47 -- 100663296 |63311697 |53824719 |18000 |152300740.8 |\08.06.14 11:02:47 -- ***************************** Latches *****************************008.06.14 11:02:47 -- WHERE|SLEEP_COUNT|LOCATION|@08.06.14 11:02:48 -- Unregistered version. SQL history disabled.'08.06.14 11:02:48 -- ******************$08.06.14 11:02:48 -- Usage checks...M08.06.14 11:02:48 -- Update your info... - for OCEAN.OCEAN2.24558591754107671[08.06.14 11:02:48 -- *************************** Flash area ***************************_08.06.14 11:02:49 -- FILE_TYPE |PERCENT_SPACE_USED|PERCENT_SPACE_RECLAIMABLE|NUMBER_OF_FILES|_08.06.14 11:02:49 -- CONTROLFILE |0 |0 |0 |_08.06.14 11:02:49 -- ONLINELOG |0 |0 |0 |_08.06.14 11:02:49 -- ARCHIVELOG |2.85 |.01 |438 |_08.06.14 11:02:49 -- BACKUPPIECE |4.35 |2.54 |47 |_08.06.14 11:02:49 -- < IMAGECOPY |0 |0 |0 |_08.06.14 11:02:49 -- FLASHBACKLOG|0 |0 |0 |=08.06.14 11:02:49 -- Check sessions with limit of 600 seconds!08.06.14 11:02:57 -- Client tasks208.06.14 11:02:58 -- We don't need run tasks now..s08.06.14 11:02:58 -- ***************** Summary OCEAN.OCEAN2.24558591754107671 92.255.188.143 514 *** 150649487908.06.14 11:03:00 -- Supermag : 1.028.2 SP4 OS : Windows 2003 Java : 1.7.0_15 Jabbers : -/- Mail:vovchenko70@mail.ru/vovchenko70@mail.ruO08.06.14 11:03:01 -- Security mode : 1 Registered since: 2012-12-18 15:56:30.0R08.06.14 11:03:01 -- Startup time : 2014-06-08 09:57:00.0 (0) Oracle : 10.2.0.4.0B08.06.14 11:03:02 -- Last full rman backup : 2014-06-06 22:06:25.0s08.06.14 11:03:03 -- Last backup checkpoint : 2014-06-06 21:13:10.0 (1) Corruption : marked:0/media:14/logic:17946208.06.14 11:03:12 -- Last analyzed : 2011-10-24 14:22:38.0 (957) Invalids : 0 Oldest non-organized object : 2014-06-07 04:56:07.0 Last system stats : 12-19-2012 02:00f08.06.14 11:03:13 -- Last transfer : 07.06.14 06:06 (28) Last calculation : 20.01.87 19:24 (240015) D08.06.14 11:00:35 -- Optimizer for Oracle bases console version 4.10"08.06.14 11:00:35 -- C:\optimizer4408.06.14 11:00:35 -- Master server: olegon.no-ip.org&08.06.14 11:00:35 -- DB server: ocean2#08.06.14 11:00:35 -- DB name: ocean)08.06.14 11:00:35 -- Requested commands:o&08.06.14 11:00:35 -- Commands accepted08.06.14 11:00:36 -- |508.06.14 11:00:36 -- ||||||||||||||||||||||||||||||||508.06.14 11:00:36 -- ||||||||| Start server |||||||||%08.06.14 11:00:36 -- DB status : OPEN?08.06.14 11:00:36 -- Client ID : OCEAN.OCEAN2.24558591754107671,08.06.14 11:00:37 -- Check program status...(08.06.14 11:00:37 -- Validation check...(08.06.14 11:00:39 -- Client number: 514 308.06.14 11:00:39 -- Program status: Nonclient mode)08.06.14 11:00:39 -- Unregistered versionb08.06.14 11:00:39 -- .............................................................................008.06.14 11:00:40 -- Archivelog enabled... Good.208.06.14 11:00:40 -- Optimizer parameters check...P08.06.14 11:00:52 -- Orders optimization disabled because of Supermag version...D08.06.14 11:00:53 -- Allowed message sending (user configuration)...M08.06.14 11:00:53 -- Alert emails : vovchenko70@mail.ru/vovchenko70@mail.ru/-(08.06.14 11:00:53 -- Alert jabbers : -/-I08.06.14 11:00:54 -- All alerts disabled, because main email unconfirmed.08.06.14 11:00:54 -- Arch : x86(08.06.14 11:00:55 -- OS : Windows 2003$08.06.14 11:00:55 -- Java : 1.7.0_15)08.06.14 11:00:56 -- pwd : C:\optimizer4(08.06.14 11:00:57 -- IP : 92.255.188.143l08.06.14 11:00:58 -- PATH : C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;c:\oracle\ora102\client_1\bin;c:\oracle\ora102\client_1;c:\oracle\ora102\db_1\bin;C:\PROGRA~1\COMMON~1\BORLAN~1\BDE;C:\SM2000\Bin;C:\orant\bin;C:\Program Files\Common Files\Acronis\SnapAPI\;C:\Program Files\Acronis\CommandLineTool\;C:\Program Files\Common Files\Acronis\TibMounter'08.06.14 11:00:58 -- ORACLE_SID : OCEAN$08.06.14 11:00:59 -- DB name : OCEAN#08.06.14 11:01:00 -- DB size : 49Gb908.06.14 11:01:01 -- Big database detected.. Ooops... ;-)[08.06.14 11:01:01 -- **************************** Sessions ****************************08.06.14 11:01:02 -- ACTIVE 18 08.06.14 11:01:02 -- INACTIVE 6 08.06.14 11:01:02 -- USER 8 #08.06.14 11:01:02 -- BACKGROUND 16 "08.06.14 11:01:02 -- DEDICATED 24 08.06.14 11:01:02 -- SUMMARY 24 \08.06.14 11:01:02 -- **************************** Computers ****************************08.06.14 11:01:03 -- OCEAN2 24 \08.06.14 11:01:03 -- ****************************** Users ******************************08.06.14 11:01:03 -- SYSMAN 7 08.06.14 11:01:03 -- SYS 1 08.06.14 11:01:03 -- null 0 [08.06.14 11:01:03 -- **************************** Programs ****************************,08.06.14 11:01:04 -- null ORACLE.EXE (ARC0) ,08.06.14 11:01:04 -- null ORACLE.EXE (ARC1) ,08.06.14 11:01:04 -- null ORACLE.EXE (CJQ0) ,08.06.14 11:01:04 -- null ORACLE.EXE (CKPT) ,08.06.14 11:01:04 -- null ORACLE.EXE (DBW0) ,08.06.14 11:01:04 -- null ORACLE.EXE (LGWR) ,08.06.14 11:01:04 -- null ORACLE.EXE (MMAN) ,08.06.14 11:01:04 -- null ORACLE.EXE (MMNL) ,08.06.14 11:01:04 -- null ORACLE.EXE (MMON) ,08.06.14 11:01:04 -- null ORACLE.EXE (PMON) ,08.06.14 11:01:04 -- null ORACLE.EXE (PSP0) ,08.06.14 11:01:04 -- null ORACLE.EXE (QMNC) ,08.06.14 11:01:04 -- null ORACLE.EXE (RECO) ,08.06.14 11:01:04 -- null ORACLE.EXE (SMON) ,08.06.14 11:01:04 -- null ORACLE.EXE (q000) ,08.06.14 11:01:04 -- null ORACLE.EXE (q001) 08.06.14 11:01:05 -- SYSMAN OMS 08.06.14 11:01:05 -- SYS null (08.06.14 11:01:05 -- Users : SYS SYSMAN \08.06.14 11:01:05 -- ************************** Recovery area **************************\08.06.14 11:01:05 -- NAME |SPACE_LIMIT |SPACE_USED |SPACE_RECLAIMABLE|NUMBER_OF_FILES|\08.06.14 11:01:05 -- G:\backup|1507374182400|108472605184|38514076160 |485 |\08.06.14 11:01:05 -- ************************ Blocking sessions ************************@08.06.14 11:01:08 -- *******************************************308.06.14 11:01:08 -- Maintenance interval : 19:00,8,08.06.14 11:01:08 -- Not maintenance time...808.06.14 11:01:08 -- Supermag database detected... Cool.'08.06.14 11:01:08 -- RDBMS version : 10"08.06.14 11:01:08 -- Good choice..C08.06.14 11:01:09 -- Small SGA. Stupid machine or admin detected...!08.06.14 11:01:09 -- trying cmd:ot08.06.14 11:01:09 -- Requested full regular optimization... I suppose, that you'll run it at least every 29 minutes.'08.06.14 11:01:09 -- Host name : OCEAN2908.06.14 11:01:10 -- Startup time : 2014-06-08 09:57:00.0208.06.14 11:01:10 -- DB time : 08.06.2014 11:01:10&08.06.14 11:01:10 -- DBID : 1754107671508.06.14 11:01:10 -- Database encoding : CL8MSWIN1251*08.06.14 11:01:11 -- Redo groups count : 3B08.06.14 11:01:11 -- Enterprise Edition features detected... Cool.;08.06.14 11:01:12 -- First document : 2005-11-18 00:00:00.0\08.06.14 11:01:12 -- **************************** Documents ****************************508.06.14 11:01:13 -- TYPE |COUNT |508.06.14 11:01:13 -- @8E>4=0O =0:;04=0O |168366|508.06.14 11:01:13 -- :B ?5@5>F5=:8 |127392|508.06.14 11:01:13 -- 0:07 ?>AB02I8:C |83707 |508.06.14 11:01:13 -- 0AE>4=0O =0:;04=0O |54821 |508.06.14 11:01:13 -- !;8G8B5;L=0O 254><>ABL |8104 |508.06.14 11:01:13 -- @>4068 ?> :0AA5 |2927 |508.06.14 11:01:14 -- >72@0BK ?> :0AA5 |2600 |508.06.14 11:01:14 -- =25=B0@870F8>==0O >?8AL|725 |508.06.14 11:01:14 -- >=B@0:B A ?>AB02I8:>< |437 |508.06.14 11:01:14 -- 0:;04=0O =0 ?5@5<5I5=85|140 |508.06.14 11:01:14 -- 0;L:C;OF8O |7 |508.06.14 11:01:14 -- ;0B56 |6 |508.06.14 11:01:14 -- :B >1=0@C65=89 |5 |508.06.14 11:01:14 -- :B ?>B5@L |5 |508.06.14 11:01:14 -- >=B@0:B A :;85=B>< |3 |508.06.14 11:01:14 -- !G5B |3 |508.06.14 11:01:14 -- >;CG5=85 ?;0B560 < |2 |508.06.14 11:01:14 -- 0AE>4 =0 ?@>872>4AB2> |2 |508.06.14 11:01:14 -- @45@ =0 4>AB02:C |1 |508.06.14 11:01:14 -- 5F5?B |1 |508.06.14 11:01:14 -- B3@C7>G=K9 ;8AB |1 |508.06.14 11:01:14 -- 0@:5B8=3>20O 0:F8O |1 |508.06.14 11:01:14 -- !:;04A:>5 B@51>20=85 |1 |508.06.14 11:01:14 -- 0:07 >B :;85=B0 |1 |508.06.14 11:01:14 -- Summary |449258|(08.06.14 11:01:15 -- Cards count : 50832i08.06.14 11:01:15 -- Recommend you to add redo group (overall count of 10 redo groups is the good choice)808.06.14 11:01:15 -- Checking free space in tablespaces:08.06.14 11:01:16 -- INDX:19Gb 08.06.14 11:01:16 -- SYSTEM:31Gb 08.06.14 11:01:16 -- SYSAUX:40Gb"08.06.14 11:01:16 -- UNDOTBS1:41Gb08.06.14 11:01:17 -- USERS:47Gb-08.06.14 11:01:17 -- Checking locked objects:908.06.14 11:01:18 -- Check system statistics... COMPLETED308.06.14 11:01:19 -- System statistics collected...408.06.14 11:01:19 -- Checking database parameters...!08.06.14 11:01:19 -- CPU cores: 4\08.06.14 11:01:20 -- *********************** Obsolete parameters ***********************,08.06.14 11:01:20 -- Set database parameters808.06.14 11:01:25 -- Checking system statistic values...+08.06.14 11:01:26 -- Check supermag grants S08.06.14 11:01:30 -- **************************************************************=08.06.14 11:01:30 -- Gathering constraint list (1st stage)...S08.06.14 11:01:31 -- **************************************************************=08.06.14 11:01:31 -- Gathering constraint list (2nd stage)...608.06.14 11:01:32 -- Gathering list of invalid indexesS08.06.14 11:01:32 -- **************************************************************=08.06.14 11:01:32 -- Partitions and subpartitions state checkS08.06.14 11:01:33 -- **************************************************************?08.06.14 11:01:33 -- Gathering list of invalid index partitionsB08.06.14 11:01:33 -- Gathering list of invalid index subpartitions/08.06.14 11:01:34 -- Index rebuild completed...S08.06.14 11:01:34 -- **************************************************************008.06.14 11:01:34 -- Gathering ff-tables list...&08.06.14 11:01:34 -- Not configured...*08.06.14 11:01:34 -- List of invalid views*08.06.14 11:01:35 -- Invalid view count: 0408.06.14 11:01:35 -- Impossible to compile : 0 views208.06.14 11:01:35 -- Views compilation finished...S08.06.14 11:01:35 -- **************************************************************=08.06.14 11:01:35 -- List of invalid procedures and functions>08.06.14 11:01:36 -- Invalid procedures and functions count: 0G08.06.14 11:01:36 -- Impossible to compile : 0 procedures and functionsE08.06.14 11:01:36 -- Procedures and functions compilation finished...S08.06.14 11:01:36 -- **************************************************************-08.06.14 11:01:36 -- List of invalid packages.08.06.14 11:01:36 -- Invalid packages count: 0708.06.14 11:01:37 -- Impossible to compile : 0 packages408.06.14 11:01:37 -- Package compilation finished...S08.06.14 11:01:37 -- **************************************************************308.06.14 11:01:37 -- List of invalid package bodies408.06.14 11:01:37 -- Invalid package bodies count: 0=08.06.14 11:01:38 -- Impossible to compile : 0 package bodies;08.06.14 11:01:38 -- Package bodies compilation finished...S08.06.14 11:01:38 -- **************************************************************-08.06.14 11:01:38 -- List of invalid triggers.08.06.14 11:01:38 -- Invalid triggers count: 0708.06.14 11:01:38 -- Impossible to compile : 0 packages408.06.14 11:01:39 -- Trigger compilation finished...S08.06.14 11:01:39 -- **************************************************************208.06.14 11:01:39 -- List of invalid object owners,08.06.14 11:01:39 -- Invalid schema count: 0.08.06.14 11:01:39 -- Impossible to compile : 0308.06.14 11:01:39 -- Schema compilation finished...B08.06.14 11:01:39 -- Validate triggers. Gathering triggers list...S08.06.14 11:01:40 -- **************************************************************T08.06.14 11:01:40 -- Delete statistics on temporary tables. Gathering tables list...508.06.14 11:01:40 -- All unused statistics deleted...*08.06.14 11:01:41 -- RMAN procedures... 10$08.06.14 11:01:41 -- RMAN delayed...'08.06.14 11:01:41 -- Summary additions:208.06.14 11:01:41 -- Orders optimization disabled.[08.06.14 11:01:42 -- ******************** Biggest segments (Top10) ********************=08.06.14 11:01:44 -- TABLE SUPERMAG.MLOG$_SMSPECTAX 10838 Mb :08.06.14 11:01:44 -- TABLE SUPERMAG.MLOG$_SMGOODS 7499 Mb H08.06.14 11:01:44 -- INDEX SUBPARTITION SUPERMAG.FFMAPREP_LOCTO 2600 Mb K08.06.14 11:01:44 -- INDEX SUBPARTITION SUPERMAG.FFMAPREP_SUPPLIER 2600 Mb K08.06.14 11:01:44 -- INDEX SUBPARTITION SUPERMAG.FFMAPREP_SALEDATE 2600 Mb J08.06.14 11:01:44 -- INDEX SUBPARTITION SUPERMAG.FFMAPREP_LOCFROM 2600 Mb F08.06.14 11:01:44 -- INDEX SUBPARTITION SUPERMAG.FFMAPREP_DOC 2600 Mb 308.06.14 11:01:44 -- TABLE SUPERMAG.SMSPEC 1128 Mb ;08.06.14 11:01:44 -- TABLE SUPERMAG.MLOG$_SMSPECRL 1069 Mb 208.06.14 11:01:45 -- TABLE SUPERMAG.FFSPEC 762 Mb \08.06.14 11:01:45 -- ********************* Non-default parameters *********************608.06.14 11:01:45 -- O7_DICTIONARY_ACCESSIBILITY TRUE H08.06.14 11:01:45 -- audit_file_dest C:\ORACLE\ORA102\ADMIN\OCEAN\ADUMP 008.06.14 11:01:45 -- audit_sys_operations FALSE %08.06.14 11:01:45 -- audit_trail XML M08.06.14 11:01:45 -- background_dump_dest C:\ORACLE\ORA102\ADMIN\OCEAN\BDUMP /08.06.14 11:01:45 -- commit_write batch,nowait +08.06.14 11:01:45 -- compatible 10.2.0.3.0 08.06.14 11:01:45 -- control_files D:\ORACLE\ORADATA\OCEAN\CONTROL01.CTL, D:\ORACLE\ORADATA\OCEAN\CONTROL02.CTL, D:\ORACLE\ORADATA\OCEAN\CONTROL03.CTL G08.06.14 11:01:45 -- core_dump_dest C:\ORACLE\ORA102\ADMIN\OCEAN\CDUMP (08.06.14 11:01:46 -- db_block_size 8192 )08.06.14 11:01:46 -- db_cache_advice OFF $08.06.14 11:01:46 -- db_domain null #08.06.14 11:01:46 -- db_name ocean 508.06.14 11:01:46 -- db_recovery_file_dest G:\backup >08.06.14 11:01:46 -- db_recovery_file_dest_size 1507374182400 408.06.14 11:01:46 -- db_recycle_cache_size 33554432 C08.06.14 11:01:46 -- dispatchers (PROTOCOL=TCP) (SERVICE=oceanXDB) 008.06.14 11:01:46 -- fast_start_mttr_target 600 +08.06.14 11:01:46 -- job_queue_processes 2 .08.06.14 11:01:46 -- large_pool_size 12582912 008.06.14 11:01:46 -- max_dump_file_size 5000000 *08.06.14 11:01:46 -- nls_language RUSSIAN *08.06.14 11:01:46 -- nls_territory RUSSIA &08.06.14 11:01:46 -- open_cursors 500 808.06.14 11:01:46 -- optimizer_features_enable 10.2.0.4 408.06.14 11:01:47 -- pga_aggregate_target 765460480 #08.06.14 11:01:47 -- processes 150 =08.06.14 11:01:47 -- query_rewrite_integrity stale_tolerated $08.06.14 11:01:47 -- recyclebin off 908.06.14 11:01:47 -- remote_login_passwordfile EXCLUSIVE ,08.06.14 11:01:47 -- sga_max_size 822083584 *08.06.14 11:01:47 -- sga_target 612368384 008.06.14 11:01:47 -- shared_pool_size 100663296 +08.06.14 11:01:47 -- timed_statistics TRUE )08.06.14 11:01:47 -- trace_enabled FALSE 908.06.14 11:01:47 -- transactions_per_rollback_segment 1 *08.06.14 11:01:47 -- undo_management AUTO *08.06.14 11:01:47 -- undo_retention 10800 .08.06.14 11:01:47 -- undo_tablespace UNDOTBS1 G08.06.14 11:01:47 -- user_dump_dest C:\ORACLE\ORA102\ADMIN\OCEAN\UDUMP [08.06.14 11:01:47 -- *********************** System statistics ***********************!08.06.14 11:01:48 -- DSTART null 08.06.14 11:01:48 -- DSTOP null 08.06.14 11:01:48 -- FLAGS 1 !08.06.14 11:01:48 -- STATUS null "08.06.14 11:01:48 -- CPUSPEE< D 601 '08.06.14 11:01:48 -- CPUSPEEDNW 567.29 %08.06.14 11:01:48 -- IOSEEKTIM 8.876 *08.06.14 11:01:48 -- IOTFRSPEED 74577.209 $08.06.14 11:01:48 -- MAXTHR 8334336 08.06.14 11:01:48 -- MBRC 59 $08.06.14 11:01:48 -- MREADTIM 9.014 #08.06.14 11:01:48 -- SLAVETHR null $08.06.14 11:01:48 -- SREADTIM 5.702 @08.06.14 11:01:48 -- *******************************************08.06.14 11:01:49 -- Eventlog :08.06.14 11:01:49 -- OLEGON-ERROR! : List process : java.sql.SQLException: ORA-01578: ORACLE data block corrupted (file # 11, block # 928)>ORA-01110: data file 11: 'D:\ORACLE\ORADATA\OCEAN\USERS+1.DBF'@08.06.14 11:01:49 -- *******************************************08.06.14 11:01:49 -- Doclog :[08.06.14 11:01:57 -- ********************** Goods storage (Top5) **********************508.06.14 11:01:57 -- 00053038 1300 !0E0@ 53 8AB5@8O :08.06.14 11:01:57 -- 000102 1200 >B>: 347*137*20 ! 1:3 /08.06.14 11:01:57 -- 000023419 1152 !?8G:8 1HB K08.06.14 11:01:57 -- 000012347 735 (>:>;04=>5 O9F> "8=45@ !N@?@87" 203 36 L08.06.14 11:01:57 -- 000015359 695 0@0<5;L "'C?0 GC?A" AA>@B8 A A>:>< 133 \08.06.14 11:01:58 -- ********************* Goods storage (Lowest5) *********************;08.06.14 11:01:58 -- 00039712 -47160 K@CG:0 10@0/18;LO@40 _08.06.14 11:01:58 -- 00039313 -1718 82> "%5;5A" 3,9% 1,0; 82>20@=O "# CH:8=0"(@020@8CA500) c08.06.14 11:01:58 -- 00039312 -1631.5 82> "8;A=5@" 4,5% 1,0; 82>20@=O "# CH:8=0"(@020@8CA500) <08.06.14 11:01:58 -- 000018364 -53.42 0@B>D5;L <KBK9 25A* @08.06.14 11:01:58 -- 000022806 -39 8A:>=B=0O :0@B0 7% (7>;>B>) @08.06.14 11:01:58 -- ********************************************08.06.14 11:01:59 -- Checking free space :=08.06.14 11:02:00 -- C:\ORACLE\ORA102\ADMIN\OCEAN\ : 52384 Mb?08.06.14 11:02:02 -- C:\ORACLE\ORA102\DB_1\DATABASE\ : 52384 Mb808.06.14 11:02:03 -- D:\ORACLE\ORADATA\OCEAN\ : 31119 Mb#08.06.14 11:02:04 -- G:\ : 22391 Mb@08.06.14 11:02:05 -- *******************************************208.06.14 11:02:05 -- Checking system tablespace...S08.06.14 11:02:05 -- ***************************************************************08.06.14 11:02:06 -- Alert log checking...U08.06.14 11:02:06 -- Log filename: C:\ORACLE\ORA102\ADMIN\OCEAN\BDUMP\alert_ocean.log(08.06.14 11:02:07 -- Lines count : 37196[08.06.14 11:02:07 -- **************************** DB files ****************************@08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\.USERS02.ORA 10000 =08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\INDX+1.DBF 7168 =08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\INDX+2.DBF 1024 >08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\INDX01.DBF 20480 <08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\REDO01.LOG 100 <08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\REDO02.LOG 100 <08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\REDO03.LOG 100 ?08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\SYSAUX+1.DBF 1024 >08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\SYSAUX01.DBF 890 >08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\SYSTEM01.DBF 730 =08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\TEMP01.DBF 5219 @08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\UNDOTBS01.DBF 9113 A08.06.14 11:02:08 -- D:\ORACLE\ORADATA\OCEAN\UNDOTBS1+1.DBF 1024 >08.06.14 11:02:09 -- D:\ORACLE\ORADATA\OCEAN\USERS+1.DBF 1024 ?08.06.14 11:02:09 -- D:\ORACLE\ORADATA\OCEAN\USERS01.DBF 32715 [08.06.14 11:02:09 -- ************************* DB files waits *************************G08.06.14 11:02:09 -- FILE#|FILENAME |CT |TIME|AVG|G08.06.14 11:02:09 -- 3 |D:\ORACLE\ORADATA\OCEAN\SYSAUX|957|37 |.04|G08.06.14 11:02:09 -- |01.DBF | | | |G08.06.14 11:02:09 -- 2 |D:\ORACLE\ORADATA\OCEAN\UNDOTB|4 |0 |0 |G08.06.14 11:02:09 -- |S01.DBF | | | |G08.06.14 11:02:09 -- 4 |D:\ORACLE\ORADATA\OCEAN\INDX01|0 |0 |0 |G08.06.14 11:02:09 -- |.DBF | | | |G08.06.14 11:02:09 -- 5 |D:\ORACLE\ORADATA\OCEAN\USERS0|0 |0 |0 |G08.06.14 11:02:10 -- |1.DBF | | | |G08.06.14 11:02:10 -- 11 |D:\ORACLE\ORADATA\OCEAN\USERS+|0 |0 |0 |G08.06.14 11:02:10 -- 7 |D:\ORACLE\ORADATA\OCEAN\INDX+1|0 |0 |0 |G08.06.14 11:02:10 -- |.DBF | | | |G08.06.14 11:02:10 -- 8 |D:\ORACLE\ORADATA\OCEAN\INDX+2|0 |0 |0 |G08.06.14 11:02:10 -- 9 |D:\ORACLE\ORADATA\OCEAN\UNDOTB|2 |0 |0 |G08.06.14 11:02:10 -- |S1+1.DBF | | | |G08.06.14 11:02:10 -- 10 |D:\ORACLE\ORADATA\OCEAN\SYSAUX|5 |0 |0 |G08.06.14 11:02:10 -- |+1.DBF | | | |G08.06.14 11:02:10 -- 1 |D:\ORACLE\ORADATA\OCEAN\SYSTEM|26 |0 |0 |G08.06.14 11:02:10 -- |01.DBF | | | |G08.06.14 11:02:10 -- 6 |D:\ORACLE\ORADATA\OCEAN\.USERS|0 |0 |0 |G08.06.14 11:02:11 -- |02.ORA | | | |\08.06.14 11:02:11 -- *********************** DB files statistics ***********************08.06.14 11:02:11 -- NAME |FILE#|PHYRDS|PHYWRTS|PHYBLKRD|PHYBLKWRT|SINGLEBLKRDS|READTIM|WRITETIM|SINGLEBLKRDTIM|AVGIOTIM|LSTIOTIM|MINIOTIM|MAXIORTM|MAXIOWTM|08.06.14 11:02:11 -- D:\ORACLE\ORADATA\OCEAN\.USERS|6 |1731 |92 |13955 |173 |1431 |193 |348 |46 |0 |0 |0 |2 |12 |08.06.14 11:02:11 -- 02.ORA | | | | | | | | | | | | | | |08.06.14 11:02:11 -- D:\ORACLE\ORADATA\OCEAN\INDX+1|7 |8589 |3 |8656 |3 |8570 |132 |2 |129 |0 |0 |0 |2 |2 |08.06.14 11:02:11 -- .DBF | | | | | | | | | | | | | | |08.06.14 11:02:11 -- D:\ORACLE\ORADATA\OCEAN\INDX+2|8 |8082 |5 |8184 |5 |8062 |127 |11 |123 |0 |0 |0 |2 |11 |08.06.14 11:02:12 -- D:\ORACLE\ORADATA\OCEAN\INDX01|4 |7924 |3 |7986 |3 |7906 |146 |0 |141 |0 |0 |0 |2 |0 |08.06.14 11:02:12 -- .DBF | | | | | | | | | | | | | | |08.06.14 11:02:12 -- D:\ORACLE\ORADATA\OCEAN\SYSAUX|10 |282 |115 |289 |143 |273 |17 |399 |9 |0 |0 |0 |6 |6 |08.06.14 11:02:12 -- +1.DBF | | | | | | | | | | | | | | |08.06.14 11:02:12 -- D:\ORACLE\ORADATA\OCEAN\SYSAUX|3 |3731 |983 |5185 |1236 |3413 |669 |592 |127 |0 |0 |0 |19 |6 |08.06.14 11:02:12 -- 01.DBF | | | | | | | | | | | | | | |08.06.14 11:02:12 -- D:\ORACLE\ORADATA\OCEAN\SYSTEM|1 |15209 |178 |60508 |228 |12250 |1189 |2 |446 |0 |0 < |0 |19 |1 |08.06.14 11:02:12 -- D:\ORACLE\ORADATA\OCEAN\UNDOTB|2 |115 |595 |115 |944 |97 |199 |1615 |5 |0 |0 |0 |19 |9 |08.06.14 11:02:12 -- S01.DBF | | | | | | | | | | | | | | |08.06.14 11:02:12 -- D:\ORACLE\ORADATA\OCEAN\UNDOTB|9 |47 |261 |47 |667 |27 |233 |549 |3 |0 |0 |0 |19 |11 |08.06.14 11:02:13 -- S1+1.DBF | | | | | | | | | | | | | | |08.06.14 11:02:13 -- D:\ORACLE\ORADATA\OCEAN\USERS+|11 |1183 |22 |4762 |63 |1081 |82 |90 |36 |0 |0 |0 |6 |11 |08.06.14 11:02:13 -- 1.DBF | | | | | | | | | | | | | | |08.06.14 11:02:13 -- D:\ORACLE\ORADATA\OCEAN\USERS0|5 |1741 |171 |13167 |270 |1457 |206 |890 |56 |0 |0 |0 |4 |11 |\08.06.14 11:02:13 -- ************************** DB files load **************************X08.06.14 11:02:13 -- FILE NAME |BLOCKS READ|BLOCKS WRITEN|TOTAL I/O|X08.06.14 11:02:13 -- D:\ORACLE\ORADATA\OCEAN\SYSTEM|60508 |228 |60736 |X08.06.14 11:02:13 -- 01.DBF | | | |X08.06.14 11:02:14 -- D:\ORACLE\ORADATA\OCEAN\.USERS|13955 |173 |14128 |X08.06.14 11:02:14 -- 02.ORA | | | |X08.06.14 11:02:14 -- D:\ORACLE\ORADATA\OCEAN\USERS0|13167 |270 |13437 |X08.06.14 11:02:14 -- 1.DBF | | | |X08.06.14 11:02:14 -- D:\ORACLE\ORADATA\OCEAN\INDX+1|8656 |3 |8659 |X08.06.14 11:02:14 -- .DBF | | | |X08.06.14 11:02:14 -- D:\ORACLE\ORADATA\OCEAN\INDX+2|8184 |5 |8189 |X08.06.14 11:02:14 -- D:\ORACLE\ORADATA\OCEAN\INDX01|7986 |3 |7989 |X08.06.14 11:02:14 -- D:\ORACLE\ORADATA\OCEAN\SYSAUX|5185 |1236 |6421 |X08.06.14 11:02:14 -- 01.DBF | | | |X08.06.14 11:02:15 -- D:\ORACLE\ORADATA\OCEAN\USERS+|4762 |63 |4825 |X08.06.14 11:02:15 -- 1.DBF | | | |X08.06.14 11:02:15 -- D:\ORACLE\ORADATA\OCEAN\UNDOTB|115 |944 |1059 |X08.06.14 11:02:15 -- S01.DBF | | | |X08.06.14 11:02:15 -- D:\ORACLE\ORADATA\OCEAN\UNDOTB|47 |667 |714 |X08.06.14 11:02:15 -- S1+1.DBF | | | |X08.06.14 11:02:15 -- D:\ORACLE\ORADATA\OCEAN\SYSAUX|289 |143 |432 |X08.06.14 11:02:15 -- +1.DBF | | | |\08.06.14 11:02:15 -- *************************** Tables load ***************************m08.06.14 11:02:16 -- TABLE_OWNER|TABLE_NAME |INSERTS|UPDATES|DELETES|TIMESTAMP |m08.06.14 11:02:16 -- SUPERMAG |SMCASHCHECKITEMS |644535 |0 |23427 |2014-06-06 23:48:29.0|m08.06.14 11:02:16 -- SUPERMAG |SMCASHCHECKS |226500 |226500 |6957 |2014-06-06 23:48:29.0|m08.06.14 11:02:16 -- SYS |WRI$_OPTSTAT_HISTGRM_HISTORY |112987 |0 |64901 |2014-06-08 08:07:02.0|m08.06.14 11:02:16 -- SUPERMAG |MLOG$_SMGOODS |17570 |17570 |0 |2014-06-07 03:55:33.0|m08.06.14 11:02:16 -- SYS |ALERT_QT |10388 |4985 |10052 |2014-06-07 15:43:06.0|m08.06.14 11:02:16 -- SYS |WRH$_LATCH_CHILDREN |23440 |0 |0 |2014-06-08 08:00:11.0|m08.06.14 11:02:16 -- SYS |WRH$_LATCH_CHILDREN |21096 |0 |0 |2014-06-08 08:00:11.0|m08.06.14 11:02:16 -- SYS |WRI$_OPTSTAT_HISTHEAD_HISTORY|17661 |0 |0 |2014-06-08 08:07:02.0|m08.06.14 11:02:16 -- SYSMAN |MGMT_NOTIFY_QTABLE |7236 |0 |7284 |2014-06-07 15:43:06.0|m08.06.14 11:02:16 -- SYS |WRI$_OPTSTAT_IND_HISTORY |5706 |0 |3438 |2014-06-08 08:07:02.0|m08.06.14 11:02:16 -- SUPERMAG |SSEVENTLOG |1191 |0 |7197 |2014-05-28 04:32:36.0|m08.06.14 11:02:16 -- SUPERMAG |SMCASHDISCCARD |7079 |0 |544 |2014-06-06 23:48:29.0|m08.06.14 11:02:17 -- SYS |WRH$_LATCH |3940 |0 |0 |2014-06-08 08:00:11.0|m08.06.14 11:02:17 -- SYS |WRH$_LATCH_PARENT |3940 |0 |0 |2014-06-08 08:00:11.0|m08.06.14 11:02:17 -- SYS |WRH$_SYSSTAT |3640 |0 |0 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |WRH$_LATCH |3546 |0 |0 |2014-06-08 08:00:11.0|m08.06.14 11:02:17 -- SYS |WRH$_LATCH_PARENT |3546 |0 |0 |2014-06-08 08:00:11.0|m08.06.14 11:02:17 -- SYS |SETTINGS$ |1743 |0 |1764 |2014-01-06 15:14:57.0|m08.06.14 11:02:17 -- SYS |DEPENDENCY$ |1134 |1232 |1134 |2014-06-07 21:30:58.0|m08.06.14 11:02:17 -- SYS |WRH$_SYSSTAT |3276 |0 |0 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |WRH$_SQL_PLAN |677 |2454 |0 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |WRI$_ADV_MESSAGE_GROUPS |1668 |0 |1316 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |WRH$_SQLSTAT |2973 |0 |0 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |OBJ$ |16 |2866 |16 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |WRH$_PARAMETER |2640 |0 |0 |2014-06-08 08:05:04.0|m08.06.14 11:02:17 -- SYS |WRH$_SQLSTAT |2638 |0 |0 |2014-06-08 08:05:04.0|m08.06.14 11:02:18 -- SYS |WRH$_LATCH_CHILDREN |2388 |0 |0 |2014-06-03 23:25:23.0|m08.06.14 11:02:18 -- SYS |WRH$_LATCH_CHILDREN |2388 |0 |0 |2014-06-02 23:35:05.0|m08.06.14 11:02:18 -- SYS |WRH$_LATCH_CHILDREN |2388 |0 |0 |2014-06-06 23:25:08.0|[08.06.14 11:02:18 -- ******************* Cache hit ratio parameters *******************808.06.14 11:02:18 -- consistent gets from cache 2537238 508.06.14 11:02:18 -- db block gets from cache 130551 108.06.14 11:02:18 -- physical reads cache 122787 \08.06.14 11:02:18 -- ********************** Optimal redo log size **********************08.06.14 11:02:19 -- 23283 [08.06.14 11:02:19 -- ******************* Last 2 hours DB files load *******************W08.06.14 11:02:19 -- BEGIN_INTERVAL_TIME |FILENAME |PHYRDS|W08.06.14 11:02:19 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\SYSTEM|13180 |W08.06.14 11:02:19 -- |01.DBF | |W08.06.14 11:02:19 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\INDX+1|5890 |W08.06.14 11:02:19 -- |.DBF | |W08.06.14 11:02:20 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\INDX+2|5455 |W08.06.14 11:02:20 -- |.DBF | |W08.06.14 11:02:20 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\INDX01|5349 |W08.06.14 11:02:20 -- 2014-6-8.9.57. 0. 0 |D:\ORACLE\ORADATA\OCEAN\SYSTEM|4233 |W08.06.14 11:02:20 -- |01.DBF | |W08.06.14 11:02:20 -- 2014-6-8.10.7. 45. 46000000|D:\< ORACLE\ORADATA\OCEAN\SYSAUX|2515 |W08.06.14 11:02:20 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\USERS0|1629 |W08.06.14 11:02:20 -- |1.DBF | |W08.06.14 11:02:20 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\.USERS|1618 |W08.06.14 11:02:20 -- |02.ORA | |W08.06.14 11:02:20 -- 2014-6-8.10.7. 45. 46000000|D:\ORACLE\ORADATA\OCEAN\USERS+|1147 |[08.06.14 11:02:21 -- ************************* Workarea usage *************************E08.06.14 11:02:21 -- PROFILE |CNT |PERCENTAGE|E08.06.14 11:02:21 -- workarea executions - optimal |13331|100 |E08.06.14 11:02:21 -- workarea executions - onepass |0 |0 |E08.06.14 11:02:21 -- workarea executions - multipas|0 |0 |E08.06.14 11:02:21 -- s | | |\08.06.14 11:02:21 -- ************************* Users in pwfile *************************  TO5 R Ua.z ]!5$ 'Y*.814 7'7;_o>AVD~EwGKPS U V X]iamLcPJeNg5j|m\,o pr nuN v pxPz{_i}I@ ҃:XYfNӒ }: Z bb@AI\C¥N 8"x)  * 5*zFP/| T $$i9cc   l_?O _o[#'k,0{5:>CG#LP3UY!^  dMbP?_*+%MHP LaserJet 1100? dXXLetter.HP LaserJet 11002xeIJ@ENNqXDWp.rd!*U (H. '%9k~_/GI^ @&" d3l9J[2AN)%"m~%l2[ݎ3ZҠ^R_ӈCcc'H/Ɲ?z|B&7tRT)^1 ? @ A B C D E F GD@l !"#$%&'()*+,-./0123456789:;<=>? H !I "J #K $L %M &N 'O (P )Q *R +S ,T -U .V /W 0X 1Y 2Z 3[ 4\ 5] 6^ 7_ 8` 9a :b ;c <d =e >f ?gD@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @h Ai Bj Ck Dl Em Fn Go Hp Iq Jr Ks Lt Mu Nv Ow Px Qy Rz S{ T| U} V~ W X Y Z [ \ ] ^ _D@l`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ D@l                                D@l                                D@l                                D@l                                   ! " # $D@l      % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B CBX !"#$%&'()*+,-./0123456789:;<=>? D !E "F #G $H %I &J 'K (L )M *N +O ,P -Q .R /S 0T 1U 2V 3W 4X 5Y 6Z 7[ 8Z 9\ :] ;^ <] =_ >` ?aD@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @b Ac Bd Ce Df Eg Fh Gi Hj Ik Jl Km Ll Mn No Op Pq Qr Rs St Ts Uu Vv Ww Xx Yy Zz [{ \z ]| ^} _~D@l`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ D@l                                D@l                                 D@l                       ! " # $ % & ' ( ) *D@l + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I JD@l      K L M N O P Q R S T U V W X Y Z [ \ ] ^ _ ` a b c d e f g h i jD@l !"#$%&'()*+,-./0123456789:;<=>? k !l "m #n $o %p &q 'r (s )t *u +v ,w -x .y /z 0{ 1| 2} 3~ 4 5 6 7 8 9 : ; < = > ?D@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _D@l`abcdefghijklmnopqrstuvwxyz{|}~ ` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~ D@l                                D@l                                  D@l                             ! " # $ % & ' (BX>@?7   V_  dMbP?_*+%"???U>@7   ]`  dMbP?_*+%"??U>@7 Oh+'0@H\p  vovchenko vovchenkoMicrosoft Excel@ ׂ@F܂՜.+,0 PXx  RePack by SPecialiST' 123   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FWorkbook`SummaryInformation(DocumentSummaryInformation8