subject:"RE\: ALTER TABLE MOVE command causes table to grow"

RE: ALTER TABLE MOVE command causes table to grow

2002-12-20 Thread Khedr, Waleed

Thanks for the follow up

-Original Message-
Sent: Friday, December 20, 2002 3:21 PM
To: Multiple recipients of list ORACLE-L


Just wanted to follow up on this in the unlikely event that anyone was still
wondering.  

In retrospect it seems likely that what caused my table to grow while doing
the Alter Table Move was the same thing that was causing my problem with new
extents being claimed when there was lots of space available in the freelist
(same table).

When the move command was issued I'm guessing that for some rows Oracle
couldn't find a block on the freelist after the first 5 tries that had
enough space for the next row and therefore grabbed another extent.

I'd guess this table is much larger than it needs to be just now.  Once we
upgrade to 9i this tablespace is a definite candidate for an increase in
blocksize...


Jay Miller

-Original Message-
Sent: Thursday, September 05, 2002 1:55 PM
To: Multiple recipients of list ORACLE-L


Jay:

  I would also wonder that the PCTINCREASE was on the table and the indexes.
10% PCTFREE is fine, but does lead to a significant number of empty blocks.
What is your PCTUSED?  If small, you will have lots of free space within
blocks.

  Just a thought.  Don't let your disk person know this happened as they may
try to sell you more hardware.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:ALTER TABLE MOVE command causes table to grow

Had an annoying surprise last week.  A table had grown unexpectedly large
and I scheduled a time over the weekend to move it to its own tablespace
from my "medium" tablespace.  
 
The table ended up growing 50%.  I had anticipated it might grow somewhat
given the PCTFREE of 10% but freeing up that space in the blocks should, at
most, have caused it to grow by 10% (assuming that 10% was completely full).
 
Does anyone have ideas as to why it would have grown by so much?  Indexes
are in a different tablespace and the only other change was from an extent
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
 
Oracle 8.1.7.2
Solaris 2.6
 
Thanks,
Jay Miller
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Khedr, Waleed
  INET: [EMAIL PROTECTED]

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

RE: ALTER TABLE MOVE command causes table to grow

2002-12-20 Thread Miller, Jay

Just wanted to follow up on this in the unlikely event that anyone was still
wondering.  

In retrospect it seems likely that what caused my table to grow while doing
the Alter Table Move was the same thing that was causing my problem with new
extents being claimed when there was lots of space available in the freelist
(same table).

When the move command was issued I'm guessing that for some rows Oracle
couldn't find a block on the freelist after the first 5 tries that had
enough space for the next row and therefore grabbed another extent.

I'd guess this table is much larger than it needs to be just now.  Once we
upgrade to 9i this tablespace is a definite candidate for an increase in
blocksize...


Jay Miller

-Original Message-
Sent: Thursday, September 05, 2002 1:55 PM
To: Multiple recipients of list ORACLE-L


Jay:

  I would also wonder that the PCTINCREASE was on the table and the indexes.
10% PCTFREE is fine, but does lead to a significant number of empty blocks.
What is your PCTUSED?  If small, you will have lots of free space within
blocks.

  Just a thought.  Don't let your disk person know this happened as they may
try to sell you more hardware.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:ALTER TABLE MOVE command causes table to grow

Had an annoying surprise last week.  A table had grown unexpectedly large
and I scheduled a time over the weekend to move it to its own tablespace
from my "medium" tablespace.  
 
The table ended up growing 50%.  I had anticipated it might grow somewhat
given the PCTFREE of 10% but freeing up that space in the blocks should, at
most, have caused it to grow by 10% (assuming that 10% was completely full).
 
Does anyone have ideas as to why it would have grown by so much?  Indexes
are in a different tablespace and the only other change was from an extent
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
 
Oracle 8.1.7.2
Solaris 2.6
 
Thanks,
Jay Miller
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-11 Thread Miller, Jay


Clever thought, but I should have supplied the size before.

It grew from app. 4Gig to app. 6Gig.

That's why I was so surprised, growing 2 Gig during a Move was rather
unexpected.  

-Original Message-
Sent: Tuesday, September 10, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L



I hope this isn't overly simplistic but, is it because of the larger
extent size?

For instance, if it was in 4m extents before and used 26M, it would have
fit in 7 extents with 2M of free space.

But when moved to 25M extents, it would use 2 extents with 24M free
space.

How many segments is the table using, and what's the real size ( ie.
sum(bytes))?

Beth

-Original Message-
Sent: Tuesday, September 10, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


DEGREE=1

-Original Message-
Sent: Monday, September 09, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L


