SQL & PL/SQL :: Many Executes And Fetches?

Jun 10, 2010

I have trace this query and found many Executes and Fetches. How can i reduce them as the query is taking much time to execute.

SELECT B.BUS_UNIT , B.REG_NO , B.PT_CODE, B.MD_CODE, A.PT_REG_DATE
FROM A_PT_BILL_MASTER A , A_PT_ORDREG B
WHERE ( A.BUS_UNIT = B.BUS_UNIT
--AND ORD_DATE >= :P_DATE_FROM
AND A.REG_NO = B.REG_NO

[code]...

View 2 Replies


ADVERTISEMENT

SQL & PL/SQL :: SP Executes Fine In One Server But Not In Another One

Jul 9, 2010

I have some trouble with a stored procedure I've created, when I run it in the server dedicated to developers it runs fine, and updates 100,000 record in 23 seconds, but when I run it in the production server it collapses and don't update anything. Here's my code.

CREATE OR REPLACE PROCEDURE cdc_sp_comp_tablas_paudit IS

TYPE t_folio_log IS TABLE OF cdc_compara_consulta_paudit.nconencfolio%TYPE;
v_folio_log t_folio_log;

CURSOR c_folios_bd IS
SELECT a.nconencfolio
FROM cdc_compara_consulta_paudit a
, cdc_consulta_encabezado b
WHERE a.nconencfolio = b.nconencfolio
[code].......

I'm using Oracle 9g,

View 10 Replies View Related

User Calls / Executes

Nov 8, 2012

Please explain :

What is the difference between : User calls and executes in

AWR Load Profile :

User calls:     1,373.51     0.80
Executes:      8,558.06     4.98

As i understand , than User calls is : the number of DML (insert , update, Delete and Select ) cursor : parse,execute , fetch , and execute is ?

Why executes > User calls ?

Or may be one pl/sql package procedure may execute many SQL ? How to explain this ?

View 2 Replies View Related

Forms :: Next-record Executes When Validate Triggers Of All Items In Block?

Apr 8, 2013

In one of my form , there is some code "next_record;" in the key-next-item trigger of one field.Here before going to next record, it is executing the WHEN-VALIDATE-TRIGGER of all the items in that record.Is it the default behavior of oracle forms?Can we override this?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved