Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: too many local sessions in global transaction
Upgrading to a later version is worth while - even if only 7.3 you would
see benefits.
I don't have access to Oracle right now but if you do something like:
select value from v$parameter where name like '%processes';
you will see the current value for your instance. SESSIONS is, by default,
calculated by Oracle based on the value of PROCESSES. So once you have the
current PROCESSES value, try increasing it a bit by editing your INIT.ORA
file appropriately. Don't go mad as other resource hungry parameters are
based on this.
Eugene Gardner (unemployed).
> during our year end processing i keep getting ora-2045 ( too many sessions
> at this site for this transaction). currently my only recourse is to do a
> dbshut/dbstart and continue.
>
> i am currently running oracle 7.1.4.1.0 under solaris 2.3 with sqlnet v1 (i
> know i am in the dark ages and its probably part of the problem) and
> relatively new to oracle. any help is appreciated.
>
> thanks in advance!
>
>
>
Received on Tue Jan 05 1999 - 13:36:52 CST
![]() |
![]() |