Re: sQLPLUS SELECT PROBLEM

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Mon, 25 Feb 2002 22:12:48 GMT
Message-ID: <3c7ab59b.699081@news.freeler.nl>

What do you mean 'freeze'? It stops giving output? If it does, check for v$session_wait to see what is happening and v$session_event to get an idea what the thing is that is consuming time.

One possibility: you have a big table with big gaps in it. While Oracle is plowing through the gaps nothing is being output.

Jaap.

On 25 Feb 2002 21:33:56 GMT, "Ronald D. Jeremy" <NO_SPAM_at_yahoo.com> wrote:

>I did a "select * from table" command on sqlplus.
>
>It seems to freeze at certain a certain record. I did a shutdown and
>startup on the database and I still have the problem.
>
>I would have to delete the entire table and start again to get back to
>normal processing of select statements.
>
>I have processes inserting and updating to the database at times. If there
>is some locking issue, would it be solved by just shuting down the database
>and restarting?
>
>What could this be? It persists even after any reads or writes to the table
>has stopped.
>
>Thanks
>
>
Received on Mon Feb 25 2002 - 16:12:48 CST