RE: sort segment request wait (was: bstat/estat)

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Thu, 31 Aug 2000 00:20:08 +1000
Message-Id: <10604.115863@fatcity.com>

Hi Ruth,

This is a fairly unusual situation. You are hardly using any CPU (a bit more than 1 second over five and a half minutes)

CPU used by this session 117

but you've spent 5 and a half minutes waiting on a 'sort segment request'

sort segment request 32645

That means that SMON is not processing the sort segment request at all. Also, there is no 'smon timer' wait in the background waits section which means that SMON is working full time on something else that it regards as very important. Incidentally, I notice that you are not using recovery parallelism ...

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Wednesday, 30 August 2000 23:38
To: Steve Adams
Cc: oracle list @fatcity
Subject: bstat/estat

Here is the bstat/estat I ran for 5 minutes while I was trying to rebuild the index. I had to kill the rebuild in order to open FTP.

Any ideas will be more than helpful. My boss thinks that I did something to the database to make the application not run right. I wasn't even working Received on Wed Aug 30 2000 - 09:20:08 CDT