oracle日志
================
。。Mon Jun 20 08:48:08 2011
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15358M/16382M, Ph+PgF:17446M/17822M
Mon Jun 20 08:48:08 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as F:\ORA\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =30
LICENSE_MAX_USERS = 0
SYS auditing is enabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 250
sessions = 280
resource_limit = TRUE
sga_max_size = 8589934592
__shared_pool_size = 1442840576
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 33554432
spfile = F:\ORA\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL1.ORA
nls_language = SIMPLIFIED CHINESE
sga_target = 8589934592
control_files = F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\CONTROL01.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\CONTROL02.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 7063207936
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
_kgl_large_heap_warning_threshold= 8388608
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = TRUE
db_domain =
dispatchers = (PROTOCOL=TCP)(DISPATCHERS=3)(SERVICE=orcl1XDB)
job_queue_processes = 10
audit_file_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\ADUMP
background_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\BDUMP
user_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\UDUMP
core_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\CDUMP
audit_trail = DB
db_name = orcl1
open_cursors = 300
pga_aggregate_target = 1707081728
PMON started with pid=2, OS id=1808
PSP0 started with pid=3, OS id=2508
MMAN started with pid=4, OS id=948
DBW0 started with pid=5, OS id=3220
LGWR started with pid=6, OS id=2708
CKPT started with pid=7, OS id=1164
SMON started with pid=8, OS id=3760
RECO started with pid=9, OS id=3912
CJQ0 started with pid=10, OS id=3792
MMON started with pid=11, OS id=2304
MMNL started with pid=12, OS id=1936
Mon Jun 20 08:48:09 2011
starting up 3 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Jun 20 08:48:09 2011
alter database mount exclusive
Mon Jun 20 08:48:14 2011
Setting recovery target incarnation to 2
Mon Jun 20 08:48:15 2011
Successful mount of redo thread 1, with mount id 1138761866
Mon Jun 20 08:48:15 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 20 08:48:15 2011
alter database open
Mon Jun 20 08:48:15 2011
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Mon Jun 20 08:48:15 2011
Started redo scan
Mon Jun 20 08:48:15 2011
Completed redo scan
9925 redo blocks read, 286 data blocks need recovery
Mon Jun 20 08:48:15 2011
Started redo application at
Thread 1: logseq 590, block 123681
Mon Jun 20 08:48:15 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 590 Reading mem 0
Mem# 0 errs 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_1.LOG
Mem# 1 errs 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_2.LOG
Mon Jun 20 08:48:15 2011
Completed redo application
Mon Jun 20 08:48:15 2011
Completed crash recovery at
Thread 1: logseq 590, block 133606, scn 367061660
286 data blocks read, 286 data blocks written, 9925 redo blocks read
Mon Jun 20 08:48:15 2011
Thread 1 advanced to log sequence 591
Thread 1 opened at log sequence 591
Current log# 4 seq# 591 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_1.LOG
Current log# 4 seq# 591 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_2.LOG
Successful open of redo thread 1
Mon Jun 20 08:48:15 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 20 08:48:15 2011
SMON: enabling cache recovery
Mon Jun 20 08:48:16 2011
Successfully onlined Undo Tablespace 1.
Mon Jun 20 08:48:16 2011
SMON: enabling tx recovery
Mon Jun 20 08:48:16 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=28, OS id=1000
Mon Jun 20 08:48:18 2011
Completed: alter database open
===============
高手给点配置意见,谢谢
================
。。Mon Jun 20 08:48:08 2011
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15358M/16382M, Ph+PgF:17446M/17822M
Mon Jun 20 08:48:08 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as F:\ORA\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =30
LICENSE_MAX_USERS = 0
SYS auditing is enabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 250
sessions = 280
resource_limit = TRUE
sga_max_size = 8589934592
__shared_pool_size = 1442840576
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 33554432
spfile = F:\ORA\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL1.ORA
nls_language = SIMPLIFIED CHINESE
sga_target = 8589934592
control_files = F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\CONTROL01.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\CONTROL02.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 7063207936
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
_kgl_large_heap_warning_threshold= 8388608
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = TRUE
db_domain =
dispatchers = (PROTOCOL=TCP)(DISPATCHERS=3)(SERVICE=orcl1XDB)
job_queue_processes = 10
audit_file_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\ADUMP
background_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\BDUMP
user_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\UDUMP
core_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL1\CDUMP
audit_trail = DB
db_name = orcl1
open_cursors = 300
pga_aggregate_target = 1707081728
PMON started with pid=2, OS id=1808
PSP0 started with pid=3, OS id=2508
MMAN started with pid=4, OS id=948
DBW0 started with pid=5, OS id=3220
LGWR started with pid=6, OS id=2708
CKPT started with pid=7, OS id=1164
SMON started with pid=8, OS id=3760
RECO started with pid=9, OS id=3912
CJQ0 started with pid=10, OS id=3792
MMON started with pid=11, OS id=2304
MMNL started with pid=12, OS id=1936
Mon Jun 20 08:48:09 2011
starting up 3 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Jun 20 08:48:09 2011
alter database mount exclusive
Mon Jun 20 08:48:14 2011
Setting recovery target incarnation to 2
Mon Jun 20 08:48:15 2011
Successful mount of redo thread 1, with mount id 1138761866
Mon Jun 20 08:48:15 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 20 08:48:15 2011
alter database open
Mon Jun 20 08:48:15 2011
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Mon Jun 20 08:48:15 2011
Started redo scan
Mon Jun 20 08:48:15 2011
Completed redo scan
9925 redo blocks read, 286 data blocks need recovery
Mon Jun 20 08:48:15 2011
Started redo application at
Thread 1: logseq 590, block 123681
Mon Jun 20 08:48:15 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 590 Reading mem 0
Mem# 0 errs 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_1.LOG
Mem# 1 errs 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_2.LOG
Mon Jun 20 08:48:15 2011
Completed redo application
Mon Jun 20 08:48:15 2011
Completed crash recovery at
Thread 1: logseq 590, block 133606, scn 367061660
286 data blocks read, 286 data blocks written, 9925 redo blocks read
Mon Jun 20 08:48:15 2011
Thread 1 advanced to log sequence 591
Thread 1 opened at log sequence 591
Current log# 4 seq# 591 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_1.LOG
Current log# 4 seq# 591 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_2.LOG
Successful open of redo thread 1
Mon Jun 20 08:48:15 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 20 08:48:15 2011
SMON: enabling cache recovery
Mon Jun 20 08:48:16 2011
Successfully onlined Undo Tablespace 1.
Mon Jun 20 08:48:16 2011
SMON: enabling tx recovery
Mon Jun 20 08:48:16 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=28, OS id=1000
Mon Jun 20 08:48:18 2011
Completed: alter database open
===============
高手给点配置意见,谢谢
交换区:在windows下也叫虚拟内存或页面文件。
共享内存的设置需要根据操作系统的情况设置,如果机器和系统的可用内存足够,应设置大点。
Thread 1 advanced to log sequence 580
Current log# 2 seq# 580 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO02_1.LOG
Current log# 2 seq# 580 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO02_2.LOG
Sun Jun 19 02:28:11 2011
Thread 1 advanced to log sequence 581
Current log# 3 seq# 581 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO03_1.LOG
Current log# 3 seq# 581 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO03_2.LOG
Sun Jun 19 04:04:39 2011
Thread 1 advanced to log sequence 582
Current log# 1 seq# 582 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_1.LOG
Current log# 1 seq# 582 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_2.LOG
Sun Jun 19 05:43:03 2011
Thread 1 advanced to log sequence 583
Current log# 4 seq# 583 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_1.LOG
Current log# 4 seq# 583 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_2.LOG
Sun Jun 19 07:17:24 2011
Thread 1 advanced to log sequence 584
Current log# 2 seq# 584 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO02_1.LOG
Current log# 2 seq# 584 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO02_2.LOG
Sun Jun 19 08:18:41 2011
Thread 1 advanced to log sequence 585
Current log# 3 seq# 585 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO03_1.LOG
Current log# 3 seq# 585 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO03_2.LOG
Sun Jun 19 09:54:31 2011
Thread 1 advanced to log sequence 586
Current log# 1 seq# 586 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_1.LOG
Current log# 1 seq# 586 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_2.LOG
Sun Jun 19 11:27:28 2011
Thread 1 advanced to log sequence 587
Current log# 4 seq# 587 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_1.LOG
Current log# 4 seq# 587 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO04_2.LOG
Sun Jun 19 13:00:09 2011
Thread 1 advanced to log sequence 588
Current log# 2 seq# 588 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO02_1.LOG
Current log# 2 seq# 588 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO02_2.LOG
Sun Jun 19 14:33:17 2011
Thread 1 advanced to log sequence 589
Current log# 3 seq# 589 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO03_1.LOG
Current log# 3 seq# 589 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO03_2.LOG
Sun Jun 19 16:07:22 2011
Thread 1 advanced to log sequence 590
Current log# 1 seq# 590 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_1.LOG
Current log# 1 seq# 590 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL1\REDO01_2.LOG
Dump file F:\ORA\product\10.2.0/admin/orcl1/bdump\alert_orcl1.log
====
Sat Jun 04 08:30:15 2011
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=39, OS id=2976
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_SCHEMA_01', 'NEWSINFO', 'KUPC$C_1_20110604083015', 'KUPC$S_1_20110604083015', 0);
kupprdp: worker process DW01 started with worker id=1, pid=57, OS id=4036
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_01', 'NEWSINFO');
Sat Jun 04 08:30:20 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2471K exceeds notification threshold (2048K)
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,'TABLE' ,to_char(KU$.BYTES_ALLOC) ,to_char(KU$.ET_PARALLEL) ,KU$.FGAC ,KU$.NONSCOPED_REF ,KU$.XMLSCHEMACOLS ,KU$.NAME ,KU$.NAME ,'TABLE_DATA' ,KU$.PART_NAME ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG ,decode(KU$.SCHEMA_OBJ.TYPE_NUM,2,decode(bitand(KU$.PROPERTY,8192),8192,'NESTED TABLE','TABLE'),19,'PARTITION',20,'PARTITION','SUBPARTITION') ,to_char(KU$.UNLOAD_METHO
Sat Jun 04 08:30:20 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2468K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,'TABLE' ,to_char(KU$.BYTES_ALLOC) ,to_char(KU$.ET_PARALLEL) ,KU$.FGAC ,KU$.NONSCOPED_REF ,KU$.XMLSCHEMACOLS ,KU$.NAME ,KU$.NAME ,'TABLE_DATA' ,KU$.PART_NAME ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG ,decode(KU$.SCHEMA_OBJ.TYPE_NUM,2,decode(bitand(KU$.PROPERTY,8192),8192,'NESTED TABLE','TABLE'),19,'PARTITION',20,'PARTITION','SUBPARTITION') ,to_char(KU$.UNLOAD_METHO
Sat Jun 04 08:30:28 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2511K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NUM
Sat Jun 04 08:30:28 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2511K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NUM
Sat Jun 04 08:30:30 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 8470K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NU
Sat Jun 04 08:30:30 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 8466K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_FHTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NU
Sat Jun 04 08:30:35 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2909K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('VIEW_T', '7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'VIEW' ,KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))
Sat Jun 04 08:30:35 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2906K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_4036.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('VIEW_T', '7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'VIEW' ,KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_VIEW_VIEW KU$ WHERE KU$.OBJ_NUM IN (SELECT * FROM TABLE(DBMS_METADATA.FETCH_OBJNUMS(200001)))
Sat Jun 04 08:34:25 2011
Thread 1 advanced to log sequence 434
Current log# 1 seq# 434 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01.LOG
Sat Jun 04 09:17:06 2011
Thread 1 advanced to log sequence 435
Current log# 2 seq# 435 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG
Sat Jun 04 14:08:13 2011
Thread 1 advanced to log sequence 436
Current log# 3 seq# 436 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Sat Jun 04 15:17:06 2011
ALTER SYSTEM SET audit_sys_operations=TRUE SCOPE=SPFILE;
Sat Jun 04 15:18:20 2011
ALTER SYSTEM SET audit_trail='DB' SCOPE=SPFILE;
Sat Jun 04 16:04:43 2011
ALTER SYSTEM SET _kgl_large_heap_warning_threshold=8388608 SCOPE=SPFILE;
Sat Jun 04 17:00:51 2011
The value (30) of MAXTRANS parameter ignored.
kupprdp: master process DM00 started with pid=48, OS id=2988
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_SCHEMA_01', 'NEWSINFO', 'KUPC$C_1_20110604170051', 'KUPC$S_1_20110604170051', 0);
kupprdp: worker process DW01 started with worker id=1, pid=51, OS id=3148
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_SCHEMA_01', 'NEWSINFO');
Sat Jun 04 17:00:53 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2471K exceeds notification threshold (2048K)
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,'TABLE' ,to_char(KU$.BYTES_ALLOC) ,to_char(KU$.ET_PARALLEL) ,KU$.FGAC ,KU$.NONSCOPED_REF ,KU$.XMLSCHEMACOLS ,KU$.NAME ,KU$.NAME ,'TABLE_DATA' ,KU$.PART_NAME ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG ,decode(KU$.SCHEMA_OBJ.TYPE_NUM,2,decode(bitand(KU$.PROPERTY,8192),8192,'NESTED TABLE','TABLE'),19,'PARTITION',20,'PARTITION','SUBPARTITION') ,to_char(KU$.UNLOAD_METHO
Sat Jun 04 17:00:53 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2468K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_3148.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_DATA_T', '7')), 0 ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,'TABLE' ,to_char(KU$.BYTES_ALLOC) ,to_char(KU$.ET_PARALLEL) ,KU$.FGAC ,KU$.NONSCOPED_REF ,KU$.XMLSCHEMACOLS ,KU$.NAME ,KU$.NAME ,'TABLE_DATA' ,KU$.PART_NAME ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG ,decode(KU$.SCHEMA_OBJ.TYPE_NUM,2,decode(bitand(KU$.PROPERTY,8192),8192,'NESTED TABLE','TABLE'),19,'PARTITION',20,'PARTITION','SUBPARTITION') ,to_char(KU$.UNLOAD_METHO
Sat Jun 04 17:00:59 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2511K exceeds notification threshold (2048K)
Details in trace file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_dw01_3148.trc
KGL object name :SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TABLE_T', '7')), KU$.OBJ_NUM ,KU$.ANC_OBJ.NAME ,KU$.ANC_OBJ.OWNER_NAME ,KU$.ANC_OBJ.TYPE_NAME ,KU$.BASE_OBJ.NAME ,KU$.BASE_OBJ.OWNER_NAME ,KU$.BASE_OBJ.TYPE_NAME ,KU$.SPARE1 ,KU$.XMLSCHEMACOLS ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TABLE' ,KU$.PROPERTY ,KU$.SCHEMA_OBJ.OWNER_NAME ,KU$.TS_NAME ,KU$.TRIGFLAG FROM SYS.KU$_HTABLE_VIEW KU$ WHERE NOT (BITAND (KU$.PROPERTY,8192)=8192) AND NOT BITAND(KU$.SCHEMA_OBJ.FLAGS,128)!=0 AND KU$.OBJ_NUM
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Dump file F:\ORA\product\10.2.0/admin/ORCL_NEWS/bdump\alert_ORCL_NEWS.log
Mon Jun 13 11:11:44 2011
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15314M/16382M, Ph+PgF:17389M/17822M
Mon Jun 13 11:11:44 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as F:\ORA\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =30
LICENSE_MAX_USERS = 0
SYS auditing is enabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 250
sessions = 280
resource_limit = TRUE
sga_max_size = 8589934592
__shared_pool_size = 1409286144
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 33554432
spfile = F:\ORA\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL_NEWS.ORA
nls_language = SIMPLIFIED CHINESE
sga_target = 8589934592
control_files = F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\CONTROL01.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\CONTROL02.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 7096762368
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
_kgl_large_heap_warning_threshold= 8388608
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = TRUE
db_domain =
dispatchers = (PROTOCOL=TCP)(DISPATCHERS=3)(SERVICE=ORCL_NEWSXDB)
job_queue_processes = 10
audit_file_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\ADUMP
background_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\BDUMP
user_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\UDUMP
core_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\CDUMP
audit_trail = DB
db_name = ORCL_NEWS
open_cursors = 300
pga_aggregate_target = 1707081728
PMON started with pid=2, OS id=3180
PSP0 started with pid=3, OS id=3752
MMAN started with pid=4, OS id=3316
DBW0 started with pid=5, OS id=2528
LGWR started with pid=6, OS id=2020
CKPT started with pid=7, OS id=3572
SMON started with pid=8, OS id=1560
RECO started with pid=9, OS id=1200
CJQ0 started with pid=10, OS id=2232
MMON started with pid=11, OS id=2676
MMNL started with pid=12, OS id=3228
Mon Jun 13 11:11:45 2011
starting up 3 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Jun 13 11:11:45 2011
alter database mount exclusive
Mon Jun 13 11:11:52 2011
Setting recovery target incarnation to 2
Mon Jun 13 11:11:52 2011
Successful mount of redo thread 1, with mount id 1138165684
Mon Jun 13 11:11:52 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 13 11:11:52 2011
alter database open
Mon Jun 13 11:11:52 2011
Thread 1 opened at log sequence 488
Current log# 4 seq# 488 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04.LOG
Successful open of redo thread 1
Mon Jun 13 11:11:52 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 13 11:11:52 2011
SMON: enabling cache recovery
Mon Jun 13 11:11:53 2011
Successfully onlined Undo Tablespace 1.
Mon Jun 13 11:11:53 2011
SMON: enabling tx recovery
Mon Jun 13 11:11:53 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=3392
Mon Jun 13 11:11:55 2011
Completed: alter database open
Mon Jun 13 11:24:12 2011
Thread 1 advanced to log sequence 489
Current log# 1 seq# 489 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01.LOG
Mon Jun 13 11:24:30 2011
Thread 1 advanced to log sequence 490
Current log# 2 seq# 490 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG
Mon Jun 13 11:25:53 2011
Thread 1 advanced to log sequence 491
Current log# 3 seq# 491 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Mon Jun 13 11:26:57 2011
Thread 1 cannot allocate new log, sequence 492
Checkpoint not complete
Current log# 3 seq# 491 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Thread 1 advanced to log sequence 492
Current log# 4 seq# 492 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04.LOG
Mon Jun 13 11:27:08 2011
Thread 1 cannot allocate new log, sequence 493
Checkpoint not complete
Current log# 4 seq# 492 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04.LOG
Thread 1 advanced to log sequence 493
Current log# 1 seq# 493 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01.LOG
Mon Jun 13 11:29:33 2011
Thread 1 cannot allocate new log, sequence 494
Checkpoint not complete
Current log# 1 seq# 493 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01.LOG
Thread 1 advanced to log sequence 494
Current log# 2 seq# 494 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG
Mon Jun 13 11:33:22 2011
alter database drop logfile group 4Mon Jun 13 11:33:22 2011
Completed: alter database drop logfile group 4
Mon Jun 13 16:28:56 2011
alter database add logfile group 4 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_2.LOG') size 100MMon Jun 13 16:28:58 2011
Completed: alter database add logfile group 4 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_2.LOG') size 100M
Mon Jun 13 16:29:21 2011
Thread 1 advanced to log sequence 495
Current log# 4 seq# 495 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_1.LOG
Current log# 4 seq# 495 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_2.LOG
Mon Jun 13 16:29:46 2011
alter database drop logfile group 1Mon Jun 13 16:29:46 2011
Completed: alter database drop logfile group 1
Mon Jun 13 16:30:01 2011
alter database add logfile group 1 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01_2.LOG') size 100MMon Jun 13 16:30:01 2011
Completed: alter database add logfile group 1 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01_2.LOG') size 100M
Mon Jun 13 16:30:10 2011
Thread 1 advanced to log sequence 496
Current log# 1 seq# 496 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01_1.LOG
Current log# 1 seq# 496 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO01_2.LOG
Mon Jun 13 16:30:27 2011
Thread 1 advanced to log sequence 497
Current log# 3 seq# 497 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Mon Jun 13 16:30:38 2011
Thread 1 cannot allocate new log, sequence 498
Checkpoint not complete
Current log# 3 seq# 497 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Thread 1 advanced to log sequence 498
Current log# 2 seq# 498 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG
Thread 1 cannot allocate new log, sequence 499
Checkpoint not complete
Current log# 2 seq# 498 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG
Mon Jun 13 16:30:50 2011
Thread 1 advanced to log sequence 499
Current log# 4 seq# 499 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_1.LOG
Current log# 4 seq# 499 mem# 1: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04_2.LOG
Mon Jun 13 16:31:45 2011
alter database clear unarchived logfile group 2Mon Jun 13 16:31:45 2011
Clearing online log 2 of thread 1 sequence number 498
Completed: alter database clear unarchived logfile group 2
Mon Jun 13 16:31:58 2011
alter database drop logfile group 2Mon Jun 13 16:31:58 2011
Completed: alter database drop logfile group 2
Mon Jun 13 16:32:01 2011
alter database add logfile group 2 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02_2.LOG') size 100MCompleted: alter database add logfile group 2 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02_2.LOG') size 100M
Mon Jun 13 16:32:18 2011
alter database drop logfile group 3Mon Jun 13 16:32:18 2011
Completed: alter database drop logfile group 3
Mon Jun 13 16:32:40 2011
alter database add logfile group 3 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03_2.LOG') size 100MMon Jun 13 16:32:41 2011
Completed: alter database add logfile group 3 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03_1.LOG','F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03_2.LOG') size 100M
Completed: alter database drop logfile group 2
Fri Jun 10 15:21:38 2011
alter database drop logfile group 2Fri Jun 10 15:21:38 2011
ORA-359 signalled during: alter database drop logfile group 2
...
Fri Jun 10 15:21:43 2011
alter database add logfile group 2 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG') size 1024MCompleted: alter database add logfile group 2 ('F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG') size 1024M
Fri Jun 10 15:22:04 2011
Thread 1 advanced to log sequence 486
Current log# 2 seq# 486 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO02.LOG
Fri Jun 10 15:22:13 2011
alter database drop logfile group 5Fri Jun 10 15:22:13 2011
Completed: alter database drop logfile group 5
Sat Jun 11 14:09:55 2011
ALTER SYSTEM SET resource_limit=TRUE SCOPE=BOTH;
Sat Jun 11 14:21:05 2011
ALTER SYSTEM SET audit_sys_operations=TRUE SCOPE=SPFILE;
Sat Jun 11 14:21:14 2011
ALTER SYSTEM SET audit_trail='DB' SCOPE=SPFILE;
Sun Jun 12 20:07:09 2011
Thread 1 advanced to log sequence 487
Current log# 3 seq# 487 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Dump file F:\ORA\product\10.2.0/admin/ORCL_NEWS/bdump\alert_ORCL_NEWS.log
Mon Jun 13 11:06:00 2011
ORACLE V10.2.0.1.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 8664, 2 Physical Cores
Process Affinity : 0x0000000000000000
Memory (Avail/Total): Ph:15311M/16382M, Ph+PgF:17387M/17822M
Mon Jun 13 11:06:00 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as F:\ORA\product\10.2.0\db_1\RDBMS
Autotune of undo retention is turned on.
IMODE=BR
ILAT =30
LICENSE_MAX_USERS = 0
SYS auditing is enabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 250
sessions = 280
resource_limit = TRUE
sga_max_size = 8589934592
__shared_pool_size = 1409286144
__large_pool_size = 16777216
__java_pool_size = 16777216
__streams_pool_size = 33554432
spfile = F:\ORA\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL_NEWS.ORA
nls_language = SIMPLIFIED CHINESE
sga_target = 8589934592
control_files = F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\CONTROL01.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\CONTROL02.CTL, F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 7096762368
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
_kgl_large_heap_warning_threshold= 8388608
remote_login_passwordfile= EXCLUSIVE
audit_sys_operations = TRUE
db_domain =
dispatchers = (PROTOCOL=TCP)(DISPATCHERS=3)(SERVICE=ORCL_NEWSXDB)
job_queue_processes = 10
audit_file_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\ADUMP
background_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\BDUMP
user_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\UDUMP
core_dump_dest = F:\ORA\PRODUCT\10.2.0\ADMIN\ORCL_NEWS\CDUMP
audit_trail = DB
db_name = ORCL_NEWS
open_cursors = 300
pga_aggregate_target = 1707081728
PMON started with pid=2, OS id=2688
PSP0 started with pid=3, OS id=2812
MMAN started with pid=4, OS id=2736
DBW0 started with pid=5, OS id=2508
LGWR started with pid=6, OS id=1956
CKPT started with pid=7, OS id=3892
SMON started with pid=8, OS id=756
RECO started with pid=9, OS id=1424
CJQ0 started with pid=10, OS id=2728
MMON started with pid=11, OS id=2040
MMNL started with pid=12, OS id=1264
Mon Jun 13 11:06:01 2011
starting up 3 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Mon Jun 13 11:06:01 2011
alter database mount exclusive
Mon Jun 13 11:06:08 2011
Setting recovery target incarnation to 2
Mon Jun 13 11:06:08 2011
Successful mount of redo thread 1, with mount id 1138134364
Mon Jun 13 11:06:08 2011
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Jun 13 11:06:08 2011
alter database open
Mon Jun 13 11:06:08 2011
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Mon Jun 13 11:06:08 2011
Started redo scan
Mon Jun 13 11:06:08 2011
Completed redo scan
6603 redo blocks read, 426 data blocks need recovery
Mon Jun 13 11:06:08 2011
Started redo application at
Thread 1: logseq 487, block 710054
Mon Jun 13 11:06:08 2011
Recovery of Online Redo Log: Thread 1 Group 3 Seq 487 Reading mem 0
Mem# 0 errs 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO03.LOG
Mon Jun 13 11:06:08 2011
Completed redo application
Mon Jun 13 11:06:08 2011
Completed crash recovery at
Thread 1: logseq 487, block 716657, scn 314091614
426 data blocks read, 425 data blocks written, 6603 redo blocks read
Mon Jun 13 11:06:08 2011
Thread 1 advanced to log sequence 488
Thread 1 opened at log sequence 488
Current log# 4 seq# 488 mem# 0: F:\ORA\PRODUCT\10.2.0\ORADATA\ORCL_NEWS\REDO04.LOG
Successful open of redo thread 1
Mon Jun 13 11:06:08 2011
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 13 11:06:08 2011
SMON: enabling cache recovery
Mon Jun 13 11:06:09 2011
Successfully onlined Undo Tablespace 1.
Mon Jun 13 11:06:09 2011
SMON: enabling tx recovery
Mon Jun 13 11:06:09 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=26, OS id=3740
Mon Jun 13 11:06:11 2011
Completed: alter database open
Mon Jun 13 11:11:25 2011
Starting background process EMN0
EMN0 started with pid=18, OS id=3032
Mon Jun 13 11:11:25 2011
Shutting down instance: further logons disabled
Mon Jun 13 11:11:25 2011
Stopping background process QMNC
Mon Jun 13 11:11:25 2011
Stopping background process CJQ0
Mon Jun 13 11:11:27 2011
Stopping background process MMNL
Mon Jun 13 11:11:28 2011
Stopping background process MMON
Mon Jun 13 11:11:29 2011
Shutting down instance (immediate)
License high water = 118
Mon Jun 13 11:11:29 2011
Stopping Job queue slave processes
Mon Jun 13 11:11:29 2011
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Mon Jun 13 11:11:35 2011
PMON failed to acquire latch, see PMON dump
PMON failed to acquire latch, see PMON dump
Mon Jun 13 11:11:41 2011
alter database close normal
Mon Jun 13 11:11:41 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Jun 13 11:11:41 2011
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 488
Successful close of redo thread 1
Mon Jun 13 11:11:42 2011
Completed: alter database close normal
Mon Jun 13 11:11:42 2011
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
Mon Jun 13 11:11:42 2011
Errors in file F:\ORA\product\10.2.0\admin\ORCL_NEWS\bdump\ORCL_NEWS_pmon_2688.trc:
ORA-00600: internal error code, arguments: [17302], [2], [], [], [], [], [], []
oracle有一个bug,上次我们工程人员讲过的,在视图上执行select * from view 就会冒出来。
冒得错误和这个差不多。具体我也不是太清楚,只是有这么个映像。
alter system set "_kgl_large_heap_warning_threshold" = 104857600 scope=spfile;
重启
处理下,现在怀疑是SGA设置过大,SGA+PGA=内存容量了,ORACLE推荐的是占内存80%.
不过可以通过修改系统配置来进行修改,改成 允许更多的内存。还有是如果修改了限制,在这种操作系统上 sga+pga也不能过大,如果sga+pga超过了3g 好像oracle服务就启动不了了。