Re: hypothetical question:select count(*) hung?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 21 Jul 1999 13:32:32 -0700
Message-ID: <37962E60.8E4C4CD5@us.oracle.com>

David

Could the table have originally been very large? if the highwater mark hasn't been reset, that's how far Oracle will search before returning a value of zero, thus giving the appearance of being hung. Check to see if there is actual disk activity taking place, or if the table's empty, truncate it to reset the HWM and see how long the select takes.

HTH. Pete

David Spaisman wrote:

> Someone recently proposed a hypothetical question to me about the following
> situation and I thought it was interesting.
>
> If there is an empty table in a database and a select count(*) is tried
> aganst an empty table.
> The connection hangs and no reply is returned. What could be the cause?
>
> Any infomration on how to resolve such a situation would be greatly
> appreciated.
>
> Thanks.
>
> David Spaisman

--
Regards

Pete

Received on Wed Jul 21 1999 - 15:32:32 CDT