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

Thanks Peter. I posed another question to Conor.

Pete Sharman wrote:

> 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
>
> ------------------------------------------------------------------------
>
> Pete Sharman <psharman_at_us.oracle.com>
> Project Manager
> Oracle University, Consulting and Vertical Education
> Oracle Corporation
>
> Pete Sharman
> Project Manager *** **** Oracle Corporation. **** "Controlling applicat<psharman_at_us.oracle.com>
> Oracle University, Consulting and Vertical Education
> Oracle Corporation
> 500 Oracle Parkway M/S OPL-B1024
> Redwood Shores
> California d
> 94065 r
> USA
> **** The statements and opinions expressed here are my **** **** own and do not necessarily represent those of **** **** Oracle Corporation. **** "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
> Additional Information:
> Last Name Sharman
> First Name Peter
> Version 2.1
Received on Wed Jul 21 1999 - 22:56:15 CDT