SQL Performance (MOSC)

MOSC Banner

Advice Tuning PL/SQL and INSERT statment

edited May 27, 2014 1:20PM in SQL Performance (MOSC) 2 commentsAnswered

Hello,


This post is about these sentences:


  1. BEGIN carga('DIVMTRO', 'GES-1.50', 'DIVMTRO', 1, 23058); END;
  2. INSERT INTO envias400 VALUES(:1, :2, , :4, :5, CURRENT_DATE, CURRENT_DATE)



1) I am not sure how to help that this PL/SQL executes with less resources. I pinned carga. Do I have to look inside the code and tune every statement there?


AWR tells me this about these sentence:

CPU Time (s)ExecutionsCPU per Exec (s)%TotalElapsed Time (s)%CPU%IOSQL IdSQL ModuleSQL Text
117.93716.853.10178.2466.160.906zczgd2a5s157SQL*PlusBEGIN carga('DIVMTRO', 'GES-1....



2) How can I tune an INSERT? ......... Any help will be appreciate.....

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