Re: Things to change after running Database Configuration Assistant?

Thanks. Can you give me some tips on what I should change in that case when going thru the assistant? I picked custom because I was told that when it asks you for the number of uses, a figure higher than 150 will configure it automatically for high utilization.

JR

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<g5r8ruo7cc2i909ctkkfh6fsj41mhuj8u5_at_4ax.com>...
> On 21 Oct 2002 12:46:50 -0700, jriker1_at_yahoo.com (John) wrote:
>
> >I'm using Windows 2000 with Oracle 8.1.7. I install Oracle without
> >the starter database. Then run the DB Config Assistant, and choose
> >custom. The only changes I make are setting the users into the system
> >to 200, and checking the archive log box. The rest I leave alone. Is
> >there anything else you need to configure when doing this to setup
> >things correctly? Looking at for example the users tablespace,
> >doesn't look like it's set to automatically increase in size as
> >needed.
> >
> >The USERS tablespace thru DBA studio look like the following:
> >
> >Size: 119552KB at 99.79% full.
> >
> >Storage Tab:
> >Initial Size: 128KB
> >Next Size 128 KB
> >Minimum Size 128 KB
> >Increment Size By 0%
> >Minimum Number 1
> >Maximum Number/Value 4096
> >
> >Will these automatically grow as needed? I'm guessing it will as when
> >I open up the properties for a particular tablespace, and highlight
> >the space used, it says "99.78% full with autoextend", but the
> >settings in the proprties bother me when there are settings like
> >Increase Size By 0%.
> >
> >THanks
> >
> >JR
>
>
> Running in custom mode and leaving everything alone doesn't make
> sense.
> Also you don't want to set a tablespace to autoextend. Once your
> datafile hit the maximum limit and/or your disk is full, you really
> are in trouble.
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Oct 22 2002 - 05:14:34 CDT