DU4.0d/ora7.3.3.5 hangs with datafile add operation

From: Mullin, Stephen \(CAP, ITS, US\) <"Mullin,>
Date: Tue, 09 Jun 1998 11:37:08 -0400

Dear Managers,

  I've a problem which both Oracle and DEC/CSC are
thrashing on, hopelessly I might add.

Problem:

 When adding > 512MB datafile to a tablespace the system
locks up everything seems to be waiting from what I can tell
(afterwards). Even the network operations stop as does the processes
on CPU0 (it seems). A reboot is necessary after waits of up to
2 hours during weekend tests. My sister node (idle) can do all this
with no problems and has the same kernel config, sysconfigtab and
resources(!) in minutes for 1 or 2 gig datafile adds.


I have been able to add a 512MB datafile to an completely idle
SAP/Oracle instance which returns successfully after
locking up the system for 10 minutes.

Config:
 8400 cluster 4.0b-w_patch 5/1.4a-w_currentpatch , 16 dual-HSZ50 v5.1-4
 8gig mem, 8xcpus on each cluster node
 8 - LSM mirrored , 6unit RAID
 Oracle 7.3.3.5/SAP 3.1g
-Stephen
g GE Capital
Information Technology Solutions WISE Project
________________________________________________________
Stephen Mullin phone:_____ (770)300-3373
WISE Project (SAP) dialcomm:____ 8* 270-3373
GE Capital IT Solutions fax:________ (770)416-9592
2825a Pacific Drive
Norcross, GA 30071
                                          smullin_at_gecits.ge.com
________________________________________________________
Received on Tue Jun 09 1998 - 17:38:26 NZST

This archive was generated by hypermail 2.4.0 : Wed Nov 08 2023 - 11:53:37 NZDT