Enrique Gomez Esteban
asked on
Oracle instance - Windows 2003 server and 10.2.0.5 terminating whith ORA-27070 erros
The following errors appear when running backups and Oracle instance must be restarted:
Wed Nov 15 03:08:01 Hora estándar romance 2017
Thread 1 advanced to log sequence 10606 (LGWR switch)
Current log# 4 seq# 10606 mem# 0: K:\SORANA1\SORANA1\REDO04. LOG
Wed Nov 15 04:00:03 Hora estándar romance 2017
Errors in file k:\sorana1\admin\sorana1\b dump\soran a1_lgwr_25 960.trc:
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04 .LOG'
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
Wed Nov 15 04:00:03 Hora estándar romance 2017
Errors in file k:\sorana1\admin\sorana1\b dump\soran a1_lgwr_25 960.trc:
ORA-00340: IO error processing online log 4 of thread 1
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04 .LOG'
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
Wed Nov 15 04:00:03 Hora estándar romance 2017
LGWR: terminating instance due to error 340
Instance terminated by LGWR, pid = 25960
Wed Nov 15 06:44:02 Hora estándar romance 2017
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Wed Nov 15 06:44:02 Hora estándar romance 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
Any suggestion about this error?
Wed Nov 15 03:08:01 Hora estándar romance 2017
Thread 1 advanced to log sequence 10606 (LGWR switch)
Current log# 4 seq# 10606 mem# 0: K:\SORANA1\SORANA1\REDO04.
Wed Nov 15 04:00:03 Hora estándar romance 2017
Errors in file k:\sorana1\admin\sorana1\b
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
Wed Nov 15 04:00:03 Hora estándar romance 2017
Errors in file k:\sorana1\admin\sorana1\b
ORA-00340: IO error processing online log 4 of thread 1
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
Wed Nov 15 04:00:03 Hora estándar romance 2017
LGWR: terminating instance due to error 340
Instance terminated by LGWR, pid = 25960
Wed Nov 15 06:44:02 Hora estándar romance 2017
Adjusting the default value of parameter parallel_max_servers
from 160 to 135 due to the value of parameter processes (150)
Wed Nov 15 06:44:02 Hora estándar romance 2017
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
Any suggestion about this error?
your file 'K:\SORANA1\SORANA1\REDO04 .LOG' has gone missing
is the disk K: still available ?
is the disk K: still available ?
ASKER
Yes.
Oracle did the startup normally.
Oracle did the startup normally.
ASKER
Dump file k:\sorana1\admin\sorana1\b dump\soran a1_lgwr_25 960.trc
Wed Nov 15 02:41:17 2017
ORACLE V10.2.0.5.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 586, 8 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:17093M/18431M, Ph+PgF:20737M/22351M, VA:1182M/2047M
Instance name: sorana1
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 25960, image: ORACLE.EXE (LGWR)
*** 2017-11-15 02:41:17.095
*** SERVICE NAME:() 2017-11-15 02:41:16.939
*** SESSION ID:(166.1) 2017-11-15 02:41:16.939
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
*** 2017-11-15 04:00:02.376
ksedmp: internal or fatal error
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04 .LOG'
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
check trace file c:\oracle\product\10.2.0\d b_1\rdbms\ trace\sora na1_ora_0. trc for preloading .sym file messages
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- -------------------------- --
_ksedst+38 CALLrel _ksedst1+0 0 1
_ksedmp+898 CALLrel _ksedst+0 0
_kcrfwcint+942 CALLrel _ksedmp+0
_kcrfw_post+389 CALLrel _kcrfwcint+0 7750F68
_kcrfw_redo_write+5 CALLrel _kcrfw_post+0 0 0
743
_ksbcti+652 CALLreg 00000000 0 0
_ksbabs+666 CALLrel _ksbcti+0
_ksbrdp+923 CALLreg 00000000 40E0A20
_opirip+674 CALLrel _ksbrdp+0
_opidrv+857 CALLrel _opirip+0 32 4 76DFEA8
_sou2o+45 CALLrel _opidrv+0 32 4 76DFEA8
_opimai_real+227 CALLrel _sou2o+0 76DFE9C 32 4 76DFEA8
_opimai+92 CALLrel _opimai_real+0 3 76DFED4
_BackgroundThreadSt CALLrel _opimai+0
art@4+495
77E3484C CALLreg 00000000
--------------------- Binary Stack Dump ---------------------
========== FRAME [1] (_ksedst+38 -> _ksedst1+0) ==========
Dump of memory from 0x076DED28 to 0x076DED38
76DED20 076DED38 00404A0B [8.m..J@.]
76DED30 00000000 00000001 [........]
========== FRAME [2] (_ksedmp+898 -> _ksedst+0) ==========
Dump of memory from 0x076DED38 to 0x076DEDF8
76DED30 076DEDF8 004033EB [..m..3@.]
76DED40 00000000 00000000 00000000 00000002 [................]
76DED50 076DEDE4 00000000 00000000 00000000 [..m.............]
76DED60 076DED94 0425BFB1 07BC8940 07BC8A3C [..m...%.@...<...]
76DED70 07BC8940 00000000 00000000 00000000 [@...............]
76DED80 00000000 00000000 076DEDBC 0425BFB1 [..........m...%.]
76DED90 07BC8940 07BC8A3C 07752274 00000159 [@...<...t"u.Y...]
76DEDA0 00000000 00000000 00000000 00000000 [................]
76DEDB0 00000002 076DEDE4 00000001 00000000 [......m.........]
76DEDC0 00000000 00000000 00000000 00000000 [................]
76DEDD0 00000000 FFFFFF0C 07750F68 07BC8160 [........h.u.`...]
76DEDE0 076DED44 00000000 076DF4F4 02A728AC [D.m.......m..(..]
76DEDF0 035B4DF8 FFFFFFFF [.M[.....]
========== FRAME [3] (_kcrfwcint+942 -> _ksedmp+0) ==========
Dump of memory from 0x076DEDF8 to 0x076DF080
76DEDF0 076DF080 009D756B [..m.ku..]
76DEE00 00000002 FD0C0CD0 FD2548F0 F2BD6BD0 [.........H%..k..]
76DEE10 00000002 FD714901 F2BD6BE0 8082AEBF [.....Iq..k......]
76DEE20 FD714908 FD2548F0 FD2548B0 00000000 [.Iq..H%..H%.....]
76DEE30 FD0C0D14 FD0C0C01 F2BD6C3C 80821B39 [........<l..9...]
76DEE40 00000000 F2BD6C3C 80821B8B 80821B90 [....<l..........]
76DEE50 FD2548F0 FD0C0CD0 80A62530 FD0C0CD0 [.H%.....0%......]
76DEE60 F2BD6C50 FC707648 808B0B40 00000001 [Pl..Hvp.@.......]
76DEE70 FD714908 808B0B40 00000001 808B6101 [.Iq.@........a..]
76DEE80 F2BD6C38 80A64456 00000000 808B6101 [8l..VD.......a..]
76DEE90 F2BD6C7C 80A6256D 808942B3 808B0B40 [|l..m%...B..@...]
76DEEA0 808B0B64 0000003D F2BD6C80 F2BD6C84 [d...=....l...l..]
76DEEB0 808B0B01 FC707648 00000000 00000A0E [....Hvp.........]
76DEEC0 00000000 00000001 00000000 00000000 [................]
76DEED0 00000000 F2BD6CD4 00000000 FFFFFFFF [.....l..........]
76DEEE0 076DEF7C FD2548B0 00000001 808B6300 [|.m..H%......c..]
76DEEF0 F2BD6CA8 80A64400 00000000 00000306 [.l...D..........]
76DEF00 00000000 FD254A90 000001E8 B969D6B8 [.....J%.......i.]
76DEF10 0000000C F7557000 00000306 000007FF [.....pU.........]
76DEF20 00000000 20707249 000001E8 F2BD6CF0 [....Irp .....l..]
76DEF30 8081C59F 076DEF58 7C828246 7C826D09 [....X.m.F..|.m.|]
76DEF40 076DEFA4 77E11F41 77E11EFB 0771DFB0 [..m.A..w...w..q.]
76DEF50 00000000 FFFFFFFF 00000024 00000001 [........$.......]
76DEF60 00000000 00000000 00000070 FFFFFFFF [........p.......]
76DEF70 FFFFFFFF 77E11F09 77E11F41 00000000 [.......wA..w....]
76DEF80 80000000 000000C0 076DEF7C 076DEF4C [........|.m.L.m.]
76DEF90 07BC8160 076DEFA8 0419474B 0771DFB0 [`.....m.KG....q.]
76DEFA0 0771DFB0 00000001 07BC8160 007E22FA [..q.....`...."~.]
76DEFB0 076DEFBC 00000006 0771DFB0 00000004 [..m.......q.....]
76DEFC0 00000000 07BC8160 00000001 00000000 [....`...........]
76DEFD0 00000009 076DF00C 007DE7D1 00000010 [......m...}.....]
76DEFE0 00000000 077109C4 07BC87A0 0775476C [......q.....lGu.]
76DEFF0 07BC8160 00000000 00000010 FFFFFFFF [`...............]
76DF000 00000000 076DF048 0047B33F 00000008 [....H.m.?.G.....]
76DF010 00000006 0000006B 3637BA10 35F6BBDC [....k.....76...5]
76DF020 00000000 6E5207AE 35F6BBDC 00000000 [......Rn...5....]
76DF030 00000001 00000000 00000000 00000000 [................]
76DF040 00000000 00000000 00000002 00000001 [................]
76DF050 00000000 07750F68 077546C4 07BC8160 [....h.u..Fu.`...]
76DF060 07BCE308 00000000 FFFFFF0C 00000000 [................]
76DF070 FFFFFFFF 00000000 00000000 00000001 [................]
========== FRAME [4] (_kcrfw_post+389 -> _kcrfwcint+0) ==========
Dump of memory from 0x076DF080 to 0x076DF134
76DF080 076DF134 00AFB85E 07750F68 FA67B90E [4.m.^...h.u...g.]
76DF090 C6D750EB 0000001A FFFFFFF7 9E3B9800 [.P............;.]
76DF0A0 076DF0DC 040E0DFA 076DF0C4 7C82A98A [..m.......m....|]
76DF0B0 0000003C 9E3B9800 FFFFFFF7 040E0DFA [<.....;.........]
76DF0C0 00DBC338 07BC8160 00000000 00000000 [8...`...........]
76DF0D0 00000000 00000000 00000000 00000001 [................]
76DF0E0 3485AC20 00000000 00000000 35F6BBDC [ ..4...........5]
76DF0F0 07BC8160 00000098 07BC8160 00000000 [`.......`.......]
76DF100 00000002 077109C4 00000001 00000001 [......q.........]
76DF110 00000000 00000001 00000000 077546C4 [.............Fu.]
76DF120 00000100 35F6BBDC 00000002 35F6BBDC [.......5.......5]
76DF130 00000100 [....]
========== FRAME [5] (_kcrfw_redo_write+5743 -> _kcrfw_post+0) ==========
Dump of memory from 0x076DF134 to 0x076DF1D0
76DF130 076DF1D0 00AFAFEC 00000000 [..m.........]
76DF140 00000000 00000000 00000003 00000000 [................]
76DF150 0000012C 243B98AA 00000000 00000038 [,.....;$....8...]
76DF160 07BC8160 035E23A0 040E59F0 000000D0 [`....#^..Y......]
76DF170 00000210 00000078 00000001 000001F0 [....x...........]
76DF180 00000001 00000001 00000100 07750F68 [............h.u.]
76DF190 00000002 00000002 07BC8160 00001A98 [........`.......]
76DF1A0 00000001 00000000 00000002 00001A99 [................]
76DF1B0 00000000 34859888 34859780 3485AD84 [.......4...4...4]
76DF1C0 3939D442 00000000 000010C5 000010C4 [B.99............]
========== FRAME [6] (_ksbcti+652 -> 00000000) ==========
Dump of memory from 0x076DF1D0 to 0x076DF1F8
76DF1D0 076DF1F8 004A313A 00000000 00000000 [..m.:1J.........]
76DF1E0 07BC8160 0000012C 00000000 3585DAD0 [`...,..........5]
76DF1F0 FCA1DFE0 076DF2AC [......m.]
========== FRAME [7] (_ksbabs+666 -> _ksbcti+0) ==========
Dump of memory from 0x076DF1F8 to 0x076DF3D0
76DF1F0 076DF3D0 004A34F3 [..m..4J.]
76DF200 035E7F30 076DF2A4 00000001 358F7D50 [0.^...m.....P}.5]
76DF210 358F7D50 358F3E30 358F3E30 00000000 [P}.50>.50>.5....]
76DF220 359BB9C4 359BB9C4 0004000D 0000000C [...5...5........]
76DF230 00000000 0008000A 00000000 00000000 [................]
76DF240 00000000 00000000 00000000 5A0B9A70 [............p..Z]
76DF250 00000098 36260D10 36260D10 3625C510 [......&6..&6..%6]
76DF260 00000000 00000000 00000001 00000000 [................]
76DF270 00000000 00000000 00000000 524F5301 [.............SOR]
76DF280 31414E41 00000000 00000000 00000000 [ANA1............]
76DF290 00000000 00000000 00000000 00000007 [................]
76DF2A0 00000000 035E2020 035E23A0 035E23B0 [.... ^..#^..#^.]
76DF2B0 035E23C0 035E23D0 035E23E0 035E2AE0 [.#^..#^..#^..*^.]
76DF2C0 035E2AF0 035E2B00 00000000 00000000 [.*^..+^.........]
76DF2D0 00000000 00000000 00000000 FFFFFFFE [................]
76DF2E0 00000001 076DF2F0 00000020 00000000 [......m. .......]
76DF2F0 5AA6EE59 01D35DB2 00000000 00000000 [Y..Z.]..........]
76DF300 00000000 00000000 0000625A 00000000 [........Zb......]
76DF310 00000000 0002625A 045A4EC4 035E2030 [....Zb...NZ.0 ^.]
76DF320 035E2420 035E2430 00000000 5AA6EE59 [ $^.0$^.....Y..Z]
76DF330 01D35DB2 00000000 00000000 00000000 [.]..............]
76DF340 00000000 0002625A 00000000 07BC8160 [....Zb......`...]
76DF350 076DF394 006B2887 36261F10 0000003F [..m..(k...&6?...]
76DF360 FFFFFFFF 00000001 0000296D 00000000 [........m)......]
76DF370 07BC8160 00000026 00000001 00000051 [`...&.......Q...]
76DF380 3625DB68 363697B0 00000000 00000002 [h.%6..66........]
76DF390 F8921DAC 00000026 3637E224 00000026 [....&...$.76&...]
76DF3A0 00000000 00000000 00000000 00427B67 [............g{B.]
76DF3B0 00000002 0000000C 040E0A20 00000051 [........ ...Q...]
76DF3C0 3625DB68 085956ED 00000008 00000039 [h.%6.VY.....9...]
========== FRAME [8] (_ksbrdp+923 -> 00000000) ==========
Dump of memory from 0x076DF3D0 to 0x076DF504
76DF3D0 076DF504 004A76B6 040E0A20 00000000 [..m..vJ. .......]
76DF3E0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
76DF400 00000000 00000000 00000000 0425D467 [............g.%.]
76DF410 00000000 00000000 0425D467 076DF4FC [........g.%...m.]
76DF420 0065E6CC 07BC8940 00000000 076DF498 [..e.@.........m.]
76DF430 00000000 00000998 0000048C 00006568 [............he..]
76DF440 5AA6EE59 01D35DB2 5257474C 00000000 [Y..Z.]..LGWR....]
76DF450 00000000 00000870 00000000 07BC8160 [....p.......`...]
76DF460 36393532 00000030 076DF488 0042257E [25960.....m.~%B.]
76DF470 354EE718 00000005 076DFD6C 354EEE94 [..N5....l.m...N5]
76DF480 00000001 076DF400 00421BFE 00000000 [......m...B.....]
76DF490 07BC8160 07711A44 076DF504 00421CDE [`...D.q...m...B.]
76DF4A0 354EEE94 48B72790 076DF2D8 00000002 [..N5.'.H..m.....]
76DF4B0 076DFDB0 3585AFC4 00000001 00000005 [..m....5........]
76DF4C0 035E1968 00000000 3625D710 36368820 [h.^.......%6 .66]
76DF4D0 076DF50C 07BC8A3C 040E0A20 FFFFFF01 [..m.<... .......]
76DF4E0 07BCF594 040E0A20 07BC8160 076DF3DC [.... ...`.....m.]
76DF4F0 02A728AC 076DFDB0 02A728AC 035E6428 [.(....m..(..(d^.]
76DF500 00000000 [....]
========== FRAME [9] (_opirip+674 -> _ksbrdp+0) ==========
Dump of memory from 0x076DF504 to 0x076DF904
76DF500 076DFDC0 009BF037 00000000 [..m.7.......]
76DF510 00000000 00000000 00000000 00000000 [................]
Repeat 15 times
76DF610 00000000 00000000 0770BF3C 0770C3B4 [........<.p...p.]
76DF620 076EDD74 00000000 003D6C70 07BC8160 [t.n.....pl=.`...]
76DF630 07BD9DD8 00000003 076DFA0A 076DF909 [..........m...m.]
76DF640 076DF808 00000001 076EDD38 00000000 [..m.....8.n.....]
76DF650 076DF674 609832A7 07BD9DD8 076DF69C [t.m..2.`......m.]
76DF660 076DFD6C 00000100 076DFE6C 00000002 [l.m.....l.m.....]
76DF670 00000000 076DFD20 60983995 07BD9DD8 [.... .m..9.`....]
76DF680 076DF69C 076DFD6C 00000100 076DFE6C [..m.l.m.....l.m.]
76DF690 076DF69C 00000000 00000680 00000EE9 [..m.............]
76DF6A0 00000002 00000002 00000000 00000000 [................]
76DF6B0 00000000 00000000 00000036 00000000 [........6.......]
76DF6C0 00000000 00000039 00000034 00000000 [....9...4.......]
76DF6D0 00000000 00000000 00000000 00000000 [................]
76DF6E0 00000000 60A48E2C 60A48E40 00000000 [....,..`@..`....]
76DF6F0 60A48E58 00000000 00000000 60A48E6C [X..`........l..`]
76DF700 60A48E80 60A48E98 60A48EB4 60A48EF8 [...`...`...`...`]
76DF710 60A48F08 00000000 00000000 00000000 [...`............]
76DF720 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
76DF740 60A48D60 00000006 60A48D68 00000003 [`..`....h..`....]
76DF750 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
76DF7B0 60A48E28 00000003 60A48D6C 00000003 [(..`....l..`....]
76DF7C0 00000000 00000000 00000000 00000001 [................]
76DF7D0 00000000 00000000 00000000 00000000 [................]
76DF7E0 00000000 00000000 60A48D60 00000006 [........`..`....]
76DF7F0 60A48ECC 00000003 00000000 00000000 [...`............]
76DF800 00000000 FFFFFFF9 7C34F9A2 FFFFFFF9 [..........4|....]
76DF810 00000000 7C350135 7C34FC0B 076DFCDC [....5.5|..4|..m.]
76DF820 076DFCDC 7C350184 7C829E78 7C829EBC [..m...5|x..|...|]
76DF830 076DFA98 076DFAA0 00000000 00000000 [..m...m.........]
76DF840 076DF850 00000000 00000000 00000000 [P.m.............]
76DF850 00000000 00000000 7C829EBC 00000017 [...........|....]
76DF860 00000007 076DFD5C FFFFFFFF 00000000 [....\.m.........]
76DF870 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
76DF900 00000000 [....]
========== FRAME [10] (_opidrv+857 -> _opirip+0) ==========
Dump of memory from 0x076DFDC0 to 0x076DFE68
76DFDC0 076DFE68 004272CA 00000032 00000004 [h.m..rB.2.......]
76DFDD0 076DFEA8 00000000 00000000 00000000 [..m.............]
76DFDE0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
76DFE20 00000000 00000000 00000001 00000000 [................]
76DFE30 00000000 00000000 07BCF480 00000000 [................]
76DFE40 07BC8A3C 076DFE9C 07BC8160 076DFED4 [<.....m.`.....m.]
76DFE50 076DFDD4 00000000 076DFFA8 02A728AC [..m.......m..(..]
76DFE60 035BACDC 00000000 [..[.....]
========== FRAME [11] (_sou2o+45 -> _opidrv+0) ==========
Dump of memory from 0x076DFE68 to 0x076DFE84
76DFE60 076DFE84 004279EE [..m..yB.]
76DFE70 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFE80 00000001 [....]
========== FRAME [12] (_opimai_real+227 -> _sou2o+0) ==========
Dump of memory from 0x076DFE84 to 0x076DFEC4
76DFE80 076DFEC4 004011E4 076DFE9C [..m...@...m.]
76DFE90 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFEA0 00000000 00000000 076E0084 FFFFFFFF [..........n.....]
76DFEB0 00000000 00000001 00000007 076DFF4C [............L.m.]
76DFEC0 00000003 [....]
========== FRAME [13] (_opimai+92 -> _opimai_real+0) ==========
Dump of memory from 0x076DFEC4 to 0x076DFF0C
76DFEC0 076DFF0C 00401061 00000003 [..m.a.@.....]
76DFED0 076DFED4 076E0030 076E0048 076E0084 [..m.0.n.H.n...n.]
76DFEE0 076DFF4C 076DFED8 076DFE44 076DFFA8 [L.m...m.D.m...m.]
76DFEF0 02A728AC 035B4AC0 FFFFFFFF 076DFF10 [.(...J[.......m.]
76DFF00 076DFF4C 076E0086 003D6C62 [L.m...n.bl=.]
========== FRAME [14] (_BackgroundThreadStart@4+ 495 -> _opimai+0) ==========
Dump of memory from 0x076DFF0C to 0x076E000C
76DFF00 076DFFB8 [..m.]
76DFF10 00401784 00000003 076DFF20 FD0C0CD0 [..@..... .m.....]
76DFF20 076E0030 076E0048 076E0084 00000000 [0.n.H.n...n.....]
76DFF30 809A49CC 7FFD6000 FD0C0CD0 00000000 [.I...`..........]
76DFF40 FD0C0CD0 80A62530 F2BD6CA4 00000000 [....0%...l......]
76DFF50 5257474C 00000000 00000000 00000001 [LGWR............]
76DFF60 040F1FCC 00000000 00000870 00000000 [........p.......]
76DFF70 00000000 00000000 00000870 0000048C [........p.......]
76DFF80 00000000 00000000 00000003 08208588 [.............. .]
76DFF90 00000003 00000000 00000000 003D4B90 [.............K=.]
76DFFA0 076DFF1C 8082EBF5 076DFFDC 02A728AC [..m.......m..(..]
76DFFB0 035B4B24 00000001 076DFFEC 77E3484F [$K[.......m.OH.w]
76DFFC0 003D4B90 00000000 00000000 003D4B90 [.K=..........K=.]
76DFFD0 00000000 076DFFC4 80833D40 FFFFFFFF [......m.@=......]
76DFFE0 77E31A78 77E34858 00000000 00000000 [x..wXH.w........]
76DFFF0 00000000 00401590 003D4B90 00000000 [......@..K=.....]
76E0000 00BC614E 00000000 00000001 [Na..........]
----- Argument/Register Address Dump -----
Argument/Register addr=0x07750F68.
Dump of memory from 0x07750F28 to 0x07751068
7750F20 243B98A8 07BC0000 [..;$....]
7750F30 00000000 00000004 00000001 00000001 [................]
7750F40 00000001 00000004 07754A94 00000000 [.........Ju.....]
7750F50 00000001 00000002 08595674 00000001 [........tVY.....]
7750F60 07751464 00000001 00000001 07750ED0 [d.u...........u.]
7750F70 3939D442 243B98AA 00000000 00000001 [B.99..;$........]
7750F80 00000004 00000001 00000001 00000001 [................]
7750F90 00000005 077546B8 00000000 00000001 [.....Fu.........]
7750FA0 00000001 08595819 00000002 07751914 [.....XY.......u.]
7750FB0 00000001 00000000 00000000 00000000 [................]
7750FC0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7750FF0 00000001 00000000 00000000 00000000 [................]
7751000 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
7751060 00000000 00000000 [........]
Argument/Register addr=0x040E0A20.
Dump of memory from 0x040E09E0 to 0x040E0B20
40E09E0 00000642 00000643 00000644 000001F4 [B...C...D.......]
40E09F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
40E0A10 00000000 00000000 00000001 00000000 [................]
40E0A20 00000074 3625D710 00000000 00000000 [t.....%6........]
40E0A30 5257474C 00000200 00000998 0000048C [LGWR............]
40E0A40 00006568 5AA6EE59 01D35DB2 5257474C [he..Y..Z.]..LGWR]
40E0A50 00000000 00000000 00000870 00000001 [........p.......]
40E0A60 0851D295 00040001 3516AF10 00000001 [..Q........5....]
40E0A70 00000000 0000107C 00000069 0000006A [....|...i...j...]
40E0A80 0000006B 00000645 00000646 00000647 [k...E...F...G...]
40E0A90 00000648 00000649 0000064A 0000064B [H...I...J...K...]
40E0AA0 0000064C 0000064D 0000064E 0000064F [L...M...N...O...]
40E0AB0 00000650 00000651 00000652 00000653 [P...Q...R...S...]
40E0AC0 00000654 00000655 00000656 00000657 [T...U...V...W...]
40E0AD0 00000658 00000659 0000065A 0000065B [X...Y...Z...[...]
40E0AE0 0000065C 0000065D 0000065E 0000065F [\...]...^..._...]
40E0AF0 00000660 00000661 00000662 00000663 [`...a...b...c...]
40E0B00 00000664 00000665 00000666 00000667 [d...e...f...g...]
40E0B10 00000668 00000669 0000066A 0000066B [h...i...j...k...]
Argument/Register addr=0x076DFEA8.
Dump of memory from 0x076DFE68 to 0x076DFFA8
76DFE60 076DFE84 004279EE [..m..yB.]
76DFE70 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFE80 00000001 076DFEC4 004011E4 076DFE9C [......m...@...m.]
76DFE90 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFEA0 00000000 00000000 076E0084 FFFFFFFF [..........n.....]
76DFEB0 00000000 00000001 00000007 076DFF4C [............L.m.]
76DFEC0 00000003 076DFF0C 00401061 00000003 [......m.a.@.....]
76DFED0 076DFED4 076E0030 076E0048 076E0084 [..m.0.n.H.n...n.]
76DFEE0 076DFF4C 076DFED8 076DFE44 076DFFA8 [L.m...m.D.m...m.]
76DFEF0 02A728AC 035B4AC0 FFFFFFFF 076DFF10 [.(...J[.......m.]
76DFF00 076DFF4C 076E0086 003D6C62 076DFFB8 [L.m...n.bl=...m.]
76DFF10 00401784 00000003 076DFF20 FD0C0CD0 [..@..... .m.....]
76DFF20 076E0030 076E0048 076E0084 00000000 [0.n.H.n...n.....]
76DFF30 809A49CC 7FFD6000 FD0C0CD0 00000000 [.I...`..........]
76DFF40 FD0C0CD0 80A62530 F2BD6CA4 00000000 [....0%...l......]
76DFF50 5257474C 00000000 00000000 00000001 [LGWR............]
76DFF60 040F1FCC 00000000 00000870 00000000 [........p.......]
76DFF70 00000000 00000000 00000870 0000048C [........p.......]
76DFF80 00000000 00000000 00000003 08208588 [.............. .]
76DFF90 00000003 00000000 00000000 003D4B90 [.............K=.]
76DFFA0 076DFF1C 8082EBF5 [..m.....]
----- End of Call Stack Trace -----
========================== ========== ========== =====
PROCESS STATE
-------------
Process global information:
process: 3625D710, call: 3637E0C8, xact: 00000000, curses: 36368820, usrses: 36368820
-------------------------- ---------- ----
SO: 3625D710, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=6, calls cur/top: 3637E0C8/3637E0C8, flag: (6) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 24
last post received-location: ksasnd
last process to post me: 36261f10 63 0
last post sent: 110 0 4
last post sent-location: kslpsr
last process posted by me: 36261f10 63 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 36294624
O/S info: user: SYSTEM, term: SVOBBDDPUB, ospid: 25960
OSD pid info: Windows thread id: 25960, image: ORACLE.EXE (LGWR)
(FOB) flags=2 fib=352A5A5C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I BM\TIVOLIO RTEMPTS.DB F
fno=202 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A5714 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\T EMP01.DBF
fno=201 lblksz=8192 fsiz=18816
(FOB) flags=2 fib=352A53CC incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I BM\IBM_TOO LS.DBF
fno=14 lblksz=8192 fsiz=6400
(FOB) flags=2 fib=352A5074 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I BM\IBM_AUD ITORIAS_01 .DBF
fno=13 lblksz=8192 fsiz=77312
(FOB) flags=2 fib=352A4D2C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I BM\TIVOLIO RTS.DBF
fno=12 lblksz=8192 fsiz=32000
(FOB) flags=2 fib=352A49E4 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W EB_CASYC.D BF
fno=11 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A469C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W EB_CAEX.DB F
fno=10 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A4344 incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\A BSI.DBF
fno=9 lblksz=8192 fsiz=19200
(FOB) flags=2 fib=352A3FFC incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\A BSD.DBF
fno=8 lblksz=8192 fsiz=19200
(FOB) flags=2 fib=352A3CB4 incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W EB_CCM.DBF
fno=7 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A396C incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W EB.DBF
fno=6 lblksz=8192 fsiz=1572864
(FOB) flags=2 fib=352A3614 incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\D MO.DBF
fno=5 lblksz=8192 fsiz=64000
(FOB) flags=2 fib=352A32CC incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\U SERS01.DBF
fno=4 lblksz=8192 fsiz=112800
(FOB) flags=2 fib=352A2F84 incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\S YSAUX01.DB F
fno=3 lblksz=8192 fsiz=131072
(FOB) flags=2 fib=352A2C3C incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\U NDOTBS01.D BF
fno=2 lblksz=8192 fsiz=206720
(FOB) flags=2 fib=352A28E4 incno=80 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\S YSTEM01.DB F
fno=1 lblksz=8192 fsiz=723840
-------------------------- ---------- ----
SO: 352A6AD4, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R EDO05.LOG
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A6AD4 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R EDO05.LOG
fno=0 lblksz=512 fsiz=102400
-------------------------- ---------- ----
SO: 352A678C, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R EDO04.LOG
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A678C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R EDO04.LOG
fno=0 lblksz=512 fsiz=102400
-------------------------- ---------- ----
SO: 352A6444, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R EDO03.LOG
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A6444 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R EDO03.LOG
fno=0 lblksz=512 fsiz=102400
-------------------------- ---------- ----
SO: 352A60FC, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R EDO02.LOG
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A60FC incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R EDO02.LOG
fno=0 lblksz=512 fsiz=102400
-------------------------- ---------- ----
SO: 352A5DA4, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R EDO01.LOG
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A5DA4 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R EDO01.LOG
fno=0 lblksz=512 fsiz=102400
-------------------------- ---------- ----
SO: 35865244, type: 5, owner: 3625D710, flag: INIT/-/-/0x00
(enqueue) RT-00000001-00000000 DID: 0000-0006-00000004
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x2
mode: X, lock_flag: 0x0, lock: 0x35865258, res: 0x358A3550
own: 0x36368820, sess: 0x36368820, proc: 0x3625D710, prv: 0x358A3558
(FOB) flags=2 fib=352A259C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\C ONTROL03.C TL
fno=2 lblksz=16384 fsiz=468
(FOB) flags=2 fib=352A2254 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\C ONTROL02.C TL
fno=1 lblksz=16384 fsiz=468
(FOB) flags=2 fib=352A1F0C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\C ONTROL01.C TL
fno=0 lblksz=16384 fsiz=468
-------------------------- ---------- ----
SO: 358E994C, type: 11, owner: 3625D710, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 3625D710,
event: 5, last message event: 12,
last message waited event: 12, next message: 00000000(0), messages read: 1
channel: (358F3E18) scumnt mount lock
scope: 1, event: 13, last mesage event: 12,
publishers/subscribers: 0/11,
messages published: 1
heuristic msg queue length: 0
-------------------------- ---------- ----
SO: 36368820, type: 4, owner: 3625D710, flag: INIT/-/-/0x00
(session) sid: 166 trans: 00000000, creator: 3625D710, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0001-0006-00000005, short-term DID: 0000-0000-00000000
txn branch: 00000000
oct: 0, prv: 0, sql: 00000000, psql: 00000000, user: 0/SYS
service name: SYS$BACKGROUND
last wait for 'log file parallel write' wait_time=0.009021 sec, seconds since wait started=0
files=1, blocks=1, requests=1
blocking sess=0x00000000 seq=2882
Dumping Session Wait History
for 'log file parallel write' count=1 wait_time=0.009021 sec
files=1, blocks=1, requests=1
for 'rdbms ipc message' count=1 wait_time=2.999977 sec
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=0.010749 sec
timeout=1, =0, =0
for 'rdbms ipc message' count=1 wait_time=1.213434 sec
timeout=79, =0, =0
for 'rdbms ipc message' count=1 wait_time=0.000000 sec
timeout=79, =0, =0
for 'log file parallel write' count=1 wait_time=0.000522 sec
files=1, blocks=2, requests=1
for 'rdbms ipc message' count=1 wait_time=0.048356 sec
timeout=7e, =0, =0
for 'log file parallel write' count=1 wait_time=0.000448 sec
files=1, blocks=2, requests=1
for 'rdbms ipc message' count=1 wait_time=0.243538 sec
timeout=97, =0, =0
for 'log file parallel write' count=1 wait_time=0.000455 sec
files=1, blocks=2, requests=1
Sampled Session History of session 166 serial 1
-------------------------- ---------- ---------- -----
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).
The history is displayed in reverse chronological order.
sample interval: 1 sec, max history 120 sec
-------------------------- ---------- ---------- -----
[2 samples, 04:00:02 - 04:00:03]
not in wait at each sample
[119 samples, 03:58:03 - 04:00:01]
idle wait at each sample
temporary object counter: 0
KTU Session Commit Cache Dump for IDLs:
KTU Session Commit Cache Dump for Non-IDLs:
-------------------------- ---------- ----
UOL used : 0 locks(used=0, free=0)
KGX Atomic Operation Log 35F6C254
Mutex 00000000(0, 0) idn 0 oper NONE
Library Cache uid 166 efd 0 whr 0 slp 0
KGX Atomic Operation Log 35F6C27C
Mutex 00000000(0, 0) idn 0 oper NONE
Library Cache uid 166 efd 0 whr 0 slp 0
KGX Atomic Operation Log 35F6C2A4
Mutex 00000000(0, 0) idn 0 oper NONE
Library Cache uid 166 efd 0 whr 0 slp 0
-------------------------- ---------- ----
SO: 353E8E3C, type: 41, owner: 36368820, flag: INIT/-/-/0x00
(dummy) nxc=0, nlb=0
-------------------------- ---------- ----
SO: 358E98A0, type: 11, owner: 3625D710, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 3625D710,
event: 6, last message event: 30,
last message waited event: 30, next message: 00000000(0), messages read: 1
channel: (358EFF50) system events broadcast channel
scope: 2, event: 121, last mesage event: 30,
publishers/subscribers: 0/14,
messages published: 1
heuristic msg queue length: 0
-------------------------- ---------- ----
SO: 3637E0C8, type: 3, owner: 3625D710, flag: INIT/-/-/0x00
(call) sess: cur 36368820, rec 0, usr 36368820; depth: 0
-------------------------- ---------- ----
SO: 354EFFA0, type: 16, owner: 3625D710, flag: INIT/-/-/0x00
(osp req holder)
PSO child state object changes :
Dump of memory from 0x3624D8D0 to 0x3624DA54
3624D8D0 0000001E 354EFFA0 00000010 000313F4 [......N5........]
3624D8E0 3637E0C8 00000003 000313F4 358E98A0 [..76...........5]
3624D8F0 0000000B 000313F4 36368820 00000004 [........ .66....]
3624D900 000312CB 358E994C 0000000B 000313F4 [....L..5........]
3624D910 351D23A4 00000007 000313F4 351D2428 [.#.5........($.5]
3624D920 00000007 000313F4 351D24AC 00000007 [.........$.5....]
3624D930 000313F4 35865244 00000005 000313F4 [....DR.5........]
3624D940 352A5DA4 00000006 000313F4 352A60FC [.]*5.........`*5]
3624D950 00000006 000313F4 352A6444 00000006 [........Dd*5....]
3624D960 000313F4 352A678C 00000006 000313F4 [.....g*5........]
3624D970 352A6AD4 00000006 000313F4 351D3B8C [.j*5.........;.5]
3624D980 00000007 000313F4 351D3C10 00000007 [.........<.5....]
3624D990 000313F4 351D3C94 00000007 000313F4 [.....<.5........]
3624D9A0 351D3D18 00000007 000313F4 351D3D9C [.=.5.........=.5]
3624D9B0 00000007 000313F4 351D3E20 00000007 [........ >.5....]
3624D9C0 000313F4 351D3EA4 00000007 000313F4 [.....>.5........]
3624D9D0 351D3F28 00000007 000313F4 351D3FAC [(?.5.........?.5]
3624D9E0 00000007 000313F4 351D4040 00000007 [........@@.5....]
3624D9F0 000313F4 351D40C4 00000007 000313F4 [.....@.5........]
3624DA00 351D4148 00000007 000313F4 351D41CC [HA.5.........A.5]
3624DA10 00000007 000313F4 351D4250 00000007 [........PB.5....]
3624DA20 000313F4 351D42D4 00000007 000313F4 [.....B.5........]
3624DA30 351D4358 00000007 000313F4 00000000 [XC.5............]
3624DA40 00000000 00000000 00000000 00000000 [................]
3624DA50 00000000 [....]
ksxpdmp: There is no skgxp context.
========================== ========== ========== =====
CURRENT SESSION'S INSTANTIATION STATE
-------------------------- ---------- -
current session=36368820
KGI STATE DUMP for session=36368820
-------------------------- ---------- -
INSTANTIATION OBJECT: object=0776CB64
type="KOKA open cursor"[1] lock=00000000 handle=00000000 body=00000000 level=0
flags=[40] executions=0
REST OF INSTANTIATION OBJECT:
address=0776CBD0 size=12
00000000 00000005 0000000A
-------------------------- ---------- -
INSTANTIATION OBJECT: object=0776CAE0
type="KOKA pseudo cursor"[2] lock=00000000 handle=00000000 body=00000000 level=0
flags=[40] executions=0
REST OF INSTANTIATION OBJECT:
address=0776CB4C size=12
00000000 00000005 0000000A
KGI STATE DUMP DONE for session=36368820
******************** Session Cursor Dump **********************
Current cursor: 0, pgadep: 0
Open cursors(pls, sys, hwm, max): 0(0, 0, 64, 300)
NULL 0 SYNTAX 0 PARSE 0 BOUND 0 FETCH 0 ROW 0
Cached frame pages(total, free):
4k(0, 0), 8k(0, 0), 16k(0, 0), 32k(0, 0)
Session cached cursors
-------------------------- ---------- ---------- ---------- ---
-------------- Generic Session Cached Cursors Dump --------
-------------------------- ---------- ---------- ---------- ---
hash table=07761D30 cnt=0 LRU=07757520 cnt=0 hit=0 max=20 NumberOfTypes=4
type#0 name=KQD count=0
type#1 name=KQD BUN count=0
type#2 name=KKS count=0
type#3 name=KNT count=0
-------------------------- ---------- ---------- ---------- ---
------Finished Dumping Generic Session Cached Cursors------
-------------------------- ---------- ---------- ---------- ---
Memory dump of process state object:
Dump of memory from 0x3625D710 to 0x3625DD10
3625D710 00000102 00000000 00000000 00000000 [................]
3625D720 00000000 351D4364 354EFFAC 3637E0C8 [....dC.5..N5..76]
3625D730 354EEE94 00000000 354EEF18 354EEF18 [..N5......N5..N5]
3625D740 354EFFA0 08000601 00000000 36368820 [..N5........ .66]
3625D750 3637E0C8 00000006 00000000 00000000 [..76............]
3625D760 00000000 00000000 358E98C4 358E9970 [...........5p..5]
3625D770 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3625D7B0 00000000 00030000 00000000 00030000 [................]
3625D7C0 00000000 00000000 00000000 00040000 [................]
3625D7D0 00000000 00030000 00000000 00030000 [................]
Repeat 1 times
3625D7F0 00000000 00030000 00000000 00000000 [................]
3625D800 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3625D840 00000000 00000000 00000000 3625D84C [............L.%6]
3625D850 3625D84C 00000000 00000000 00000000 [L.%6............]
3625D860 3625D860 3625D860 00000000 00000000 [`.%6`.%6........]
3625D870 00000000 00000000 00000000 0000006E [............n...]
3625D880 00000000 07005645 00000018 00000004 [....EV..........]
3625D890 000000E3 000005F8 36261F10 36261F10 [..........&6..&6]
3625D8A0 00010000 00000000 00000000 00000000 [................]
3625D8B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625D8D0 00006568 00000000 00000000 00000000 [he..............]
3625D8E0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3625D910 3625D710 00000000 00000000 00000000 [..%6............]
3625D920 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
3625D980 00000000 00000000 00000000 3625D98C [..............%6]
3625D990 3625D98C 00000000 00000000 00000001 [..%6............]
3625D9A0 00000000 00000870 00000998 0000048C [....p...........]
3625D9B0 00006568 5AA6EE59 01D35DB2 5257474C [he..Y..Z.]..LGWR]
3625D9C0 00000000 00000000 00000870 00000000 [........p.......]
3625D9D0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625D9F0 00000000 00000000 00000003 FFFFFFFF [................]
3625DA00 00000000 00000000 00000000 00000000 [................]
Repeat 7 times
3625DA80 00000000 00000000 54535953 00004D45 [........SYSTEM..]
3625DA90 00000000 00000000 00000000 00000000 [................]
3625DAA0 00000000 00000000 00000006 424F5653 [............SVOB]
3625DAB0 50444442 00004255 00000000 00000000 [BDDPUB..........]
3625DAC0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625DAE0 00000000 00000000 00000000 0000000A [................]
3625DAF0 00000000 424F5653 50444442 00004255 [....SVOBBDDPUB..]
3625DB00 00000000 0000000A 36393532 00000030 [........25960...]
3625DB10 00000000 00000000 00000000 00000000 [................]
3625DB20 00000005 4341524F 452E454C 28204558 [....ORACLE.EXE (]
3625DB30 5257474C 00000029 00000000 00000000 [LGWR)...........]
3625DB40 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625DB60 00000000 00000011 00000002 00000000 [................]
3625DB70 00000000 00000000 00000000 00000000 [................]
Repeat 9 times
3625DC10 00000200 00000000 00000000 00000000 [................]
3625DC20 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625DC40 36294624 3625E244 3625D644 00000000 [$F)6D.%6D.%6....]
3625DC50 358C00A8 00000000 00000000 00000000 [...5............]
3625DC60 00000000 00000000 00000000 00000000 [................]
3625DC70 3625DC70 3625DC70 00490000 00000000 [p.%6p.%6..I.....]
3625DC80 00018BC8 0043AF4C 005B8BC8 00000000 [....L.C...[.....]
3625DC90 00000000 00000000 00000000 00000000 [................]
3625DCA0 00000000 00000000 000007E8 00000000 [................]
3625DCB0 00000088 00000000 000007E8 00000000 [................]
3625DCC0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3625DD00 00000000 00000001 00000005 00000000 [................]
Symbolic dump of process state object:
KSUPRFLG = 6
KSUPRSER = 1
KSUPRIOC = 1
KSLLALAQ = 0X00000000
KSLLAWAT = 0X00000000
KSLLAWHY = 0
KSLLAWER = 0
KSLLALOW = 0
KSLLAPSC = 227
KSLLAPRC = 1528
KSLLAPRV = 24
KSLLAPSN = 4
KSLLID1R = 0
KSLLID2R = 0
KSLLRTYP = ''
KSLLRMTY = 0
KSUPRPID = ''
KSUPRUNM = ''
KSUPRMNM = ''
KSUPRPNM = ''
KSUPRTID = ''
KSSRCOBJ = 0X00000000
KSSRCFRE = 0X00000000
KSSRCSRC = 0X00000000
KSSRCDST = 0X00000000
KSASTQNX = 0X3625D98C
KSASTQPR = 0X3625D98C
KSASTRPL = 0
KSUPRPUM = 4435788
KSUPRPNAM = 101320
KSUPRPRAM = 4784128
KSUPRPFM = 0
KSUPRPMM = 5999560
KSFD PGA DUMPS
Number of completed I/O requests=0 flags=1
END OF PROCESS STATE
---------------------
PINNED BUFFER HISTORY (oldest pin first)
---------------------
END OF PINNED BUFFER HISTORY
No block in buffer pin history is suitable for redo dump.
error 340 detected in background process
ORA-00340: IO error processing online log 4 of thread 1
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04 .LOG'
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
Wed Nov 15 02:41:17 2017
ORACLE V10.2.0.5.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 8 - type 586, 8 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:17093M/18431M, Ph+PgF:20737M/22351M, VA:1182M/2047M
Instance name: sorana1
Redo thread mounted by this instance: 1
Oracle process number: 6
Windows thread id: 25960, image: ORACLE.EXE (LGWR)
*** 2017-11-15 02:41:17.095
*** SERVICE NAME:() 2017-11-15 02:41:16.939
*** SESSION ID:(166.1) 2017-11-15 02:41:16.939
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
*** 2017-11-15 04:00:02.376
ksedmp: internal or fatal error
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
check trace file c:\oracle\product\10.2.0\d
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- --------------------------
_ksedst+38 CALLrel _ksedst1+0 0 1
_ksedmp+898 CALLrel _ksedst+0 0
_kcrfwcint+942 CALLrel _ksedmp+0
_kcrfw_post+389 CALLrel _kcrfwcint+0 7750F68
_kcrfw_redo_write+5 CALLrel _kcrfw_post+0 0 0
743
_ksbcti+652 CALLreg 00000000 0 0
_ksbabs+666 CALLrel _ksbcti+0
_ksbrdp+923 CALLreg 00000000 40E0A20
_opirip+674 CALLrel _ksbrdp+0
_opidrv+857 CALLrel _opirip+0 32 4 76DFEA8
_sou2o+45 CALLrel _opidrv+0 32 4 76DFEA8
_opimai_real+227 CALLrel _sou2o+0 76DFE9C 32 4 76DFEA8
_opimai+92 CALLrel _opimai_real+0 3 76DFED4
_BackgroundThreadSt CALLrel _opimai+0
art@4+495
77E3484C CALLreg 00000000
--------------------- Binary Stack Dump ---------------------
========== FRAME [1] (_ksedst+38 -> _ksedst1+0) ==========
Dump of memory from 0x076DED28 to 0x076DED38
76DED20 076DED38 00404A0B [8.m..J@.]
76DED30 00000000 00000001 [........]
========== FRAME [2] (_ksedmp+898 -> _ksedst+0) ==========
Dump of memory from 0x076DED38 to 0x076DEDF8
76DED30 076DEDF8 004033EB [..m..3@.]
76DED40 00000000 00000000 00000000 00000002 [................]
76DED50 076DEDE4 00000000 00000000 00000000 [..m.............]
76DED60 076DED94 0425BFB1 07BC8940 07BC8A3C [..m...%.@...<...]
76DED70 07BC8940 00000000 00000000 00000000 [@...............]
76DED80 00000000 00000000 076DEDBC 0425BFB1 [..........m...%.]
76DED90 07BC8940 07BC8A3C 07752274 00000159 [@...<...t"u.Y...]
76DEDA0 00000000 00000000 00000000 00000000 [................]
76DEDB0 00000002 076DEDE4 00000001 00000000 [......m.........]
76DEDC0 00000000 00000000 00000000 00000000 [................]
76DEDD0 00000000 FFFFFF0C 07750F68 07BC8160 [........h.u.`...]
76DEDE0 076DED44 00000000 076DF4F4 02A728AC [D.m.......m..(..]
76DEDF0 035B4DF8 FFFFFFFF [.M[.....]
========== FRAME [3] (_kcrfwcint+942 -> _ksedmp+0) ==========
Dump of memory from 0x076DEDF8 to 0x076DF080
76DEDF0 076DF080 009D756B [..m.ku..]
76DEE00 00000002 FD0C0CD0 FD2548F0 F2BD6BD0 [.........H%..k..]
76DEE10 00000002 FD714901 F2BD6BE0 8082AEBF [.....Iq..k......]
76DEE20 FD714908 FD2548F0 FD2548B0 00000000 [.Iq..H%..H%.....]
76DEE30 FD0C0D14 FD0C0C01 F2BD6C3C 80821B39 [........<l..9...]
76DEE40 00000000 F2BD6C3C 80821B8B 80821B90 [....<l..........]
76DEE50 FD2548F0 FD0C0CD0 80A62530 FD0C0CD0 [.H%.....0%......]
76DEE60 F2BD6C50 FC707648 808B0B40 00000001 [Pl..Hvp.@.......]
76DEE70 FD714908 808B0B40 00000001 808B6101 [.Iq.@........a..]
76DEE80 F2BD6C38 80A64456 00000000 808B6101 [8l..VD.......a..]
76DEE90 F2BD6C7C 80A6256D 808942B3 808B0B40 [|l..m%...B..@...]
76DEEA0 808B0B64 0000003D F2BD6C80 F2BD6C84 [d...=....l...l..]
76DEEB0 808B0B01 FC707648 00000000 00000A0E [....Hvp.........]
76DEEC0 00000000 00000001 00000000 00000000 [................]
76DEED0 00000000 F2BD6CD4 00000000 FFFFFFFF [.....l..........]
76DEEE0 076DEF7C FD2548B0 00000001 808B6300 [|.m..H%......c..]
76DEEF0 F2BD6CA8 80A64400 00000000 00000306 [.l...D..........]
76DEF00 00000000 FD254A90 000001E8 B969D6B8 [.....J%.......i.]
76DEF10 0000000C F7557000 00000306 000007FF [.....pU.........]
76DEF20 00000000 20707249 000001E8 F2BD6CF0 [....Irp .....l..]
76DEF30 8081C59F 076DEF58 7C828246 7C826D09 [....X.m.F..|.m.|]
76DEF40 076DEFA4 77E11F41 77E11EFB 0771DFB0 [..m.A..w...w..q.]
76DEF50 00000000 FFFFFFFF 00000024 00000001 [........$.......]
76DEF60 00000000 00000000 00000070 FFFFFFFF [........p.......]
76DEF70 FFFFFFFF 77E11F09 77E11F41 00000000 [.......wA..w....]
76DEF80 80000000 000000C0 076DEF7C 076DEF4C [........|.m.L.m.]
76DEF90 07BC8160 076DEFA8 0419474B 0771DFB0 [`.....m.KG....q.]
76DEFA0 0771DFB0 00000001 07BC8160 007E22FA [..q.....`...."~.]
76DEFB0 076DEFBC 00000006 0771DFB0 00000004 [..m.......q.....]
76DEFC0 00000000 07BC8160 00000001 00000000 [....`...........]
76DEFD0 00000009 076DF00C 007DE7D1 00000010 [......m...}.....]
76DEFE0 00000000 077109C4 07BC87A0 0775476C [......q.....lGu.]
76DEFF0 07BC8160 00000000 00000010 FFFFFFFF [`...............]
76DF000 00000000 076DF048 0047B33F 00000008 [....H.m.?.G.....]
76DF010 00000006 0000006B 3637BA10 35F6BBDC [....k.....76...5]
76DF020 00000000 6E5207AE 35F6BBDC 00000000 [......Rn...5....]
76DF030 00000001 00000000 00000000 00000000 [................]
76DF040 00000000 00000000 00000002 00000001 [................]
76DF050 00000000 07750F68 077546C4 07BC8160 [....h.u..Fu.`...]
76DF060 07BCE308 00000000 FFFFFF0C 00000000 [................]
76DF070 FFFFFFFF 00000000 00000000 00000001 [................]
========== FRAME [4] (_kcrfw_post+389 -> _kcrfwcint+0) ==========
Dump of memory from 0x076DF080 to 0x076DF134
76DF080 076DF134 00AFB85E 07750F68 FA67B90E [4.m.^...h.u...g.]
76DF090 C6D750EB 0000001A FFFFFFF7 9E3B9800 [.P............;.]
76DF0A0 076DF0DC 040E0DFA 076DF0C4 7C82A98A [..m.......m....|]
76DF0B0 0000003C 9E3B9800 FFFFFFF7 040E0DFA [<.....;.........]
76DF0C0 00DBC338 07BC8160 00000000 00000000 [8...`...........]
76DF0D0 00000000 00000000 00000000 00000001 [................]
76DF0E0 3485AC20 00000000 00000000 35F6BBDC [ ..4...........5]
76DF0F0 07BC8160 00000098 07BC8160 00000000 [`.......`.......]
76DF100 00000002 077109C4 00000001 00000001 [......q.........]
76DF110 00000000 00000001 00000000 077546C4 [.............Fu.]
76DF120 00000100 35F6BBDC 00000002 35F6BBDC [.......5.......5]
76DF130 00000100 [....]
========== FRAME [5] (_kcrfw_redo_write+5743 -> _kcrfw_post+0) ==========
Dump of memory from 0x076DF134 to 0x076DF1D0
76DF130 076DF1D0 00AFAFEC 00000000 [..m.........]
76DF140 00000000 00000000 00000003 00000000 [................]
76DF150 0000012C 243B98AA 00000000 00000038 [,.....;$....8...]
76DF160 07BC8160 035E23A0 040E59F0 000000D0 [`....#^..Y......]
76DF170 00000210 00000078 00000001 000001F0 [....x...........]
76DF180 00000001 00000001 00000100 07750F68 [............h.u.]
76DF190 00000002 00000002 07BC8160 00001A98 [........`.......]
76DF1A0 00000001 00000000 00000002 00001A99 [................]
76DF1B0 00000000 34859888 34859780 3485AD84 [.......4...4...4]
76DF1C0 3939D442 00000000 000010C5 000010C4 [B.99............]
========== FRAME [6] (_ksbcti+652 -> 00000000) ==========
Dump of memory from 0x076DF1D0 to 0x076DF1F8
76DF1D0 076DF1F8 004A313A 00000000 00000000 [..m.:1J.........]
76DF1E0 07BC8160 0000012C 00000000 3585DAD0 [`...,..........5]
76DF1F0 FCA1DFE0 076DF2AC [......m.]
========== FRAME [7] (_ksbabs+666 -> _ksbcti+0) ==========
Dump of memory from 0x076DF1F8 to 0x076DF3D0
76DF1F0 076DF3D0 004A34F3 [..m..4J.]
76DF200 035E7F30 076DF2A4 00000001 358F7D50 [0.^...m.....P}.5]
76DF210 358F7D50 358F3E30 358F3E30 00000000 [P}.50>.50>.5....]
76DF220 359BB9C4 359BB9C4 0004000D 0000000C [...5...5........]
76DF230 00000000 0008000A 00000000 00000000 [................]
76DF240 00000000 00000000 00000000 5A0B9A70 [............p..Z]
76DF250 00000098 36260D10 36260D10 3625C510 [......&6..&6..%6]
76DF260 00000000 00000000 00000001 00000000 [................]
76DF270 00000000 00000000 00000000 524F5301 [.............SOR]
76DF280 31414E41 00000000 00000000 00000000 [ANA1............]
76DF290 00000000 00000000 00000000 00000007 [................]
76DF2A0 00000000 035E2020 035E23A0 035E23B0 [.... ^..#^..#^.]
76DF2B0 035E23C0 035E23D0 035E23E0 035E2AE0 [.#^..#^..#^..*^.]
76DF2C0 035E2AF0 035E2B00 00000000 00000000 [.*^..+^.........]
76DF2D0 00000000 00000000 00000000 FFFFFFFE [................]
76DF2E0 00000001 076DF2F0 00000020 00000000 [......m. .......]
76DF2F0 5AA6EE59 01D35DB2 00000000 00000000 [Y..Z.]..........]
76DF300 00000000 00000000 0000625A 00000000 [........Zb......]
76DF310 00000000 0002625A 045A4EC4 035E2030 [....Zb...NZ.0 ^.]
76DF320 035E2420 035E2430 00000000 5AA6EE59 [ $^.0$^.....Y..Z]
76DF330 01D35DB2 00000000 00000000 00000000 [.]..............]
76DF340 00000000 0002625A 00000000 07BC8160 [....Zb......`...]
76DF350 076DF394 006B2887 36261F10 0000003F [..m..(k...&6?...]
76DF360 FFFFFFFF 00000001 0000296D 00000000 [........m)......]
76DF370 07BC8160 00000026 00000001 00000051 [`...&.......Q...]
76DF380 3625DB68 363697B0 00000000 00000002 [h.%6..66........]
76DF390 F8921DAC 00000026 3637E224 00000026 [....&...$.76&...]
76DF3A0 00000000 00000000 00000000 00427B67 [............g{B.]
76DF3B0 00000002 0000000C 040E0A20 00000051 [........ ...Q...]
76DF3C0 3625DB68 085956ED 00000008 00000039 [h.%6.VY.....9...]
========== FRAME [8] (_ksbrdp+923 -> 00000000) ==========
Dump of memory from 0x076DF3D0 to 0x076DF504
76DF3D0 076DF504 004A76B6 040E0A20 00000000 [..m..vJ. .......]
76DF3E0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
76DF400 00000000 00000000 00000000 0425D467 [............g.%.]
76DF410 00000000 00000000 0425D467 076DF4FC [........g.%...m.]
76DF420 0065E6CC 07BC8940 00000000 076DF498 [..e.@.........m.]
76DF430 00000000 00000998 0000048C 00006568 [............he..]
76DF440 5AA6EE59 01D35DB2 5257474C 00000000 [Y..Z.]..LGWR....]
76DF450 00000000 00000870 00000000 07BC8160 [....p.......`...]
76DF460 36393532 00000030 076DF488 0042257E [25960.....m.~%B.]
76DF470 354EE718 00000005 076DFD6C 354EEE94 [..N5....l.m...N5]
76DF480 00000001 076DF400 00421BFE 00000000 [......m...B.....]
76DF490 07BC8160 07711A44 076DF504 00421CDE [`...D.q...m...B.]
76DF4A0 354EEE94 48B72790 076DF2D8 00000002 [..N5.'.H..m.....]
76DF4B0 076DFDB0 3585AFC4 00000001 00000005 [..m....5........]
76DF4C0 035E1968 00000000 3625D710 36368820 [h.^.......%6 .66]
76DF4D0 076DF50C 07BC8A3C 040E0A20 FFFFFF01 [..m.<... .......]
76DF4E0 07BCF594 040E0A20 07BC8160 076DF3DC [.... ...`.....m.]
76DF4F0 02A728AC 076DFDB0 02A728AC 035E6428 [.(....m..(..(d^.]
76DF500 00000000 [....]
========== FRAME [9] (_opirip+674 -> _ksbrdp+0) ==========
Dump of memory from 0x076DF504 to 0x076DF904
76DF500 076DFDC0 009BF037 00000000 [..m.7.......]
76DF510 00000000 00000000 00000000 00000000 [................]
Repeat 15 times
76DF610 00000000 00000000 0770BF3C 0770C3B4 [........<.p...p.]
76DF620 076EDD74 00000000 003D6C70 07BC8160 [t.n.....pl=.`...]
76DF630 07BD9DD8 00000003 076DFA0A 076DF909 [..........m...m.]
76DF640 076DF808 00000001 076EDD38 00000000 [..m.....8.n.....]
76DF650 076DF674 609832A7 07BD9DD8 076DF69C [t.m..2.`......m.]
76DF660 076DFD6C 00000100 076DFE6C 00000002 [l.m.....l.m.....]
76DF670 00000000 076DFD20 60983995 07BD9DD8 [.... .m..9.`....]
76DF680 076DF69C 076DFD6C 00000100 076DFE6C [..m.l.m.....l.m.]
76DF690 076DF69C 00000000 00000680 00000EE9 [..m.............]
76DF6A0 00000002 00000002 00000000 00000000 [................]
76DF6B0 00000000 00000000 00000036 00000000 [........6.......]
76DF6C0 00000000 00000039 00000034 00000000 [....9...4.......]
76DF6D0 00000000 00000000 00000000 00000000 [................]
76DF6E0 00000000 60A48E2C 60A48E40 00000000 [....,..`@..`....]
76DF6F0 60A48E58 00000000 00000000 60A48E6C [X..`........l..`]
76DF700 60A48E80 60A48E98 60A48EB4 60A48EF8 [...`...`...`...`]
76DF710 60A48F08 00000000 00000000 00000000 [...`............]
76DF720 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
76DF740 60A48D60 00000006 60A48D68 00000003 [`..`....h..`....]
76DF750 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
76DF7B0 60A48E28 00000003 60A48D6C 00000003 [(..`....l..`....]
76DF7C0 00000000 00000000 00000000 00000001 [................]
76DF7D0 00000000 00000000 00000000 00000000 [................]
76DF7E0 00000000 00000000 60A48D60 00000006 [........`..`....]
76DF7F0 60A48ECC 00000003 00000000 00000000 [...`............]
76DF800 00000000 FFFFFFF9 7C34F9A2 FFFFFFF9 [..........4|....]
76DF810 00000000 7C350135 7C34FC0B 076DFCDC [....5.5|..4|..m.]
76DF820 076DFCDC 7C350184 7C829E78 7C829EBC [..m...5|x..|...|]
76DF830 076DFA98 076DFAA0 00000000 00000000 [..m...m.........]
76DF840 076DF850 00000000 00000000 00000000 [P.m.............]
76DF850 00000000 00000000 7C829EBC 00000017 [...........|....]
76DF860 00000007 076DFD5C FFFFFFFF 00000000 [....\.m.........]
76DF870 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
76DF900 00000000 [....]
========== FRAME [10] (_opidrv+857 -> _opirip+0) ==========
Dump of memory from 0x076DFDC0 to 0x076DFE68
76DFDC0 076DFE68 004272CA 00000032 00000004 [h.m..rB.2.......]
76DFDD0 076DFEA8 00000000 00000000 00000000 [..m.............]
76DFDE0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
76DFE20 00000000 00000000 00000001 00000000 [................]
76DFE30 00000000 00000000 07BCF480 00000000 [................]
76DFE40 07BC8A3C 076DFE9C 07BC8160 076DFED4 [<.....m.`.....m.]
76DFE50 076DFDD4 00000000 076DFFA8 02A728AC [..m.......m..(..]
76DFE60 035BACDC 00000000 [..[.....]
========== FRAME [11] (_sou2o+45 -> _opidrv+0) ==========
Dump of memory from 0x076DFE68 to 0x076DFE84
76DFE60 076DFE84 004279EE [..m..yB.]
76DFE70 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFE80 00000001 [....]
========== FRAME [12] (_opimai_real+227 -> _sou2o+0) ==========
Dump of memory from 0x076DFE84 to 0x076DFEC4
76DFE80 076DFEC4 004011E4 076DFE9C [..m...@...m.]
76DFE90 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFEA0 00000000 00000000 076E0084 FFFFFFFF [..........n.....]
76DFEB0 00000000 00000001 00000007 076DFF4C [............L.m.]
76DFEC0 00000003 [....]
========== FRAME [13] (_opimai+92 -> _opimai_real+0) ==========
Dump of memory from 0x076DFEC4 to 0x076DFF0C
76DFEC0 076DFF0C 00401061 00000003 [..m.a.@.....]
76DFED0 076DFED4 076E0030 076E0048 076E0084 [..m.0.n.H.n...n.]
76DFEE0 076DFF4C 076DFED8 076DFE44 076DFFA8 [L.m...m.D.m...m.]
76DFEF0 02A728AC 035B4AC0 FFFFFFFF 076DFF10 [.(...J[.......m.]
76DFF00 076DFF4C 076E0086 003D6C62 [L.m...n.bl=.]
========== FRAME [14] (_BackgroundThreadStart@4+
Dump of memory from 0x076DFF0C to 0x076E000C
76DFF00 076DFFB8 [..m.]
76DFF10 00401784 00000003 076DFF20 FD0C0CD0 [..@..... .m.....]
76DFF20 076E0030 076E0048 076E0084 00000000 [0.n.H.n...n.....]
76DFF30 809A49CC 7FFD6000 FD0C0CD0 00000000 [.I...`..........]
76DFF40 FD0C0CD0 80A62530 F2BD6CA4 00000000 [....0%...l......]
76DFF50 5257474C 00000000 00000000 00000001 [LGWR............]
76DFF60 040F1FCC 00000000 00000870 00000000 [........p.......]
76DFF70 00000000 00000000 00000870 0000048C [........p.......]
76DFF80 00000000 00000000 00000003 08208588 [.............. .]
76DFF90 00000003 00000000 00000000 003D4B90 [.............K=.]
76DFFA0 076DFF1C 8082EBF5 076DFFDC 02A728AC [..m.......m..(..]
76DFFB0 035B4B24 00000001 076DFFEC 77E3484F [$K[.......m.OH.w]
76DFFC0 003D4B90 00000000 00000000 003D4B90 [.K=..........K=.]
76DFFD0 00000000 076DFFC4 80833D40 FFFFFFFF [......m.@=......]
76DFFE0 77E31A78 77E34858 00000000 00000000 [x..wXH.w........]
76DFFF0 00000000 00401590 003D4B90 00000000 [......@..K=.....]
76E0000 00BC614E 00000000 00000001 [Na..........]
----- Argument/Register Address Dump -----
Argument/Register addr=0x07750F68.
Dump of memory from 0x07750F28 to 0x07751068
7750F20 243B98A8 07BC0000 [..;$....]
7750F30 00000000 00000004 00000001 00000001 [................]
7750F40 00000001 00000004 07754A94 00000000 [.........Ju.....]
7750F50 00000001 00000002 08595674 00000001 [........tVY.....]
7750F60 07751464 00000001 00000001 07750ED0 [d.u...........u.]
7750F70 3939D442 243B98AA 00000000 00000001 [B.99..;$........]
7750F80 00000004 00000001 00000001 00000001 [................]
7750F90 00000005 077546B8 00000000 00000001 [.....Fu.........]
7750FA0 00000001 08595819 00000002 07751914 [.....XY.......u.]
7750FB0 00000001 00000000 00000000 00000000 [................]
7750FC0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
7750FF0 00000001 00000000 00000000 00000000 [................]
7751000 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
7751060 00000000 00000000 [........]
Argument/Register addr=0x040E0A20.
Dump of memory from 0x040E09E0 to 0x040E0B20
40E09E0 00000642 00000643 00000644 000001F4 [B...C...D.......]
40E09F0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
40E0A10 00000000 00000000 00000001 00000000 [................]
40E0A20 00000074 3625D710 00000000 00000000 [t.....%6........]
40E0A30 5257474C 00000200 00000998 0000048C [LGWR............]
40E0A40 00006568 5AA6EE59 01D35DB2 5257474C [he..Y..Z.]..LGWR]
40E0A50 00000000 00000000 00000870 00000001 [........p.......]
40E0A60 0851D295 00040001 3516AF10 00000001 [..Q........5....]
40E0A70 00000000 0000107C 00000069 0000006A [....|...i...j...]
40E0A80 0000006B 00000645 00000646 00000647 [k...E...F...G...]
40E0A90 00000648 00000649 0000064A 0000064B [H...I...J...K...]
40E0AA0 0000064C 0000064D 0000064E 0000064F [L...M...N...O...]
40E0AB0 00000650 00000651 00000652 00000653 [P...Q...R...S...]
40E0AC0 00000654 00000655 00000656 00000657 [T...U...V...W...]
40E0AD0 00000658 00000659 0000065A 0000065B [X...Y...Z...[...]
40E0AE0 0000065C 0000065D 0000065E 0000065F [\...]...^..._...]
40E0AF0 00000660 00000661 00000662 00000663 [`...a...b...c...]
40E0B00 00000664 00000665 00000666 00000667 [d...e...f...g...]
40E0B10 00000668 00000669 0000066A 0000066B [h...i...j...k...]
Argument/Register addr=0x076DFEA8.
Dump of memory from 0x076DFE68 to 0x076DFFA8
76DFE60 076DFE84 004279EE [..m..yB.]
76DFE70 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFE80 00000001 076DFEC4 004011E4 076DFE9C [......m...@...m.]
76DFE90 00000032 00000004 076DFEA8 00000000 [2.........m.....]
76DFEA0 00000000 00000000 076E0084 FFFFFFFF [..........n.....]
76DFEB0 00000000 00000001 00000007 076DFF4C [............L.m.]
76DFEC0 00000003 076DFF0C 00401061 00000003 [......m.a.@.....]
76DFED0 076DFED4 076E0030 076E0048 076E0084 [..m.0.n.H.n...n.]
76DFEE0 076DFF4C 076DFED8 076DFE44 076DFFA8 [L.m...m.D.m...m.]
76DFEF0 02A728AC 035B4AC0 FFFFFFFF 076DFF10 [.(...J[.......m.]
76DFF00 076DFF4C 076E0086 003D6C62 076DFFB8 [L.m...n.bl=...m.]
76DFF10 00401784 00000003 076DFF20 FD0C0CD0 [..@..... .m.....]
76DFF20 076E0030 076E0048 076E0084 00000000 [0.n.H.n...n.....]
76DFF30 809A49CC 7FFD6000 FD0C0CD0 00000000 [.I...`..........]
76DFF40 FD0C0CD0 80A62530 F2BD6CA4 00000000 [....0%...l......]
76DFF50 5257474C 00000000 00000000 00000001 [LGWR............]
76DFF60 040F1FCC 00000000 00000870 00000000 [........p.......]
76DFF70 00000000 00000000 00000870 0000048C [........p.......]
76DFF80 00000000 00000000 00000003 08208588 [.............. .]
76DFF90 00000003 00000000 00000000 003D4B90 [.............K=.]
76DFFA0 076DFF1C 8082EBF5 [..m.....]
----- End of Call Stack Trace -----
==========================
PROCESS STATE
-------------
Process global information:
process: 3625D710, call: 3637E0C8, xact: 00000000, curses: 36368820, usrses: 36368820
--------------------------
SO: 3625D710, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=6, calls cur/top: 3637E0C8/3637E0C8, flag: (6) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 24
last post received-location: ksasnd
last process to post me: 36261f10 63 0
last post sent: 110 0 4
last post sent-location: kslpsr
last process posted by me: 36261f10 63 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 36294624
O/S info: user: SYSTEM, term: SVOBBDDPUB, ospid: 25960
OSD pid info: Windows thread id: 25960, image: ORACLE.EXE (LGWR)
(FOB) flags=2 fib=352A5A5C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I
fno=202 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A5714 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\T
fno=201 lblksz=8192 fsiz=18816
(FOB) flags=2 fib=352A53CC incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I
fno=14 lblksz=8192 fsiz=6400
(FOB) flags=2 fib=352A5074 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I
fno=13 lblksz=8192 fsiz=77312
(FOB) flags=2 fib=352A4D2C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\I
fno=12 lblksz=8192 fsiz=32000
(FOB) flags=2 fib=352A49E4 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W
fno=11 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A469C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W
fno=10 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A4344 incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\A
fno=9 lblksz=8192 fsiz=19200
(FOB) flags=2 fib=352A3FFC incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\A
fno=8 lblksz=8192 fsiz=19200
(FOB) flags=2 fib=352A3CB4 incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W
fno=7 lblksz=8192 fsiz=65536
(FOB) flags=2 fib=352A396C incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\W
fno=6 lblksz=8192 fsiz=1572864
(FOB) flags=2 fib=352A3614 incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\D
fno=5 lblksz=8192 fsiz=64000
(FOB) flags=2 fib=352A32CC incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\U
fno=4 lblksz=8192 fsiz=112800
(FOB) flags=2 fib=352A2F84 incno=1 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\S
fno=3 lblksz=8192 fsiz=131072
(FOB) flags=2 fib=352A2C3C incno=2 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\U
fno=2 lblksz=8192 fsiz=206720
(FOB) flags=2 fib=352A28E4 incno=80 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\S
fno=1 lblksz=8192 fsiz=723840
--------------------------
SO: 352A6AD4, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A6AD4 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
--------------------------
SO: 352A678C, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A678C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
--------------------------
SO: 352A6444, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A6444 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
--------------------------
SO: 352A60FC, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A60FC incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
--------------------------
SO: 352A5DA4, type: 6, owner: 3625D710, flag: INIT/-/-/0x00
(FIB) flags=512 reference cnt=1 incno=0 seqno=1
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
(FOB) flags=262154 fib=352A5DA4 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\R
fno=0 lblksz=512 fsiz=102400
--------------------------
SO: 35865244, type: 5, owner: 3625D710, flag: INIT/-/-/0x00
(enqueue) RT-00000001-00000000 DID: 0000-0006-00000004
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x2
mode: X, lock_flag: 0x0, lock: 0x35865258, res: 0x358A3550
own: 0x36368820, sess: 0x36368820, proc: 0x3625D710, prv: 0x358A3558
(FOB) flags=2 fib=352A259C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\C
fno=2 lblksz=16384 fsiz=468
(FOB) flags=2 fib=352A2254 incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\C
fno=1 lblksz=16384 fsiz=468
(FOB) flags=2 fib=352A1F0C incno=0 pending i/o cnt=0
fname=K:\SORANA1\SORANA1\C
fno=0 lblksz=16384 fsiz=468
--------------------------
SO: 358E994C, type: 11, owner: 3625D710, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 3625D710,
event: 5, last message event: 12,
last message waited event: 12, next message: 00000000(0), messages read: 1
channel: (358F3E18) scumnt mount lock
scope: 1, event: 13, last mesage event: 12,
publishers/subscribers: 0/11,
messages published: 1
heuristic msg queue length: 0
--------------------------
SO: 36368820, type: 4, owner: 3625D710, flag: INIT/-/-/0x00
(session) sid: 166 trans: 00000000, creator: 3625D710, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0001-0006-00000005, short-term DID: 0000-0000-00000000
txn branch: 00000000
oct: 0, prv: 0, sql: 00000000, psql: 00000000, user: 0/SYS
service name: SYS$BACKGROUND
last wait for 'log file parallel write' wait_time=0.009021 sec, seconds since wait started=0
files=1, blocks=1, requests=1
blocking sess=0x00000000 seq=2882
Dumping Session Wait History
for 'log file parallel write' count=1 wait_time=0.009021 sec
files=1, blocks=1, requests=1
for 'rdbms ipc message' count=1 wait_time=2.999977 sec
timeout=12c, =0, =0
for 'rdbms ipc message' count=1 wait_time=0.010749 sec
timeout=1, =0, =0
for 'rdbms ipc message' count=1 wait_time=1.213434 sec
timeout=79, =0, =0
for 'rdbms ipc message' count=1 wait_time=0.000000 sec
timeout=79, =0, =0
for 'log file parallel write' count=1 wait_time=0.000522 sec
files=1, blocks=2, requests=1
for 'rdbms ipc message' count=1 wait_time=0.048356 sec
timeout=7e, =0, =0
for 'log file parallel write' count=1 wait_time=0.000448 sec
files=1, blocks=2, requests=1
for 'rdbms ipc message' count=1 wait_time=0.243538 sec
timeout=97, =0, =0
for 'log file parallel write' count=1 wait_time=0.000455 sec
files=1, blocks=2, requests=1
Sampled Session History of session 166 serial 1
--------------------------
The sampled session history is constructed by sampling
the target session every 1 second. The sampling process
captures at each sample if the session is in a non-idle wait,
an idle wait, or not in a wait. If the session is in a
non-idle wait then one interval is shown for all the samples
the session was in the same non-idle wait. If the
session is in an idle wait or not in a wait for
consecutive samples then one interval is shown for all
the consecutive samples. Though we display these consecutive
samples in a single interval the session may NOT be continuously
idle or not in a wait (the sampling process does not know).
The history is displayed in reverse chronological order.
sample interval: 1 sec, max history 120 sec
--------------------------
[2 samples, 04:00:02 - 04:00:03]
not in wait at each sample
[119 samples, 03:58:03 - 04:00:01]
idle wait at each sample
temporary object counter: 0
KTU Session Commit Cache Dump for IDLs:
KTU Session Commit Cache Dump for Non-IDLs:
--------------------------
UOL used : 0 locks(used=0, free=0)
KGX Atomic Operation Log 35F6C254
Mutex 00000000(0, 0) idn 0 oper NONE
Library Cache uid 166 efd 0 whr 0 slp 0
KGX Atomic Operation Log 35F6C27C
Mutex 00000000(0, 0) idn 0 oper NONE
Library Cache uid 166 efd 0 whr 0 slp 0
KGX Atomic Operation Log 35F6C2A4
Mutex 00000000(0, 0) idn 0 oper NONE
Library Cache uid 166 efd 0 whr 0 slp 0
--------------------------
SO: 353E8E3C, type: 41, owner: 36368820, flag: INIT/-/-/0x00
(dummy) nxc=0, nlb=0
--------------------------
SO: 358E98A0, type: 11, owner: 3625D710, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 3625D710,
event: 6, last message event: 30,
last message waited event: 30, next message: 00000000(0), messages read: 1
channel: (358EFF50) system events broadcast channel
scope: 2, event: 121, last mesage event: 30,
publishers/subscribers: 0/14,
messages published: 1
heuristic msg queue length: 0
--------------------------
SO: 3637E0C8, type: 3, owner: 3625D710, flag: INIT/-/-/0x00
(call) sess: cur 36368820, rec 0, usr 36368820; depth: 0
--------------------------
SO: 354EFFA0, type: 16, owner: 3625D710, flag: INIT/-/-/0x00
(osp req holder)
PSO child state object changes :
Dump of memory from 0x3624D8D0 to 0x3624DA54
3624D8D0 0000001E 354EFFA0 00000010 000313F4 [......N5........]
3624D8E0 3637E0C8 00000003 000313F4 358E98A0 [..76...........5]
3624D8F0 0000000B 000313F4 36368820 00000004 [........ .66....]
3624D900 000312CB 358E994C 0000000B 000313F4 [....L..5........]
3624D910 351D23A4 00000007 000313F4 351D2428 [.#.5........($.5]
3624D920 00000007 000313F4 351D24AC 00000007 [.........$.5....]
3624D930 000313F4 35865244 00000005 000313F4 [....DR.5........]
3624D940 352A5DA4 00000006 000313F4 352A60FC [.]*5.........`*5]
3624D950 00000006 000313F4 352A6444 00000006 [........Dd*5....]
3624D960 000313F4 352A678C 00000006 000313F4 [.....g*5........]
3624D970 352A6AD4 00000006 000313F4 351D3B8C [.j*5.........;.5]
3624D980 00000007 000313F4 351D3C10 00000007 [.........<.5....]
3624D990 000313F4 351D3C94 00000007 000313F4 [.....<.5........]
3624D9A0 351D3D18 00000007 000313F4 351D3D9C [.=.5.........=.5]
3624D9B0 00000007 000313F4 351D3E20 00000007 [........ >.5....]
3624D9C0 000313F4 351D3EA4 00000007 000313F4 [.....>.5........]
3624D9D0 351D3F28 00000007 000313F4 351D3FAC [(?.5.........?.5]
3624D9E0 00000007 000313F4 351D4040 00000007 [........@@.5....]
3624D9F0 000313F4 351D40C4 00000007 000313F4 [.....@.5........]
3624DA00 351D4148 00000007 000313F4 351D41CC [HA.5.........A.5]
3624DA10 00000007 000313F4 351D4250 00000007 [........PB.5....]
3624DA20 000313F4 351D42D4 00000007 000313F4 [.....B.5........]
3624DA30 351D4358 00000007 000313F4 00000000 [XC.5............]
3624DA40 00000000 00000000 00000000 00000000 [................]
3624DA50 00000000 [....]
ksxpdmp: There is no skgxp context.
==========================
CURRENT SESSION'S INSTANTIATION STATE
--------------------------
current session=36368820
KGI STATE DUMP for session=36368820
--------------------------
INSTANTIATION OBJECT: object=0776CB64
type="KOKA open cursor"[1] lock=00000000 handle=00000000 body=00000000 level=0
flags=[40] executions=0
REST OF INSTANTIATION OBJECT:
address=0776CBD0 size=12
00000000 00000005 0000000A
--------------------------
INSTANTIATION OBJECT: object=0776CAE0
type="KOKA pseudo cursor"[2] lock=00000000 handle=00000000 body=00000000 level=0
flags=[40] executions=0
REST OF INSTANTIATION OBJECT:
address=0776CB4C size=12
00000000 00000005 0000000A
KGI STATE DUMP DONE for session=36368820
******************** Session Cursor Dump **********************
Current cursor: 0, pgadep: 0
Open cursors(pls, sys, hwm, max): 0(0, 0, 64, 300)
NULL 0 SYNTAX 0 PARSE 0 BOUND 0 FETCH 0 ROW 0
Cached frame pages(total, free):
4k(0, 0), 8k(0, 0), 16k(0, 0), 32k(0, 0)
Session cached cursors
--------------------------
-------------- Generic Session Cached Cursors Dump --------
--------------------------
hash table=07761D30 cnt=0 LRU=07757520 cnt=0 hit=0 max=20 NumberOfTypes=4
type#0 name=KQD count=0
type#1 name=KQD BUN count=0
type#2 name=KKS count=0
type#3 name=KNT count=0
--------------------------
------Finished Dumping Generic Session Cached Cursors------
--------------------------
Memory dump of process state object:
Dump of memory from 0x3625D710 to 0x3625DD10
3625D710 00000102 00000000 00000000 00000000 [................]
3625D720 00000000 351D4364 354EFFAC 3637E0C8 [....dC.5..N5..76]
3625D730 354EEE94 00000000 354EEF18 354EEF18 [..N5......N5..N5]
3625D740 354EFFA0 08000601 00000000 36368820 [..N5........ .66]
3625D750 3637E0C8 00000006 00000000 00000000 [..76............]
3625D760 00000000 00000000 358E98C4 358E9970 [...........5p..5]
3625D770 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3625D7B0 00000000 00030000 00000000 00030000 [................]
3625D7C0 00000000 00000000 00000000 00040000 [................]
3625D7D0 00000000 00030000 00000000 00030000 [................]
Repeat 1 times
3625D7F0 00000000 00030000 00000000 00000000 [................]
3625D800 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3625D840 00000000 00000000 00000000 3625D84C [............L.%6]
3625D850 3625D84C 00000000 00000000 00000000 [L.%6............]
3625D860 3625D860 3625D860 00000000 00000000 [`.%6`.%6........]
3625D870 00000000 00000000 00000000 0000006E [............n...]
3625D880 00000000 07005645 00000018 00000004 [....EV..........]
3625D890 000000E3 000005F8 36261F10 36261F10 [..........&6..&6]
3625D8A0 00010000 00000000 00000000 00000000 [................]
3625D8B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625D8D0 00006568 00000000 00000000 00000000 [he..............]
3625D8E0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
3625D910 3625D710 00000000 00000000 00000000 [..%6............]
3625D920 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
3625D980 00000000 00000000 00000000 3625D98C [..............%6]
3625D990 3625D98C 00000000 00000000 00000001 [..%6............]
3625D9A0 00000000 00000870 00000998 0000048C [....p...........]
3625D9B0 00006568 5AA6EE59 01D35DB2 5257474C [he..Y..Z.]..LGWR]
3625D9C0 00000000 00000000 00000870 00000000 [........p.......]
3625D9D0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625D9F0 00000000 00000000 00000003 FFFFFFFF [................]
3625DA00 00000000 00000000 00000000 00000000 [................]
Repeat 7 times
3625DA80 00000000 00000000 54535953 00004D45 [........SYSTEM..]
3625DA90 00000000 00000000 00000000 00000000 [................]
3625DAA0 00000000 00000000 00000006 424F5653 [............SVOB]
3625DAB0 50444442 00004255 00000000 00000000 [BDDPUB..........]
3625DAC0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625DAE0 00000000 00000000 00000000 0000000A [................]
3625DAF0 00000000 424F5653 50444442 00004255 [....SVOBBDDPUB..]
3625DB00 00000000 0000000A 36393532 00000030 [........25960...]
3625DB10 00000000 00000000 00000000 00000000 [................]
3625DB20 00000005 4341524F 452E454C 28204558 [....ORACLE.EXE (]
3625DB30 5257474C 00000029 00000000 00000000 [LGWR)...........]
3625DB40 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625DB60 00000000 00000011 00000002 00000000 [................]
3625DB70 00000000 00000000 00000000 00000000 [................]
Repeat 9 times
3625DC10 00000200 00000000 00000000 00000000 [................]
3625DC20 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
3625DC40 36294624 3625E244 3625D644 00000000 [$F)6D.%6D.%6....]
3625DC50 358C00A8 00000000 00000000 00000000 [...5............]
3625DC60 00000000 00000000 00000000 00000000 [................]
3625DC70 3625DC70 3625DC70 00490000 00000000 [p.%6p.%6..I.....]
3625DC80 00018BC8 0043AF4C 005B8BC8 00000000 [....L.C...[.....]
3625DC90 00000000 00000000 00000000 00000000 [................]
3625DCA0 00000000 00000000 000007E8 00000000 [................]
3625DCB0 00000088 00000000 000007E8 00000000 [................]
3625DCC0 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
3625DD00 00000000 00000001 00000005 00000000 [................]
Symbolic dump of process state object:
KSUPRFLG = 6
KSUPRSER = 1
KSUPRIOC = 1
KSLLALAQ = 0X00000000
KSLLAWAT = 0X00000000
KSLLAWHY = 0
KSLLAWER = 0
KSLLALOW = 0
KSLLAPSC = 227
KSLLAPRC = 1528
KSLLAPRV = 24
KSLLAPSN = 4
KSLLID1R = 0
KSLLID2R = 0
KSLLRTYP = ''
KSLLRMTY = 0
KSUPRPID = ''
KSUPRUNM = ''
KSUPRMNM = ''
KSUPRPNM = ''
KSUPRTID = ''
KSSRCOBJ = 0X00000000
KSSRCFRE = 0X00000000
KSSRCSRC = 0X00000000
KSSRCDST = 0X00000000
KSASTQNX = 0X3625D98C
KSASTQPR = 0X3625D98C
KSASTRPL = 0
KSUPRPUM = 4435788
KSUPRPNAM = 101320
KSUPRPRAM = 4784128
KSUPRPFM = 0
KSUPRPMM = 5999560
KSFD PGA DUMPS
Number of completed I/O requests=0 flags=1
END OF PROCESS STATE
---------------------
PINNED BUFFER HISTORY (oldest pin first)
---------------------
END OF PINNED BUFFER HISTORY
No block in buffer pin history is suitable for redo dump.
error 340 detected in background process
ORA-00340: IO error processing online log 4 of thread 1
ORA-00345: redo log write error block 4295 count 1
ORA-00312: online log 4 thread 1: 'K:\SORANA1\SORANA1\REDO04
ORA-27070: async read/write failed
OSD-04016: Error al poner en la cola una solicitud de E/S asíncrona.
O/S-Error: (OS 1784) El búfer del usuario no es válido para esta operación.
Undoubtly, your files are ok, database will not open eitherways.
It seems it's not a VM environment, right? Do you have any OS side backups running during this time (Networker, Veritas, etc...)?
I think some tool is interfering your database IO operations or you have faulty hardware/driver.
Whats in the Windows System and Application EventLogs?
It seems it's not a VM environment, right? Do you have any OS side backups running during this time (Networker, Veritas, etc...)?
I think some tool is interfering your database IO operations or you have faulty hardware/driver.
Whats in the Windows System and Application EventLogs?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes. Disable TSM backups has been a good workaround and the problem it is not happening now.
Regarding the Oracle Note about Legato, well LEGATO software is not running but it could be another disk driver.
Regards and thanks for your help.
Regarding the Oracle Note about Legato, well LEGATO software is not running but it could be another disk driver.
Regards and thanks for your help.
Is this virtual environment? What events do you have in a Windows System and Application EventLogs from the time reported above?
Would you mind to paste contents of a file: k:\sorana1\admin\sorana1\b
Regards,
Daniel