Re: concurrent access

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 4 Oct 2005 21:11:43 -0700
Message-ID: <Paudne6469C2z97eRVn-tg@comcast.com>

"sk" <sk_at_dkfjd.com> wrote in message news:0LG0f.1721$yS6.1017_at_clgrps12...
> > Also what do you mean hang? It can take quite awhile for the query to
> > return. It won't do anything until it completes.
> > Jim
> >
> It stops in the middle and after that it doesn't do anything so
> i had to stop the sql plus.
>
> sk
>
>

You are going to have to do some basic problem solving yourself.

1. Create a small stand alone table.
2. Open 2 sqlpus sessions
3. Select from one
4. Select from the other.

It should work without a problem. In Oracle readers don't block writers and writers don't block readers.
If it does and your original table does not then call support and open a tar with them.
Jim Received on Tue Oct 04 2005 - 23:11:43 CDT