Private_strands 7 at log switch 很多
数据库操作非常缓慢，无法更新大量数据，导入导出操错Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228421
Current log# 1 seq# 1228421 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228422
Current log# 2 seq# 1228422 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228423
Current log# 3 seq# 1228423 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228424
Current log# 1 seq# 1228424 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 04:56:56 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228425
Current log# 2 seq# 1228425 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 05:10:16 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228426
Current log# 3 seq# 1228426 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228427
Current log# 1 seq# 1228427 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 05:38:20 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228428
Current log# 2 seq# 1228428 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 05:38:43 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228429
Current log# 3 seq# 1228429 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 05:48:47 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228430
Current log# 1 seq# 1228430 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 06:07:02 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228431
Current log# 2 seq# 1228431 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 06:51:44 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228432
Current log# 3 seq# 1228432 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 08:49:40 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228433
Current log# 1 seq# 1228433 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 10:54:31 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228434
Current log# 2 seq# 1228434 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 11:37:04 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228435
Current log# 3 seq# 1228435 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 11:38:38 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228436
Current log# 1 seq# 1228436 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 11:39:17 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228437
Current log# 2 seq# 1228437 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 11:40:31 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228438
Current log# 3 seq# 1228438 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 12:36:47 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228439
Current log# 1 seq# 1228439 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 13:38:24 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228440
Current log# 2 seq# 1228440 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 13:39:38 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228441
Current log# 3 seq# 1228441 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 13:42:47 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228442
Current log# 1 seq# 1228442 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 13:44:57 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228443
Current log# 2 seq# 1228443 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 14:39:18 2008
Errors in file /databases/app/oracle/admin/r2gdb/bdump/r2gdb_s000_2251.trc:
ORA-00942: table or view does not exist
Tue Mar 11 15:00:25 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228444
Current log# 3 seq# 1228444 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 15:49:27 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228445
Current log# 1 seq# 1228445 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 15:49:53 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228446
Current log# 2 seq# 1228446 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 15:50:11 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228447
Current log# 3 seq# 1228447 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 15:50:33 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228448
Current log# 1 seq# 1228448 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 16:00:50 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228449
Current log# 2 seq# 1228449 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 16:01:48 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228450
Current log# 3 seq# 1228450 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 16:02:22 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228451
Current log# 1 seq# 1228451 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 16:03:03 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228452
Current log# 2 seq# 1228452 mem# 0: /databases/app/oracle/oradata/r2gdb/redo02.log
Tue Mar 11 16:08:17 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228453
Current log# 3 seq# 1228453 mem# 0: /databases/app/oracle/oradata/r2gdb/redo03.log
Tue Mar 11 16:09:22 2008
Private_strands 7 at log switch
Thread 1 advanced to log sequence 1228454
Current log# 1 seq# 1228454 mem# 0: /databases/app/oracle/oradata/r2gdb/redo01.log
Tue Mar 11 16:10:16 2008
很多，请问啥原因，怎解决
谢谢
[[i] 本帖最后由 noahsark 于 2008-3-17 13:34 编辑 [/i]] 这么高深，应该不是数据库管理员能解决的吧！找一下系统管理员！
页:
[1]