Re: Init.ora modification and problem.

Hi

300000 Isn't an error. V_$sgastat give always 300000 of free memory. My Database is not running with big objects. problem is not here.... Info: i've pinned many packages (STANDARD, DBMS_SQL, DBMS_APPLICATION_INFO) ...

I want to do this:
large_pool_size=300000 (I think it's ok) shared_pool_size=81920000 (I think it's ok) hash_multiblock_io_count=8 (??) # (i doubt now) db_block_lru_latches=4 (??) #because 4 processors, it's correct optimizer_index_caching=99 (I think it's ok)

for information
optimizer_index_caching=50 # it's actual value, i think it's not very good in 8.1.7
up to 99
optimizer_index_cost_adj=25 # it's actual value, i think it's not very good in 8.1.7
no change for the moment

Do you know how to calculate stripe length ? Bay one!
disk1(10Go) disk 2(40Go) disk 3(20Go) Total capacity = 70 Go

Bay two in hard mirror
disk1(10Go) disk 2(40Go) disk 3(20Go) Total capacity = 70 Go

in this sample it's 3 ?

for 8 disk ... it's 8 ?

Bests regards and thanks
Epicentre Team A

"Mihail Daskalov" <mdaskalo_at_tlogica.com> wrote in message news:9f9e62ec.0208241505.62cc7462_at_posting.google.com...
> "Epicentre team A" <oracle_at_epicentre.fr> wrote in message
news:<ak7jj9$n9e$1_at_wanadoo.fr>...
> > Hi
> >
> > I want to change parameter file but when massives imports via Sql Loader
> > import stop about 15 minutes. There is importants core dump errors.
> > On server no problem with pagging or swapping operations (normal)
> >
> > Platform: HP-UX
> > Oracle Enterprise 8.1.7
> > Ram 2 Go
> > Raid 1
> >
> >
> >
> > Before change we have.
> >
> > db_files=200
> > large_pool_size=614400
> > shared_pool_size=80485760
> > hash_multiblock_io_count=0
> > db_block_lru_latches=2
> > cursor_sharing_force=exact
> > optimizer_index_caching=50
> >
> > After Change it's
> >
> >
> > db_files=150
> > large_pool_size=300000
> > shared_pool_size=81920000
> > hash_multiblock_io_count=8
> > db_block_lru_latches=4
> > cursor_sharing_force=force
> > optimizer_index_caching=99
> >
> >
> > I've you an idea ?
> > Denis Jeanneret
>
>
>
> Please return
> cursor_sharing parameter to exact.
>
> It can cause a lot of problems (due to various bugs).
> You didn't indicate which version of Oracle 8.1.7 do you have.
> If you have the base release (8.1.7.0.0) I would advise you to upgrade
> your Oracle Server to 8.1.7.4 version.
>
> Your setting of
> large_pool_size=300000
> (if it is not a typographical error, is very bad IMO).
> Please either set it to 0, or set it to something quite larger e.g.
> 50000000.
> You say you have 2GB of RAM. Probably you could increase your
> db_block_buffers to a quite large value. You don't show what your
> current value is,
> but if you don't have any other databases you can set it to
> (640MB / db_block_size).
>
> Another possible problem on the OS level could be setting maxdsiz too
> low. I think by default it is 64MB, which is los. I thing the value of
> maxdsiz is given in blocks of 512 bytes. For more detail you need to
> see your HP-UX documentation.
>
> Next time please give more details about the errors.
> About the operating system, and version of Oracle.
>
> HTH,
> Mihail Daskalov,
> Brainbench MVP for Oracle Admin
> http://www.brainbench.com
Received on Sun Aug 25 2002 - 06:33:33 CDT