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 is
le recipients of list ORACLE-L <[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 (Beliz
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.
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. Th
