What IS the "database connection error" ? I.e. what is the actual ORA-error message?

E.g. ORA-18 or ORA-25 ???

Ciao

Clemens

--- Original Message ---
>
> On Oct 9, 2006, at 5:45 PM, CLEMENS.BLEILE@(protected):
>
> >
> > Hi,
> >
> > what di you mean with "stop accepting connection" ?
> >
>
> the client will get database connection error.
>
> > Do you get an error message, does it just hang or is the connect very
> > slow? Try with sqlplus and send the error-message.
> >
>
> No slowdown, just client having problem to connect.
>
> > How much memory do you have in your system? What is SGA_MAX_SIZE,
> > SGA_TARGET and PGA_AGGREGATE_TARGET? In addition send the output of
> > "free".
>
>
> This is a AMD64 system running 64 bit version of Oracle 10g
>
> Value when I gotten into problem.
>
>
> Physical memory : 8 gig
> SGA_MAX_SIZE : 4.2 gig
> SGA_TARGET : 2.2 gig
>
> Aggregate PGA : 783 MB
>
>
> Don't have the free output at that point but the current value
> is
>
>          total     used     free   shared   buffers
>  
> cached
> Mem:     8125976   7581276   544700       0   546020
>  
> 6226444
> -/+ buffers/cache:   808812   7317164
> Swap:    4200988       0   4200988
>
> with the new (current) setting of
>
> SGA_MAX_SIZE : 3.2 gig
> SGA_TARGET : 3.2 gig
> Aggregate PGA : 783 MB
>
> Quesiton :
>
> In "Oracle Database 10g - Linux Administration", there was a
> section
> where configuring oracle for > 2.7 GB SGA.
>
> It recommended the following
> 1. Creating a ram disk by doing
>  umount /dev/shm
>  mount -t ramfs ramfs /dev/shm
>  chown oracle:dba /dev/shm
>
> 2. change /etc/security/limits.conf
>  oracle soft memlock 3145728
>  oracle hard memlock 3145728
>
> 3. echo 8589934592 > /proc/sys/kernel/shmmax
>
>
> I have often assume the above only apply to 32-bit linux
> systems, does
> it apply to 64-bit version of SUSE ? since share memory parameter
> are
> handle by orarun.
>
>
>
>
>
> >
> > Thanks
> >
> > Clemens
> >
> > --- Original Message ---
> >> Hi,
> >>
> >>  I have this machine that consistently show memory utilization
> >> reach
> >> 99% and then stop accepting connection. There are no alert log
> >> being
> >> generated in bdump. I have changed SGA_MAX, sessions_CACHE_CURSORS,
> >>
> >> open_cursors, sessions parameter in the past, what can be
> >> creating
> >> this?
> >>
> >>  This is a new machine that I recently moved to and has more
> >> memory
> >> than the previous machine (same application). The only thing
> >> I think
> >> is significantly different is the SGA_MAX size and the use of
> >> nic
> >> bonding.
> >>
> >>  Thanks.
> >>
> >>
> >> --
> >> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> >> For additional commands, email: suse-oracle-help@(protected)
> >> Please see http://www.suse.com/oracle/ before posting
> >>
> >
>
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before posting
>


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting