Xref: alice comp.databases.oracle.server:83133 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!uninett.no!cleanfeed.inet.tele.dQ!netscum.int!not-for-mail From: Brian Rasmusson Newsgroups: comp.databases.oracle.server Subject: Re: Checkpoint stalls database for seconds Date: Wed, 02 Feb 2000 23:05:45 +0100 Organization: Belle Systems Lines: 107 Message-ID: <3898AA39.8F1C18D1@bellesystems.com> References: <38988E5A.CD2D3483@bellesystems.com> <389899a0.178561467@news.eagles.bbs.net.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.inet.tele.dk 949529362 20777 195.249.38.199 (Wed 2346 September 1993 22:09:22 GMT) X-Complaints-To: Department of Written Abuse NNTP-Posting-Date: Wed 2346 September 1993 22:09:22 GMT To: Steve Adams X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en Hi Steve, thanks for your suggestion, my on-site engineers will try your trick! > In any case, it would be helpful to see the output of V$SYSTEM_EVENT, to > get more info on what your hold ups really are. The output looks like this: EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT ---------------------------------------------------------------- ----------- -------------- ----------- ------------ Null event 1 1 0 0 latch free 5 5 0 0 pmon timer 274 274 0 0 process startup 8 0 0 0 rdbms ipc reply 7 0 0 0 rdbms ipc message 2549 809 0 0 imm op 10 0 0 0 io done 2796 0 0 0 slave wait 3227 422 0 0 control file sequential read 181 0 0 0 control file parallel write 332 0 0 0 EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT ---------------------------------------------------------------- ----------- -------------- ----------- ------------ refresh controlfile command 1 0 0 0 write complete waits 14 0 0 0 buffer busy waits 8 0 0 0 log file sequential read 12 0 0 0 log file single write 17 0 0 0 log file parallel write 2795 0 0 0 log file switch completion 5 0 0 0 log file sync 475 0 0 0 db file sequential read 39755 0 0 0 db file scattered read 21 0 0 0 db file parallel write 3342 2 0 0 EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT ---------------------------------------------------------------- ----------- -------------- ----------- ------------ direct path read 192 0 0 0 direct path write 144 0 0 0 instance state change 1 0 0 0 smon timer 5 2 0 0 library cache pin 2 0 0 0 file identify 45 0 0 0 file open 184 0 0 0 SQL*Net message to client 186085 0 0 0 SQL*Net message from client 186084 0 0 0 SQL*Net more data from client 5621 0 0 0 Thanks again, Brian