Re: Table not reusing deleted space

2003-10-03 Thread Kaing, Leng
. --- 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

Re: Table not reusing deleted space

2003-10-03 Thread Daniel Fink
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

2003-10-03 Thread JayMiller
: 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

RE: Table not reusing deleted space

2003-10-03 Thread JayMiller
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

RE: Table not reusing deleted space

2003-10-02 Thread Sinardy Xing
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

Re: Table not reusing deleted space

2003-10-02 Thread Binley Lim
-- -- 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

Re: Table not reusing deleted space

2003-10-02 Thread Daniel Fink
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

RE: Table not reusing deleted space

2003-10-02 Thread Wolfgang Breitling
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

RE: Table not reusing deleted space

2003-10-01 Thread Sinardy Xing
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

Re: Table not reusing deleted space

2003-10-01 Thread Daniel Fink
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

Re: Table not reusing deleted space

2003-10-01 Thread Dave Hau
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

RE: Table not reusing deleted space

2003-10-01 Thread Kaing, Leng
: 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