Oracle Enterprise Manager SetupPreferencesHelpLogout Database: HIBRETDB > Most Recent Alert Log Entries Most Recent Alert Log Entries Page RefreshedApr 28, 2007 9:12:59 AM This shows the last 100,000 bytes of the alert log. The log is constantly growing, so select the browser's Refresh button to see the most recent log entries. Number of Lines Displayed2,447 Private_strands 1 at log switch Thread 1 advanced to log sequence 42880 Current log# 3 seq# 42880 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 18:53:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42881 Current log# 1 seq# 42881 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42882 Current log# 2 seq# 42882 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 18:54:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42883 Current log# 3 seq# 42883 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 18:54:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42884 Current log# 1 seq# 42884 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 18:54:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42885 Current log# 2 seq# 42885 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 18:57:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42886 CurPrivate_strands 1 at log switch Thread 1 advanced to log sequence 42887 Current log# 1 seq# 42887 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 18:57:49 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42888 Current log# 2 seq# 42888 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 18:59:45 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42889 Current log# 3 seq# 42889 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:00:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42890 Current log# 1 seq# 42890 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:00:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42891 Current log# 2 seq# 42891 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:01:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42892 Current log# 3 seq# 42892 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:03:15 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 1 seq# 42893 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42894 Current log# 2 seq# 42894 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:04:50 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42895 Current log# 3 seq# 42895 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:05:03 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42896 Current log# 1 seq# 42896 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:05:28 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42897 Current log# 2 seq# 42897 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:06:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42898 Current log# 3 seq# 42898 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:06:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42899 Current log# 1 seq# 42899 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:08Private_strands 1 at log switch Thread 1 advanced to log sequence 42900 Current log# 2 seq# 42900 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42901 Current log# 3 seq# 42901 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:08:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42902 Current log# 1 seq# 42902 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42903 Current log# 2 seq# 42903 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:09:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42904 Current log# 3 seq# 42904 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:10:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42905 Current log# 1 seq# 42905 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:10:32 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42906 Current log# 2 seq# 42906 meThu Apr 26 19:10:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42907 Current log# 3 seq# 42907 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:12:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42908 Current log# 1 seq# 42908 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:13:32 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42909 Current log# 2 seq# 42909 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:14:15 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42910 Current log# 3 seq# 42910 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:14:44 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42911 Current log# 1 seq# 42911 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:15:06 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42912 Current log# 2 seq# 42912 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to Current log# 3 seq# 42913 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42914 Current log# 1 seq# 42914 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42915 Current log# 2 seq# 42915 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:17:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42916 Current log# 3 seq# 42916 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:18:15 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42917 Current log# 1 seq# 42917 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:18:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42918 Current log# 2 seq# 42918 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42919 Current log# 3 seq# 42919 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence Current log# 1 seq# 42920 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:20:18 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42921 Current log# 2 seq# 42921 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:20:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42922 Current log# 3 seq# 42922 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:28:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42923 Current log# 1 seq# 42923 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42924 Current log# 2 seq# 42924 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:29:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42925 Current log# 3 seq# 42925 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42926 Current log# 1 seq# 42926 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:29:50 2007 Private_strands Thread 1 advanced to log sequence 42927 Current log# 2 seq# 42927 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:30:40 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42928 Current log# 3 seq# 42928 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:30:56 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42929 Current log# 1 seq# 42929 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:31:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42930 Current log# 2 seq# 42930 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:31:41 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42931 Current log# 3 seq# 42931 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:32:18 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42932 Current log# 1 seq# 42932 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42933 Current log# 2 seq# 42933 mem# 0: /Private_strands 1 at log switch Thread 1 advanced to log sequence 42934 Current log# 3 seq# 42934 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42935 Current log# 1 seq# 42935 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42936 Current log# 2 seq# 42936 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42937 Current log# 3 seq# 42937 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42938 Current log# 1 seq# 42938 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42939 Current log# 2 seq# 42939 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42940 Current log# 3 seq# 42940 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 429 Current log# 1 seq# 42941 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:33:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42942 Current log# 2 seq# 42942 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:33:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42943 Current log# 3 seq# 42943 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:34:48 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42944 Current log# 1 seq# 42944 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:35:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42945 Current log# 2 seq# 42945 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42946 Current log# 3 seq# 42946 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:36:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42947 Current log# 1 seq# 42947 mem# 0: /u03/HIBRETDB/redo01.log Private_strands Thread 1 advanced to log sequence 42948 Current log# 2 seq# 42948 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42949 Current log# 3 seq# 42949 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:36:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42950 Current log# 1 seq# 42950 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:37:04 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42951 Current log# 2 seq# 42951 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:37:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42952 Current log# 3 seq# 42952 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:37:59 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42953 Current log# 1 seq# 42953 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:38:18 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42954 Current log# 2 seq# 42954 mem# 0: /Thu Apr 26 19:38:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42955 Current log# 3 seq# 42955 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:38:44 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42956 Current log# 1 seq# 42956 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:39:01 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42957 Current log# 2 seq# 42957 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42958 Current log# 3 seq# 42958 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:39:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42959 Current log# 1 seq# 42959 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:40:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42960 Current log# 2 seq# 42960 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42961 CurThu Apr 26 19:41:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42962 Current log# 1 seq# 42962 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:42:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42963 Current log# 2 seq# 42963 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42964 Current log# 3 seq# 42964 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42965 Current log# 1 seq# 42965 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:43:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42966 Current log# 2 seq# 42966 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:44:18 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42967 Current log# 3 seq# 42967 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42968 Current log# 1 seq# 42968 mePrivate_strands 1 at log switch Thread 1 advanced to log sequence 42969 Current log# 2 seq# 42969 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42970 Current log# 3 seq# 42970 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42971 Current log# 1 seq# 42971 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:45:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42972 Current log# 2 seq# 42972 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42973 Current log# 3 seq# 42973 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:46:29 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42974 Current log# 1 seq# 42974 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42975 Current log# 2 seq# 42975 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:46:47Private_strands 1 at log switch Thread 1 advanced to log sequence 42976 Current log# 3 seq# 42976 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:47:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42977 Current log# 1 seq# 42977 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:48:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42978 Current log# 2 seq# 42978 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:50:59 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42979 Current log# 3 seq# 42979 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 19:52:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42980 Current log# 1 seq# 42980 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:52:45 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42981 Current log# 2 seq# 42981 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:56:41 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 3 seq# 42982 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 42983 Current log# 1 seq# 42983 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 19:57:29 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42984 Current log# 2 seq# 42984 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 19:57:43 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42985 Current log# 3 seq# 42985 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 20:00:05 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42986 Current log# 1 seq# 42986 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 20:04:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42987 Current log# 2 seq# 42987 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 20:07:29 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42988 Current log# 3 seq# 42988 mem# 0: /u03/HIBRETDB/redo03.log Private_strands Thread 1 advanced to log sequence 42989 Current log# 1 seq# 42989 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 20:12:56 2007 Starting background process EMN0 EMN0 started with pid=36, OS id=26007 Thu Apr 26 20:12:57 2007 Shutting down instance: further logons disabled Thu Apr 26 20:12:57 2007 Stopping background process QMNC Thu Apr 26 20:12:57 2007 Stopping background process CJQ0 Thu Apr 26 20:12:58 2007 Stopping background process MMNL Thu Apr 26 20:12:59 2007 Stopping background process MMON Thu Apr 26 20:13:00 2007 Shutting down instance (immediate) License high water mark = 255 Thu Apr 26 20:13:00 2007 Stopping Job queue slave processes Thu Apr 26 20:13:00 2007 Job queue slave processes stopped All dispatchers and shared servers shutdown Thu Apr 26 20:13:07 2007 ALTER DATABASE CLOSE NORMAL Thu Apr 26 20:13:08 2007 SMON: disabling tx recovery SMON: disabling cache recovery Thu Apr 26 20:13:08 2007 Shutting down archive processes Archiving is disabled Archive process shutdown avoiThread 1 closed at log sequence 42989 Successful close of redo thread 1 Thu Apr 26 20:13:11 2007 Completed: ALTER DATABASE CLOSE NORMAL Thu Apr 26 20:13:11 2007 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thu Apr 26 20:23:51 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 2 shared and 81 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT =81 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.4.System parameters with non-default values: processes = 700 sessions = 775 timed_statistics = FALSE sga_max_size = 2902458368 __shared_pool_size = 872415232 shared_pool_size = 536870912 __large_pool_size = 33554432 large_pool_size = 33554432 __java_pool_size = 33554432 java_pool_size = 33554432 shared_pool_reserved_size= 53477376 enqueue_resources = 5000 nls_date_format = DD-MON-RRRR sga_target = 2902458368 control_files = /u03/UBDATA/control01.ctl, /u03/UBDATA/control02.ctl, /u03/UBDATA/control03.ctl db_block_size = 8192 __db_cache_size = 1946157056 db_cache_size = 1946157056 db_writer_processes = 2 compatible = 10.1.0.2.0 log_buffer = 5242880 db_files = 250 db_file_multiblock_read_count= 8 db_recovery_file_dest = /u01/ db_recovery_file_dest_size= 2147483648 fast_start_mttr_target = 300 transactions = 810 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 1800 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=HIBRETDBXDB) session_cached_cursors = 50 utl_file_dir = * plsql_optimize_level = 0 job_queue_processes = 2 parallel_max_servers = 8 background_dump_dest = /u01/app/oracle/admin/HIBRETDB/bdump user_dump_dest = /u01/app/oracle/admin/HIBRETDB/udump core_dump_dest = /u01/app/oracle/admin/HIBRETDB/cdump sort_area_size = 65536 db_name = HIBRETDB open_cursors = 5000 optimizer_mode = ALL_ROWS blank_trimming = TRUE _optimizer_cost_based_transformation= OFF parallel_adaptive_multi_user= FALSE optimizer_index_cost_adj = 50 opt query_rewrite_enabled = FALSE pga_aggregate_target = 792723456 optimizer_dynamic_sampling= 1 _allow_level_without_connect_by= TRUE PMON started with pid=2, OS id=26326 MMAN started with pid=3, OS id=26328 DBW0 started with pid=4, OS id=26330 DBW1 started with pid=5, OS id=26332 LGWR started with pid=6, OS id=26334 CKPT started with pid=7, OS id=26336 SMON started with pid=8, OS id=26338 RECO started with pid=9, OS id=26340 Thu Apr 26 20:24:04 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... CJQ0 started with pid=10, OS id=26342 Thu Apr 26 20:24:04 2007 starting up 1 shared server(s) ... Thu Apr 26 20:24:29 2007 ALTER DATABASE MOUNT Thu Apr 26 20:33:19 2007 Controlfile identified with block size 16384 Thu Apr 26 20:33:23 2007 Setting recovery target incarnation to 2 Thu Apr 26 20:33:23 2007 Successful mount of redo thread 1, with mount id 1823863951 Thu Apr 26 20:33:23 2007 Database mounted in Exclusive Mode. Completed: ALTThu Apr 26 20:33:23 2007 ALTER DATABASE OPEN Thu Apr 26 20:33:24 2007 Maximum redo generation record size = 148480 bytes Maximum redo generation change vector size = 145080 bytes Private_strands 0 at log switch Thread 1 opened at log sequence 42989 Current log# 1 seq# 42989 mem# 0: /u03/HIBRETDB/redo01.log Successful open of redo thread 1 Thu Apr 26 20:33:24 2007 SMON: enabling cache recovery Thu Apr 26 20:33:26 2007 Successfully onlined Undo Tablespace 1. Thu Apr 26 20:33:26 2007 SMON: enabling tx recovery Thu Apr 26 20:33:26 2007 Database Characterset is WE8ISO8859P1 Thu Apr 26 20:33:28 2007 Starting background process QMNC QMNC started with pid=17, OS id=26680 Thu Apr 26 20:33:30 2007 replication_dependency_tracking turned off (no async multimaster replication found) Thu Apr 26 20:33:30 2007 Starting background process MMON Starting background process MMNL MMON started with pid=14, OS id=26682 MMNL started with pid=15, OS id=26684 Thu Apr 26 20:33:31 2007 Completed: ALTER DATABASEThu Apr 26 20:33:35 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Thu Apr 26 20:36:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42990 Current log# 2 seq# 42990 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 21:00:59 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42991 Current log# 3 seq# 42991 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 21:30:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42992 Current log# 1 seq# 42992 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 22:00:15 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42993 Current log# 2 seq# 42993 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 22:00:27 2007 Private_strands 1 at log switch Thread 1 advanced Current log# 3 seq# 42994 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 22:00:39 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42995 Current log# 1 seq# 42995 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 22:00:52 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42996 Current log# 2 seq# 42996 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 22:01:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42997 Current log# 3 seq# 42997 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 22:01:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42998 Current log# 1 seq# 42998 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 22:01:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 42999 Current log# 2 seq# 42999 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 22:02:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43000 Current log# 3 seq# 43000 mem# 0: /u03/HIBRETDB/reThu Apr 26 22:02:21 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43001 Current log# 1 seq# 43001 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43002 Current log# 2 seq# 43002 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 22:06:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43003 Current log# 3 seq# 43003 mem# 0: /u03/HIBRETDB/redo03.log Thu Apr 26 22:52:00 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43004 Current log# 1 seq# 43004 mem# 0: /u03/HIBRETDB/redo01.log Thu Apr 26 23:03:39 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43005 Current log# 2 seq# 43005 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43006 Current log# 3 seq# 43006 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43007 Current log# 1 seq# 43007 mePrivate_strands 1 at log switch Thread 1 advanced to log sequence 43008 Current log# 2 seq# 43008 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43009 Current log# 3 seq# 43009 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43010 Current log# 1 seq# 43010 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43011 Current log# 2 seq# 43011 mem# 0: /u03/HIBRETDB/redo02.log Thu Apr 26 23:37:18 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43012 Current log# 3 seq# 43012 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 00:04:03 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43013 Current log# 1 seq# 43013 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 00:48:22 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43014 Current log# 2 seq# 43014 mem# 0: /u03/HIBRETDB/redo0Fri Apr 27 01:24:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43015 Current log# 3 seq# 43015 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 02:00:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43016 Current log# 1 seq# 43016 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 02:47:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43017 Current log# 2 seq# 43017 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 03:17:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43018 Current log# 3 seq# 43018 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 03:41:33 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43019 Current log# 1 seq# 43019 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 04:16:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43020 Current log# 2 seq# 43020 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 05:00:06 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43021 Current log# 3 seq# 43021 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 05:37:22 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43022 Current log# 1 seq# 43022 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 06:14:28 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43023 Current log# 2 seq# 43023 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 06:58:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43024 Current log# 3 seq# 43024 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 07:20:57 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43025 Current log# 1 seq# 43025 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 07:46:06 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43026 Current log# 2 seq# 43026 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 08:00:10 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43027 Current loFri Apr 27 08:03:21 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43028 Current log# 1 seq# 43028 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 08:06:13 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43029 Current log# 2 seq# 43029 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 08:09:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43030 Current log# 3 seq# 43030 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 08:13:49 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43031 Current log# 1 seq# 43031 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 08:15:48 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43032 Current log# 2 seq# 43032 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 08:21:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43033 Current log# 3 seq# 43033 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 08:28:33 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43034 Current log# 1 seq# 43034 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 08:35:56 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43035 Current log# 2 seq# 43035 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 08:39:57 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43036 Current log# 3 seq# 43036 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 08:44:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43037 Current log# 1 seq# 43037 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 08:50:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43038 Current log# 2 seq# 43038 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 08:55:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43039 Current log# 3 seq# 43039 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 09:00:16 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43040 Current loFri Apr 27 09:04:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43041 Current log# 2 seq# 43041 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 09:08:31 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43042 Current log# 3 seq# 43042 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 09:17:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43043 Current log# 1 seq# 43043 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 09:19:28 2007 Shutting down instance (abort) License high water mark = 270 Instance terminated by USER, pid = 3646 Fri Apr 27 09:19:36 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 2 shared and 81 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.4.0. System parameters with non-default values: processes = 700 sessions = 775 timed_statistics = FALSE sga_max_size = 2902458368 __shared_pool_size = 872415232 shared_pool_size = 536870912 __large_pool_size = 33554432 large_pool_size = 33554432 __java_pool_size = 33554432 java_pool_size = 33554432 shared_pool_reserved_size= 53477376 enqueue_resources = 5000 nls_date_format = DD-MON-RRRR sga_target = 2902458368 control_files = /u03/UBDATA/control01.ctl, /u03/UBDATA/control02.ctl, /u03/UBDATA/control03.ctl db_block_size = 8192 __db_cache_size = 1946157056 db_cache_size = 1946157056 db_writer_processes = 2 compatible = 10.1.0.2.0 log_buffer = 5242880 db_file db_file_multiblock_read_count= 8 db_recovery_file_dest = /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size= 2147483648 fast_start_mttr_target = 300 transactions = 810 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 1800 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=HIBRETDBXDB) session_cached_cursors = 50 utl_file_dir = * plsql_optimize_level = 0 job_queue_processes = 2 parallel_max_servers = 8 background_dump_dest = /u01/app/oracle/admin/HIBRETDB/bdump user_dump_dest = /u01/app/oracle/admin/HIBRETDB/udump core_dump_dest = /u01/app/oracle/admin/HIBRETDB/cdump sort_area_size = 65536 db_name = HIBRETDB open_cursors = 5000 optimizer_mode = ALL_ROWS blank_trimming = TRUE _optimizer_cost_b parallel_adaptive_multi_user= FALSE optimizer_index_cost_adj = 50 optimizer_index_caching = 90 query_rewrite_enabled = FALSE pga_aggregate_target = 792723456 optimizer_dynamic_sampling= 1 _allow_level_without_connect_by= TRUE PMON started with pid=2, OS id=3715 MMAN started with pid=3, OS id=3717 DBW0 started with pid=4, OS id=3719 DBW1 started with pid=5, OS id=3721 LGWR started with pid=6, OS id=3723 CKPT started with pid=7, OS id=3725 SMON started with pid=8, OS id=3727 RECO started with pid=9, OS id=3729 Fri Apr 27 09:19:39 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... CJQ0 started with pid=10, OS id=3731 Fri Apr 27 09:19:40 2007 starting up 1 shared server(s) ... Fri Apr 27 09:19:40 2007 ALTER DATABASE MOUNT Fri Apr 27 09:19:40 2007 Controlfile identified with block size 16384 Fri Apr 27 09:19:44 2007 Setting recovery target incarnation to 2 Fri Apr 27 09:19:44 2007 Successful mount of redo thread 1, with moFri Apr 27 09:19:44 2007 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Fri Apr 27 09:19:45 2007 ALTER DATABASE OPEN Fri Apr 27 09:19:45 2007 Beginning crash recovery of 1 threads Fri Apr 27 09:19:45 2007 Started redo scan Fri Apr 27 09:19:45 2007 Completed redo scan 4080 redo blocks read, 1575 data blocks need recovery Fri Apr 27 09:19:46 2007 Started redo application at Thread 1: logseq 43042, block 4914, scn 0.0 Fri Apr 27 09:19:46 2007 Recovery of Online Redo Log: Thread 1 Group 3 Seq 43042 Reading mem 0 Mem# 0 errs 0: /u03/HIBRETDB/redo03.log Fri Apr 27 09:19:46 2007 Recovery of Online Redo Log: Thread 1 Group 1 Seq 43043 Reading mem 0 Mem# 0 errs 0: /u03/HIBRETDB/redo01.log Fri Apr 27 09:19:46 2007 Completed redo application Fri Apr 27 09:19:46 2007 Completed crash recovery at Thread 1: logseq 43043, block 1449, scn 0.513278713 1575 data blocks read, 1575 data blocks written, 4080 redo blocks read Fri Apr 27 09:19:46 2007 Thread 1 advanced to log seMaximum redo generation record size = 148480 bytes Maximum redo generation change vector size = 145080 bytes Private_strands 1 at log switch Thread 1 opened at log sequence 43044 Current log# 2 seq# 43044 mem# 0: /u03/HIBRETDB/redo02.log Successful open of redo thread 1 Fri Apr 27 09:19:47 2007 SMON: enabling cache recovery Fri Apr 27 09:19:47 2007 Successfully onlined Undo Tablespace 1. Fri Apr 27 09:19:47 2007 SMON: enabling tx recovery Fri Apr 27 09:19:47 2007 Database Characterset is WE8ISO8859P1 Fri Apr 27 09:19:48 2007 Starting background process QMNC QMNC started with pid=17, OS id=3757 Fri Apr 27 09:19:49 2007 replication_dependency_tracking turned off (no async multimaster replication found) Fri Apr 27 09:19:50 2007 Starting background process MMON Starting background process MMNL MMON started with pid=18, OS id=3769 MMNL started with pid=19, OS id=3771 Fri Apr 27 09:19:51 2007 Completed: ALTER DATABASE OPEN Fri Apr 27 09:19:54 2007 db_recovery_file_dest_size of 2048 MB is 0user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Fri Apr 27 09:28:06 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43045 Current log# 3 seq# 43045 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 09:34:28 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43046 Current log# 1 seq# 43046 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 09:40:56 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43047 Current log# 2 seq# 43047 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 09:46:08 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43048 Current log# 3 seq# 43048 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 09:52:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43049 Current log# 1 seq# 43049 mem# 0: /u03/HIBRETDB/redo01.log Fri APrivate_strands 1 at log switch Thread 1 advanced to log sequence 43050 Current log# 2 seq# 43050 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 10:01:15 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43051 Current log# 3 seq# 43051 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 10:07:22 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43052 Current log# 1 seq# 43052 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 10:11:18 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43053 Current log# 2 seq# 43053 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 10:16:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43054 Current log# 3 seq# 43054 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 10:21:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43055 Current log# 1 seq# 43055 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43056 CurFri Apr 27 10:24:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43057 Current log# 3 seq# 43057 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 10:26:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43058 Current log# 1 seq# 43058 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 10:27:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43059 Current log# 2 seq# 43059 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 10:28:35 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43060 Current log# 3 seq# 43060 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 10:31:36 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43061 Current log# 1 seq# 43061 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 10:31:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43062 Current log# 2 seq# 43062 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 10:32:50 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43063 Current log# 3 seq# 43063 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 10:37:44 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43064 Current log# 1 seq# 43064 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 10:44:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43065 Current log# 2 seq# 43065 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 10:49:07 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43066 Current log# 3 seq# 43066 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 10:51:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43067 Current log# 1 seq# 43067 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 10:54:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43068 Current log# 2 seq# 43068 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 10:58:33 2007 ALTER SYSTEM SET timed_statistics=TRUE SCOPE=MEMORY; Fri Apr 27 10:59:19 2007 PrivatThread 1 advanced to log sequence 43069 Current log# 3 seq# 43069 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 11:01:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43070 Current log# 1 seq# 43070 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 11:06:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43071 Current log# 2 seq# 43071 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 11:10:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43072 Current log# 3 seq# 43072 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 11:16:48 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43073 Current log# 1 seq# 43073 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 11:20:17 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43074 Current log# 2 seq# 43074 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 11:25:04 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43075 Current loFri Apr 27 11:29:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43076 Current log# 1 seq# 43076 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 11:39:43 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43077 Current log# 2 seq# 43077 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 11:49:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43078 Current log# 3 seq# 43078 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 12:00:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43079 Current log# 1 seq# 43079 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 12:07:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43080 Current log# 2 seq# 43080 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 12:19:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43081 Current log# 3 seq# 43081 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 12:34:28 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43082 Current log# 1 seq# 43082 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 12:44:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43083 Current log# 2 seq# 43083 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 12:57:32 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43084 Current log# 3 seq# 43084 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 13:03:26 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43085 Current log# 1 seq# 43085 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 13:10:55 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43086 Current log# 2 seq# 43086 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 13:17:55 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43087 Current log# 3 seq# 43087 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 13:24:41 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43088 Current loFri Apr 27 13:30:33 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43089 Current log# 2 seq# 43089 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43090 Current log# 3 seq# 43090 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 13:31:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43091 Current log# 1 seq# 43091 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 13:35:29 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43092 Current log# 2 seq# 43092 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 13:38:10 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43093 Current log# 3 seq# 43093 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 13:38:43 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43094 Current log# 1 seq# 43094 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 13:39:04 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 2 seq# 43095 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 13:42:07 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43096 Current log# 3 seq# 43096 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 13:45:37 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43097 Current log# 1 seq# 43097 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 13:49:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43098 Current log# 2 seq# 43098 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 13:55:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43099 Current log# 3 seq# 43099 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 14:00:40 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43100 Current log# 1 seq# 43100 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 14:04:48 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43101 Current log# 2 seq# 43101 mem# 0: /u03/HIBRETDB/reFri Apr 27 14:11:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43102 Current log# 3 seq# 43102 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 14:15:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43103 Current log# 1 seq# 43103 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 14:20:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43104 Current log# 2 seq# 43104 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 14:25:27 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43105 Current log# 3 seq# 43105 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 14:31:13 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43106 Current log# 1 seq# 43106 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 14:36:04 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43107 Current log# 2 seq# 43107 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 14:41:59 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43108 Current log# 3 seq# 43108 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 14:47:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43109 Current log# 1 seq# 43109 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 14:55:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43110 Current log# 2 seq# 43110 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 15:00:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43111 Current log# 3 seq# 43111 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 15:06:45 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43112 Current log# 1 seq# 43112 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 15:13:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43113 Current log# 2 seq# 43113 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 15:18:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43114 Current loFri Apr 27 15:22:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43115 Current log# 1 seq# 43115 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 15:27:00 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43116 Current log# 2 seq# 43116 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 15:28:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43117 Current log# 3 seq# 43117 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 15:29:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43118 Current log# 1 seq# 43118 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 15:30:35 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43119 Current log# 2 seq# 43119 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 15:33:45 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43120 Current log# 3 seq# 43120 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 15:37:10 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43121 Current log# 1 seq# 43121 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 15:39:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43122 Current log# 2 seq# 43122 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 15:40:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43123 Current log# 3 seq# 43123 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 15:43:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43124 Current log# 1 seq# 43124 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 15:49:19 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43125 Current log# 2 seq# 43125 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 15:54:33 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43126 Current log# 3 seq# 43126 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 15:59:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43127 Current loFri Apr 27 16:03:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43128 Current log# 2 seq# 43128 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 16:09:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43129 Current log# 3 seq# 43129 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 16:11:06 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43130 Current log# 1 seq# 43130 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 16:12:59 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43131 Current log# 2 seq# 43131 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 16:13:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43132 Current log# 3 seq# 43132 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 16:14:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43133 Current log# 1 seq# 43133 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 16:15:36 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43134 Current log# 2 seq# 43134 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 16:21:10 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43135 Current log# 3 seq# 43135 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 16:26:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43136 Current log# 1 seq# 43136 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 16:27:23 2007 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/HIBRETDB/udump/hibretdb_ora_25674.trc. Fri Apr 27 16:33:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43137 Current log# 2 seq# 43137 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 16:39:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43138 Current log# 3 seq# 43138 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 16:45:17 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43139 Current log# 1 seq# 43139 mem# 0: Fri Apr 27 16:50:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43140 Current log# 2 seq# 43140 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 17:00:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43141 Current log# 3 seq# 43141 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 17:12:41 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43142 Current log# 1 seq# 43142 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 17:21:28 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43143 Current log# 2 seq# 43143 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 17:45:35 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43144 Current log# 3 seq# 43144 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:02:13 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43145 Current log# 1 seq# 43145 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:12:44 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43146 Current log# 2 seq# 43146 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43147 Current log# 3 seq# 43147 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:13:31 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43148 Current log# 1 seq# 43148 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:24:57 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43149 Current log# 2 seq# 43149 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43150 Current log# 3 seq# 43150 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43151 Current log# 1 seq# 43151 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:28:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43152 Current log# 2 seq# 43152 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log sThread 1 advanced to log sequence 43153 Current log# 3 seq# 43153 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:30:39 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43154 Current log# 1 seq# 43154 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:30:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43155 Current log# 2 seq# 43155 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 18:32:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43156 Current log# 3 seq# 43156 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:32:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43157 Current log# 1 seq# 43157 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43158 Current log# 2 seq# 43158 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 18:33:32 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43159 Current log# 3 seq# 43159 mem# 0: /Fri Apr 27 18:37:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43160 Current log# 1 seq# 43160 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:43:01 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43161 Current log# 2 seq# 43161 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 18:43:19 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43162 Current log# 3 seq# 43162 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43163 Current log# 1 seq# 43163 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:45:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43164 Current log# 2 seq# 43164 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 18:45:49 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43165 Current log# 3 seq# 43165 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:46:14 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 1 seq# 43166 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:46:28 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43167 Current log# 2 seq# 43167 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 18:47:15 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43168 Current log# 3 seq# 43168 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:47:59 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43169 Current log# 1 seq# 43169 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:48:29 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43170 Current log# 2 seq# 43170 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 18:52:57 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43171 Current log# 3 seq# 43171 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43172 Current log# 1 seq# 43172 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:53Private_strands 1 at log switch Thread 1 advanced to log sequence 43173 Current log# 2 seq# 43173 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43174 Current log# 3 seq# 43174 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:54:10 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43175 Current log# 1 seq# 43175 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:54:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43176 Current log# 2 seq# 43176 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43177 Current log# 3 seq# 43177 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:55:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43178 Current log# 1 seq# 43178 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:56:07 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43179 Current log# 2 seq# 43179 meFri Apr 27 18:57:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43180 Current log# 3 seq# 43180 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 18:57:47 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43181 Current log# 1 seq# 43181 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 18:59:10 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43182 Current log# 2 seq# 43182 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43183 Current log# 3 seq# 43183 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43184 Current log# 1 seq# 43184 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43185 Current log# 2 seq# 43185 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:05:19 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43186 Current log# 3 seq# 43186 meFri Apr 27 19:08:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43187 Current log# 1 seq# 43187 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:10:15 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43188 Current log# 2 seq# 43188 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:10:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43189 Current log# 3 seq# 43189 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:10:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43190 Current log# 1 seq# 43190 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:11:04 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43191 Current log# 2 seq# 43191 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:11:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43192 Current log# 3 seq# 43192 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to Current log# 1 seq# 43193 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:12:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43194 Current log# 2 seq# 43194 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:13:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43195 Current log# 3 seq# 43195 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:14:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43196 Current log# 1 seq# 43196 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:17:22 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43197 Current log# 2 seq# 43197 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43198 Current log# 3 seq# 43198 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43199 Current log# 1 seq# 43199 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 Current log# 2 seq# 43200 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:18:06 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43201 Current log# 3 seq# 43201 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:19:01 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43202 Current log# 1 seq# 43202 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:20:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43203 Current log# 2 seq# 43203 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:21:32 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43204 Current log# 3 seq# 43204 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43205 Current log# 1 seq# 43205 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:22:35 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43206 Current log# 2 seq# 43206 mem# 0: /u03/HIBRETDB/redo02.log Private_strands Thread 1 advanced to log sequence 43207 Current log# 3 seq# 43207 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43208 Current log# 1 seq# 43208 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43209 Current log# 2 seq# 43209 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43210 Current log# 3 seq# 43210 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43211 Current log# 1 seq# 43211 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:27:40 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43212 Current log# 2 seq# 43212 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:28:20 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43213 Current log# 3 seq# 43213 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced t Current log# 1 seq# 43214 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:29:26 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43215 Current log# 2 seq# 43215 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:29:44 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43216 Current log# 3 seq# 43216 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43217 Current log# 1 seq# 43217 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:30:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43218 Current log# 2 seq# 43218 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:36:21 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43219 Current log# 3 seq# 43219 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:37:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43220 Current log# 1 seq# 43220 mem# 0: /u03/HIBRETDB/redo01.log Private_strands Thread 1 advanced to log sequence 43221 Current log# 2 seq# 43221 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43222 Current log# 3 seq# 43222 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:44:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43223 Current log# 1 seq# 43223 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43224 Current log# 2 seq# 43224 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43225 Current log# 3 seq# 43225 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:44:34 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43226 Current log# 1 seq# 43226 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:46:45 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43227 Current log# 2 seq# 43227 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:47:35 2007 PThread 1 advanced to log sequence 43228 Current log# 3 seq# 43228 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43229 Current log# 1 seq# 43229 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43230 Current log# 2 seq# 43230 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43231 Current log# 3 seq# 43231 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:48:00 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43232 Current log# 1 seq# 43232 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:48:27 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43233 Current log# 2 seq# 43233 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:48:59 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43234 Current log# 3 seq# 43234 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log sThread 1 advanced to log sequence 43235 Current log# 1 seq# 43235 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:49:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43236 Current log# 2 seq# 43236 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:50:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43237 Current log# 3 seq# 43237 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43238 Current log# 1 seq# 43238 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 19:50:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43239 Current log# 2 seq# 43239 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:51:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43240 Current log# 3 seq# 43240 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:56:44 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43241 Current log# 1 seq# 43241 mem# 0: /Private_strands 1 at log switch Thread 1 advanced to log sequence 43242 Current log# 2 seq# 43242 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 19:57:30 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43243 Current log# 3 seq# 43243 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 19:59:37 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43244 Current log# 1 seq# 43244 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:00:00 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43245 Current log# 2 seq# 43245 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:00:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43246 Current log# 3 seq# 43246 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:00:43 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43247 Current log# 1 seq# 43247 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43248 CurFri Apr 27 20:02:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43249 Current log# 3 seq# 43249 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43250 Current log# 1 seq# 43250 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43251 Current log# 2 seq# 43251 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:03:29 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43252 Current log# 3 seq# 43252 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:09:45 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43253 Current log# 1 seq# 43253 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:10:06 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43254 Current log# 2 seq# 43254 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:11:41 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43255 CurFri Apr 27 20:13:11 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43256 Current log# 1 seq# 43256 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:13:21 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43257 Current log# 2 seq# 43257 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43258 Current log# 3 seq# 43258 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:14:05 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43259 Current log# 1 seq# 43259 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:19:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43260 Current log# 2 seq# 43260 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:21:19 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43261 Current log# 3 seq# 43261 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:23:17 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 1 seq# 43262 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43263 Current log# 2 seq# 43263 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43264 Current log# 3 seq# 43264 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:23:56 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43265 Current log# 1 seq# 43265 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43266 Current log# 2 seq# 43266 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43267 Current log# 3 seq# 43267 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:24:36 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43268 Current log# 1 seq# 43268 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:27:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence Current log# 2 seq# 43269 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:27:57 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43270 Current log# 3 seq# 43270 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:28:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43271 Current log# 1 seq# 43271 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:31:37 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43272 Current log# 2 seq# 43272 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:31:55 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43273 Current log# 3 seq# 43273 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43274 Current log# 1 seq# 43274 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43275 Current log# 2 seq# 43275 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 Current log# 3 seq# 43276 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43277 Current log# 1 seq# 43277 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43278 Current log# 2 seq# 43278 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 20:32:53 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43279 Current log# 3 seq# 43279 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 20:34:33 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43280 Current log# 1 seq# 43280 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 20:37:22 2007 Starting background process EMN0 EMN0 started with pid=29, OS id=14054 Fri Apr 27 20:37:22 2007 Shutting down instance: further logons disabled Fri Apr 27 20:37:22 2007 Stopping background process QMNC Fri Apr 27 20:37:22 2007 Stopping background process CJQ0 Fri Apr 27 20:37:24 2007 Stopping background process MMNL Fri Apr 27 20:Stopping background process MMON Fri Apr 27 20:37:27 2007 Shutting down instance (immediate) License high water mark = 321 Fri Apr 27 20:37:27 2007 Stopping Job queue slave processes Fri Apr 27 20:37:27 2007 Job queue slave processes stopped Fri Apr 27 20:38:50 2007 All dispatchers and shared servers shutdown Fri Apr 27 20:38:51 2007 ALTER DATABASE CLOSE NORMAL Fri Apr 27 20:38:52 2007 SMON: disabling tx recovery Fri Apr 27 20:39:40 2007 SMON: disabling cache recovery Fri Apr 27 20:39:41 2007 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Thread 1 closed at log sequence 43280 Successful close of redo thread 1 Fri Apr 27 20:42:24 2007 Completed: ALTER DATABASE CLOSE NORMAL Fri Apr 27 20:42:25 2007 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Fri Apr 27 20:53:30 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 2 shared and 81 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT =81 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.4.0. System parameters with non-default values: processes = 700 sessions = 775 timed_statistics = FALSE sga_max_size = 2902458368 __shared_pool_size = 872415232 shared_pool_size = 536870912 __large_pool_size = 33554432 large_pool_size = 33554432 __java_pool_size = 33554432 java_pool_size = 3 shared_pool_reserved_size= 53477376 enqueue_resources = 5000 nls_date_format = DD-MON-RRRR sga_target = 2902458368 control_files = /u03/UBDATA/control01.ctl, /u03/UBDATA/control02.ctl, /u03/UBDATA/control03.ctl db_block_size = 8192 __db_cache_size = 1946157056 db_cache_size = 1946157056 db_writer_processes = 2 compatible = 10.1.0.2.0 log_buffer = 5242880 db_files = 250 db_file_multiblock_read_count= 8 db_recovery_file_dest = /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size= 2147483648 fast_start_mttr_target = 300 transactions = 810 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 1800 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=HIBRETDBXDB) session_cached_cursors = 50 u plsql_optimize_level = 0 job_queue_processes = 2 parallel_max_servers = 8 background_dump_dest = /u01/app/oracle/admin/HIBRETDB/bdump user_dump_dest = /u01/app/oracle/admin/HIBRETDB/udump core_dump_dest = /u01/app/oracle/admin/HIBRETDB/cdump sort_area_size = 65536 db_name = HIBRETDB open_cursors = 5000 optimizer_mode = ALL_ROWS blank_trimming = TRUE _optimizer_cost_based_transformation= OFF parallel_adaptive_multi_user= FALSE optimizer_index_cost_adj = 50 optimizer_index_caching = 90 query_rewrite_enabled = FALSE pga_aggregate_target = 792723456 optimizer_dynamic_sampling= 1 _allow_level_without_connect_by= TRUE PMON started with pid=2, OS id=14524 MMAN started with pid=3, OS id=14526 DBW0 started with pid=4, OS id=14528 DBW1 started with pid=5, OS id=14530 LGWR started with pid=6, OS id=14532 CKPT started with pid=7, OS id=14534 SMON started witRECO started with pid=9, OS id=14538 Fri Apr 27 20:53:32 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... CJQ0 started with pid=10, OS id=14540 Fri Apr 27 20:53:32 2007 starting up 1 shared server(s) ... Fri Apr 27 20:54:44 2007 ALTER DATABASE MOUNT Fri Apr 27 21:02:26 2007 Controlfile identified with block size 16384 Fri Apr 27 21:02:30 2007 Starting ORACLE instance (normal) Fri Apr 27 21:02:30 2007 Setting recovery target incarnation to 2 Fri Apr 27 21:02:31 2007 Successful mount of redo thread 1, with mount id 1823970018 Fri Apr 27 21:02:31 2007 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Fri Apr 27 21:02:31 2007 ALTER DATABASE OPEN Fri Apr 27 21:02:32 2007 Maximum redo generation record size = 148480 bytes Maximum redo generation change vector size = 145080 bytes Private_strands 0 at log switch Thread 1 opened at log sequence 43280 Current log# 1 seq# 43280 mem# 0: /u03/HIBRETDB/redo01.log Successful open Fri Apr 27 21:02:32 2007 SMON: enabling cache recovery Fri Apr 27 21:02:37 2007 Successfully onlined Undo Tablespace 1. Fri Apr 27 21:02:37 2007 SMON: enabling tx recovery Fri Apr 27 21:02:38 2007 Database Characterset is WE8ISO8859P1 Fri Apr 27 21:02:40 2007 Starting background process QMNC QMNC started with pid=15, OS id=14853 Fri Apr 27 21:02:42 2007 replication_dependency_tracking turned off (no async multimaster replication found) Fri Apr 27 21:02:44 2007 Starting background process MMON Starting background process MMNL MMON started with pid=18, OS id=14861 MMNL started with pid=19, OS id=14863 Fri Apr 27 21:02:49 2007 Completed: ALTER DATABASE OPEN Fri Apr 27 21:02:57 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Fri Apr 27 21:13:12 2007 Private_strands 1 aThread 1 advanced to log sequence 43281 Current log# 2 seq# 43281 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 21:43:50 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43282 Current log# 3 seq# 43282 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 22:00:12 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43283 Current log# 1 seq# 43283 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 22:00:27 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43284 Current log# 2 seq# 43284 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 22:00:40 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43285 Current log# 3 seq# 43285 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43286 Current log# 1 seq# 43286 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 22:01:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43287 Current log# 2 seq# 43287 mem# 0: /Fri Apr 27 22:01:35 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43288 Current log# 3 seq# 43288 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 22:01:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43289 Current log# 1 seq# 43289 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 22:02:13 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43290 Current log# 2 seq# 43290 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 22:02:37 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43291 Current log# 3 seq# 43291 mem# 0: /u03/HIBRETDB/redo03.log Fri Apr 27 22:23:27 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43292 Current log# 1 seq# 43292 mem# 0: /u03/HIBRETDB/redo01.log Fri Apr 27 23:00:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43293 Current log# 2 seq# 43293 mem# 0: /u03/HIBRETDB/redo02.log Fri Apr 27 23:24:29 2007 Private_strands 1 at log swThread 1 advanced to log sequence 43294 Current log# 3 seq# 43294 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 00:00:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43295 Current log# 1 seq# 43295 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 00:33:38 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43296 Current log# 2 seq# 43296 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 01:02:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43297 Current log# 3 seq# 43297 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 01:46:05 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43298 Current log# 1 seq# 43298 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 02:03:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43299 Current log# 2 seq# 43299 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43300 Current log# 3 seq# 43300 mem# 0: /Thread 1 cannot allocate new log, sequence 43301 Checkpoint not complete Current log# 3 seq# 43300 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43301 Current log# 1 seq# 43301 mem# 0: /u03/HIBRETDB/redo01.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43302 Current log# 2 seq# 43302 mem# 0: /u03/HIBRETDB/redo02.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43303 Current log# 3 seq# 43303 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43304 Current log# 1 seq# 43304 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 02:17:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43305 Current log# 2 seq# 43305 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 03:00:55 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43306 Current log# 3 seq# 43306 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 03:33:2Private_strands 1 at log switch Thread 1 advanced to log sequence 43307 Current log# 1 seq# 43307 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 04:00:24 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43308 Current log# 2 seq# 43308 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 04:32:37 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43309 Current log# 3 seq# 43309 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 05:08:26 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43310 Current log# 1 seq# 43310 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 05:54:02 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43311 Current log# 2 seq# 43311 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 06:00:21 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43312 Current log# 3 seq# 43312 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 06:00:46 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 1 seq# 43313 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 06:01:25 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43314 Current log# 2 seq# 43314 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 06:32:39 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43315 Current log# 3 seq# 43315 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 07:02:44 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43316 Current log# 1 seq# 43316 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 07:38:41 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43317 Current log# 2 seq# 43317 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 07:43:14 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43318 Current log# 3 seq# 43318 mem# 0: /u03/HIBRETDB/redo03.log Private_strands 1 at log switch Thread 1 advanced to log sequence 43319 Current log# 1 seq# 43319 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 07:45Private_strands 1 at log switch Thread 1 advanced to log sequence 43320 Current log# 2 seq# 43320 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 07:46:08 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43321 Current log# 3 seq# 43321 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 07:46:42 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43322 Current log# 1 seq# 43322 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 07:46:57 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43323 Current log# 2 seq# 43323 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 07:48:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43324 Current log# 3 seq# 43324 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 07:53:50 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43325 Current log# 1 seq# 43325 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 07:54:59 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 2 seq# 43326 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 08:01:09 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43327 Current log# 3 seq# 43327 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 08:07:58 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43328 Current log# 1 seq# 43328 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 08:15:45 2007 Shutting down instance (abort) License high water mark = 177 Instance terminated by USER, pid = 12785 Sat Apr 28 08:15:54 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 2 shared and 81 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT =81 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.4.0.System parameters with non-default values: processes = 700 sessions = 775 timed_statistics = FALSE sga_max_size = 2902458368 __shared_pool_size = 872415232 shared_pool_size = 536870912 __large_pool_size = 33554432 large_pool_size = 33554432 __java_pool_size = 33554432 java_pool_size = 33554432 shared_pool_reserved_size= 53477376 enqueue_resources = 5000 nls_date_format = DD-MON-RRRR sga_target = 2902458368 control_files = /u03/UBDATA/control01.ctl, /u03/UBDATA/control02.ctl, /u03/UBDATA/control03.ctl db_block_size = 8192 __db_cache_size = 1946157056 db_cache_size = 1946157056 db_writer_processes = 2 compatible = 10.1.0.2.0 log_buffer = 5242880 db_files = 250 db_file_multiblock_read_count= 8 db_recovery_file_dest = /u01/ db_recovery_file_dest_size= 2147483648 fast_start_mttr_target = 300 transactions = 810 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 1800 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=HIBRETDBXDB) session_cached_cursors = 50 utl_file_dir = * plsql_optimize_level = 0 job_queue_processes = 2 parallel_max_servers = 8 background_dump_dest = /u01/app/oracle/admin/HIBRETDB/bdump user_dump_dest = /u01/app/oracle/admin/HIBRETDB/udump core_dump_dest = /u01/app/oracle/admin/HIBRETDB/cdump sort_area_size = 65536 db_name = HIBRETDB open_cursors = 5000 optimizer_mode = ALL_ROWS blank_trimming = TRUE _optimizer_cost_based_transformation= OFF parallel_adaptive_multi_user= FALSE optimizer_index_cost_adj = 50 opt query_rewrite_enabled = FALSE pga_aggregate_target = 792723456 optimizer_dynamic_sampling= 1 _allow_level_without_connect_by= TRUE PMON started with pid=2, OS id=12905 MMAN started with pid=3, OS id=12907 DBW0 started with pid=4, OS id=12909 DBW1 started with pid=5, OS id=12911 LGWR started with pid=6, OS id=12913 CKPT started with pid=7, OS id=12915 SMON started with pid=8, OS id=12917 RECO started with pid=9, OS id=12919 Sat Apr 28 08:16:04 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... CJQ0 started with pid=10, OS id=12922 Sat Apr 28 08:16:04 2007 starting up 1 shared server(s) ... Sat Apr 28 08:16:09 2007 ALTER DATABASE MOUNT Sat Apr 28 08:16:09 2007 Controlfile identified with block size 16384 Sat Apr 28 08:16:13 2007 Setting recovery target incarnation to 2 Sat Apr 28 08:16:13 2007 Successful mount of redo thread 1, with mount id 1823939017 Sat Apr 28 08:16:13 2007 Database mounted in Exclusive Mode. Completed: ALTSat Apr 28 08:16:13 2007 ALTER DATABASE OPEN Sat Apr 28 08:16:14 2007 Beginning crash recovery of 1 threads Sat Apr 28 08:16:14 2007 Started redo scan Sat Apr 28 08:16:14 2007 Completed redo scan 774 redo blocks read, 365 data blocks need recovery Sat Apr 28 08:16:15 2007 Started redo application at Thread 1: logseq 43328, block 2017, scn 0.0 Sat Apr 28 08:16:15 2007 Recovery of Online Redo Log: Thread 1 Group 1 Seq 43328 Reading mem 0 Mem# 0 errs 0: /u03/HIBRETDB/redo01.log Sat Apr 28 08:16:15 2007 Completed redo application Sat Apr 28 08:16:15 2007 Completed crash recovery at Thread 1: logseq 43328, block 2791, scn 0.514466516 365 data blocks read, 362 data blocks written, 774 redo blocks read Sat Apr 28 08:16:15 2007 Thread 1 advanced to log sequence 43329 Maximum redo generation record size = 148480 bytes Maximum redo generation change vector size = 145080 bytes Private_strands 1 at log switch Thread 1 opened at log sequence 43329 Current log# 2 seq# 43329 mem# 0: /u03/HIBRSuccessful open of redo thread 1 Sat Apr 28 08:16:15 2007 SMON: enabling cache recovery Sat Apr 28 08:16:16 2007 Successfully onlined Undo Tablespace 1. Sat Apr 28 08:16:16 2007 SMON: enabling tx recovery Sat Apr 28 08:16:16 2007 Database Characterset is WE8ISO8859P1 Sat Apr 28 08:16:17 2007 Starting background process QMNC QMNC started with pid=16, OS id=12951 Sat Apr 28 08:16:19 2007 replication_dependency_tracking turned off (no async multimaster replication found) Sat Apr 28 08:16:20 2007 Starting background process MMON Starting background process MMNL MMON started with pid=17, OS id=12970 MMNL started with pid=18, OS id=12972 Sat Apr 28 08:16:22 2007 Completed: ALTER DATABASE OPEN Sat Apr 28 08:16:25 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Sat Apr 28 Private_strands 1 at log switch Thread 1 advanced to log sequence 43330 Current log# 3 seq# 43330 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 08:28:23 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43331 Current log# 1 seq# 43331 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 08:29:28 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43332 Current log# 2 seq# 43332 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 08:30:36 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43333 Current log# 3 seq# 43333 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 08:37:46 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43334 Current log# 1 seq# 43334 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 08:43:54 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43335 Current log# 2 seq# 43335 mem# 0: /u03/HIBRETDB/redo02.log Sat Apr 28 08:52:52 2007 Private_strands 1 at log switch Thread 1 advanced to Current log# 3 seq# 43336 mem# 0: /u03/HIBRETDB/redo03.log Sat Apr 28 08:57:51 2007 Private_strands 1 at log switch Thread 1 advanced to log sequence 43337 Current log# 1 seq# 43337 mem# 0: /u03/HIBRETDB/redo01.log Sat Apr 28 09:09:25 2007 Shutting down instance (abort) License high water mark = 197 Sat Apr 28 09:09:28 2007 Timed out trying to start process q001. Sat Apr 28 09:09:30 2007 Instance terminated by USER, pid = 19175 Sat Apr 28 09:09:36 2007 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 Picked latch-free SCN scheme 3 KCCDEBUG_LEVEL = 0 Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST Autotune of undo retention is turned on. Dynamic strands is set to TRUE Running with 2 shared and 81 private strand(s). Zero-copy redo is FALSE IMODE=BR ILAT =81 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 10.1.0.4.0. System parameters with non-default values: processes sessions = 775 timed_statistics = FALSE sga_max_size = 2902458368 __shared_pool_size = 872415232 shared_pool_size = 536870912 __large_pool_size = 33554432 large_pool_size = 33554432 __java_pool_size = 33554432 java_pool_size = 33554432 shared_pool_reserved_size= 53477376 enqueue_resources = 5000 nls_date_format = DD-MON-RRRR sga_target = 2902458368 control_files = /u03/UBDATA/control01.ctl, /u03/UBDATA/control02.ctl, /u03/UBDATA/control03.ctl db_block_size = 8192 __db_cache_size = 1946157056 db_cache_size = 1946157056 db_writer_processes = 2 compatible = 10.1.0.2.0 log_buffer = 5242880 db_files = 250 db_file_multiblock_read_count= 8 db_recovery_file_dest = /u01/app/oracle/flash_recovery_area db_recovery_file_dest_size= 2147483648 fa transactions = 810 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 1800 remote_login_passwordfile= EXCLUSIVE db_domain = dispatchers = (PROTOCOL=TCP) (SERVICE=HIBRETDBXDB) session_cached_cursors = 50 utl_file_dir = * plsql_optimize_level = 0 job_queue_processes = 2 parallel_max_servers = 8 background_dump_dest = /u01/app/oracle/admin/HIBRETDB/bdump user_dump_dest = /u01/app/oracle/admin/HIBRETDB/udump core_dump_dest = /u01/app/oracle/admin/HIBRETDB/cdump sort_area_size = 65536 db_name = HIBRETDB open_cursors = 5000 optimizer_mode = ALL_ROWS blank_trimming = TRUE _optimizer_cost_based_transformation= OFF parallel_adaptive_multi_user= FALSE optimizer_index_cost_adj = 50 optimizer_index_caching = 90 query_rewrite_enabled = FALSE pga_aggreg optimizer_dynamic_sampling= 1 _allow_level_without_connect_by= TRUE PMON started with pid=2, OS id=19264 MMAN started with pid=3, OS id=19266 DBW0 started with pid=4, OS id=19268 DBW1 started with pid=5, OS id=19270 LGWR started with pid=6, OS id=19272 CKPT started with pid=7, OS id=19274 SMON started with pid=8, OS id=19276 RECO started with pid=9, OS id=19278 Sat Apr 28 09:09:43 2007 starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... CJQ0 started with pid=10, OS id=19280 Sat Apr 28 09:09:43 2007 starting up 1 shared server(s) ... Sat Apr 28 09:09:46 2007 ALTER DATABASE MOUNT Sat Apr 28 09:09:46 2007 Controlfile identified with block size 16384 Sat Apr 28 09:09:50 2007 Setting recovery target incarnation to 2 Sat Apr 28 09:09:50 2007 Successful mount of redo thread 1, with mount id 1823975770 Sat Apr 28 09:09:50 2007 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sat Apr 28 09:09:50 2007 ALTER DATABASE OPEN Sat Apr 2Beginning crash recovery of 1 threads Sat Apr 28 09:09:51 2007 Started redo scan Sat Apr 28 09:09:51 2007 Completed redo scan 2047 redo blocks read, 955 data blocks need recovery Sat Apr 28 09:09:52 2007 Started redo application at Thread 1: logseq 43337, block 5502, scn 0.0 Sat Apr 28 09:09:52 2007 Recovery of Online Redo Log: Thread 1 Group 1 Seq 43337 Reading mem 0 Mem# 0 errs 0: /u03/HIBRETDB/redo01.log Sat Apr 28 09:09:52 2007 Completed redo application Sat Apr 28 09:09:52 2007 Completed crash recovery at Thread 1: logseq 43337, block 7549, scn 0.514565936 955 data blocks read, 943 data blocks written, 2047 redo blocks read Sat Apr 28 09:09:53 2007 Rolling back half complete log switch of thread 1 Thread 1 advanced to log sequence 43338 Maximum redo generation record size = 148480 bytes Maximum redo generation change vector size = 145080 bytes Private_strands 1 at log switch Thread 1 opened at log sequence 43338 Current log# 2 seq# 43338 mem# 0: /u03/HIBRETDB/redo02.log SuSat Apr 28 09:09:53 2007 SMON: enabling cache recovery Sat Apr 28 09:09:53 2007 Successfully onlined Undo Tablespace 1. Sat Apr 28 09:09:53 2007 SMON: enabling tx recovery Sat Apr 28 09:09:53 2007 Database Characterset is WE8ISO8859P1 Sat Apr 28 09:09:54 2007 Starting background process QMNC QMNC started with pid=19, OS id=19306 Sat Apr 28 09:09:55 2007 replication_dependency_tracking turned off (no async multimaster replication found) Sat Apr 28 09:09:56 2007 Starting background process MMON Starting background process MMNL MMON started with pid=16, OS id=19316 MMNL started with pid=18, OS id=19318 Sat Apr 28 09:09:58 2007 Completed: ALTER DATABASE OPEN Sat Apr 28 09:10:00 2007 db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a user-specified limit on the amount of space that will be used by this database for recovery-related files, and does not reflect the amount of space available in the underlying filesystem or ASM diskgroup. Database | Setup | Preferences | Help | Logout Copyright © 1996, 2005, Oracle. All rights reserved. About Oracle Enterprise Manager 10g Database Control