Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> INSERT ALL Statement times out in AN EJB enviornment
Hi all,,
am now facing a prblm with insert all statement in Oracle...it takes too much time greater than two minutes ,,,is there any way to optimize my query...
the query given below...
INSERT ALL
INTO object_version_permission( object_version_guid, permission_guid )
VALUES ( object_version, :permission_guid_ ) INTO workflow_audit ( workflow_audit_guid, object_version_guid, new_ws_instance_guid, notes, old_ws_instance_guid, user_guid) VALUES ( SYS_GUID(), object_version, workstage_inst, :note_,workstage_inst, :user_guid_ )
FROM object_version_permission op JOIN object_version_workstage ovw ON op.object_version_guid = ovw.object_version_guid AND ws_instance_guid != :ws_instance_guid_ WHERE op.permission_guid IN ( per_guid_ ) ';
per_guid_ variable contains around 100 guids.... Received on Mon Jun 26 2006 - 08:30:58 CDT