Adding datafile hungs instance for 60 seconds
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.
Regards .
Any ideas more than welcome :).
Grzegorz
--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 04 2018 - 18:13:42 CEST