查询V$latch遇到ORA-07445错误

www.wwf.co · 发表于 2005-1-10 21:19

好象trc扩展名的附件不能上传！我把文件后缀名改成txt，再次上传！

www.wwf.co · 发表于 2005-1-10 21:25

换没有没有上传成功，不知怎么的！我就贴一些片段，整个文件有2m多一些。
/ora/app/oracle/admin/oracle/udump/oracle_ora_41206.trc
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
ORACLE_HOME = /ora/app/oracle/product/9.2.0
System name: AIX
Node name: its_data
Release: 1
Version: 5
Machine: 005D0C0F4C00
Instance name: oracle
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 41206, image: oracle@its_data (TNS V1-V3)

*** SESSION ID

42.248) 2005-01-10 20:53:20.345
*** 2005-01-10 20:53:20.345
Exception signal: 11 0x100047b50 (lnxmin+0188) a1230000
Registers:
iar: 0000000100047b50, msr: 800000000000d0b2
lr: 00000001025a1a58,  cr: 0000000024422484
r00: 0000000000000000, r01: 0fffffffffff9a70, r02: 0000000110219448,
r03: 00000063ffffffa0, r04: 00000001027e6ce0, r05: 0000000000000001,
r06: 000000011057ab38, r07: 0fffffffffff9b20, r08: 0000000102987e50,
r09: 0000006400000064, r10: 0000000000000000, r11: 0000000000000000,
r12: 0000000000000000, r13: 0000000110465970, r14: 00000001100b4ca8,
r15: 00000001100b4ca0, r16: 000000011057a8d0, r17: 000000011057a8b0,
r18: 0000000000000008, r19: 0000000000000080, r20: 0000000000000002,
r21: 000000011057a490, r22: 0000000000000100, r23: 0000000000000001,
r24: 000000011057afa8, r25: 0000000000000004, r26: 000000011057b140,
r27: 000000011057afb0, r28: 0000000000000000, r29: 0000000000000001,
r30: 0000000000000000, r31: 0000000102e31748,
----- Call Stack Trace -----
calling             call    entry             argument values in hex
location          type    point             (? means dubious value)
-------------------- -------- -------------------- ----------------------------
lnxmin+01a4       ?       00000000
qerfxFetch+0fec    bl    qerfxGCol          4000000000004 ? 63FFFFFF94 ?
                                                11057B620 ? 7000000369F3640 ?
                                                102DAFF08 ? 102987E50 ?
qergsFetch+02e0    bl    01FD7B90
qervwFetch+008c    bl    01FD7B90
rwsfcd+0060       bl    _ptrgl
qerjoFetch+037c    bl    _ptrgl

www.wwf.co · 发表于 2005-1-10 21:26

