topic Re: sqlplus and SIGSEGV for stack growth failure in Operating System - HP-UX

sqlplus and SIGSEGV for stack growth failure

Raquel Candelaria — Mon, 04 Jun 2001 16:46:34 GMT

Hi,

I am the Unix systems administrator for the HP L 9000 systems I not oracle expert but the oracle guys said that this problem is a system problem, when the run sqlplus cdi/cdi;

SQL> desc production_metadata;
They receiced this error

Pid 1796 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or tack size exceeded maxsiz. Memory fault (coredump).

I modified the kernel parameters and I select General
OLTP Database Server system and installed all the patches
December 2000 and a couple for oracle and still having the same problem. I need some help. :o(

Re: sqlplus and SIGSEGV for stack growth failure

Rita C Workman — Mon, 04 Jun 2001 16:58:54 GMT

Well, it could be a problem with the kernel parm (maxdsiz I believe) needs increased..or it could be something else. Before I would make changes to the kernel, I would ensure my swap space is reasonable.

Then you might want to check this thread---could also be something about your links....
http://mail.gnu.org/pipermail/ddd/2001-March/000669.html

Hope this helps,
Rita

Re: sqlplus and SIGSEGV for stack growth failure

A. Clay Stephenson — Mon, 04 Jun 2001 17:35:57 GMT

Hi:

I'm almost positive you need to increase maxssiz.

Regards, Clay

Re: sqlplus and SIGSEGV for stack growth failure

MANOJ SRIVASTAVA — Mon, 04 Jun 2001 17:44:06 GMT

Hi Raquel

I have a suggestion , plesae check the all the following system kernel parameters :Parameter Required
==================================
SHMMAX 1gb
SHMMIN 1
SHMMNI 100
SHMSEG 10

SEMMNI 70
SEMMNS 200
MAX_THREAD_PROC >= 256

This along with the disk partitions ( long name ) , maxdsiz should be able able to sort out the OS related variables.

Manoj Srivastava

Re: sqlplus and SIGSEGV for stack growth failure

Raquel Candelaria — Wed, 06 Jun 2001 16:32:19 GMT

Thank you for the answers but I am going to give more detail s. I have 3 databases running, each one use 261 MB real memory. The system has 2049.8 MB in RAM, Swap 4096MB, 1 processor 440MHz.
OS B.11.0.U, OS Kernel 64.
kernel parameters
max_thread_proc 256
maxdsiz 268435456
maxdsiz_64bit 1073741824
maxfiles 2048
maxfiles_lim 2048
maxssiz 8388608
maxssiz_64bit 16777216
maxswapchunks 4096
maxtsiz 67108864
maxtsiz_64bit 1073741824
maxuprc 597
maxusers 200
shmem 1
shmmax 1073741824
shmmni 512
shmseg

Re: sqlplus and SIGSEGV for stack growth failure

Raquel Candelaria — Wed, 06 Jun 2001 16:35:47 GMT

Thank you for your answers but I am going to give more details.I changed but it didn't work. I have 3 databases running, each one use 261 MB real memory. The system has 2049.8 MB in RAM, Swap 4096MB, 1 processor 440MHz.
OS B.11.0.U, OS Kernel 64.
These are the kernel parameters
max_thread_proc 256
maxdsiz 268435456
maxdsiz_64bit 1073741824
maxfiles 2048
maxfiles_lim 2048
maxssiz 8388608
maxssiz_64bit 16777216
maxswapchunks 4096
maxtsiz 67108864
maxtsiz_64bit 1073741824
maxuprc 597
maxusers 200
shmem 1
shmmax 1073741824
shmmni 512
shmseg 32

Re: sqlplus and SIGSEGV for stack growth failure

Rita C Workman — Wed, 06 Jun 2001 16:45:58 GMT

I don't consider myself a tuning expert....that said...

I think think your maxdsize (max data segment size (bytes) is a bit high. Possibly you could chg to something more like 67108864.

Just a thought....you may want to double check or wait for others comments.

Regards,
Rita

Re: sqlplus and SIGSEGV for stack growth failure

Don Morris_1 — Thu, 07 Jun 2001 14:19:56 GMT

As mentioned above -- have you tried increasing
maxssiz above the 8Mb default you list as the
current value?