Re: smon is hogging CPU resources

From: Alexander Skwar <alexander_at_skwar.name>
Date: Mon, 30 Oct 2006 15:57:31 +0100
Message-ID: <1773194.o5hxWZzFiq@work.message-center.info>

Steve Howard <stevedhoward_at_gmail.com>:

> Hi Alexander,

Hello!

> How much sorting are you doing?

Unknown.

> smon is responsible for doing sort
> segment cleanup, which can take awhile if you have had a partitcularly
> large sort(s).

Hm. I don't know the application and much less the SQLs it is generating or using. How do I find out, if I have particularly large sorts?

Alexander Skwar

-- 
It's hard to argue that God hated Oklahoma.  If He didn't, why is it so
close to Texas?

Received on Mon Oct 30 2006 - 08:57:31 CST