- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle Expert needed....server=dedicated question
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 02:33 AM
тАО02-04-2004 02:33 AM
I am by no means an Oracle person. Just know enough to keep myself to keep myself from getting into too much mischief..
Here's my quesiton:
Getting some complaints from end users that our biggest Oracle database is running slow....everything looked fine, but in checking with some DBA staff discovered a bunch of DEDICATED connections by some folks.
Now I thought I remembered something about DEDICATED connections getting some sort of preferential processing privileges....am I mistaken?
Thanks,
Rita
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 02:36 AM
тАО02-04-2004 02:36 AM
Re: Oracle Expert needed....server=dedicated question
Oracle tries to get as much work done as it can.
There are other reasons the database could be slow. If system peformance is optimal, I'd download the oracle stats pack for your database, install it or better yet make your dba install it.
Then you can get some good measure of internal database performance.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 02:50 AM
тАО02-04-2004 02:50 AM
Re: Oracle Expert needed....server=dedicated question
Have a look at the attached doc from Oracle Metalink. I think #2 under the "Types of Connection Requests" section may interest you.
I don't know if it'll help or not. Hopefully it will.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 02:54 AM
тАО02-04-2004 02:54 AM
Re: Oracle Expert needed....server=dedicated question
Andy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 03:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 03:09 AM
тАО02-04-2004 03:09 AM
Re: Oracle Expert needed....server=dedicated question
We run MTS (multi-threaded). How many dispatchers are set up...I'd have to ask the Head DBA guy.
My understanding is that with multi-threaded, Oracle dispatchers wait for a user to make a request and then run the job, then the next request and so forth, ... thus distributing the resources evenly to end user requests.
Now with a dedicated connection, it's a little different...the user connects as server=dedicated and he gets a dispatcher from Oracle. So he's connected, got a dispatcher, and sits....he(or she) isn't running anything yet, just connected, but that dispatcher belongs to that dedicated connection and they will hold it until they got out.
See my point......
If I see several dedicated connections sitting there...wouldn't this hold up some measure of Oracle resources? Wouldn't that leave the simple MTS request to wait until a dispatcher is freed up...and possibly causing a slowdown to the end-user community.
Did that make any sense...
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 03:12 AM
тАО02-04-2004 03:12 AM
Re: Oracle Expert needed....server=dedicated question
From experience. If the user isn't doing anything, running sql whatever, havinig an open connection does not effect performance.
One nasty sql job that needs to be tuned up can do this to you Rita.
Our dba sometimes spends half his day working with developers to keep nasty sql code out of production. On a development server we commonly see performance spikes sometimes bad enough that Glance picks them up.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 03:18 AM
тАО02-04-2004 03:18 AM
Re: Oracle Expert needed....server=dedicated question
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 03:24 AM
тАО02-04-2004 03:24 AM
Re: Oracle Expert needed....server=dedicated question
Point 1:
The Oracle Listener performs many tasks, but the ones that play a role in the connection process are the creation of the dedicated server process, or the redirection to a dispatcher process.
Creation of any process on a computer consumes memory and CPU, but as it pertains to this article, it consumes time.
When the database is configured to allow only dedicated connections, the Listener receives a connect request and passes the task of creating the dedicated server process to the operating system. Once the time to create this process has elapsed, the Listener can then redirect the client to it. A redirect packet is then sent to the client if the dedicated server process did not inherit the same port number then the Listener, otherwise a resend packet is sent. The client then connects to the dedicated server process and continues with the login to the database.
This Listener connection process can be sped up if the server process can be pre-created. If the process can be created prior to the connection request, the Listener will not have to wait to send the redirect or resend packets, but send them right after the connect request comes in. This is possible if the Oracle Database is configured for Shared Server. In a Shared Server configuration,
processes called dispatchers are created by the process monitor (PMON) and register their network protocol information with the listener. By making themselves available, the Listener will redirect the connect request to the dispatcher rather then wait to create a dedicated server process. Such a configuration can decrease the connect time considerably.
.... In other words it takes longer to connect via Dedicated than non-Dedicated ...
Point 2:
The next bottleneck the Listener could encounter is too many concurrent connection requests. The Listener process, like any other has limits - it is constrained by CPU speed and available memory. Although system growth is usually faster than Moore's Law (that PCs double in processing power every few years), there are techniques that can assist in scaling the Listener.
... I am running this rather large database on an old K box with on 3.5Gb RAM, and yes there is even a java app running for their batch processing....So I am tight on resources on this box until they replace it...
Look like I got another hit on this post...so I'm going to submit this and go back and do more reading...
Point a 'coming !
Rita
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-04-2004 03:26 AM
тАО02-04-2004 03:26 AM
Re: Oracle Expert needed....server=dedicated question
Exactly ... !!! And since the Dedicated connections are the ever greedy Developer/Programmers, and the MTS are the poor end users...You nailed it !!
Rgrds,
Rita