Re: Please comments This Tablespace Setup

[Quoted] Don't agree on autoextent; adding datafiles manually is even more firefighting,
but let's leave that for discussions at the fireplace, over a good glass, enjoying
a fine cigar...

[Quoted] I opt for: initial: 16k (twice your blocksize: 1 header, 1 datablock) reason: small (reference kind of) tables fit nicely in 1 initial extent. next: depends on your largest tables, anything from 128k to 1280k to 12M, but keep
it with just two or three tops.
Reason: allocating extents is perfomance releated. pctincrease: 0; reason better performance (what's easier for the Oracle process:
building a house with similar shaped stones or all different?)

[Quoted] Fragmentation, or extents ar enot worrying (anymore, since 7.3), nor bad for performance.
[Quoted] Allocating extents is bad for performance...

[Quoted] I don't understand your 5 files... either these were made too big to start with, or
for some reason, only file 5 is being used. With autoextent ON, why bother having 5 files
for one tablespace??? Or is maxsize set as well? What was the reason for having 5 datafiles
for one tablespace?

[Quoted] BTW, 505 extents max is default for 8k (249 for 4k, 121 for 2k blocksize) Which brings up: why go for 8k? OLTP has 2k - 8k, DSS/DW 8k - 32k. 8k seems hybrid.

--
[Quoted] Kind Regards,
Frank
"Howard J. Rogers" <howardjr_at_www.com> wrote in message
news:39756ac3_at_news.iprimus.com.au...


>

> Johnson <syner_at_pd.jaring.my> wrote in message


> news:8l3o2p$bg2$1_at_news5.jaring.my...

> > Hello DBA,

> >

> > Please comment on this tablespace (Mydata) setup, running in NT, with

> > db_block_size = 8k. Do I need to fine tuning or rezise it? Since I put

 the


> > autoextent = ON.

> > --------------------------------------------------------


> >

> > Tablespace storage statistic

> > -Total block : 284160

> > -Used Block : 283526

> > -Free : 634

> >

> > This tablespace is having 5 datafiles :

> > - Data1 - 75520 Blocks

> > - Data2 - 20480 Blocks

> > - Data3 - 12800 Blocks

> > - Data4 - 12800 Blocks

> > - Data5 - 162560 Blocks

> >

> > The default storage

> > - Initial - 40960

> > - next - 40960

> > - Min Ext - 1

> > - Max Ext - 505

> > - Pct increase - 50

> >

>

>

> PCTINCREASE should never be anything other than zero (fragmentation).

> MAXEXTENT of 505??  Unusual number...but regardless, for optimal

> performance, no segment should ever have more than half a dozen extents.

>

> Incidentally, the autoextend clause should never be specified unless you

 are


> opting out of continually monitoring your database and doing *proactive*


> management, instead of mere firefighting.

>

> Regards

> HJR

>

>

> > Thanks for you comment.

> >

> >

> >

> >

>

>