oracle 导致CPU使用率只升不降达到100% oracle ,cpu,上升,100% 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 重启后也如此?把日志贴上来吧。 在redhat 6.0 安装oracle 10g 32位的时候 出现过同样的问题。 是由于时间函数引起的。 sqlplus /nolog 也无响应 重启后cpu就降到1%了,然后再一直升,三四天升到100%。oracle检测一般有哪些方法?怎么能检测出问题原因?我过后会生成statspack报告连同日志一块贴上来,大家一块帮我看看 下面是alert_.log从后往前截取的Started first pass scanMon Sep 15 08:06:03 2014Completed first pass scan 5299 redo blocks read, 502 data blocks need recoveryMon Sep 15 08:06:03 2014Started recovery at Thread 1: logseq 794, block 118731, scn 0.0Recovery of Online Redo Log: Thread 1 Group 1 Seq 794 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOGMon Sep 15 08:06:05 2014Ended recovery at Thread 1: logseq 794, block 124030, scn 3272.2759596637 502 data blocks read, 502 data blocks written, 5299 redo blocks readCrash recovery completed successfullyMon Sep 15 08:06:05 2014Thread 1 advanced to log sequence 795Thread 1 opened at log sequence 795 Current log# 2 seq# 795 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOGSuccessful open of redo thread 1.Mon Sep 15 08:06:06 2014SMON: enabling cache recoveryMon Sep 15 08:06:06 2014Undo Segment 1 OnlinedUndo Segment 2 OnlinedUndo Segment 3 OnlinedUndo Segment 4 OnlinedUndo Segment 5 OnlinedUndo Segment 6 OnlinedUndo Segment 7 OnlinedUndo Segment 8 OnlinedUndo Segment 9 OnlinedUndo Segment 10 OnlinedSuccessfully onlined Undo Tablespace 1.Mon Sep 15 08:06:06 2014SMON: enabling tx recoveryMon Sep 15 08:06:06 2014Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Completed: alter database openMon Sep 15 16:26:59 2014Thread 1 advanced to log sequence 796 Current log# 3 seq# 796 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOGTue Sep 16 06:42:52 2014Thread 1 advanced to log sequence 797 Current log# 1 seq# 797 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOGTue Sep 16 15:17:49 2014Thread 1 advanced to log sequence 798 Current log# 2 seq# 798 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOGDump file g:\oracle\admin\rzwlkp\bdump\alert_rzwlkp.logTue Sep 16 18:10:53 2014ORACLE V9.2.0.1.0 - Production vsnsta=0vsnsql=12 vsnxtr=3Windows 2000 Version 5.2 Service Pack 2, CPU type 586Tue Sep 16 18:10:53 2014Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 2Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.1.0.System parameters with non-default values: processes = 1000 timed_statistics = TRUE shared_pool_size = 209715200 sga_max_size = 1093215012 large_pool_size = 8388608 java_pool_size = 33554432 control_files = G:\oracle\oradata\RZWLKP\CONTROL01.CTL, G:\oracle\oradata\RZWLKP\CONTROL02.CTL, G:\oracle\oradata\RZWLKP\CONTROL03.CTL db_block_size = 8192 db_cache_size = 738197504 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 32 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = RZWLKP dispatchers = (PROTOCOL=TCP) (SERVICE=RZWLKPXDB) job_queue_processes = 10 hash_join_enabled = TRUE hash_area_size = 1048576 background_dump_dest = G:\oracle\admin\RZWLKP\bdump user_dump_dest = G:\oracle\admin\RZWLKP\udump core_dump_dest = G:\oracle\admin\RZWLKP\cdump sort_area_size = 1048576 db_name = RZWLKP open_cursors = 300 star_transformation_enabled= TRUE query_rewrite_enabled = TRUE pga_aggregate_target = 734003200 aq_tm_processes = 1PMON started with pid=2DBW0 started with pid=3DBW1 started with pid=4LGWR started with pid=5CKPT started with pid=6SMON started with pid=7RECO started with pid=8CJQ0 started with pid=9QMN0 started with pid=10Tue Sep 16 18:10:56 2014starting up 1 shared server(s) ...starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...Tue Sep 16 18:10:57 2014alter database mount exclusive Tue Sep 16 18:11:04 2014Successful mount of redo thread 1, with mount id 4101192372.Tue Sep 16 18:11:04 2014Database mounted in Exclusive Mode.Completed: alter database mount exclusiveTue Sep 16 18:11:04 2014alter database openTue Sep 16 18:11:04 2014Beginning crash recovery of 1 threadsTue Sep 16 18:11:04 2014Started first pass scanTue Sep 16 18:11:05 2014Completed first pass scan 7151 redo blocks read, 667 data blocks need recoveryTue Sep 16 18:11:05 2014Started recovery at Thread 1: logseq 798, block 64806, scn 0.0Recovery of Online Redo Log: Thread 1 Group 2 Seq 798 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOGTue Sep 16 18:11:08 2014Ended recovery at Thread 1: logseq 798, block 71957, scn 3272.3911275493 667 data blocks read, 667 data blocks written, 7151 redo blocks readCrash recovery completed successfullyTue Sep 16 18:11:08 2014Thread 1 advanced to log sequence 799Thread 1 opened at log sequence 799 Current log# 3 seq# 799 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOGSuccessful open of redo thread 1.Tue Sep 16 18:11:08 2014SMON: enabling cache recoveryTue Sep 16 18:11:09 2014Undo Segment 1 OnlinedUndo Segment 2 OnlinedUndo Segment 3 OnlinedUndo Segment 4 OnlinedUndo Segment 5 OnlinedUndo Segment 6 OnlinedUndo Segment 7 OnlinedUndo Segment 8 OnlinedUndo Segment 9 OnlinedUndo Segment 10 OnlinedSuccessfully onlined Undo Tablespace 1.Tue Sep 16 18:11:09 2014SMON: enabling tx recoveryTue Sep 16 18:11:09 2014Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Completed: alter database openTue Sep 16 18:12:48 2014Thread 1 advanced to log sequence 800 Current log# 1 seq# 800 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOGTue Sep 16 18:13:09 2014Thread 1 advanced to log sequence 801 Current log# 2 seq# 801 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOGWed Sep 17 02:58:46 2014Thread 1 advanced to log sequence 802 Current log# 3 seq# 802 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOGDump file g:\oracle\admin\rzwlkp\bdump\alert_rzwlkp.logWed Sep 17 11:05:30 2014ORACLE V9.2.0.1.0 - Production vsnsta=0vsnsql=12 vsnxtr=3Windows 2000 Version 5.2 Service Pack 2, CPU type 586Wed Sep 17 11:05:30 2014Starting ORACLE instance (normal)LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0SCN scheme 2Using log_archive_dest parameter default valueLICENSE_MAX_USERS = 0SYS auditing is disabledStarting up ORACLE RDBMS Version: 9.2.0.1.0.System parameters with non-default values: processes = 1000 timed_statistics = TRUE shared_pool_size = 209715200 sga_max_size = 1093215012 large_pool_size = 8388608 java_pool_size = 33554432 control_files = G:\oracle\oradata\RZWLKP\CONTROL01.CTL, G:\oracle\oradata\RZWLKP\CONTROL02.CTL, G:\oracle\oradata\RZWLKP\CONTROL03.CTL db_block_size = 8192 db_cache_size = 738197504 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 32 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = RZWLKP dispatchers = (PROTOCOL=TCP) (SERVICE=RZWLKPXDB) job_queue_processes = 10 hash_join_enabled = TRUE hash_area_size = 1048576 background_dump_dest = G:\oracle\admin\RZWLKP\bdump user_dump_dest = G:\oracle\admin\RZWLKP\udump core_dump_dest = G:\oracle\admin\RZWLKP\cdump sort_area_size = 1048576 db_name = RZWLKP open_cursors = 300 star_transformation_enabled= TRUE query_rewrite_enabled = TRUE pga_aggregate_target = 734003200 aq_tm_processes = 1PMON started with pid=2DBW0 started with pid=3DBW1 started with pid=4LGWR started with pid=5CKPT started with pid=6SMON started with pid=7RECO started with pid=8CJQ0 started with pid=9QMN0 started with pid=10Wed Sep 17 11:05:34 2014starting up 1 shared server(s) ...starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...Wed Sep 17 11:05:35 2014alter database mount exclusive Wed Sep 17 11:05:42 2014Successful mount of redo thread 1, with mount id 4101253505.Wed Sep 17 11:05:42 2014Database mounted in Exclusive Mode.Completed: alter database mount exclusiveWed Sep 17 11:05:42 2014alter database openWed Sep 17 11:05:42 2014Beginning crash recovery of 1 threadsWed Sep 17 11:05:42 2014Started first pass scanWed Sep 17 11:05:42 2014Completed first pass scan 12216 redo blocks read, 1213 data blocks need recoveryWed Sep 17 11:05:44 2014Started recovery at Thread 1: logseq 802, block 151483, scn 0.0Recovery of Online Redo Log: Thread 1 Group 3 Seq 802 Reading mem 0 Mem# 0 errs 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOGWed Sep 17 11:05:47 2014Ended recovery at Thread 1: logseq 802, block 163699, scn 3274.706227793 1213 data blocks read, 1213 data blocks written, 12216 redo blocks readCrash recovery completed successfullyWed Sep 17 11:05:48 2014Thread 1 advanced to log sequence 803Thread 1 opened at log sequence 803 Current log# 1 seq# 803 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOGSuccessful open of redo thread 1.Wed Sep 17 11:05:48 2014SMON: enabling cache recoveryWed Sep 17 11:05:49 2014Undo Segment 1 OnlinedUndo Segment 2 OnlinedUndo Segment 3 OnlinedUndo Segment 4 OnlinedUndo Segment 5 OnlinedUndo Segment 6 OnlinedUndo Segment 7 OnlinedUndo Segment 8 OnlinedUndo Segment 9 OnlinedUndo Segment 10 OnlinedSuccessfully onlined Undo Tablespace 1.Wed Sep 17 11:05:49 2014SMON: enabling tx recoveryWed Sep 17 11:05:49 2014Database Characterset is AL32UTF8replication_dependency_tracking turned off (no async multimaster replication found)Completed: alter database open cpu使用升高时监测一下系统中存在的锁,看看哪个对象被锁住最频繁SELECT l.session_id sid, s.serial#, l.locked_mode 锁模式, l.oracle_username 登录用户, l.os_user_name 登录机器用户名, s.machine 机器名, s.terminal 终端用户名, o.object_name 被锁对象名, s.logon_time 登录数据库时间 FROM v$locked_object l, all_objects o, v$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid ORDER BY sid, s.serial#; 看看当cpu100%时,使用中的SQL有没有死锁,查找最耗时SQL,很有可能是索引问题 查找CPU高的系统进程,然后定位到对应的会话及SQL语句 查了,没有对象被锁住。下面两次查询进程所占cpu,一直在升,但我看另外一台cpu正常的服务器,查询session所占cpu也是一直升的 检查是否有无定时计算或递归调用或是死循环,一直后台执行,抢占CPU资源 服务器装的是windows server 2003 日志我看不出问题, 你这个cpu到100%的时候,内存是多少?连接数是多少? 把你的statspack报告贴上来,或发我邮箱[email protected] 19号那天可能weblogic或数据库出问题了,连接池自动断开连接。重新建了一个weblogic域,把项目部署上了。这三天cpu竟然没上升,我再观察一短时间看看,然后查看内存、连接数,以及生成statspack报告,到时候大家再帮我看看,感谢! 怎样改变Oracle数据库的表中字段的类型? 通过服务命连接oracle数据库,在配置网络服务名时点击测试一直没有反应 在线高分求解:PL SQL Procedure/Function 模糊查询中 通配符的使用 大家帮我看看这个sql怎么写 如何查看sql执行计划 又一个简单的查询语句问题 这些参数在oracle中是什么意思? pl/sql 的问题,高手帮忙呀 如何能看到一个已建好的表的主键 dbca相关问题 Oracle 条件trigger
把日志贴上来吧。 在redhat 6.0 安装oracle 10g 32位的时候 出现过同样的问题。 是由于时间函数引起的。 sqlplus /nolog 也无响应
Started first pass scanMon Sep 15 08:06:03 2014
Completed first pass scan
5299 redo blocks read, 502 data blocks need recovery
Mon Sep 15 08:06:03 2014
Started recovery at
Thread 1: logseq 794, block 118731, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 794 Reading mem 0
Mem# 0 errs 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOG
Mon Sep 15 08:06:05 2014
Ended recovery at
Thread 1: logseq 794, block 124030, scn 3272.2759596637
502 data blocks read, 502 data blocks written, 5299 redo blocks read
Crash recovery completed successfully
Mon Sep 15 08:06:05 2014
Thread 1 advanced to log sequence 795
Thread 1 opened at log sequence 795
Current log# 2 seq# 795 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOG
Successful open of redo thread 1.
Mon Sep 15 08:06:06 2014
SMON: enabling cache recovery
Mon Sep 15 08:06:06 2014
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Mon Sep 15 08:06:06 2014
SMON: enabling tx recovery
Mon Sep 15 08:06:06 2014
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon Sep 15 16:26:59 2014
Thread 1 advanced to log sequence 796
Current log# 3 seq# 796 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOG
Tue Sep 16 06:42:52 2014
Thread 1 advanced to log sequence 797
Current log# 1 seq# 797 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOG
Tue Sep 16 15:17:49 2014
Thread 1 advanced to log sequence 798
Current log# 2 seq# 798 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOG
Dump file g:\oracle\admin\rzwlkp\bdump\alert_rzwlkp.log
Tue Sep 16 18:10:53 2014
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Tue Sep 16 18:10:53 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 1000
timed_statistics = TRUE
shared_pool_size = 209715200
sga_max_size = 1093215012
large_pool_size = 8388608
java_pool_size = 33554432
control_files = G:\oracle\oradata\RZWLKP\CONTROL01.CTL, G:\oracle\oradata\RZWLKP\CONTROL02.CTL, G:\oracle\oradata\RZWLKP\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 738197504
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 32
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = RZWLKP
dispatchers = (PROTOCOL=TCP) (SERVICE=RZWLKPXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
hash_area_size = 1048576
background_dump_dest = G:\oracle\admin\RZWLKP\bdump
user_dump_dest = G:\oracle\admin\RZWLKP\udump
core_dump_dest = G:\oracle\admin\RZWLKP\cdump
sort_area_size = 1048576
db_name = RZWLKP
open_cursors = 300
star_transformation_enabled= TRUE
query_rewrite_enabled = TRUE
pga_aggregate_target = 734003200
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
QMN0 started with pid=10
Tue Sep 16 18:10:56 2014
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 16 18:10:57 2014
alter database mount exclusive
Tue Sep 16 18:11:04 2014
Successful mount of redo thread 1, with mount id 4101192372.
Tue Sep 16 18:11:04 2014
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Tue Sep 16 18:11:04 2014
alter database open
Tue Sep 16 18:11:04 2014
Beginning crash recovery of 1 threads
Tue Sep 16 18:11:04 2014
Started first pass scan
Tue Sep 16 18:11:05 2014
Completed first pass scan
7151 redo blocks read, 667 data blocks need recovery
Tue Sep 16 18:11:05 2014
Started recovery at
Thread 1: logseq 798, block 64806, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 798 Reading mem 0
Mem# 0 errs 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOG
Tue Sep 16 18:11:08 2014
Ended recovery at
Thread 1: logseq 798, block 71957, scn 3272.3911275493
667 data blocks read, 667 data blocks written, 7151 redo blocks read
Crash recovery completed successfully
Tue Sep 16 18:11:08 2014
Thread 1 advanced to log sequence 799
Thread 1 opened at log sequence 799
Current log# 3 seq# 799 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOG
Successful open of redo thread 1.
Tue Sep 16 18:11:08 2014
SMON: enabling cache recovery
Tue Sep 16 18:11:09 2014
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Tue Sep 16 18:11:09 2014
SMON: enabling tx recovery
Tue Sep 16 18:11:09 2014
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Tue Sep 16 18:12:48 2014
Thread 1 advanced to log sequence 800
Current log# 1 seq# 800 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOG
Tue Sep 16 18:13:09 2014
Thread 1 advanced to log sequence 801
Current log# 2 seq# 801 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO02.LOG
Wed Sep 17 02:58:46 2014
Thread 1 advanced to log sequence 802
Current log# 3 seq# 802 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOG
Dump file g:\oracle\admin\rzwlkp\bdump\alert_rzwlkp.log
Wed Sep 17 11:05:30 2014
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Wed Sep 17 11:05:30 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
processes = 1000
timed_statistics = TRUE
shared_pool_size = 209715200
sga_max_size = 1093215012
large_pool_size = 8388608
java_pool_size = 33554432
control_files = G:\oracle\oradata\RZWLKP\CONTROL01.CTL, G:\oracle\oradata\RZWLKP\CONTROL02.CTL, G:\oracle\oradata\RZWLKP\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 738197504
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 32
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = RZWLKP
dispatchers = (PROTOCOL=TCP) (SERVICE=RZWLKPXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
hash_area_size = 1048576
background_dump_dest = G:\oracle\admin\RZWLKP\bdump
user_dump_dest = G:\oracle\admin\RZWLKP\udump
core_dump_dest = G:\oracle\admin\RZWLKP\cdump
sort_area_size = 1048576
db_name = RZWLKP
open_cursors = 300
star_transformation_enabled= TRUE
query_rewrite_enabled = TRUE
pga_aggregate_target = 734003200
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
DBW1 started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
CJQ0 started with pid=9
QMN0 started with pid=10
Wed Sep 17 11:05:34 2014
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 17 11:05:35 2014
alter database mount exclusive
Wed Sep 17 11:05:42 2014
Successful mount of redo thread 1, with mount id 4101253505.
Wed Sep 17 11:05:42 2014
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Sep 17 11:05:42 2014
alter database open
Wed Sep 17 11:05:42 2014
Beginning crash recovery of 1 threads
Wed Sep 17 11:05:42 2014
Started first pass scan
Wed Sep 17 11:05:42 2014
Completed first pass scan
12216 redo blocks read, 1213 data blocks need recovery
Wed Sep 17 11:05:44 2014
Started recovery at
Thread 1: logseq 802, block 151483, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 802 Reading mem 0
Mem# 0 errs 0: G:\ORACLE\ORADATA\RZWLKP\REDO03.LOG
Wed Sep 17 11:05:47 2014
Ended recovery at
Thread 1: logseq 802, block 163699, scn 3274.706227793
1213 data blocks read, 1213 data blocks written, 12216 redo blocks read
Crash recovery completed successfully
Wed Sep 17 11:05:48 2014
Thread 1 advanced to log sequence 803
Thread 1 opened at log sequence 803
Current log# 1 seq# 803 mem# 0: G:\ORACLE\ORADATA\RZWLKP\REDO01.LOG
Successful open of redo thread 1.
Wed Sep 17 11:05:48 2014
SMON: enabling cache recovery
Wed Sep 17 11:05:49 2014
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Wed Sep 17 11:05:49 2014
SMON: enabling tx recovery
Wed Sep 17 11:05:49 2014
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
SELECT l.session_id sid,
s.serial#,
l.locked_mode 锁模式,
l.oracle_username 登录用户,
l.os_user_name 登录机器用户名,
s.machine 机器名,
s.terminal 终端用户名,
o.object_name 被锁对象名,
s.logon_time 登录数据库时间
FROM v$locked_object l, all_objects o, v$session s
WHERE l.object_id = o.object_id
AND l.session_id = s.sid
ORDER BY sid, s.serial#;
日志我看不出问题, 你这个cpu到100%的时候,内存是多少?
连接数是多少?