When trying to execute select * from tablename from two differnt sql plus
instances at the same time
( the same user ) both of sql plus stop working and don't get any response
until i restart the sql plus.
Why ?

sk

"sk" <sk@dkfjd.com> wrote in message news:AnG%e.2077$z26.500@edtnps84...
> When trying to execute select * from tablename from two differnt sql plus
> instances at the same time
> ( the same user ) both of sql plus stop working and don't get any response
> until i restart the sql plus.
> Why ?
>
> sk
>
>
Is the table a view with an order by? If so maybe it is taking a long time
to sort the records and send you results. You shouldn't have any problems
with concurrent access. What happens if you select from just one sqlplus
session.
Jim

Jim

Thanks for replay.

> Is the table a view with an order by?
No I am not specifying any "orderby"
This table is the view with about 30000 rows and( with about 5 fields
varchar nothing special).


>What happens if you select from just one sqlplus
> session.
I don't have any problem. Just it takes time to display everything.


The thing is we met similar problem with the application we are developing
in JAVA.
what it does is execuing following two lines I am accessing throught jdbc

select count(*) from thistableview
select * from thistableview

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?

SK



"Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in message
news:2OudnQDxFMicY6LeRVn-tg@comcast.com...
>
> "sk" <sk@dkfjd.com> wrote in message news:AnG%e.2077$z26.500@edtnps84...
> > When trying to execute select * from tablename from two differnt sql
plus
> > instances at the same time
> > ( the same user ) both of sql plus stop working and don't get any
response
> > until i restart the sql plus.
> > Why ?
> >
> > sk
> >
> >
> Is the table a view with an order by? If so maybe it is taking a long
time
> to sort the records and send you results. You shouldn't have any problems
> with concurrent access. What happens if you select from just one sqlplus
> session.
> Jim
>
>

On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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

>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@sybrandb.demon.nl> wrote in message
news:rlh0k1h9264qc7q12f0ui1jd967iafugv5@4ax.com...
> On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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

"sk" <sk@dkfjd.com> wrote in message
news:rPZ%e.287729$tt5.194598@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@sybrandb.demon.nl> wrote in message
> news:rlh0k1h9264qc7q12f0ui1jd967iafugv5@4ax.com...
> > On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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

I only get this error.

OALL8 is in an inconsistent state

this is from oracle or jdbc?

Sk



"Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in message
news:uuqdnePpPaG6BN3eRVn-jw@comcast.com...
>
> "sk" <sk@dkfjd.com> wrote in message
> news:rPZ%e.287729$tt5.194598@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@sybrandb.demon.nl> wrote in message
>> news:rlh0k1h9264qc7q12f0ui1jd967iafugv5@4ax.com...
>> > On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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
>
>

"sk" <sdkfjksd@dkfjd.com> wrote in message
news:mg10f.323336$on1.273371@clgrps13...
> I only get this error.
>
> OALL8 is in an inconsistent state
>
> this is from oracle or jdbc?
>
> Sk
>
>
>
> "Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in message
> news:uuqdnePpPaG6BN3eRVn-jw@comcast.com...
> >
> > "sk" <sk@dkfjd.com> wrote in message
> > news:rPZ%e.287729$tt5.194598@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@sybrandb.demon.nl> wrote in message
> >> news:rlh0k1h9264qc7q12f0ui1jd967iafugv5@4ax.com...
> >> > On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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

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@attbi.net> wrote in message
news:IfmdnS_7cYL8LN3eRVn-tA@comcast.com...
>
> "sk" <sdkfjksd@dkfjd.com> wrote in message
> news:mg10f.323336$on1.273371@clgrps13...
>> I only get this error.
>>
>> OALL8 is in an inconsistent state
>>
>> this is from oracle or jdbc?
>>
>> Sk
>>
>>
>>
>> "Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in message
>> news:uuqdnePpPaG6BN3eRVn-jw@comcast.com...
>> >
>> > "sk" <sk@dkfjd.com> wrote in message
>> > news:rPZ%e.287729$tt5.194598@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@sybrandb.demon.nl> wrote in message
>> >> news:rlh0k1h9264qc7q12f0ui1jd967iafugv5@4ax.com...
>> >> > On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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
>
>

"sk" <sdkfjksd@dkfjd.com> wrote in message
news:7n20f.323344$on1.256859@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@attbi.net> wrote in message
> news:IfmdnS_7cYL8LN3eRVn-tA@comcast.com...
> >
> > "sk" <sdkfjksd@dkfjd.com> wrote in message
> > news:mg10f.323336$on1.273371@clgrps13...
> >> I only get this error.
> >>
> >> OALL8 is in an inconsistent state
> >>
> >> this is from oracle or jdbc?
> >>
> >> Sk
> >>
> >>
> >>
> >> "Jim Kennedy" <kennedy-downwithspammersfamily@attbi.net> wrote in
message
> >> news:uuqdnePpPaG6BN3eRVn-jw@comcast.com...
> >> >
> >> > "sk" <sk@dkfjd.com> wrote in message
> >> > news:rPZ%e.287729$tt5.194598@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@sybrandb.demon.nl> wrote in message
> >> >> news:rlh0k1h9264qc7q12f0ui1jd967iafugv5@4ax.com...
> >> >> > On Sun, 02 Oct 2005 19:25:03 GMT, "sk" <sk@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