Home -> Mailing Lists -> Oracle-L -> Adding datafile hungs instance for 60 seconds

Adding datafile hungs instance for 60 seconds

From: GG <grzegorzof_at_interia.pl>
Date: Fri, 4 May 2018 18:13:42 +0200
Message-ID: <f5de49cf-0b7a-ade9-b3be-14f1009730c9_at_interia.pl> 






Hello,



     I've been hit by strange hang issue during execution of alter 
tablespace tbs add datafile '/u02...' size 1g autoextend on .
The tbs is where huge lob segment exists (around 1TB in total) and the 
SGA is around 160GB  (with huge pages enabled on linux).
The db was rather idle load 1.0 (cpu_count 32) but issue appeared when 
around 700 sessions started to waiting on cpu and after that on
commit (log file sync). I'm wondering if there is a checkpoint on 
tablespace level done as a part of adding datafile or anything special ?
It has lasted around 1minute and after this db was idle again with 
nothing in alertlog (except RMS0 process killed due to 30sec hang) .
It is EE 11.2.0.4 with latest PSU.


Any ideas more than welcome :).



Regards .


Grzegorz





--
http://www.freelists.org/webpage/oracle-l


Received on Fri May 04 2018 - 18:13:42 CEST












Original text of this message