Advice Tuning PL/SQL and INSERT statment
Hello,
This post is about these sentences:
- BEGIN carga('DIVMTRO', 'GES-1.50', 'DIVMTRO', 1, 23058); END;
- 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) | Executions | CPU per Exec (s) | %Total | Elapsed Time (s) | %CPU | %IO | SQL Id | SQL Module | SQL Text |
---|---|---|---|---|---|---|---|---|---|
117.93 | 7 | 16.85 | 3.10 | 178.24 | 66.16 | 0.90 | 6zczgd2a5s157 | SQL*Plus | BEGIN carga('DIVMTRO', 'GES-1.... |
2) How can I tune an INSERT? ......... Any help will be appreciate.....