.
---
From: Daniel Fink [EMAIL PROTECTED]
Date: Wed, 01 Oct 2003 07:53:14 -0600
Subject: Re: Table not reusing deleted space
This is a multi-part message in MIME format.
--D366F924536517C4833C5849
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
07:53:14 -0600
Subject: Re: Table not reusing deleted space
This is a multi-part message in MIME format.
--D366F924536517C4833C5849
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Leng,
I recall a similar scenario some months ago. It had to do
: Re: Table not reusing deleted space
This is a multi-part message in MIME format.
--D366F924536517C4833C5849
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Leng,
I recall a similar scenario some months ago. It had to do with the average
row size (quite large
not reusing deleted space
This is a multi-part message in MIME format.
--D366F924536517C4833C5849
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Leng,
I recall a similar scenario some months ago. It had to do with the average
row size (quite large) and the block
From: Sinardy Xing [EMAIL PROTECTED]
Date: Wed, 1 Oct 2003 14:51:40 +0800
Subject: RE: Table not reusing deleted space
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
--
--
From: Sinardy Xing [EMAIL PROTECTED]
Date: Wed, 1 Oct 2003 14:51:40 +0800
Subject: RE: Table not reusing deleted space
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
1841134958 51269912100
1528
From: Sinardy Xing [EMAIL PROTECTED]
Date: Wed, 1 Oct 2003 14:51:40 +0800
Subject: RE: Table not reusing deleted space
Hi Kaing,
Have you check
CONNECT_TASK 1841134958 512699
12100 1528
From: Sinardy Xing [EMAIL PROTECTED]
Date: Wed, 1 Oct 2003 14:51:40 +0800
Subject: RE: Table not reusing deleted space
Hi
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
-Original Message-
Sent: 01 October 2003 14:20
To: Multiple recipients of list ORACLE-L
Hello everyone,
Env: 8.1.7.4, SunOs 5.8 64 Bit
We seem to hitting bug 1262161. The bug seems to
Leng,
I recall a similar scenario some months ago. It had to do with the average row size
(quite large) and the block size. The average row size was just under 1/2 of the block
size, so the chances of a new row finding a spot in an existing block was slim. Add in
that there is a limit (5 I
Hi Leng,
You mentioned that the table is subject to high insert, update and
delete activity. Is it possible that the high watermark of the table
has in fact been growing, even though the steady state size is around
200K rows? Since deletes don't actually shrink the size of a table
(only
: Wed, 1 Oct 2003 14:51:40 +0800
Subject: RE: Table not reusing deleted space
Hi Kaing,
Have you check the degree of fragmentation?
have you check your extent size?
Sinardy
--
Leng Kaing
Email: [EMAIL PROTECTED]
Phone: +61-3-9203-7589
Hello everyone,
Env: 8.1.7.4, SunOs 5.8 64 Bit
We seem to hitting bug 1262161. The bug seems to imply that tables with triggers
behind them do not reuse blocks on the freelist. We have a table that should only use
1G (num_rows * avg_row_len), but is actually using 4.1G and growing in size!! It
13 matches
Mail list logo