Maybe the "big" process is not doing intermittent commits, and is straining
the rollback segments?
Have you checked the growth and skew of your indices?
Have you checked whether you can disable the indices while the process is
running, then enable them?
Is it doing inserts or updates or both?
Does the code have scary SQL in it?
Are you using SQL*Loader, and if not, why not? You may be able to do a
"direct path" load.
You need to take a look at the statistics for the SQL it is running to
identify any poorly performing statements, then tune them. That will
probably be the biggest bang for your buck.
Sorry I can't be more explicit without more information...
Diana
-----Original Message-----
Sent: Tuesday, March 20, 2001 2:26 AM
To: Multiple recipients of list ORACLE-L
Hallo all you experts,
I have an Oracle database, every night it is read many files into the
database, but all the procedures take so long, it keeps taking all the next
day almost.
It shouldnt do that, because the system is very slow because of this. When I
run other things during the day, many things are slow, for instance when i
delete 1000 rows it shouldnt take one hour, which it takes while the "big"
process is running. Do
you have any suggestion what I should do to trace the whole problem?
When i delete 1000 rows during "low"-time, then it just take a few seconds
to delete the records.
Hope anyone can help me with suggestions.
Roland Sköldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Diana Duncan
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
