Re: concurrent access

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
>
>
Received on Sun Oct 02 2005 - 22:08:02 CDT