Re: Oracle users...

Ellen,

what do you mean that "only one session is active at any one time?" How do you know this? Via AIX utilities or Oracle? Are the sessions doing adhoc queries (via SQLPLUS for example)? or are they applications like an Oracle FORMS or Pro*C program? Are the users all doing essentially the same thing (running the same application like a customer service program) or different things (like some doing order entry, others doing reports, and others processing orders)?

Just so we have a sense of discussing the same issue, an Oracle session is a user connection to the database. The same user can have multiple sessions. All of your users can be connected using the same oracle user name, eg scott. Then within each session Oracle operates using Transactions. A new transaction begins when the previous one is commited or rolled back. In a transaction Oracle presents the data to the user independently of other sessions. Transactions are the means of providing the independence that Jeremy discussed.

For some reason I suspect maybe you are checking the processes running in AIX. You see only one Oracle server process and conclude that only one session is running there. The server can handle multiple sessions without spawning multiple processes. So if this is the "session" you meant, then you just need the information that one oracle server does not equal one oracle session.

Hope this helps

   ed

In article <3662557A.14169D11_at_nettrack.com.au>,   Ellen Chiem <ellen_at_nettrack.com.au> wrote:
> 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
> >

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 08:55:38 CST