hanging select statements

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. Received on Sat Aug 02 2003 - 10:44:31 CDT