Re: OAS report server sometimes does not create reports
- From: Yong Huang <yong321@xxxxxxxxx>
- To: DimitreRadoulov <cichomitiko@xxxxxxxxx>
- Date: Fri, 7 Sep 2012 10:39:41 -0700 (PDT)
Resend:
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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
