RE: exceeded soft sessionspace limit

Rob,

if this is unix, then there is a command 'ulimit -a' which shows all the
'soft limits' per process on the box.

I use HP servers and 'sessionspace' is not one of them shown, but this is probably different on other boxes.
Basically, if a process hits a limit then it 'dies' - sometimes without error/warning messages, others do have them. I presume the error is from Oracle which could mean that some session has hit an OS defined limit.
If you find that the limits cannot be increased for a process using
'ulimit <option> new_value' then a kernel rebuild will be in order as
the kernel defined hard limit has been reached. Option is usually the first letter of the resource in the list produced by 'ulimit -a'.

for example :

root_at_hp013> ulimit -a            
time(seconds)        unlimited   
file(blocks)         unlimited   
data(kbytes)         65536       
stack(kbytes)        8192        
memory(kbytes)       unlimited   
coredump(blocks)     4194303     
nofiles(descriptors) 2048        

To show only the data(space) limit, use the first letter as an option flag :

root_at_hp013> ulimit -d
65536

I can then change it using :

root_at_hp013> ulimit -d 2048
root_at_hp013> ulimit -d
2048

But if I try to exceed the kernel deined hard limits :

root_at_hp013> ulimit -d 65537 sh: ulimit: The specified value exceeds the user's allowable limit.

Hopefully, ulimit -a will show you something that might help.

HTH Norman.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com
------------------------------------------------------------------------

-----Original Message-----
From: Rob Edgar [mailto:robedgar_at_hkstar.com] Posted At: Wednesday, April 11, 2001 7:57 AM Posted To: server
Conversation: exceeded soft sessionspace limit Subject: exceeded soft sessionspace limit

Anyone can help?

1. What does this mean
2. Should I be worried
3. Why is the date wrong even though sysdate and the date on the server OS is correct.
   • 2001-03-20 18:36:47.125
   • SESSION ID:(15.16740) 2001-03-20 18:36:47.078 Session 14 exceeded soft sessionspace limit of 0x100000 bytes.

Thanks
Rob Received on Tue Apr 17 2001 - 08:23:22 CDT