SQL Performance (MOSC)

MOSC Banner

query insertion rate need to increase

edited Feb 26, 2014 12:00PM in SQL Performance (MOSC) 3 commentsAnswered

HI,

on 11.2.0.3 database.One procedire is calling some sql and it is doing bulk inserts.

Builk insert is happening through one package.

Below is the query inside procedure.Now It is taking 15 min for bulk insertion.

Now team want to reduce to 11min.Any idea let me know please.

CREATE
OR REPLACE PACKAGE BODY "PO_CALL_PKG"
/***************************************************************************/
/*
-- NAME po_call_pkg
-- TYPE stored pl/sql PACKAGE BODY
-- PURPOSE ...
--
-- HISTORY
-- MM/DD/YY Who Patch Description
--! 02/10/14 RG P324929_1 Modified to store trip charge information to
--! the call.
-- PROCEDURES
-- -----------------
-- create_trouble_call

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center