Re: sql statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 14 Jan 2001 08:35:08 +0100
Message-ID: <93rn3a$bb324$3@ID-62141.news.dfncis.de>

"Eric Givler" <egivler_at_flash.net> wrote in message news:c4a86.4155$J%.468367_at_news.flash.net...
> Let me clarify... When I ran it, it just sat there. I looked at my
> processes and it said: SQL*Plus Not responding (under NT). I didn't wait
> forever, but I waited at least a minute. I thought this would be
"snappy".
> Any ideas?
>
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3a6129eb_at_news.iprimus.com.au...
> > Did you try a semi-colon at the end? Depends what you mean by 'it just
sat
> > there', I guess. As written, your code has no terminator. Oracle needs
to
> > be told you've finished typing and its up to it now to actually go and
do
> > something. Semi-colon or back-slash would do.
>
>
>

*Only* 1 minute? You are selecting from very complicated datadictionary views, and the result is going very much to depend on how well your database is tuned.
The statement as is *is* correct.
BTW: 'not responding' simply means your client is waiting for the server to return data, so it is *quite* normal.
Try to use a little more patience, or may be you could use some tuning check ups.

Regards,

Sybrand Bakker, Oracle DBA Received on Sun Jan 14 2001 - 01:35:08 CST