What is the DEGREE setting on the table?

-Original Message-
Sent: Monday, September 09, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L


alter table email_request_queue
move
tablespace ts_email_request
storage (initial 25m next 25m pctincrease 0);

-Original Message-
Sent: Monday, September 09, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


How did you perform the move?  Was the operation done in parallel?

-Original Message-
Sent: Friday, September 06, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly
large 
and I scheduled a time over the weekend to move it to its own tablespace

from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow
somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should,
at 
most, have caused it to grow by 10% (assuming that 10% was completely
full).

  
Does anyone have ideas as to why it would have grown by so much?
Indexes 
are in a different tablespace and the only other change was from an
extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed
tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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

RE: ALTER TABLE MOVE command causes table to grow

2002-09-10 Thread Seefelt, Beth



I hope this isn't overly simplistic but, is it because of the larger
extent size?

For instance, if it was in 4m extents before and used 26M, it would have
fit in 7 extents with 2M of free space.

But when moved to 25M extents, it would use 2 extents with 24M free
space.

How many segments is the table using, and what's the real size ( ie.
sum(bytes))?

Beth

-Original Message-
Sent: Tuesday, September 10, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


DEGREE=1

-Original Message-
Sent: Monday, September 09, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L


What is the DEGREE setting on the table?

-Original Message-
Sent: Monday, September 09, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L


alter table email_request_queue
move
tablespace ts_email_request
storage (initial 25m next 25m pctincrease 0);

-Original Message-
Sent: Monday, September 09, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


How did you perform the move?  Was the operation done in parallel?

-Original Message-
Sent: Friday, September 06, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly
large 
and I scheduled a time over the weekend to move it to its own tablespace

from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow
somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should,
at 
most, have caused it to grow by 10% (assuming that 10% was completely
full).

  
Does anyone have ideas as to why it would have grown by so much?
Indexes 
are in a different tablespace and the only other change was from an
extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed
tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE

RE: ALTER TABLE MOVE command causes table to grow

2002-09-10 Thread Miller, Jay


DEGREE=1

-Original Message-
Sent: Monday, September 09, 2002 8:38 PM
To: Multiple recipients of list ORACLE-L


What is the DEGREE setting on the table?

-Original Message-
Sent: Monday, September 09, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L


alter table email_request_queue
move
tablespace ts_email_request
storage (initial 25m next 25m pctincrease 0);

-Original Message-
Sent: Monday, September 09, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


How did you perform the move?  Was the operation done in parallel?

-Original Message-
Sent: Friday, September 06, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858)

RE: ALTER TABLE MOVE command causes table to grow

2002-09-09 Thread Johnston, Tim


What is the DEGREE setting on the table?

-Original Message-
Sent: Monday, September 09, 2002 4:48 PM
To: Multiple recipients of list ORACLE-L


alter table email_request_queue
move
tablespace ts_email_request
storage (initial 25m next 25m pctincrease 0);

-Original Message-
Sent: Monday, September 09, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


How did you perform the move?  Was the operation done in parallel?

-Original Message-
Sent: Friday, September 06, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

RE: ALTER TABLE MOVE command causes table to grow

2002-09-09 Thread Miller, Jay


alter table email_request_queue
move
tablespace ts_email_request
storage (initial 25m next 25m pctincrease 0);

-Original Message-
Sent: Monday, September 09, 2002 1:54 PM
To: Multiple recipients of list ORACLE-L


How did you perform the move?  Was the operation done in parallel?

