• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 750
  • Last Modified:

Session 8 exceeded soft sessionspace limit of 0x100000 bytes.


We are continiously (atleast twice a month) getting the below error in the trace file

Session 8 exceeded soft sessionspace limit of 0x100000 bytes.
Session 8 exceeded soft sessionspace limit of 0x100000 bytes.

Oracle version is : 8.1.7.

Because of this error the users are not able to connect to the database though the shared server but we can able to connect through the dedicated one.

can anybody advice on how to resove this issue???

Thanks in advance.
  • 2
1 Solution
manzoor_dbaAuthor Commented:
what is xxx?

if that was supposed to draw attention, you should refrain from doing that, posting extra comments delays notification of a neglected question.

for your problem though,  a search of google and oracle support sights seem to indicate the problem might be in your java installation.
you could try to reinstall java

if that doesn't work you should open a request with Oracle support to resolve the issue.  8i isn't in support anymore but they might be willing to help if there is a known workaround
Richard OlutolaConsultantCommented:
Are you on Unix/linux oe Windows?

manzoor_dbaAuthor Commented:
Raising an SR with oracle
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now