April 1999
Intermediate to advanced
552 pages
15h 39m
English
Content preview from Oracle Distributed SystemsBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
SQL*Net/Net8 Tuning
The most effective network tuning you can do for SQL*Net/Net8 is to reduce the number of round-trip messages between the client machines and database server. You can control this behavior in various ways, such as setting your application’s ARRAY_SIZE (the number of records that are processed with each fetch), the size of the session data unit (SDU), and the use of stored procedures. In addition, scalability issues can be improved by tuning your MTS configuration. Net8 introduces additional multiplexing and connection pooling capabilities which scale to support tens of thousands of users.
Do You Have a Problem?
The first step in addressing SQL*Net/Net8 scalability is to recognize whether your system is experiencing a performance degradation and act accordingly. If you are using multi-threaded server, your primary concerns are whether the dispatchers are keeping up with the rate of requests and whether the server processes are able to handle the volume of activity. If you are using prespawned servers, your concerns are whether you have enough servers and whether the machine has the resources to accommodate their memory and CPU usage. Methods of diagnosing all of these situation are included here.
Tuning the multi-threaded server
Tuning the multi-threaded server amounts to configuring more dispatchers and adding or reducing server processes. The book Oracle Performance Tuning, 2nd edition, by Mark Gurry and Peter Corrigan (O’Reilly & Associates, 1996) includes SQL ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.