Hi there,

Just wondering if anyone experience this.

It took me 10 mins to execute brp.close(i)

My codes are as follow

spool.report = "rwhinh143011XXX"
if isspace(spool.device) then
i = brp.open(spool.report,spool.device,1)
else
i = brp.open(spool.report,spool.device,0)
endif

if i > 0 then
read.main.table()
brp.close(i)
else
choice.again()
endif

start bshell with trace command:
-- -set ORAPROF=0.5
to find, what Oracle Process, takes the time, if Oracle is used.
You will find the file 'oraprof' in the users home or $BSE/tmp. Reproduce the issue and analyze the file to see, which SQL-Statements need more than 0.5 seconds to execute.

Regards
D. Schneider

What was the spool.device? Just wondering if this might impact it some - but not 10 minutes worth of time.

Can you check how many files you have in your tmp directory? If you never clean it up it could be that handling the directory causes the problem.

Regards,
Han

Thanks for everyone who reply, especially Daniel.

I managed to find out the SQL that caused the delay.

brp.close / rprt_close are indications to report indicating stopping of rprt_sends / brp.ready so that report starts it's own processing (like sorting , formating and finally printing ) . If the report prints certain summary information processing lots of detailed lines , brp.close would not go ahead until the report is printed / showed up . This can give a feeling of slow brp.close / rprt_close.