我还没见过It seems to be a fairly common problem and I have witnessed it happen myself in Oracle versions 7.3.4 and 8.0 on HP-UX and AIX. There is little information about it in the public domain because Oracle's standard response seems to be "send us system state dumps at 5 or 10 minute intervals" and log a TAR, in which case the resolutions do not get posted on Metalink. If you report this as a problem in any release other than 8i or 9i Oracle will tell you to upgrade to a supported version which isn't all that helpful. There are various ways to find out what is causing the hang (setting event 10400 is one) but the information is pretty useless if you can do nothing to prevent it. Most occurrences of the problem are caused by a memory leak and can be cured by setting event 10262 at level 0 (which is the size in bytes tolerated). Include the following line in the init.ora file, remembering that all event entries have to be adjacent. event="10262 trace name context forever, level 0" levle 0 在oracle 9.2 中不行I set this in an Oracle7 database on HP-UX 10.20 that was suffering from database hangs and it miraculously cured it!
7.3.4 and 8.0 on HP-UX and AIX. There is little information about it in the public domain
because Oracle's standard response seems to be "send us system state dumps at 5 or 10 minute
intervals" and log a TAR, in which case the resolutions do not get posted on Metalink. If you
report this as a problem in any release other than 8i or 9i Oracle will tell you to upgrade to
a supported version which isn't all that helpful.
There are various ways to find out what is causing the hang (setting event 10400 is one) but the
information is pretty useless if you can do nothing to prevent it. Most occurrences of the
problem are caused by a memory leak and can be cured by setting event 10262 at level 0 (which is
the size in bytes tolerated). Include the following line in the init.ora file, remembering that
all event entries have to be adjacent. event="10262 trace name context forever, level 0"
levle 0 在oracle 9.2 中不行I set this in an Oracle7 database on HP-UX 10.20 that was suffering from database hangs and it
miraculously cured it!