Tuning - Report Generation ?

[ggnanaraj]

We have the following setup for pay slip generation...

JSP - front end
Java code - called by JSP
J2EE - application server
Oracle - database.

The application refers 4 tables for the salary information. For 100 employee records, it takes 7 minutes. It calculates the salary for each employee and inserts into a table and then fetches from this table to display in the report.

Any ideas about tuning this further to bring down this 7 minutes? So also, how do you trace this application ?

Do give your valuable suggestions.

Thanks for your valuable time.

Regards.

[Orca777]

Hi,
1) First try to transport the business-logic for calulating to the database in form of oa procedure or even a package.

It seems that the Net-Traffic due to many small SQL'S kill the performance.

2)

ALTER SESSION SET SQL_TRACE =TRUE;

Outside of the session you can enable Tracing :

DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION (

   sid       NUMBER,

   serial#   NUMBER,

   sql_trace BOOLEAN);

Orca