PL/SQL (MOSC)

MOSC Banner

Performance issue

edited Dec 12, 2011 7:53AM in PL/SQL (MOSC) 5 commentsAnswered
Hello,

Below procedure takes 20-30 min sometimes much time to execute,

Please help on this to improve performance

Table Count for VENDOR_ASSIGN_MATRIX :1065

Count for cust_acct : 556114

Count for Cust_acct_rel : 894232

create or replace
PROCEDURE        vendor_auto_assign (
   v_repoagent    IN   VARCHAR2 DEFAULT '',
   v_userid       IN   VARCHAR2 DEFAULT '',
   v_computerid   IN   VARCHAR2 DEFAULT ''
)
AS
   v_vnr_cnt       NUMBER        := 0;
   v_ven1_per      NUMBER        := 0;
   v_ven2_per      NUMBER        := 0;
   v_ven3_per      NUMBER        := 0;
   v_ven4_per      NUMBER        := 0;
   v_rec_cnt       NUMBER        := 0;
   v_first_ins     NUMBER        := 0;
   v_sec_ins       NUMBER        := 0;
   v_third_ins     NUMBER        := 0;
   v_four_ins      NUMBER        := 0;
   v_errcode       NUMBER        := 0;

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