When creating new database with DBCA it's take 3 hours!!

[Giel Smits]

When I create a new db with oracle 9i.
it take three hours..

when I do a sar ==> disk usage is very high
and swapinfo -t ==> 78&. ..
So it' really matter of performance..

Question : Im new to oracle ..
I want a tiny database (just for testing)
What should the init.ora read?

My system has 512 mb is a C3000 s700 visualize workstation.

When I do dmesg.. it says mlock_region failed
But /etc/privgroup is set correctly I beleave

==> dba RTPRIO RTSHED MLOCK CHOWN

user oracle has group dba as default group.

Thanx in advance!!

[Giel Smits]

Hi, Here's /stand/system.. hope that's okay.

Note : is is a C3000 machine with 512mb memory.

Kernel parms:
---------------------* Tunable parameters

STRMSGSZ 65535
bufpages (NPROC*3)
dbc_min_pct 20
default_disk_ir 1
max_thread_proc 256
maxdsiz 1073741824
maxdsiz_64bit (MAXDSIZ*2)
maxfiles 2048
maxfiles_lim 2048
maxssiz 134217728
maxssiz_64bit 0X040000000
maxswapchunks 4096
maxuprc 3686
maxusers 300
maxvgs 80
msgmap (NPROC+2)
msgmax 32768
msgmnb 65535
msgmni (NPROC)
msgseg (NPROC*4)
msgssz 128
msgtql (NPROC)
ncdnode 200
ncsize ((8*NPROC+2048)+VX_NCSIZE)
nfile 34816
nflocks 4096
nhtbl_scale 1
ninode 40000
nproc 4096
npty 400
nstrpty 400
nstrtel (MAXUSERS)
nswapdev 25
semmap ((NPROC*2)+2)
semmni (NPROC*2)
semmns 16384
semmnu (NPROC-4)
semume 64
semvmx 32768
shmmax (0X40000000/2)
shmmni 512
shmseg 32
swapmem_on 0
timeslice 1
vps_ceiling 64

[harry d brown jr]

Geil,

I had a Sun Solaris 10K box that took 6 hours. I'd also be interested in "how" to speed up the "process".

live free or die
harry

[Bill Thorsteinson]

When you install Oracle
you can install a prebuilt
database. This is the
fastest way to get a testing database.

You can also create a database
by cloning an existing
database. The documentation
on cloning had been incomplete, but a few people
have placed info on the net.

I have found it is faster
to use the generate scripts
option than to use the
interactive tool.

[Jeanine Kone]

When you say you want a small database, you need to be concerned not only with the init.ora which will determine how much memory is used, but also with the actual create database command and what tablespaces and datafiles are being created. If you create a tablespace with a large datafile, it will take longer than using a small datafile. You may want to check on how much disk space (i.e. in datafiles) are being allocated to system, temp, rollback, tools, and user tablespaces.

Jeanine

[Aashish Raj]

hi,

you can manually create the database as using DBCA will run scripts for all the options(context,java) even if you do not need one.

you can use the default init.ora which has come with the oracle installation.just change the db_name,control_file parameter in it .

if your db_name is test mv init.ora to inittest.ora
and do the following
log in as oracle
$export ORACLE_SID=test
$sqlplus internal
sql>create database test
datafile '/oradata01/test/system01.dbf' size 200m
logfile
group 1('/oradata01/test/log1a.log') size 1m,
group 2
('/oradata01/test/log2a.log')
size 1m
maxdatafiles 50 ;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

This will create a test database and now you can create tablespaces for rollback,temp,and data.

thanks
AR

[Giel Smits]

Okay.. Thanx guys..

Last question..
Are the SGA default values in init.ora
okay... or should i increase/decrease some
settings??

Thanx.

[Ryan Kogelheide]

A big chunk of the time is the dbca loading the jserver. If you don't need smtp/tcp/aq, you can avoid this option.

Note also that jserver needs an additional 20M of memory added to the shared pool.

Strangely enough, an oracle rep once told me that DBCA is the better choice - even for experts.

For memory config of a small simple db on a workstation, keep db_block_buffers max 10% of your system memory and set your shared pool to about 30M for non-jserver and 50M for jserver.

[Eileen Millen]

The timeslice should be 10.
You must have used the database template when
the kernel was built.
Eileen