| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: trace file question
Hi,
This is probably related to usage of JVM.
Have a look at Metalink Note: 103954.1 (subject Session Exceeded Soft Sessionspace Limit of 0x100000 Bytes) which suggests you can probably ignore this.
If you get it constantly, look at if you need to increase the parameters
JAVA_MAX_SESSIONSPACE_SIZE and / or JAVA_SOFT_SESSIONSPACE_LIMIT
Also take a look at Note:105236.1 Subject: Simple Guideline for Tuning Memory Parameters Using the Oracle8i JVM
>From an Oracle forum posting:
"
There's not a great deal on these, but here goes.
There are 2 init.ora parameters that let you control the session memory usage for Java programs.
java_soft_sessionspace_limit:
When a user's session-duration Java state exceeds this size, Aurora generates a warning that goes into the RDBMS .trc file. The default is 1MB. You should understand the memory requirements of your deployed applications, especially as they relate to usage of session space. This parameter allows you to specify a "soft limit" on Java memory usage in a session, as a means to warn you if something is awry.
java_max_sessionspace_size: (hidden parameter)
When a user's session-duration Java state attempts to exceeds this size,
Aurora kills the session with an out-of-memory failure. The default is 4GB.
This limit is purposely set extremely high to be normally invisible. If a
user-invokable Java program executing in the server can be used in a way
that is not self-limiting in its memory usage, then this setting may be
useful to place a hard limit on the amount of session space made available
to it.
"
it then says later:
"The kernel group contends that there is a "bug" of sorts on this and the
zero indicates you are using the default value.
Nobody can tell me when this will be fixed."
HTH,
Bruce Reardon
-----Original Message-----
Sent: Tuesday, 8 January 2002 20:40
I have a trace file generated by the database. At the end of the file you
will see an error of
Session 10 exceeded soft sessionspace limit of 0x100000 bytes.
What is this ? How can I handle that if needed ?
Thank you
bunyamin
Dump file G:\orafiles\uybs3\tracefiles\udump\ORA01216.TRC
Fri Jan 04 18:46:40 2002
ORACLE V8.1.7.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Windows 2000 Version 5.0 , CPU type 586
Instance name: uybs3
Redo thread mounted by this instance: 1
Oracle process number: 25
Windows thread id: 1216, image: ORACLE.EXE
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jan 09 2002 - 01:28:49 CST
 |
 |