Re: concurrent access

>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
Received on Sun Oct 02 2005 - 18:12:23 CDT