-Original Message-
Sent: Friday, September 06, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (note EXACT spel

RE: ALTER TABLE MOVE command causes table to grow

2002-09-09 Thread Johnston, Tim


How did you perform the move?  Was the operation done in parallel?

-Original Message-
Sent: Friday, September 06, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-06 Thread Miller, Jay


No LOBS.  Here's the definition:

 REQUEST_IDNOT NULL NUMBER
 PROFILE_IDNOT NULL NUMBER
 ACCOUNT_IDNOT NULL NUMBER
 TEMPLATE_ID   NOT NULL NUMBER
 GENERIC_DIFFERENTIATORNOT NULL NUMBER
 REQUEST_TYPE  NOT NULL CHAR(1)
 ACCOUNT_NONOT NULL CHAR(8)
 EFFECTIVE_DATENOT NULL DATE
 EMAIL_ADDRESS NOT NULL VARCHAR2(100)
 EMAIL_SUBJECT NOT NULL VARCHAR2(100)
 EMAIL_BODYNOT NULL VARCHAR2(4000)
 STATUSNOT NULL CHAR(1)
 STATUS_CHANGE_DATENOT NULL DATE
 TWEED_SERVER_IDNUMBER
 TWEED_PACKAGE_PRIORITY NUMBER
 TWEED_SENDER_ACCOUNT  NOT NULL VARCHAR2(50)
 TWEED_SCHEDULED_DELIVERY_DATE NOT NULL DATE
 TWEED_CUSTOMER_URLNOT NULL VARCHAR2(255)
 SENDER_SERVER_ID   NUMBER
 SENDER_INSTANCE_ID NUMBER
 CREATE_DATE   NOT NULL DATE
 CREATE_USER   NOT NULL VARCHAR2(35)
 UPDATE_DATEDATE
 UPDATE_USERVARCHAR2(35)


-Original Message-
Sent: Thursday, September 05, 2002 5:23 PM
To: Multiple recipients of list ORACLE-L


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay


Yes, it's from DBA_SEGMENTS.  And there was no DML against the table during
the ALTER TABLE MOVE command which is when it grew.
 
Re the 10% PCT_FREE there's minimal update activity.  It has constant low
level insert activity during the month, then a batch delete at the end of
the month followed by a batch insert at the beginning of the month.  But
even if that wasn't the case how would a low PCT_FREE cause it to grow
during the MOVE command?  I'm not certain I understand what you're aiming at
there.
 
Jay 

-Original Message-
Sent: Thursday, September 05, 2002 3:18 PM
To: Multiple recipients of list ORACLE-L



just to be certain we are on the same page, 
you mention uniform sizing which is on 
the tablespace level, so I want to make 
sure the PCT_INCREASE you provided was pulled 
from dba_segments.  if so then i'd say a bit 
more info would need to have some light shed 
on it persay was there much DML put against 
this table last week.  a PCT_FREE of 10% 
wouldn't be such a good idea for a table 
with varying length column data. 


-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 2:43 PM 
To: Multiple recipients of list ORACLE-L 


pct increase is 0 (uniform sizing) 

-Original Message- 
Sent: Thursday, September 05, 2002 2:00 PM 
To: Multiple recipients of list ORACLE-L 



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
< mailto:[EMAIL PROTECTED]  > ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).


  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
< http://www.orafaq.com  >  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Johnston, Tim


What the table definition?  Are there any LOB's on it?

-Original Message-
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Markham, Richard

Title: RE: ALTER TABLE MOVE command causes table to grow





just to be certain we are on the same page,
you mention uniform sizing which is on 
the tablespace level, so I want to make
sure the PCT_INCREASE you provided was pulled
from dba_segments.  if so then i'd say a bit
more info would need to have some light shed
on it persay was there much DML put against
this table last week.  a PCT_FREE of 10%
wouldn't be such a good idea for a table 
with varying length column data.



-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 2:43 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ALTER TABLE MOVE command causes table to grow



pct increase is 0 (uniform sizing)


-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L




you didn't mention the PCT_INCREASE of this segment. 


-Original Message- 
<mailto:[EMAIL PROTECTED]> ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 



Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).


  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 


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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay


Hi Stephen,

PCT Increase 0, the indexes are in a different tablespace.

PCT Used was 40, I just recently increased it to 75.

Do you know if the MOVE command moves blocks as they currently exist or if
it behaves like an export/import?  If the latter (which was my assumption)
I'd expect that a low PCTUSED would actually shrink the table since each
block in the new tablespace would fill up entirely except for the PCTFREE.

Jay

-Original Message-
Sent: Thursday, September 05, 2002 1:55 PM
To: Multiple recipients of list ORACLE-L


Jay:

  I would also wonder that the PCTINCREASE was on the table and the indexes.
10% PCTFREE is fine, but does lead to a significant number of empty blocks.
What is your PCTUSED?  If small, you will have lots of free space within
blocks.

  Just a thought.  Don't let your disk person know this happened as they may
try to sell you more hardware.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:ALTER TABLE MOVE command causes table to grow

Had an annoying surprise last week.  A table had grown unexpectedly large
and I scheduled a time over the weekend to move it to its own tablespace
from my "medium" tablespace.  
 
The table ended up growing 50%.  I had anticipated it might grow somewhat
given the PCTFREE of 10% but freeing up that space in the blocks should, at
most, have caused it to grow by 10% (assuming that 10% was completely full).
 
Does anyone have ideas as to why it would have grown by so much?  Indexes
are in a different tablespace and the only other change was from an extent
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
 
Oracle 8.1.7.2
Solaris 2.6
 
Thanks,
Jay Miller
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Miller, Jay


pct increase is 0 (uniform sizing)

-Original Message-
Sent: Thursday, September 05, 2002 2:00 PM
To: Multiple recipients of list ORACLE-L



