oracle 90,请教,为什么我的oracle进程始终占用90%cpu的时间?

*************************

alert log 中存在错误信息,不过不能理解。

Errors in file /oracle/app/oracle/admin/ora8/udump/ora_26310.trc:

ORA-00600: internal error code, arguments: [521], [0], [], [], [], [], [], []

*************************

Mon Oct  1 11:44:45 2001

Thread 1 advanced to log sequence 44802

Current log# 3 seq# 44802 mem# 0: /oracle/oradata/ora8/redoora803.log

Mon Oct  1 22:10:57 2001

Starting ORACLE instance (normal)

Mon Oct  1 22:11:37 2001

Shutting down instance (immediate)

License high water mark = 30

Mon Oct  1 22:12:26 2001

Starting ORACLE instance (normal)

Mon Oct  1 22:12:41 2001

ALTER DATABASE CLOSE NORMAL

Mon Oct  1 22:12:41 2001

SMON: disabling tx recovery

SMON: disabling cache recovery

Mon Oct  1 22:12:42 2001

Thread 1 closed at log sequence 44802

Mon Oct  1 22:12:42 2001

Completed: ALTER DATABASE CLOSE NORMAL

Mon Oct  1 22:12:42 2001

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

Mon Oct  1 22:12:53 2001

Errors in file /oracle/app/oracle/admin/ora8/udump/ora_26310.trc:

ORA-00600: internal error code, arguments: [521], [0], [], [], [], [], [], []

Mon Oct  1 22:13:07 2001

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

LICENSE_MAX_USERS = 0

Starting up ORACLE RDBMS Version: 8.0.4.3.0.

System parameters with non-default values:

processes                = 100

shared_pool_size         = 50000000

nls_date_format          = yyyy/mm/dd

control_files            = /oracle/oradata/ora8/control01.ctl, /oracle/oradata/ora8/control02.ctl, /oracle/oradata/ora8/control03.ctl

db_block_buffers         = 25000

db_block_size            = 4096

log_archive_start        = TRUE

log_archive_dest         = /u02/archive/

log_archive_format       = arch_%s.arc

log_buffer               = 8192

log_checkpoint_interval  = 1000000

db_files                 = 80

db_file_multiblock_read_count= 8

dml_locks                = 100

rollback_segments        = r01, r02, r03, r04

sequence_cache_entries   = 30

sequence_cache_hash_buckets= 10

global_names             = TRUE

db_name                  = ora8

open_cursors             = 200

ifile                    = /oracle/app/oracle/admin/ora8/pfile/configora8.ora

background_dump_dest     = /oracle/app/oracle/admin/ora8/bdump

user_dump_dest           = /oracle/app/oracle/admin/ora8/udump

max_dump_file_size       = 10240

core_dump_dest           = /oracle/app/oracle/admin/ora8/cdump

PMON started with pid=2

DBW0 started with pid=3

ARCH started with pid=4

LGWR started with pid=5

CKPT started with pid=6

SMON started with pid=7

RECO started with pid=8

Mon Oct  1 22:13:10 2001

alter database  mount

Mon Oct  1 22:13:10 2001

Successful mount of redo thread 1.

Mon Oct  1 22:13:10 2001

Completed: alter database  mount

Mon Oct  1 22:13:10 2001

alter database open

Mon Oct  1 22:13:11 2001

Thread 1 opened at log sequence 44802

Current log# 3 seq# 44802 mem# 0: /oracle/oradata/ora8/redoora803.log

Successful open of redo thread 1.

Mon Oct  1 22:13:11 2001

SMON: enabling cache recovery

SMON: enabling tx recovery

Mon Oct  1 22:13:13 2001

Completed: alter database open

Shutting down instance (immediate)

License high water mark = 1

Mon Oct  1 22:13:54 2001

ALTER DATABASE CLOSE NORMAL

Mon Oct  1 22:13:54 2001

SMON: disabling tx recovery

SMON: disabling cache recovery

Mon Oct  1 22:13:55 2001

Thread 1 closed at log sequence 44802

Mon Oct  1 22:13:56 2001

Completed: ALTER DATABASE CLOSE NORMAL

Mon Oct  1 22:13:56 2001

ALTER DATABASE DISMOUNT

Completed: ALTER DATABASE DISMOUNT

Tue Oct  2 04:25:10 2001

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

LICENSE_MAX_USERS = 0

Starting up ORACLE RDBMS Version: 8.0.4.3.0.

System parameters with non-default values:

processes                = 100

shared_pool_size         = 50000000

nls_date_format          = yyyy/mm/dd

control_files            = /oracle/oradata/ora8/control01.ctl, /oracle/oradata/ora8/control02.ctl, /oracle/oradata/ora8/control03.ctl

db_block_buffers         = 25000

db_block_size            = 4096

log_archive_start        = TRUE

log_archive_dest         = /u02/archive/

log_archive_format       = arch_%s.arc

log_buffer               = 8192

log_checkpoint_interval  = 1000000

db_files                 = 80

db_file_multiblock_read_count= 8

dml_locks                = 100

rollback_segments        = r01, r02, r03, r04

sequence_cache_entries   = 30

sequence_cache_hash_buckets= 10

global_names             = TRUE

db_name                  = ora8

open_cursors             = 200

ifile                    = /oracle/app/oracle/admin/ora8/pfile/configora8.ora

background_dump_dest     = /oracle/app/oracle/admin/ora8/bdump

user_dump_dest           = /oracle/app/oracle/admin/ora8/udump

max_dump_file_size       = 10240

core_dump_dest           = /oracle/app/oracle/admin/ora8/cdump

PMON started with pid=2

DBW0 started with pid=3

ARCH started with pid=4

LGWR started with pid=5

CKPT started with pid=6

SMON started with pid=7

RECO started with pid=8

Tue Oct  2 04:25:12 2001

alter database  mount

Tue Oct  2 04:25:13 2001

Successful mount of redo thread 1.

Tue Oct  2 04:25:13 2001

Completed: alter database  mount

Tue Oct  2 04:25:13 2001

alter database open

Tue Oct  2 04:25:14 2001

Thread 1 opened at log sequence 44802

Current log# 3 seq# 44802 mem# 0: /oracle/oradata/ora8/redoora803.log

Successful open of redo thread 1.

Tue Oct  2 04:25:14 2001

SMON: enabling cache recovery

SMON: enabling tx recovery

Tue Oct  2 04:25:16 2001

Completed: alter database open

Tue Oct  2 10:49:48 2001

Thread 1 advanced to log sequence 44803

Current log# 1 seq# 44803 mem# 0: /oracle/oradata/ora8/redoora801.log

Tue Oct  2 20:07:23 2001

Thread 1 advanced to log sequence 44804

Current log# 2 seq# 44804 mem# 0: /oracle/oradata/ora8/redoora802.log

Wed Oct  3 12:08:42 2001

Thread 1 advanced to log sequence 44805

Current log# 3 seq# 44805 mem# 0: /oracle/oradata/ora8/redoora803.log

Wed Oct  3 13:13:19 2001

Thread 1 advanced to log sequence 44806

Current log# 1 seq# 44806 mem# 0: /oracle/oradata/ora8/redoora801.log

Wed Oct  3 13:46:07 2001

Thread 1 advanced to log sequence 44807

Current log# 2 seq# 44807 mem# 0: /oracle/oradata/ora8/redoora802.log

Wed Oct  3 14:12:33 2001

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值