ho hum..

I previously got this error "12500" when session reached a level. Since then I have tuned down the sort_area_size to 100k from 1 meg.


I then started hitting ora-4031 which forced me to up my shared pool x 100 megs to 400 megs

This morning I got a ora-12500 at session level 669 - which showed an Oracle process level (in task manager) of 890 + megs.

So it appears I am hitting a problem I hit before at 1.2gb for user processes+sharedpool joined. Now I am hitting it at 900 megs.

I have not bounced the Database yet but it the session connection problem persists i.e. can't handle new log-ons I will be forced to reduce the shared pool by 100 megs - this may push me back into the Ora-4031 problem again.

To put mildly, help!!!. I didn't experience any of these problems with 7.3.4 - since moving to 8i I have hit two show stoppers which has forced to to put in changes + bounce the Database each week.