Re: OAS report server sometimes does not create reports

Indeed, the PL/SQL engine can be in Oracle forms or reports. I wish it offered something equivalent to dba_* and v$* views, an easy way to monitor its working mechanism.

For now, I'll write a cron job (in addition to another one that creates a dummy report) to run strace on all report server processes. If the output has strings like ORA-4020 or deadlock, it emails me.

Yong Huang

• On Wed, 9/5/12, Radoulov, Dimitre <cichomitiko_at_gmail.com> wrote:

> comments from the link you posted:
>
>> Does the report server implement its own
>> sophiscated RDBMS engine,
>> or at least the library cache locking mechanism?)
>
> Oracle Forms has its own PL/SQL engine:
>
> PL/SQL Engine
>
> The PL/SQL compilation and run-time system is an engine that
> compiles and executes PL/SQL units.
> The engine can be installed in the database or in an
> application development tool, such as Oracle Forms.
>
> goo.gl/sENRd
>
> Regards
> Dimitre

--
http://www.freelists.org/webpage/oracle-l