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