大家好,请问这个oracle日志文件有问题吗?现在开发了一个系统,有2000人左右访问就很慢,重启一下可能速度快点,但是人一多又很慢了,我对数据库死锁或堵塞不大了解,请高手赐教!Fri May 22 08:09:26 2009
Errors in file d:\oracle\admin\h090520\udump\h090520_s000_4560.trc:
ORA-00942: table or view does not existFri May 22 08:09:26 2009
Errors in file d:\oracle\admin\h090520\udump\h090520_s001_948.trc:
ORA-00942: table or view does not existFri May 22 08:45:20 2009
Errors in file d:\oracle\admin\h090520\udump\h090520_s000_4560.trc:
ORA-00942: table or view does not exist
Errors in file d:\oracle\admin\h090520\udump\h090520_s000_4560.trc:
ORA-00942: table or view does not existFri May 22 08:09:26 2009
Errors in file d:\oracle\admin\h090520\udump\h090520_s001_948.trc:
ORA-00942: table or view does not existFri May 22 08:45:20 2009
Errors in file d:\oracle\admin\h090520\udump\h090520_s000_4560.trc:
ORA-00942: table or view does not exist
Thread 1 advanced to log sequence 20
Current log# 1 seq# 20 mem# 0: D:\ORACLE\ORADATA\H090520\REDO01.LOG
Dump file d:\oracle\admin\h090520\bdump\alert_h090520.log
Fri May 22 10:05:44 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Fri May 22 10:05:44 2009
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 = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\h090520\CONTROL01.CTL, D:\oracle\oradata\h090520\CONTROL02.CTL, D:\oracle\oradata\h090520\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = h090520
dispatchers = (PROTOCOL=TCP) (SERVICE=h090520XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\h090520\bdump
user_dump_dest = D:\oracle\admin\h090520\udump
core_dump_dest = D:\oracle\admin\h090520\cdump
sort_area_size = 524288
db_name = H090520
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri May 22 10:05:48 2009
/* OracleOEM */ ALTER DATABASE MOUNT
Fri May 22 10:05:52 2009
Successful mount of redo thread 1, with mount id 1927771260.
Fri May 22 10:05:52 2009
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Fri May 22 10:05:52 2009
/* OracleOEM */ ALTER DATABASE OPEN
Fri May 22 10:05:52 2009
Beginning crash recovery of 1 threads
Fri May 22 10:05:52 2009
Started first pass scan
Fri May 22 10:05:53 2009
Completed first pass scan
14337 redo blocks read, 162 data blocks need recovery
Fri May 22 10:05:53 2009
Started recovery at
Thread 1: logseq 20, block 23924, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 20 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\H090520\REDO01.LOG
Fri May 22 10:05:54 2009
Ended recovery at
Thread 1: logseq 20, block 38261, scn 0.3147148
162 data blocks read, 162 data blocks written, 14337 redo blocks read
Crash recovery completed successfully
Fri May 22 10:05:54 2009
Thread 1 advanced to log sequence 21
Thread 1 opened at log sequence 21
Current log# 2 seq# 21 mem# 0: D:\ORACLE\ORADATA\H090520\REDO02.LOG
Successful open of redo thread 1.
Fri May 22 10:05:54 2009
SMON: enabling cache recovery
Fri May 22 10:05:54 2009
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.
Fri May 22 10:05:54 2009
SMON: enabling tx recovery
Fri May 22 10:05:54 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Dump file d:\oracle\admin\h090520\bdump\alert_h090520.log
Fri May 22 12:11:10 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Fri May 22 12:11:10 2009
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 = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\h090520\CONTROL01.CTL, D:\oracle\oradata\h090520\CONTROL02.CTL, D:\oracle\oradata\h090520\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = h090520
dispatchers = (PROTOCOL=TCP) (SERVICE=h090520XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\h090520\bdump
user_dump_dest = D:\oracle\admin\h090520\udump
core_dump_dest = D:\oracle\admin\h090520\cdump
sort_area_size = 524288
db_name = H090520
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri May 22 12:11:13 2009
/* OracleOEM */ ALTER DATABASE MOUNT
Fri May 22 12:11:17 2009
Successful mount of redo thread 1, with mount id 1927769569.
Fri May 22 12:11:17 2009
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Fri May 22 12:11:17 2009
/* OracleOEM */ ALTER DATABASE OPEN
Fri May 22 12:11:17 2009
Beginning crash recovery of 1 threads
Fri May 22 12:11:17 2009
Started first pass scan
Fri May 22 12:11:18 2009
Completed first pass scan
29196 redo blocks read, 292 data blocks need recovery
Fri May 22 12:11:18 2009
Started recovery at
Thread 1: logseq 21, block 149942, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 21 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\H090520\REDO02.LOG
Fri May 22 12:11:19 2009
Ended recovery at
Thread 1: logseq 21, block 179138, scn 0.3289046
292 data blocks read, 292 data blocks written, 29196 redo blocks read
Crash recovery completed successfully
Fri May 22 12:11:19 2009
Thread 1 advanced to log sequence 22
Thread 1 opened at log sequence 22
Current log# 3 seq# 22 mem# 0: D:\ORACLE\ORADATA\H090520\REDO03.LOG
Successful open of redo thread 1.
Fri May 22 12:11:19 2009
SMON: enabling cache recovery
Fri May 22 12:11:19 2009
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.
Fri May 22 12:11:19 2009
SMON: enabling tx recovery
Fri May 22 12:11:19 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN
Dump file d:\oracle\admin\h090520\bdump\alert_h090520.log
Fri May 22 15:03:38 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Fri May 22 15:03:38 2009
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 = 150
timed_statistics = TRUE
shared_pool_size = 50331648
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\h090520\CONTROL01.CTL, D:\oracle\oradata\h090520\CONTROL02.CTL, D:\oracle\oradata\h090520\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = h090520
dispatchers = (PROTOCOL=TCP) (SERVICE=h090520XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\h090520\bdump
user_dump_dest = D:\oracle\admin\h090520\udump
core_dump_dest = D:\oracle\admin\h090520\cdump
sort_area_size = 524288
db_name = H090520
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Fri May 22 15:03:41 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri May 22 15:03:42 2009
/* OracleOEM */ ALTER DATABASE MOUNT
Fri May 22 15:03:46 2009
Successful mount of redo thread 1, with mount id 1927898958.
Fri May 22 15:03:46 2009
Database mounted in Exclusive Mode.
Completed: /* OracleOEM */ ALTER DATABASE MOUNT
Fri May 22 15:03:46 2009
/* OracleOEM */ ALTER DATABASE OPEN
Fri May 22 15:03:46 2009
Beginning crash recovery of 1 threads
Fri May 22 15:03:46 2009
Started first pass scan
Fri May 22 15:03:46 2009
Completed first pass scan
25116 redo blocks read, 267 data blocks need recovery
Fri May 22 15:03:46 2009
Started recovery at
Thread 1: logseq 22, block 43187, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 22 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\H090520\REDO03.LOG
Fri May 22 15:03:47 2009
Ended recovery at
Thread 1: logseq 22, block 68303, scn 0.3372905
267 data blocks read, 267 data blocks written, 25116 redo blocks read
Crash recovery completed successfully
Fri May 22 15:03:48 2009
Thread 1 advanced to log sequence 23
Thread 1 opened at log sequence 23
Current log# 1 seq# 23 mem# 0: D:\ORACLE\ORADATA\H090520\REDO01.LOG
Successful open of redo thread 1.
Fri May 22 15:03:48 2009
SMON: enabling cache recovery
Fri May 22 15:03:48 2009
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.
Fri May 22 15:03:48 2009
SMON: enabling tx recovery
Fri May 22 15:03:48 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: /* OracleOEM */ ALTER DATABASE OPEN