Home » RDBMS Server » Server Administration » dedicated database server connections vs. globalization of sessions
dedicated database server connections vs. globalization of sessions [message #126450] Mon, 04 July 2005 13:01 Go to next message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
We have a scenario where corporately we have always developed our Oracle apps to have the database user connect to the database through a dedicated database server connection. This allows for the application DBA (me) to be able to trace each session back to the user.

A new project is underway and they are looking at using globalization of sessions where a pool of connections are established up front and the users connect via one of the established connections. This is supposed to have some performance benefits but I am worried we will lose the ability to track a sessions back to the user or a certain amount of database auditing.

The app being developed now is .net and the Microsoft 'techies' have said session pooling is the way to go for an app with a large number of users connecting to the database. Our system DBA is not keen on the globalization of sessions at all and wants to maintain a dedicated user connection.
I am the application DBA in the middle trying to find the best solution from a practical, cost effective perspective.

We do have some documents with pros and cons to both but am wondering what you're standpoint may be on this topic. I have also read a document by James Koopman http://databasejournal.com/features/oracle/article.php/3435431 which offers some tracing methods using identity management. We have not used these identity management techniques in the past and not sure we can. I believe the enterprise edition of Oracle is required to establish this level of identity management but could be wrong.

Any thoughts, comments, suggestions, opinions would be greatly appreciated.


Re: dedicated database server connections vs. globalization of sessions [message #126554 is a reply to message #126450] Tue, 05 July 2005 10:40 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I can't offer much help, but I think I read that oracle 10g has some new tracing facilities through built in packages (and possibly oem) that may help in your situation, if you end up with something other than dedicated server. I think also that asktom.oracle.com has some questions dealing with this topic.
Re: dedicated database server connections vs. globalization of sessions [message #126601 is a reply to message #126554] Tue, 05 July 2005 20:53 Go to previous message
Bruce Carson
Messages: 38
Registered: February 2005
Location: Nova Scotia, Canada
Member
thank you for the repsonse.
will visit ask tom on the topic
Previous Topic: Error message: -6502
Next Topic: grant access to database
Goto Forum:
  


Current Time: Fri Jan 10 07:22:07 CST 2025