Hi
I was working on few sandboxes on a clover ETL server. I enabled SQL tracing and had to do that for each individual graph. I was wondering is there a way to enable SQL tracing at server level or in other words at global level as a property or something, instead of adding dbexecute components in individual graphs?
Hi,
Could you please be more specific – what “SQL tracing” did you mean? If you meant “Print statement” attribute in DBExecute component, it can only be set on component level.
Hi
What i mean was DB tracing. The below link specifiy what i want to do.
http://www.orafaq.com/wiki/SQL_Trace
http://docs.oracle.com/cd/B10500_01/ser … ltrace.htm
Basically i want to create .trc files, to trace the SQL query and track the efficiency of how DB is being accessed by ETL. I need this to analyze and improve performance of my pages.
One way i was hoping to proceed here was to create a wrapper around the class invoked for initiating DB connection by clover ETL engine and update the trace session there.
Something like, before returning connection back to Clover, execute DB tracing queries. In this case for each sandbox or graph execution tracing will be enabled by default. We can again have a check like threadsafeconnection check to allow user to switch tracing on or off.
Is this a feasible solution?
We are sorry, but since Clover is designed as a generic tool, such a solution would not meet this attribute. Solution with DBExecute component in every single graph should be feasible workaround