Re: concurrent access

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_at_attbi.net> wrote in message news:2OudnQDxFMicY6LeRVn-tg_at_comcast.com...
>
> "sk" <sk_at_dkfjd.com> wrote in message news:AnG%e.2077$z26.500_at_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
>
>
Received on Sun Oct 02 2005 - 14:25:03 CDT