Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 747
  • Last Modified:

Session 8 exceeded soft sessionspace limit of 0x100000 bytes.

Hi,

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.
0
manzoor_dba
Asked:
manzoor_dba
  • 2
1 Solution
 
manzoor_dbaAuthor Commented:
xxx
0
 
sdstuberCommented:
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
0
 
Richard OlutolaConsultantCommented:
Are you on Unix/linux oe Windows?

R.
0
 
manzoor_dbaAuthor Commented:
Raising an SR with oracle
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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