RE: Slow database

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: Roland.Skoldblom_at_ica.se

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: 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Diana Duncan
  INET: dduncan_at_arsenaldigital.com

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