Re: A single dedicated server shared between multiple sessions?

"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote

> Don't overcomplicate things.

I was trying to be precise. :-)

> A session is a session. I don't want to make the
> difference you make here. Makes no sense to me.

There is a huge difference between an Oracle sesssion and what the OP calls an Oracle Forms Session (as seen from the Forms side)

> Don't give your own interpretation to 'session'. Oracle has clear terms
> for what a process and a session is.

I have not. Simply said that the term session when used on the client has a very _different_ meaning that what a session is (as in v$session) on the Oracle side.

Simply put - a developer can consider 20 open cursors as 20 client sessions to the database. This seems to be the case with the OP's reference to Form sessions whe he mentioned "opening a new session per form".

However, if those "sessions" were made across the _same_ client-connection-handle-to-Oracle, all these cursors will be serviced the same Oracle session and a single Oracle dedicated server process. Thus the reason for thinking that the Oracle session/server process is being "shared". And also the reason for the somewhat confusing/misleading subject header of this thread.

> Don't use MTS in this context, it makes things even more unclear.

I don't see the confusion. But then I've had my 4th cup of coffee so far. ;-)

--
Billy