"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 - 10:35:46 CDT
