1. Latest News
  2. Submit Press Release
  1. PR Home
  2. Latest News
  3. Feeds
  4. Alerts
  5. Submit Free Press Release
  6. Journalist Account
  7. PRNewswire Distribution
Dbametrix Solutions Logo

How to Avoid Server Performance bottleneck in Oracle Database Server

Server monitoring and disk I/O tuning is playing major task in Oracle database performance tuning.

 
PRLog - Jul. 23, 2012 - Keeping your file systems and directories, including the root directory, slim helps prevent cluttering of the file systems, thus helping administration. This also enhances performance, since the file system does not have to deal with the overhead of managing a large number of unwieldy partitions. Directory lookups are relatively slow, and their speed is in many ways directly proportional to directory size. Hence, keep your directories as small as possible. Directory sizes are usually based on bytes in most Unix and Linux systems. You can check the directory sizes via the “ls –l” command. When you start seeing multiple of bytes like 4096, 8192, etc, it’s time to start cleaning up.

http://www.dbametrix.com/remote-monitoring.html

Truncate all old log files. If left unattended, Oracle’s trace and other logs, such as alert.log, listener.log, and so on, can grow very large, taking up a lot of file system space. For tips on managing Oracle log files, create some unique strategy for purging and schedule the scripts. Similarly, purge all core dumps, temporary files, and error logs generated by your applications. Remove very old backups including export backups, e-mails, and so forth from disk and, if necessary, archive them to tape.

Many times, even after a good cleanup, directory entries do not reduce in size. Dropping and re-creating the directory can rectify such a situation. However, if multiple subdirectories are involved, this can be quite cumbersome. Large directory entries are not problems in themselves. They are only reminders that we need to clean up, remove all unnecessary files, and keep directories compact.

In addition to checking for I/O bottlenecks, proactive monitoring for availability of free space is also mandatory. In live production environment, lack of free space is instant death. Adding more disks to an external disk array is usually a relatively easy task, especially with hot-pluggable configurations, in which new disks can be plugged in while the system is online. However, availability of the required disks might be a problem. You can take advantage of storage area or network storage devices. Given such external environments in which we have limited control, the best we can do is to implement full-fledged proactive monitoring for free space. Sometimes required free space is in danger of being used up, or when maximum hardware capacity is about to be reached. Give advance warning to your higher authorities to ensure timely availability of resources. Means, if we are monitoring constantly free space then we can eliminate such kind of issues. If database environment is complex then we can create some scripts and schedule for monitoring. Remember, database monitoring is essential for 24/7 running large production databases.

About Dbametrix:
Dbametrix offers exclusive remote Oracle database monitoring with strong SLA and response time. Dbametrix is team of Remote dba specialists and experts who are having more than 12 years experience in remote database administration field. For more detail of services, kindly check from http://www.dbametrix.com

--- End ---

Click to Share

Contact Email:
***@dbametrix.com Email Verified
Source:Dbametrix Solutions
Phone:877-778-3851
City/Town:Skokie - Illinois - United States
Industry:Business, Software
Tags:oracle tuning, performance tuning in oracle, oracle db, oracle io tuning, oracle in performance
Shortcut:prlog.org/11931608
Disclaimer:   Issuers of the press releases are solely responsible for the content of their press releases. PRLog can't be held liable for the content posted by others.   Report Abuse

Latest Press Releases By “

More...

Trending News...



  1. SiteMap
  2. Privacy Policy
  3. Terms of Service
  4. Copyright Notice
  5. About
  6. Advertise
Like PRLog?
9K2K1K
Click to Share