Re: SQLPLUS window freezes

The window freezes, but it does not mean that things have stopped working. When you issue a command like this from SQL*Plus on NT, then SQL*Plus sends the command to the database. When the window appears "frozen", it's just the application waiting for response from the database to your query. The longer the query, the more time that it will take to get that response. If you let it sit long enough, the results of the query will be returned back to you, and so will the control of your window. IMO, this is not necessarily good design of SQL*Plus for the NT platform, but I've learned to live with it.

HTH,
Brian

Saugato Mukerji wrote:
>
> Hi
>
> a big query like
>
> select count(*) from bigTable;
>
> -- freezes the SQLPLUS window on NT . The table bigTable has 20 million
> rows.
> -- is there a way to abort the query other than killing the SQLPLUS window
> -- from taskmanager.
>
> thanks
>
> Saugato
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================