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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 16 Apr 2002 18:59:26 +0200
Message-ID: <q1mobu4p3llfa2hrom224i8g48sptqhsub@4ax.com>

On 16 Apr 2002 03:41:55 -0700, odette.h_at_gmx.de (odette) wrote:

>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

If you press F5 the select gets executed immediately. This just means your select lasts at least 10 minutes.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 16 2002 - 11:59:26 CDT