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

Home -> Community -> Usenet -> c.d.o.server -> Re: How can i change the MAXEXTENTS ??

Re: How can i change the MAXEXTENTS ??

From: John P. Higgins <jh33378_at_deere.com>
Date: Thu, 06 Aug 1998 20:32:49 -0500
Message-ID: <35CA5940.EBE9428D@deere.com>

James C. Specht, Jr. wrote:

> Thomas Kyte wrote:
> >
> > A copy of this was sent to ashesh48_at_my-dejanews.com
> > (if that email address didn't require changing)
> > On Thu, 06 Aug 1998 17:17:33 GMT, you wrote:
> >
> > >Hi All, I got into the problem with the MAXEXTENTS of the table. It has
> > >reached to its maxlevel of the 121/121. How can I increase it?? Has anybody
> > >know the syntex for it ? How it affects to performace? And what is the
> > >recommanded number oof extents for a table??
> > >
> > >Thanx for any help in advance.
> > >Ashesh
> > >
> > >-----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
> > What version of Oracle? Try:
> >
> > SQL> alter table <TNAME> storage ( maxextents unlimited );
> >
> > or use some other number in place of unlimited.
> >
> > As long as your extent size is a multiple of your db_file_multiblock_read_count,
> > having 1, 100 or 1000 (or more) extents is pretty much the same.
> >
> >
> > Thomas Kyte
> > tkyte_at_us.oracle.com
> > Oracle Government
> > Herndon VA
> >
> > http://govt.us.oracle.com/ -- downloadable utilities
> >
> > ----------------------------------------------------------------------------
> > Opinions are mine and do not necessarily reflect those of Oracle Corporation
> >
> > Anti-Anti Spam Msg: if you want an answer emailed to you,
> > you have to make it easy to get email to you. Any bounced
> > email will be treated the same way i treat SPAM-- I delete it.
>
> I have been told that you should keep you extents at 1. The more
> extents you have the slower your responses get. It is even discussed in
> the Oracle Admin Guide. Am I wasting my weekends resizing tables to
> keep myself at 1 extent?

  Check out http://www.europa.com/~orapub/papers/abs101.html Avoiding A Database Reorganization

Oracle guru Craig A. Shallahamer wrote this to expose the myth of fragmentation related performance problems. Received on Thu Aug 06 1998 - 20:32:49 CDT

Original text of this message

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