| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Slow database
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: Roland.Skoldblom_at_ica.se
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Tue Mar 20 2001 - 02:29:07 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |