Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Installing 8.1.7
Ron - Sorry I wasn't clear. There are two alternatives for LMTs, automatic
and uniform. You are entirely correct that there are many possibilities.
Then I discovered the paper: "How to Stop Defragmenting and Start Living:
The Definitive Word on Fragmentation"
http://metalink.oracle.com/cgi-bin/cr/getfile_cr.cgi?239049
This certainly sounded GREAT to me (I found it through the Gennick paper you
reference). That mentions that Oracle has slightly different recommendations
for Oracle8i. I found an Oracle paper "Fragmentation and Data
Reorganization"
http://otn.oracle.com/deploy/availability/htdocs/fragment.html, which
contains the following statements:
Oracle has a number of recommendations: First, set all the extents in a tablespace to the same size (to me that says Uniform). Second, . . . Choose tablespaces for segments based on threerecommended extent sizes, 128k, 4MB, or 128MB.
I believe that both papers are based on the same philosophy. At this point I
am basing my physical layouts based on these two papers, believing that this
represents the direction that Oracle is going. If you or anyone else has
more information to contribute, I am eager to listen.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Friday, September 21, 2001 2:10 PM
To: Multiple recipients of list ORACLE-L
Dennis,
I know that Oracle lists 3 sizes for the LMTbut you can specify any size
extent if you do not use the "auto" feature. I have created a lot of
different LMT extent sizes for tables that are like in size and activity.
That way I have a better handle on the resources especually when the disks
are a premium. Why put an active table initial 50 K next 50 K in a 128K
tablespace. Why not manage the tablespace and make the extents 100 K?
>From the ORAMAG article:"The Autuallocate option allows
Oracle to take control of the extent allocation. Oracle will use extent
sizes of 64KB, 1MB, 8MB, and 64MB to manage space in the tablespace." The
table created in the tablespace will adapt the auto extent policy of the
tablespace and use increasingly larger extents as the table grows in size."
"Locally Managed Tablespaces"
by Jonathan Gennick. located at
http://www.oracle.com/oramag/oracle/00-nov/o60o8i.html
Just a thought.
ROR mª¿ªm
>>> DWILLIAMS_at_LIFETOUCH.COM 09/21/01 12:00PM >>>
Ramon -
-----Original Message-----
Sent: Friday, September 21, 2001 10:40 AM
To: Multiple recipients of list ORACLE-L
Hi folks,
Actually I have 8.0.5 and will install 8.1.7 in the weekend, and would like to have somethings clear.
Actually I have just 2 tablespaces, but planning to make one for each
application system,
will be like 7.
Of course will make all kind of backups, cold, hot including redo logs, password files, parameter files and archives.
What I am planning to do is make an export of the user owner of the all
objects and
make and import in the new DB.
My DB is transactional, not that heavily, like 40 users, but like 12 of them are remote.
Hardware
Compaq
2 Pentium III processor 800 mhz
6 Hard Drive 9.1 GB - raid 5
1 GB Memory
Win 2000 server
Thanks in advance and sure that your help will be very, very useful.
Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do>
Dominican Republic
809-565-3121
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: RROGERS_at_galottery.org 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM 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: 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 Fri Sep 21 2001 - 13:57:12 CDT