Web Development

Ask something
Discussion Locked

Oracle Report Background Engine

0 helpful
1 reply

by shsaifee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When any user runs an Oracle Report, The Oracle Report Background Engine opens, it remains open even after the user has closed the report. Due to this the report Background Engine resides in the memory. And due to this the share of memory which should be available to other users is not free and the system performance deteriorates.

Is there any method by which the Oracle Report Background Engine can be closed when the user closes the report?

1 reply

by gary_w

Yes, add the ORACLE_SHUTDOWN parameter to your paramter list when calling the report.

Add_Parameter(pl_id,'ORACLE_SHUTDOWN',TEXT_PARAMETER,'Yes'); -- 'Yes' must be mixed case!

Gary

This discussion is closed to new replies.