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).
