RE: DB Parameters

Does the table you are deleting has any child table(s)? If yes, then are the foreign keys in the child table(s) indexed?

Guang

-----Original Message-----
Wolfgang Breitling
Sent: Thursday, October 09, 2003 11:34 AM To: Multiple recipients of list ORACLE-L

I was tempted to point to the /*+ _try_harder */ hint (revealed by Jonathan Lewis at this year's IOUG), but that won't be available until Oracle 10. Until then we have to use the old methods of identifying where the time is spent and figure out what can be done to eliminate as much of it as possible.

I have seen deletes take a long time if the table was heavily indexed. Removing the indexes before the delete and rebuilding afterwards was the solution there.

At 02:29 AM 10/9/2003, you wrote:
>Hi List ,
>
>Can you help me please ,
>
>What are the database parameters that i have to increase or modify in
>order to increase the speed of my ddl
>statments ,i have a statment that delete a table with 40000 record but it
>takes about nine hours to accomplish !!!
>
>Is their any parameters on the server that i have to check ??,Increase
>rollback segment is not helpfull at all .
>Iam running oracle 9.2.0.1.0 production .

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).