"sk" <sdkfjksd_at_dkfjd.com> wrote in message
news:7n20f.323344$on1.256859_at_clgrps13...
> I don't get anything. If there is an error where can I see it.
> it will be displayed in the sqlplus or log?
>
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
> news:IfmdnS_7cYL8LN3eRVn-tA_at_comcast.com...
> >
> > "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
> >
> >
>
>
Stop top posting, it makes it hard to read. It should be in sqlplus.
Jim
Received on Sun Oct 02 2005 - 23:45:34 CDT
