Re: Oracle users...

Hi Jeremy,
Thanks for your prompt response. If that is the case, then how can you explain why only one session is active at any one time?. Most of the user are only do select statment, insert or update.

:-) ellen

Jeremy Russell wrote:

> Hi Ellen - Oracle will handle the requests in parallel - and therefore
> all your users can access data separately. Oracle arranges requests
> such that readers of data are independent of each other, whilst
> writers do not impact or affect other readers/writers, save that
> updated and uncommitted information is not available to other users
> and that two writers cannot update the same row(s) until one of them
> commits/confirms their updates.
>
> Hope that's what you wanted to hear.
>
> JR
>
> Ellen Chiem <ellen_at_nettrack.com.au> wrote:
> >Hi all,
> > Just one question in regards to how Oracle handle users request.
> >
> >Platform : AIX version 4.1.5 , ORACLE version 7.1.6
> >Problem: If for instance, I have 20 or so Unix users logging in to the
> >database. Once they are login to the database, they use just one oracle
> >userid. What I want to know is, how does Oracle handle the user
> >request...sequentially or parallel?. The problem I have is it, there are
> >20 users login the database but only one session is active at anyone
> >time. Will it makes a differnnent if they use unquie oracle id ?
> >
> >thanks and regards
> >Ellen Chiem
Received on Mon Nov 30 1998 - 02:21:15 CST