you didn't mention the PCT_INCREASE of this segment. 

-Original Message- 
 ] 
Sent: Thursday, September 05, 2002 12:09 PM 
To: Multiple recipients of list ORACLE-L 


Had an annoying surprise last week.  A table had grown unexpectedly large 
and I scheduled a time over the weekend to move it to its own tablespace 
from my "medium" tablespace.  
  
The table ended up growing 50%.  I had anticipated it might grow somewhat 
given the PCTFREE of 10% but freeing up that space in the blocks should, at 
most, have caused it to grow by 10% (assuming that 10% was completely full).

  
Does anyone have ideas as to why it would have grown by so much?  Indexes 
are in a different tablespace and the only other change was from an extent 
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
  
Oracle 8.1.7.2 
Solaris 2.6 
  
Thanks, 
Jay Miller 
  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
  
-- 
Author: Miller, Jay 
  INET: [EMAIL PROTECTED] 

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: [EMAIL PROTECTED] (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.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Karniotis, Stephen


Jay:

  I would also wonder that the PCTINCREASE was on the table and the indexes.
10% PCTFREE is fine, but does lead to a significant number of empty blocks.
What is your PCTUSED?  If small, you will have lots of free space within
blocks.

  Just a thought.  Don't let your disk person know this happened as they may
try to sell you more hardware.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject:ALTER TABLE MOVE command causes table to grow

Had an annoying surprise last week.  A table had grown unexpectedly large
and I scheduled a time over the weekend to move it to its own tablespace
from my "medium" tablespace.  
 
The table ended up growing 50%.  I had anticipated it might grow somewhat
given the PCTFREE of 10% but freeing up that space in the blocks should, at
most, have caused it to grow by 10% (assuming that 10% was completely full).
 
Does anyone have ideas as to why it would have grown by so much?  Indexes
are in a different tablespace and the only other change was from an extent
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
 
Oracle 8.1.7.2
Solaris 2.6
 
Thanks,
Jay Miller
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Karniotis, Stephen
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Markham, Richard

Title: RE: ALTER TABLE MOVE command causes table to grow





you didn't mention the PCT_INCREASE of this segment.


-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 05, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Subject: ALTER TABLE MOVE command causes table to grow



Had an annoying surprise last week.  A table had grown unexpectedly large
and I scheduled a time over the weekend to move it to its own tablespace
from my "medium" tablespace.  
 
The table ended up growing 50%.  I had anticipated it might grow somewhat
given the PCTFREE of 10% but freeing up that space in the blocks should, at
most, have caused it to grow by 10% (assuming that 10% was completely full).
 
Does anyone have ideas as to why it would have grown by so much?  Indexes
are in a different tablespace and the only other change was from an extent
size of 4 meg to one of 25 meg.  Both are dictionary managed tablespaces.  
 
Oracle 8.1.7.2
Solaris 2.6
 
Thanks,
Jay Miller
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Miller, Jay
  INET: [EMAIL PROTECTED]


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: [EMAIL PROTECTED] (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).

Re: ALTER TABLE MOVE command causes table to grow

2002-09-05 Thread Jeffrey Beckstrom



But 
that's 10% per block.  If all of the blocks had used the pctfree area then 
would have a lot of growth.>>> [EMAIL PROTECTED] 
9/5/02 12:08:30 PM >>>Had an annoying surprise last week.  A 
table had grown unexpectedly largeand I scheduled a time over the weekend to 
move it to its own tablespacefrom my "medium" tablespace.  The 
table ended up growing 50%.  I had anticipated it might grow 
somewhatgiven the PCTFREE of 10% but freeing up that space in the blocks 
should, atmost, have caused it to grow by 10% (assuming that 10% was 
completely full).Does anyone have ideas as to why it would have grown by 
so much?  Indexesare in a different tablespace and the only other 
change was from an extentsize of 4 meg to one of 25 meg.  Both are 
dictionary managed tablespaces.  Oracle 8.1.7.2Solaris 
2.6Thanks,Jay Miller-- Please see the official ORACLE-L 
FAQ: http://www.orafaq.com-- Author: 
Miller, Jay  INET: [EMAIL PROTECTED]Fat City Network 
Services    -- (858) 538-5051  FAX: (858) 538-5051San 
Diego, California    -- Public Internet 
access / Mailing 
ListsTo 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from).  You mayalso send the HELP command for 
other information (like subscribing).

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

RE: ALTER TABLE MOVE command causes table to grow

Re: ALTER TABLE MOVE command causes table to grow

17 matches

Site Navigation

Mail list logo

Footer information