Re: DDL slow, but DML fast.

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 14 Oct 2006 16:29:19 -0700
Message-ID: <1160868555.336705@bubbleator.drizzle.com>

DaLoverhino wrote:
> Hello. We have an outsourced test team that is testing upgrade scripts
> from a previous version of our product to a later version. In the
> course of testing, they would remove multiple times the schema to be
> upgraded. Somewhere along the line, it turns out DDL operations have
> become slower and slower, to the point where it practically hangs. So
> creating users, tables, etc, gets to be practically impossible.
>
> I looked at the script and I couldn't see anything that could possibly
> do anything, some table columns were altered, some tables were created,
> a few indexes are created, some are dropped.
>
> I'm beginning to think that the script itself isn't to blame, and that
> they must have done something else to the instance that they
> overlooked. Does anyone have any suggestions at all as to what might
> be going on? Thanks.

Trace.

But while you are at it consider the possible importance of:

1. Number of simultaneously connected users on the system (even test)
2. Possible contention with any users
3. Version number
4. Available freespace
5. Tablespace type (dictionary or locally managed)

none of which you mentioned.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Oct 14 2006 - 18:29:19 CDT