Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle users...
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 - 01:07:33 CST