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 cleaning up sort segment extents.

Incidentally, I notice that you are not using recovery parallelism ...


-----Original Message-----
Sent: Wednesday, 30 August 2000 23:38


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