Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database creation is slow w/ 8.1.6 & Linux
If you are using the dbassist, it will of course do everything in one shot,
which means:
creating hundreds of views, grants, synonyms and packages. This is
definitely not going to complete in a few minutes. Also the create database
itself is not going to complete in a few minutes as all the files are zeroed
out, not just created.
And, finally, most likely you are running with the default Oracle
parameters. And yes, especially if you don't need Java, they are wrong:
db_block_buffers to small, shared_pool_size to small, java_pool_size too big
(20M). You're probably looking at excessive paging, don't you.
Just a few hints, as your post doesn't contain any conclusive clues, regrettably.
Hth,
Sybrand Bakker, Oracle DBA
"Steven L. Dahlin" <sdahlin_at_micron.net> wrote in message
news:39E9BB23.1CD7DACB_at_micron.net...
> I am having a problem with the database creation with Oracle 8.1.6 on a
> RedHat Linux 6.2 box. The process is running slow, I mean REALLY slow.
> In fact I kill the process before it finishes. This is the case whether
>
> I use dbassist or run the script it can creat. I was thinking one of
> the kernel parameters might be too low, or that running X and dbassist
> on the same box might put a strain on resources, but I cannot imagine
> things could be this slow.
>
> The box is a 240 Mhz K6 with 128Mb of Ram. The kernel parameters are as
>
> follows:
>
> SHMMAX 0x8000000 (though I am considering dropping it to 0x4000000)
> SHMMIN 1
> SHMMNI 100
> SHMSEG 10
>
> SEMMNI 128
> SEMMSL 250
> SEMMNS (SEMMNI*SEMMSL)
> SEMOPM 100
> SEMVMX 32767
>
> Does anyone have any suggestions (yes I know the box is a little slow
> but it is all I can devote to the task right now)? The strange thing is
>
> that when I had this setup with Oracle 8.0.5 on Redhat 6.0 I had no such
>
> problems.
>
> Thanks,
> Steve
>
>
>
>
>
Received on Sun Oct 15 2000 - 14:40:16 CDT