我现在往oracle10g数据库里面写频繁写入大量数据,数据跑上2到3个小时后导致我安装数据库的机器自动重启
郁闷!下面就是我oracle10G的数据库日志!希望大家能给我提下意见,做个抛砖引玉。
Wed Aug 03 22:56:34 2011
Thread 1 advanced to log sequence 69
Current log# 2 seq# 69 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Aug 03 23:26:12 2011
Thread 1 advanced to log sequence 70
Current log# 3 seq# 70 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Aug 03 23:55:08 2011
Thread 1 advanced to log sequence 71
Current log# 1 seq# 71 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Aug 04 00:23:19 2011
Thread 1 advanced to log sequence 72
Current log# 2 seq# 72 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Aug 04 00:51:54 2011
Thread 1 advanced to log sequence 73
Current log# 3 seq# 73 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
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 = 150
__shared_pool_size = 138412032
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 612368384
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 457179136
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
MMAN started with pid=8, OS id=140
DBW0 started with pid=11, OS id=424
DBW1 started with pid=14, OS id=524
DBW2 started with pid=17, OS id=208
LGWR started with pid=20, OS id=604
CKPT started with pid=23, OS id=644
SMON started with pid=26, OS id=464
RECO started with pid=29, OS id=680
CJQ0 started with pid=32, OS id=672
MMON started with pid=35, OS id=752
MMNL started with pid=38, OS id=756
Thu Aug 04 09:11:16 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Aug 04 09:11:17 2011
alter database mount exclusive
PSP0 started with pid=5, OS id=272
PMON started with pid=2, OS id=268
Setting recovery target incarnation to 2
Thu Aug 04 09:11:21 2011
Successful mount of redo thread 1, with mount id 1286035637
郁闷!下面就是我oracle10G的数据库日志!希望大家能给我提下意见,做个抛砖引玉。
Wed Aug 03 22:56:34 2011
Thread 1 advanced to log sequence 69
Current log# 2 seq# 69 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Aug 03 23:26:12 2011
Thread 1 advanced to log sequence 70
Current log# 3 seq# 70 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Aug 03 23:55:08 2011
Thread 1 advanced to log sequence 71
Current log# 1 seq# 71 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thu Aug 04 00:23:19 2011
Thread 1 advanced to log sequence 72
Current log# 2 seq# 72 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thu Aug 04 00:51:54 2011
Thread 1 advanced to log sequence 73
Current log# 3 seq# 73 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
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 = 150
__shared_pool_size = 138412032
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEORCL.ORA
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 612368384
control_files = E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 457179136
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 8
db_recovery_file_dest = E:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
job_queue_processes = 10
audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\ORCL\CDUMP
db_name = orcl
open_cursors = 300
pga_aggregate_target = 203423744
MMAN started with pid=8, OS id=140
DBW0 started with pid=11, OS id=424
DBW1 started with pid=14, OS id=524
DBW2 started with pid=17, OS id=208
LGWR started with pid=20, OS id=604
CKPT started with pid=23, OS id=644
SMON started with pid=26, OS id=464
RECO started with pid=29, OS id=680
CJQ0 started with pid=32, OS id=672
MMON started with pid=35, OS id=752
MMNL started with pid=38, OS id=756
Thu Aug 04 09:11:16 2011
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Aug 04 09:11:17 2011
alter database mount exclusive
PSP0 started with pid=5, OS id=272
PMON started with pid=2, OS id=268
Setting recovery target incarnation to 2
Thu Aug 04 09:11:21 2011
Successful mount of redo thread 1, with mount id 1286035637
看看是否操作系统或者外部因素造成的,因为你数据库没有关闭信息,是数据库直接DOWN了?还是操作系统直接DOWN了?
我机器是8核的,内存也有4G。 总的情况就是机器跑上3到4个小时 就直接给你重启。系统里的日志也没有什么有价值的日志。 说到内存是不是oracle10G里面有什么配置需要改大点 就是消耗内存的参数