database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
Firebird
ㆍOracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Oracle Q&A 39637 게시물 읽기
No. 39637
DB속도가 느려지고 ALRT LOG에 이렇게 자꾸보이네요 도와주세요
작성자
말하자
작성일
2012-09-12 10:33ⓒ
2012-09-12 14:13ⓜ
조회수
4,978

ORACLE 8.1.7

 

Wed Sep 12 10:18:10 2012
Timed out trying to start shared server S001.
Wed Sep 12 10:22:14 2012
Performance statistics empty: data overflow
Wed Sep 12 10:29:21 2012
Errors in file c:\oracle\admin\orcl\udump\orclS001.TRC:
ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28757], [], [], [], [], [], []
 

Dump file c:\oracle\admin\orcl\bdump\orclALRT.LOG
Wed Sep 12 13:50:29 2012
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
  processes                = 400
  shared_pool_size         = 126629580
  large_pool_size          = 41943040
  java_pool_size           = 20971520
  control_files            = e:\oracle\orcl\ctrl\control01.ctl, e:\oracle\orcl\ctrl\control02.ctl, e:\oracle\orcl\ctrl\control03.ctl
  db_block_buffers         = 46213
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  distributed_transactions = 40
  instance_name            = ORCL
  service_names            = orcl
  mts_dispatchers          = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer), (protocol=TCP)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = orcl
  open_cursors             = 300
  os_authent_prefix        =
  job_queue_processes      = 4
  job_queue_interval       = 60
  parallel_max_servers     = 4
  background_dump_dest     = c:\oracle\admin\orcl\bdump
  user_dump_dest           = c:\oracle\admin\orcl\udump
  max_dump_file_size       = 10240
  oracle_trace_collection_name=
Obsolete system parameters with specified values:
  distributed_lock_timeout
End of obsolete system parameter listing
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Sep 12 13:50:33 2012
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Sep 12 13:50:34 2012
alter database mount exclusive
Wed Sep 12 13:50:41 2012
Successful mount of redo thread 1, with mount id 1321602225.
Wed Sep 12 13:50:41 2012
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Wed Sep 12 13:50:41 2012
alter database open
Beginning crash recovery of 1 threads
Wed Sep 12 13:50:41 2012
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 3 Seq 134538 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\ORCL\REDOLOG\REDO03.LOG
Wed Sep 12 13:50:44 2012
Thread recovery: finish rolling forward thread 1
Thread recovery: 1366 data blocks read, 1199 data blocks written, 9984 redo blocks read
Crash recovery completed successfully
Wed Sep 12 13:50:45 2012
Thread 1 advanced to log sequence 134539
Thread 1 opened at log sequence 134539
  Current log# 1 seq# 134539 mem# 0: D:\ORACLE\ORCL\REDOLOG\REDO01.LOG
Successful open of redo thread 1.
Wed Sep 12 13:50:45 2012
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Sep 12 13:51:10 2012
Completed: alter database open
Wed Sep 12 14:00:16 2012
found dead multi-threaded server 'S001', pid = (15, 5)
Wed Sep 12 14:00:53 2012
found dead multi-threaded server 'S000', pid = (12, 2)

 

[Top]
No.
제목
작성자
작성일
조회
39640결과값을 다음행의 시작값으로 [1]
shitline
2012-09-14
4551
39639DOL님 다시 한번 도움을 요청합니다. [1]
논어
2012-09-13
4340
39638카운터 구할때.. [3]
궁금
2012-09-13
4523
39637DB속도가 느려지고 ALRT LOG에 이렇게 자꾸보이네요 도와주세요
말하자
2012-09-12
4978
39636한 row로 select하기 도와주세요 ㅠㅠ [1]
알티
2012-09-11
4613
39635주(week) 혹은 기간단위로 between 하기 [3]
김홍찬
2012-09-11
4456
39634distinct ? Group by ? .. 근무시작일과 근무종료일을 합칠경우. [1]
EJ
2012-09-11
4817
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.020초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다