Hi DBA's,
I've been trying to isolate the bottleneck with our Oracle database.
I work as an Oracle DBA for the Government of a developing country (Belize).
Recently, as it is income tax time, the department has to reconcile all
witholdings by the employer with their payment receipt
records.
Denmark Weatherburne wrote:
I know tuning the SQL might be required, however, I don't have much
experience in this area. The SQL statemements were written by consultants
who have long left. We do have the source code though.
Ak for your money back. You are right, usually SQL is the reason.
[EMAIL PROTECTED] cc: bcc: Subject: Please help resolving report generation performance problem... Hi DBA's,I've been trying to isolate the bottleneck with our Oracle database.I work as an Oracle DBA for the Government of a developing country (Belize).Recently, as it is income tax time
Denmark,
Sifting through the clues in your email, it is almost dead certain that the
SQL statements in your overnight reports must be tuned. Adding rollback
segments has no effect on reports (usually). Modifying initialization
parameters is unlikely to affect such specific problems also.
To