Re: Slow database

From: Oliver Artelt <oli_at_md.transnet.de>
Date: Tue, 20 Mar 2001 18:08:04 -0800
Message-ID: <F001.002D2598.20010320133050@fatcity.com>

Hi,

it's difficult to help you because we don't know anything about your nightmare skript. Either you do a business/application tuning about these procedures or you can create a ressource plan and drive this with low processor resources.

oli

-- 
Oliver Artelt
Oracle Certified DBA

cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
email: info@cubeoffice.de # web: http://www.cubeoffice.de



Roland.Skoldblom_at_ica.se wrote


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

>

> To: ORACLE-L_at_fatcity.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Oliver Artelt
  INET: oli_at_md.transnet.de

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

Received on Tue Mar 20 2001 - 20:08:04 CST