Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Reorganizing tables

RE: Reorganizing tables

From: BALA,PRAKASH (HP-USA,ex1) <prakash.bala_at_hp.com>
Date: Mon, 24 Mar 2003 11:32:52 -0800
Message-Id: <24765.322916@fatcity.com>


Hi Dennis,

Let me try to answer part of question#1. We only deal with warehouse applications. So there are only inserts and updates.

All tablespaces are LMTs and I use 3 extent sizes (128K, 4M and 32M).

I do not mix the staging (insert and truncate) tables and the normal tables in the same tablespace.

Once I month, I run a job for tables in 128K and 4M tablespaces to see whether I need to promote them to a higher extent size. If so, I export, drop, recreate and import in a new tablespace. I do not use the 'alter table ... move ...' command since it retains the old extent size for the very 1st extent in the new tablespace.

I have your other questions in my 'to do' list but have not got time to work on them yet.

Thanks
Prakash

-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM] Sent: Monday, March 24, 2003 12:39
To: Multiple recipients of list ORACLE-L Subject: Reorganizing tables

We have a new manager, and at his last employer the DBAs reorganize Oracle tables on a regular basis. I don't reorg tables on a regular basis. He is lobbying us to investigate this and test whether it would or wouldn't increase performance. We are on Oracle 8.1.6, Compaq Tru64, all tables are LMT with uniform extents. This is an OLTP system, but the users continue to add reports and the reports do quite a few full table scans. The reports are probably the critical performance issue at this time.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).
Received on Mon Mar 24 2003 - 13:32:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US