Apparently the developer only knew T-SQL and didn't know PL/SQL.
Temporary tables are usually a big nono. They are a likely common cause
for contention, especially if multiple users are running the same
procedure, and there is only one temporary table.
If the problem gets even worse when those temporary tables are created
and dropped in the procedure.
If you really think you need temporary tables (in Oracle you usually
don't), you should create a GLOBALLY TEMPORARY table instead.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Mar 21 2006 - 05:51:02 CST
