Re: How to reconstruct whether an select gets executed on the database

From: Frank <a_at_b.c>
Date: Tue, 16 Apr 2002 14:23:16 +0200
Message-ID: <1018958121.627929@makrell.interpost.no>

Hi!
The views:
v$open_cursor and v$sqlarea could be worth looking into, you probably must be user system to use them.

You could try to test with a very simple query (eg. SELECT * FROM DUAL) to see if you get a response- if it works it might be a very though
query you are running (either because something is badly optimized or because it is heavy to compute).

Frank

"odette" <odette.h_at_gmx.de> wrote in message news:66e0618e.0204160241.2a902c29_at_posting.google.com...
> Me problem refers to oracle 9i.
> Is there any possiblity to find out, whether a selection, started in
> the sql-worksheet, gets executed?
> I start and connect the database, then I start the worksheet and
> insert my sql-statement. After inserting I press F5 to start the
> transaction, but also after 10 minutes nothing happend.
>
> Thanks for your help,
> Odette
Received on Tue Apr 16 2002 - 07:23:16 CDT