Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: memory problem
"Mario Clynen" <mario.clynen_at_ixsys.net> wrote in message
news:8ia9vf$od6$1_at_news0.skynet.be...
> A print of my initORCL.ora :
>
> db_name = dbname
> instance_name = ORCL
> service_names = dbname
> control_files = ("/opt/oracle/dbs/oradata/dbname/control01.ctl",
> "/opt/oracle/dbs/oradata/dbname/control02.ctl")
> java_pool_size = 20971520
Well, you've been given the default 20M of Java Pool, which it is highly unlikely you'll need at this stage of the game. Reduce that to something trivial (last time I tried, I was unable to actually set it to zero, but from memory, I think 4K worked)
> log_checkpoint_interval = 10000
> log_checkpoint_timeout = 1800
> rollback_segments = (r01, r02, r03, r04)
> background_dump_dest = /opt/oracle/admin/dbname/bdump
> core_dump_dest = /opt/oracle/admin/dbname/cdump
> user_dump_dest = /opt/oracle/admin/dbname/udump
> db_block_size = 2048
Ridiculous block size. If you haven't created a database yet, change it -preferably to 16K
> remote_login_passwordfile = exclusive
> os_authent_prefix = ""
> job_queue_processes = 0
> job_queue_interval = 60
> distributed_transactions = 10
> open_links = 4
> mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
> mts_servers = 1
> compatible = "8.1.0"
>
> Everything is default,
I don't see a db_block_buffers. God knows what the Oracle 8.1 default is, but knowing 8.1 it's bound to be huge, which means your databsae buffer cache is going to be bigger than it needs to be. Add a new line to set db_block_buffers=200 (say). It's small, but see if that gets things going: you can always increase it incrementally later.
Regards
HJR
>I've not changed anything yet
> During installation oracle, he has already gives a error "ORACLE not
> available" but he has continued
> I've no much experience with oracle, I always worked with sybase on
solaris
>
> Thanks
>
> "Mervyn at ifwdc.com" <merv_at_ifwdc.com> wrote in message
> news:8i8pjh$2g27$1_at_brimstone.medianet.ie...
> > Mario,
> >
> > there should be a file called initorcl.ora in your $ORACLE_HOME/dbs
> > directory. It defines how much memory your SGA will take up.
> >
> > 4 things usually are the major memory requirements.
> >
> > SHARED_POOL=
> > JAVA_SHARED_POOL=
> > DB_BLOCK_BUFFERS=
> > BLOCK_SIZE=
> >
> > What size are these? It may be easier to paste the whole content of
> > initorcl.ora file to the group.
> >
> > Merv.
> > mario clynen <mario.clynen_at_ixsys.net> wrote in message
> > news:8i7lkf$a0d$1_at_news1.skynet.be...
> > > When I try to start the database with dbstart,
> > >
> >
> >
> >
>
>
Received on Thu Jun 15 2000 - 00:00:00 CDT