Re: Checkpoint stalls database for seconds

Hi Brian,

Sorry, I cannot comment on this, because timed_statistics is not on.

Regards,
Steve Adams

http://www.ixora.com.au/

http://www.oreilly.com/catalog/orinternals/

http://www.christianity.net.au/

On Wed, 02 Feb 2000 23:05:45 +0100, Brian Rasmusson <brasmuss_at_bellesystems.com> wrote:

>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
Received on Wed Feb 02 2000 - 19:53:12 CST