Re: Oracle/Sun Crashing

You have 4 CPU's but only 256 Meg of RAM ??? What's wrong with THIS picture ??
With 2 tables of 40 million rows, I could easily use 128 Meg just in DB buffers, let alone an entire SGA !!
How big IS your SGA ??? Be sure you do not go past 128 meg or the database may be stealing resources from the system itself.

--
Alan E. Vervaeke
Database Administrator
Oracle Certified Professional

Who is watching your database 24x7? We are blackpearl.net

Dave <none_at_nowhere.nothere.oops> wrote in message news:82gd51$4r4$1_at_lure.pipex.net...
> Hi, I need help
> I have SUN Sparc Centre 2000 running Oracle 7.3.3
> As of Friday it is hanging completely. I can't get in to
> it and have to power it down and bring it back up again.
> Some details below.
>
> > uname -a
> SunOS scs2000 5.5.1 Generic sun4d sparc SUNW,SPARCcenter-2000
>
>
> /etc/system
>
> set shmsys:shminfo_shmmax=268435456
> set shmsys:shminfo_shmmin=200
> set shmsys:shminfo_shmmni=200
> set shmsys:shminfo_shmseg=200
> set semsys:seminfo_semmap=250
> set semsys:seminfo_semmni=500
> set semsys:seminfo_semmns=500
> set semsys:seminfo_semmnu=500
> set semsys:seminfo_semmsl=500
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semume=100
> set semsys:seminfo_semusz=256
> set semsys:seminfo_semvmx=32767
> set semsys:seminfo_semaem=16384
>
> The Machine has 4 cpu's and 256mb ram.
>
> Oracle seems fine, it starts up and SQL Selects still work fine.
> If I try and build an index it will run for a while and then crash.
> Clock still ticks but network dies and console hangs up.
> Stop-A does not work.
> Is my Oracle database broken?
> How can I tell.
> My Oracle tables are big, 2 tables of 40 million rows.
>
> Any help please!!
> dave_at_scsdirect.co.uk
>
>
>
>
Received on Mon Dec 06 1999 - 08:55:40 CST