I'm trying out the ENABLE STATEMENT LOGGING feature and I'm finding that long running SCRIPTs are not being logged. Is that the case or am I missing something?
I am using version 2.31 Build 4.
Thanks,
Kevin

Kevin,

<< I'm trying out the ENABLE STATEMENT LOGGING feature and I'm finding that long running SCRIPTs are not being logged. Is that the case or am I missing something? >>

Yes, the statement logging only applies to individual SQL statements, not to scripts.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim. Any chance we can get scripts included in the future? Or are individual statements in scripts logged?

Kevin,

<< Thanks Tim. Any chance we can get scripts included in the future? Or are individual statements in scripts logged? >>

The individual statements in the script are logged, and it is assumed that the rest is easily-diagnosed.

The reason why statements are log-able in the first place is because the query optimizer could potentially make bad decisions, or the data could grow and result in statements that no longer work well within a given timeframe.

Tim Young
Elevate Software
www.elevatesoft.com

Tim,
I just tried a quick test. Ran a 'slow query', which got logged as expected. I took the same query and stuck it in a script, (e.g. Execute Immediate 'slow query') and in that case, the query was not logged.
Thanks,
Kevin

Kevin,

<< I just tried a quick test. Ran a 'slow query', which got logged as expected. I took the same query and stuck it in a script, (e.g. Execute Immediate 'slow query') and in that case, the query was not logged. >>

Yes, you're correct - the script progress is effectively "hiding" the execution time for the query because EDB isn't interested in the individual query execution times in a script (at least not from the standpoint of the overall elapsed time for the script).

I'm going to need to add a new layer of progress updating to the query execution in the scripts, and this will be fixed in the next 2.3` build 5.

Tim Young
Elevate Software
www.elevatesoft.com

<< fixed in the next 2.3` build 5. >>

Sorry, typo - 2.31 Build 5.

Tim Young
Elevate Software
www.elevatesoft.com

Thanks Tim!