Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> INSERT ALL Statement times out in AN EJB enviornment

INSERT ALL Statement times out in AN EJB enviornment

From: <nibum2001_at_gmail.com>
Date: 26 Jun 2006 06:30:58 -0700
Message-ID: <1151328658.339836.110660@b68g2000cwa.googlegroups.com>


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_ )
 SELECT ovw.object_version_guid object_version, ovw.ws_instance_guid workstage_inst
	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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US