http://www.sql.ru/forum/377566/vopros-pro-shutdown-abort
ora-600 [16513] [1403] [20]
SQL > Select count (*) from $ obj;
COUNT (*)
----------
6296
SQL > delete from $ obj;
6296 rows deleted.
SQL > shutdown abort
ORACLE instance shut down.
SQL > Startup;
ORACLE instance started.
Total System Global Area 135760720 bytes
Fixed Size 731984 bytes
Variable Size 104857600 bytes
Database Buffers 29360128 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA- 01092 : ORACLE instance terminated. Disconnection forced
after all objects are created from the bootstrap $, when the first call
=====================
PARSING IN CURSOR # 5 len = 52 dep = 1 uid = 0 oct = 3 lid = 0 tim = 2701521679320 hv = 782031521 ad = '84756cb8 '
Select ctime, mtime, stime from obj $ where obj # =: 1
END OF STMT
PARSE # 5 : c = 0 , e = 966 , p = 0 , cr = 0 , cu = 0 , mis = 1 , r = 0 , dep = 1 , og = 0 , tim = 2701521679306
BINDS # 5 :
bind 0 : dty = 2 mxl = 22 ( 22 ) mal = 00 scl = 00 pre = 00 oacflg = 08 oacfl2 = 1 Size = 24 offset = 0
bfp = ffffffff7cc6a138 bln = 22 avl = 02 flg = 05
value = 4
EXEC # 5 : c = 10000 , e = 1,340 , p = 0 , cr = 0 , cu = 0 , mis = 0 , r = 0 , dep = 1 , og = 4 , tim = 2701521681024
WAIT # 5 : Nam = 'file db Sequential Read ' ela = 109 p1 = 1 p2 = 94 p3 = 1
WAIT # 5 : Nam = 'db file Sequential Read' ela = 78 p1 = 1 p2 = 1291 p3 = 1
Begin Cleaning out Block ...
Block header dump: 0x0040050b
Object ID on Block? Y
seg / obj: 0x24 csc: 0x00. 2452 itc: 2 flg: O typ: 2 - INDEX
fsl: 2 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn / Fsc
0x01 0x000a.00a. 00000004 0x008000ba. 0002 . 01 CB - 0 SCN 0x0000.000021c0
0x02 0x0002. 013 . 00000378 0x00800025. 0075 .0 F ---- 298 fsc 0x0fd9.00000000
- Poskipal -
----- End of leaf dump Block -----
Found All committed transactions
- Poskipal
Block cleanout Record , SCN: 0x0000.001b3c72 ver: opt 0x01: 0x01, entries follow ...
itli: 2 flg: 2 scn: 0x0000. 00000001
Block header dump: 0x0040050b
Object ID on Block? Y
seg / obj: 0x24 csc: 0x00.1b3c72 itc: 2 flg: O typ: 2 - INDEX
fsl: 0 fnx: 0x0 ver: 0x01
Itl Xid Uba Flag Lck Scn / Fsc
0x01 0x000a.00a. 00000004 0x008000ba. 0002 . 01 CB - 0 SCN 0x0000.000021c0
0x02 0x0002. 013 . 00000378 0x00800025. 0075 .0 F C --- 0 scn 0x0000.00000001
- T. E he just commits, no checks, as a result of
... clean out dump
Internal or Fatal error
ORA- 00600 : internal error code, arguments: [ 16513 ], [ 1403 ], [ 4 ], [], [], [], []
- Ora1403 - no data found
No comments:
Post a Comment