Oracle Reports Server
The Oracle Reports server component allows for the fast deployment of reports, documents and spreadsheets, all using data from the Oracle database. To achieve this function the Oracle reports server must interface with an Oracle9iAS instance (and Oracle Portal) to manage the incoming report requests and send the completed reports back to the requesting user. To understand the Oracle Reports server, letís take a simple example and following the report steps (figure 1.12).
Invocation - The Reports server is invoked via the end-user entering a URL (or clicking a link on a web page).
Routing - The Oracle9iAS instance intercepts the HTML or XML request, and directs the request to the Reports CGI (or Reports servlets).
Request validation - Oracle reports then parses the HTML or XML request and determines the report and the security rules for the report. If secure, Oracle Reports send an HTML page back to the end-user to accept a user name and password.
Execution - The verified request is then queued for execution in the Reports server. Please note that you can configure multiple runtime engines for each reports server.
Formatting - Upon completion of the execution, the Reports server formats the output as HTML and forwards the completed report to the Oracle9iAS instance.
Delivery - The Oracle9iAS instance then completes the request by sending the completed report to the end-user.
Read more here:
Is your Database Healthy?
Oracle is the worlds most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.
BC has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.
Just call 800-766-1884 to schedule your health check.