Re: concurrent access

"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 Received on Sun Oct 02 2005 - 21:37:46 CDT