*** 2005-01-10 20:53:20.417
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [] [] [] [] [] []
Current SQL statement for this session:
select latch#, name, gets, misses from v$latch
----- Call Stack Trace -----
calling             call    entry             argument values in hex
location          type    point             (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+0148       bl    ksedst             1027ED414 ?
ssexhd+0288       bl    01FD8038
00004CCC          ?       00000000

--------------------- Binary Stack Dump ---------------------

========== FRAME [1] (ksedmp+0148 -> ksedst) ==========
Dump of memory from 0x0FFFFFFFFFFF8FF0 to 0x0FFFFFFFFFFF93A0
FFFFFFFFFFF8FF0 0FFFFFFF FFFF93A0 24404828 00000000  [........$@H(....]
FFFFFFFFFFF9000 00000001 000B6058 00000000 05F91278  [......`X.......x]
FFFFFFFFFFF9010 08000000 00000001 00000000 00000000  [................]
FFFFFFFFFFF9020 00000001 027ED414 00000021 F8C74B00  [.....~.....!..K.]
FFFFFFFFFFF9030 00000000 41E27AC0 0121962B 357ABD05  [....A.z..!.+5z..]
FFFFFFFFFFF9040 0F570884 E5443A10 024D70E7 B7E5DC3C  [.W...D:..Mp....<]
FFFFFFFFFFF9050 12E0BE82 6D694B2F 00000000 00000000  [....miK/........]
FFFFFFFFFFF9060 00000001 FFFF90E0 00000000 00000000  [................]

www.wwf.co · 发表于 2005-1-10 21:28

===================================================
Files currently opened by this process:
===================================================
PROCESS STATE
-------------
Process global information:
   process: 7000000316b9940, call: 7000000318c7b40, xact: 0, curses: 700000031770b68, usrses: 700000031770b68
  ----------------------------------------
  SO: 7000000316b9940, type: 2, owner: 0, flag: INIT/-/-/0x00
  (process) Oracle pid=22, calls cur/top: 7000000318c7b40/7000000318c7b40, flag: (0) -
         int error: 0, call error: 0, sess error: 0, txn error 0
  (post info) last post received: 0 0 0
            last post received-location: No post
            last process to post me: none
            last post sent: 0 0 0
            last post sent-location: No post
            last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000003174efa0
O/S info: user: oracle, term: pts/0, ospid: 41206
OSD pid info: Unix process pid: 41206, image: oracle@its_data (TNS V1-V3)
----------------------------------------
SO: 700000031770b68, type: 4, owner: 7000000316b9940, flag: INIT/-/-/0x00
(session) trans: 0, creator: 7000000316b9940, flag: (41) USR/- BSY/-/-/-/-/-
            DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
            txn branch: 0
            oct: 3, prv: 0, sql: 70000003544fd30, psql: 70000003544fd30, user: 0/SYS
O/S info: user: oracle, term: pts/0, ospid: 53522, machine: its_data
            program: sqlplus@its_data (TNS V1-V3)
application name: sqlplus@its_data (TNS V1-V3), hash value=0
last wait for 'SQL*Net message to client' blocking sess=0x0 seq=54 wait_time=5
            driver id=62657100, #bytes=1, =0
temporary object counter: 0
   ----------------------------------------
   SO: 700000033747370, type: 52, owner: 700000031770b68, flag: INIT/-/-/0x00
   LIBRARY OBJECT PIN: pin=700000033747370 handle=70000003c6623b0 mode=S lock=700000033745fb0
   user=700000031770b68 session=700000031770b68 count=1 mask=0041 savepoint=115 flags=[00]
   ----------------------------------------
   SO: 700000033745fb0, type: 51, owner: 700000031770b68, flag: INIT/-/-/0x00
   LIBRARY OBJECT LOCK: lock=700000033745fb0 handle=70000003c6623b0 mode=N
   call pin=0 session pin=700000033747370
   htl=700000033746020[70000003650bff0,70000003650bff0] htb=70000003650bff0
   user=700000031770b68 session=700000031770b68 count=1 flags=PNS/[08] savepoint=115
   LIBRARY OBJECT HANDLE: handle=70000003c6623b0
   namespace=CRSR flags=RON/KGHP/PN0/[10010000]
   kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch#=1
   lwt=70000003c6623e0[70000003c6623e0,70000003c6623e0] ltm=70000003c6623f0[70000003c6623f0,70000003c6623f0]
   pwt=70000003c662410[70000003c662410,70000003c662410] ptm=70000003c6624a0[70000003c6624a0,70000003c6624a0]
   ref=70000003c6623c0[7000000353904f8, 7000000353904f8] lnd=70000003c6624b8[70000003c6624b8,70000003c6624b8]
      LIBRARY OBJECT: object=700000038dfd2b8
      type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
      DEPENDENCIES: count=4 size=16
      ACCESSES: count=1 size=16
      TRANSLATIONS: count=1 size=16
      DATA BLOCKS:
      data#    heap  pointer status pins change
      ----- -------- -------- ------ ---- ------
         0 700000038dfd598 7000000353b9b88 I/P/A    0 NONE
         6 700000038dfd3d8 7000000353b9680 I/P/A    1 NONE
   ----------------------------------------
   SO: 70000003bd5c290, type: 51, owner: 700000031770b68, flag: INIT/-/-/0x00
   LIBRARY OBJECT LOCK: lock=70000003bd5c290 handle=70000003544fd30 mode=N

www.wwf.co · 发表于 2005-1-10 21:29

******************** Cursor Dump ************************
Current cursor: 1, pgadep: 0
pgactx: 7000000353b9680 ctxcbk: 0 ctxqbc: 0 ctxrws: 7000000369f3e70
Explain plan:
Plan Table
--------
-------------------------------------------------------------------------------------------------------------------------
| Operation                   | Name             | Rows  | Bytes | Cost  |  TQ  |IN-OUT| PQ Distrib |Pstart| Pstop |
-------------------------------------------------------------------------------------------------------------------------
| SELECT STATEMENT             |                   |    0 |    0 |    0 |    |    |          |    |    |
|  MERGE JOIN                   |                   |    0 |    0 |    0 |    |    |          |    |    |
| VIEW                      |                   |    0 |    0 |    0 |    |    |          |    |    |
| SORT GROUP BY             |                   |    0 |    0 |    0 |    |    |          |    |    |
|    FIXED TABLE FULL          | X$KSLLT          |    0 |    0 |    0 |    |    |          |    |    |
| SORT JOIN                   |                   |    0 |    0 |    0 |    |    |          |    |    |
| FIXED TABLE FULL          | X$KSLLD          |    0 |    0 |    0 |    |    |          |    |    |
-------------------------------------------------------------------------------------------------------------------------
Cursor Dump:
----------------------------------------
Cursor 1 (110570340): CURFETCH  curiob: 11057ba10
curflg: 4e curpar: 0 curusr: 0 curses 700000031770b68
cursor name: select latch#, name, gets, misses from v$latch
child pin: 700000033747370, child lock: 700000033745fb0, parent lock: 70000003bd5c290
xscflg: 80100074, parent handle: 70000003544fd30, xscfl2: 4200409
  nxt: 5.0x00000008  nxt: 4.0x00000760  nxt: 3.0x00000460  nxt: 2.0x00000688
  nxt: 1.0x000007d0
Cursor frame allocation dump:
frm: -------- Comment --------  Size  Seg Off
whp size: 45976/49952
Dump of CURRENT WORK HEAP:
******************************************************
HEAP DUMP heap name="cursor work he"  desc=110573d78
extent sz=0x1068 alt=32767 het=32767 rec=0 flg=2 opc=2
parent=110594290 owner=0 nex=0 xsz=0x2068
EXTENT 0 addr=110587e10
  Chunk       110587e20 sz=    8280 freeable  "sort subheap "  ds=110579820
110587E20 10B38F00 00002059 00000000 00000000  [...... Y........]
110587E30 00000001 10573D78 00000001 10579820  [.....W=x.....W. ]
110587E40 00000001 10589EB8 50B38F00 00002031  [.....X..P..... 1]
110587E50 00000000 00000000 00000001 10589EC8  [.............X..]
110587E60 00002020 00000000 00560000 00000000  [..  .....V......]
110587E70 00000000 00000000 0003C203 0CFF0180  [................]

www.wwf.co · 发表于 2005-1-10 21:37

另外，按照wyq21973的说法，我导出sys用户下的内容，出错了：
如下：

C:\>exp

Export: Release 9.2.0.1.0 - Production on 星期一 1月 10 15:53:08 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

用户名: sys/wangweifeng@oracle as sysdba

连接到: Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
输入数组提取缓冲区大小: 4096 >

导出文件: EXPDAT.DMP> c:\sys_aix.dmp

(1)E(完整的数据库)，(2)U(用户) 或 (3)T(表): (2)U >

导出权限 (yes/no): yes >

导出表数据 (yes/no): yes >

压缩区 (yes/no): yes >

已导出 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集

即将导出指定的用户...
要导出的用户: (RETURN 以退出) > sys

要导出的用户: (RETURN 以退出) >

. 正在导出 pre-schema 过程对象和操作
. 正在导出用户 SYS 的外部函数库名称
. 导出 PUBLIC 类型同义词
. 导出私有类型同义词
. 正在导出用户 SYS 的对象类型定义
即将导出 SYS 的对象 ...
. 正在导出数据库链接
. 正在导出序号
. 正在导出群集定义
EXP-00056: 遇到 ORACLE 错误 3127
ORA-03127: 在活动操作结束之前不允许进行新的操作
EXP-00056: 遇到 ORACLE 错误 3127
ORA-03127: 在活动操作结束之前不允许进行新的操作
EXP-00000: 导出终止失败