This chapter describes how to tune Oracle Database. It contains the following sections: Importance of Tuning Operating System Tools Tuning Memory Management Tuning Disk I/O Monitoring Disk Performance System Global Area Tuning the Operating System Buffer Cache 1.1 Importance of Tuning Oracle Database is a highly optimizable software product. Frequent tuning optimizes system performance and […]
Operating System Tuning for Oracle Database Read More »
A few weeks back, a user asked me about running an automated task every other week. Though most of us use cron as needed to run those nice little tasks that clean up core files and evaluate the contents of log files in the middle of the night, running a task every other week or
Tune your system more by disabling all unwanted and unused daemons from running on the system. This can be done by editing the /etc/inetd.conf file and the rc files or directories. Modify the /etc/inetd.conf file and disable unnecessary daemons running on the system. # vi /etc/inetd.conf # # Configuration file for inetd(1M). See inetd.conf(4). #
Unix Disabling Daemons / services from inetd.conf Read More »
Tune your system more by disabling all unwanted and unused daemons from running on the system. This can be done by editing the /etc/inetd.conf file and the rc files or directories. Modify the /etc/inetd.conf file and disable unnecessary daemons running on the system. # vi /etc/inetd.conf # # Configuration file for inetd(1M). See inetd.conf(4). #
Unix Disabling Daemons / services from inetd.conf Read More »
Kernel This should be the first file backed up. If it gets deleted you can restore it back. This file is often named /kernel, /unix, or /vmunix. Password File Having a backup of the password file is a good idea, in case the system password file gets compromised. This is the file referred to as
Unix Backup Key Files !! Read More »
Listing all the preocess ids: # /usr/bin/ps -ef | sed 1d | awk ‘{print $2}’ Mapping the files to ports using the PID: # /usr/proc/bin/pfiles 2>/dev/null | /usr/xpg4/bin/grep or # /usr/bin/ps -o pid -o args -p | sed 1d Mapping the sockname to port using the port number: # for i in `ps -e|awk ‘{print
How to find and trace open ports in unix Read More »
At the very least, collect the following information for each system that you have: 1. Hostname: % hostname 2. Hostname aliases: % grep `hostname` /etc/hosts | awk ‘{ print $3 }’ 3. Host network addresses: % grep `hostname` /etc/hosts | awk ‘{ print $1 }’ 4. Host ID: % hostid 5. System serial number: On
Collecting Unix System Information Read More »
To identify processes to kill we need to view the FULL output from the ps command (we use the comm field). But by default we are not able to view full command. So here is the solution.. Solaris : /usr/ucb/ps -awux You may need two “w” options. From ps(1b): -w Uses a wide output format
To identify processes to kill we need to view the FULL output from the ps command (we use the comm field). But by default we are not able to view full command. So here is the solution.. Solaris : /usr/ucb/ps -awux You may need two “w” options. From ps(1b): -w Uses a wide output format
Error messages like the following in syslog.log: Aug 14 00:14:05 cust1 vmunix: LVM: Performed a switch for Lun ID = 0 (pv = 0x000000005ed22800), from raw device 0x1f00b400 (with priority: 0, and current flags: 0x40) to raw device 0x1f03b400 (with priority: 1, and current flags: 0x0). Aug 14 00:14:05 cust1 vmunix: LVM: Performed a switch
How to interpret PV and VG numbers from HP-UX syslog.log Read More »