Re: hanging select statements

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 02 Aug 2003 08:56:38 -0700
Message-ID: <XaRWa.34139$Ne.24008@fed1read03>

Ryan Gaffuri wrote:

> I have a package that users dbms_jobs to execute a bunch of processes
> in parallel. I log these events to a log table that inserts and
> updates with an autonomous transaction then commits. If an exception
> occurs it still commits;
>
> I try to select from this table and my select statement 'hangs';
>
> It only has like 50 records.
>
> Im doing a 'select *'. There are no select for update clauses and no
> lock table commands.
>
> what could be blocking my select statement? All im doing is inserting
> and updating on the table.

ALWAYS specify OS (& version) and version of oRacle.

HUH? In theory writers do not block readers.

Using what utility/interface is being used to issue the SELECT? Received on Sat Aug 02 2003 - 10:56:38 CDT