Runtime

[Marciel]

Is there any time to get the runtime of a report (Reports 6i)?

[dr_gori]

Maybe you can save in a variable the time that started the report. (at the Trigger Before_report. And in the end, it saves the time that ended at After_Report.

So do whatever you want with the difference. It must be time. (I have not tested, but it should work )

[Marciel]

DR_GORI,

The Trigger After_Report is triggered by closing the report, and not when finishing the execution (at least in Reports 6i is so). Does not work.

I tried to get the final time in a formatting trigger, but it also goes wrong. The first page is formatted before the execution of Query (strange, I know ...).


Do you have any other suggestions? Maybe there is any oracle function that you do this?

[dr_gori]

Try set the Data Sysdate in a report group variable from the report.
Hence you use this variable in After_report. Theoretically, whatever has this variable will be the end date. (Again, I did not test this - it's just an idea): - /

[Marciel]

Because it's expensive, it does not work either. Reports does not obey the logical order "Executes Query-> Report Format". It performs and formats in parallel.

The Trigger After_Report is only fired when the report is closed, no chance to use it.

You can pick up the start time, for example by the Trigger after_parameter_form. The hard thing is to get the end time.

[dr_gori]

My ideas so ended
But see, take a look at this tuning document, which there is how to measure the time of a report.
Just do not help if you want this count in time of time execution, type, to maintain a history.
http://en.glufke.net/oracle/download/27 ... tuning.pdf

[Marciel]

Well ... I would really like to put the runtime in the body of the report, for the user to keep control. But it already helps me. It cost.

[Marciel]

Has anyone ever used the SRW.TRACE_START function at Reports 6i? I am trying to use as follows:

Select all

 
function BeforeReport return boolean is 
    x varchar2(40); 
begin 
    srw.get_report_name(x); 
    --srw.do_sql('alter session set sql_trace true'); 
    srw.traceopts.mask := srw.trace_prf; 
    srw.trace_start(x || '.log', srw.trace_replace, srw.traceopts); 
    return (TRUE); 
end; 
 
function AfterReport return boolean is 
begin 
    srw.trace_end; 
    return (TRUE); 
end; 

... But when running the report closes alone without giving any error message.

[Marciel]

DR_GORI,

This tip has already helped, but there is still a problem: the time is marked between the start of the execution and the closing of the report. If the user stays half an hour with the report open, this time is counted.

Well, I think it's the best it can be done. I just put it right here to register.

If someone can use the srw.trace_start () function, or know the reason why it does not work, please post it here. Can it be by connecting to a 10G bank where this function was "deprecated"?