error asynch descriptor resize, 11g R2 on ms w2k8 x64 on VMware ESX v4.0.0
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Nov 2010 12:07:07 -0400
environment:
testing. not production.
Oracle 11g R2 x64 standard edition one, 11.2.0.1 p6.
MS W2K8 R1 x64 standard edition
VMware ESX v4.0.0
internal SAS RAID, p410 controller, no para-virtualization.
(server is an older HP ML 370 G5, Intel Xeon 5400 series, so no
virtualization features supported in the hardware).
A hang analyze - text of interest describing the blocking session:
and is blocked by
=> Oracle session identified by:
{
instance: 1 (mydb.mydb)
os id: 4004
process id: 34, ORACLE.EXE (SHAD)
session id: 86
session serial #: 2956
}
which is not in a wait:
{
last wait: 13 min 35 sec ago
blocking: 1 session
wait history:
1. event: 'asynch descriptor resize'
time waited: 0.000006 sec
wait id: 5216 p1: 'outstanding #aio'=0x0
p2: 'current aio
limit'=0xffffffff
p3: 'new aio limit'=0x4b2
* time between wait #1 and #2: 0.283570 sec
2. event: 'asynch descriptor resize'
time waited: 0.000007 sec
wait id: 5215 p1: 'outstanding #aio'=0x0
p2: 'current aio
limit'=0xffffffff
p3: 'new aio limit'=0x4b2
* time between wait #2 and #3: 0.046643 sec
3. event: 'asynch descriptor resize'
time waited: 0.000007 sec
wait id: 5214 p1: 'outstanding #aio'=0x0
p2: 'current aio
limit'=0xffffffff
p3: 'new aio limit'=0x4b2
It would appear that I will be experiencing the joy of opening an SR in a
virtualized environment.
Searches of the web and MOS returned little other than a post by April back
in May and a short entry here:
http://blog.younes.ca/2010/07/asynch-descriptor-resize.html
and this:
*asynch descriptor resize [ID 1081977.1]
I'd greatly appreciate any insight anyone might have with respect to this
prior to opening the SR.
Yes, I do plan to attempt to reproduce this on bare metal.
*
thanks,
Paul
Other related posts:
