Because businesses are utilizing more shared databases and parallel systems, network administrators and DBAs need to know how network communications can affect database and application performance. That being said, every Oracle database tuning project must include database tuning along with network monitoring and tuning.

Explore the advantages of Oracle 10g database tuning.

Database systems can be delayed by network issues during:

- The period of time between a client’s request and the server’s response

- The time elapsed between when a server responds and when the end user receives the data

Both of these circumstances may appear to be an application performance problem to an end user, even though the system is operating perfectly otherwise.

Get a better understanding of Oracle 10g performance.

But What Can a DBA Do?

Network administrators, as they should be, are responsible for network tuning. Small IT organizations might have DBAs who pull double duty as network admins, but most do not. This results in DBAs not having enough resources to fix network performance problems. And while Oracle DBAs don’t have access to many network tuning tools, there are ways to control frequency and size of network packets. They are important tools for improving Oracle 10g performance.

Changing the refresh interval can allow snapshots to send substantial amounts of data at less frequent intervals. Though this change is not difficult, it is important in reducing traffic network-wide, and reducing the amount of time it takes to send large packets since more network resources have been freed up.

Get some Oracle 10g database tuning tips.

The parameter files mentioned below are what gives a DBA the ability to adjust the frequency and size of packet transmission across the entire network:

- protocol.ora

- sqlnet.ora

- tnsmanes.ora

- listener.ora

Consult your Oracle database reference guides to locate the parameters and their settings within those files that can impact Oracle 10g performance. While their power may be minimal, they could still greatly improve the performance of a distributed Oracle database.

Incoming search terms for the article:

• Because businesses are utilizing more shared databases and parallel systems network administrators and DBAs need to know how network communications can affect database and application performance