"sk" <sdkfjksd_at_dkfjd.com> wrote in message
news:mg10f.323336$on1.273371_at_clgrps13...
> I only get this error.
>
> OALL8 is in an inconsistent state
>
> this is from oracle or jdbc?
>
> Sk
>
>
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
> news:uuqdnePpPaG6BN3eRVn-jw_at_comcast.com...
> >
> > "sk" <sk_at_dkfjd.com> wrote in message
> > news:rPZ%e.287729$tt5.194598_at_edtnps90...
> >>
> >> >OALL8 is in an inconsistent state
> >> So this tells I don't have enought memory/or CPU?
> >>
> >> For 30000 records what kind of CPU and RAM you are
> >> expecting? We have P4 with 1 GB RAM for test machines.
> >>
> >> SGA configured are the following
> >> Share Pool 64MB
> >> Buffer Cache 24MB
> >> Large 8
> >> Java Pool 32
> >> Total SGA 128
> >>
> >>
> >> SK
> >>
> >> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> >> news:rlh0k1h9264qc7q12f0ui1jd967iafugv5_at_4ax.com...
> >> > On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk_at_dkfjd.com> wrote:
> >> >
> >> > >If running only one instance of the application, we don't have any
> >> problem.
> >> > >However, when two users trying to do the same thing at the same
time.
> >> > >Sometimes we get (OALL8 is in an inconsistent state) error.
> >> > >
> >> > >Any clue?
> >> >
> >> > Looks like your server doesn't have enough RAM and/or CPU, and is
page
> >> > faulting heavily, because you have cranked up the memory to 'tune'
the
> >> > database.
> >> >
> >> > --
> >> > Sybrand Bakker, Senior Oracle DBA
> >>
> >>
> >
> > What is the exact error message?(including error number)
> > Jim
> >
> >
>
>
Probably a JDBC error. If you do it in sqlplus what is the error?
Jim
Received on Sun Oct 02 2005 - 23:21:06 CDT
