Home » Developer & Programmer » Data Integration » Regarding default select clauses executing during OWB Mapping execution - (OWB 11gR2)
Regarding default select clauses executing during OWB Mapping execution - [message #475034] Sat, 11 September 2010 02:56
jeevanrag
Messages: 1
Registered: September 2010
Junior Member
All-

While observing the statements executing during an OWB(11gR2) Mapping execution,by monitoring the session using SQL Developer

Iam finding the following statements executing multiple times and possibly consuming more of the mapping execution time:-
SELECT MAX(EXECUTION_AUDIT_ID) FROM ALL_RT_AUDIT_MAP_RUNS WHERE MAP_NAME = :B1

SELECT SYS_CONTEXT('owb_workspace' , 'workspaceID' ) FROM DUAL

SELECT nvl2(translate(20040101, 'A1234567890','A'), 'F', 'T') FROM DUAL

SELECT USER FROM SYS.DUAL
These statements have no relation to be business logic being implemented.And seem to be generated by OWB default settings.
Can anyone please let me know how to reduce the frequencey of the above mentioned statements or if possible remove them from the OWB mapping execution.

So that the mapping would run more faster
Previous Topic: Locations still 10.2 after export/import to 11.2.0.1
Next Topic: ORA-00955 when deploying a table
Goto Forum:
  


Current Time: Thu Mar 28 10:20:02 CDT 2024