Methods required to obtain a formatted explain plan differ depending on which version of Oracle you are using. The initial steps to create a plan table and make the optimizer populate the plan table with the execution plan are common to all versions of Oracle. Note that there are limitations with explain plan when the …
Plan Table and methods for obtaining a formatted Explain Plan Read More »
iostat (input/output statistics) an utility that reports Central Processing Unit (CPU) statistics and input/output statistics for devices and partitions. The iostat command is used for monitoring system input/output device loading by observing the time the devices are active in relation to their average transfer rates. The iostat command generates reports that can be used to …
Analyzing Database Server I/O Bottlenecks using IOSTAT Read More »
ps (process statistics) is an utility that reports a snapshot of the current processes. By default, ps selects all processes with the same effective user ID (euid=EUID) as the current user and associated with the same terminal as the invoker. It displays the process ID (pid=PID), the terminal associated with the process (tname=TTY), the cumulated …
Identifying CPU and Memory Intensive processes on a database server using PS Read More »
mpstat (multiple processor statistics) is an utility that report processors related statistics. Below is the sample default output generated by mpstat with no options: The report generated by the mpstat command has the following format: CPU: Processor number, starts with 0. The keyword all indicates that statistics are calculated as averages among all processors. %user: …
Analyzing Database Server CPU/Processor Bottlenecks using MPSTAT Read More »
Preparing a Linux server to install oracle has been made easy with the help of oracle-validated rpm package. Install of oracle-validated automates the download and install of all required RPMs including dependencies, setup of Linux kernel parameters, creation of oracle user (Linux user) and dba, oinstall groups I have been thinking of trying out oracle-validated …
Prepare your Linux Server to install Oracle database using oracle-validated RPM Read More »
vmstat (virtual memory statistics) reports information about processes, memory, paging, block IO, traps, and cpu activity. Below is the sample default output generated by vmstat with no options: Column description of default output. Procs r: The number of processes waiting for run time. b: The number of processes in uninterruptible sleep. Memory swpd: the amount …
Analyzing Database Server Bottlenecks using VMSTAT Read More »
You can now find my HTML version of below Oracle Installation guides under cookbook section: Install Oracle Database 8i (8.1.7) on Red Hat Linux 7.3 (Kernel 2.4.18-3 i386 32 Bit) Install Oracle Database 9i (9.2.0.6) on Red Hat Enterprise Linux 4 / CentOS 4 (2.6.9-5.0.3.EL i386 32 Bit) Install Oracle Database 9i (9.2.0.8) on Red …
Introduction Yum (Yellow dog Updater, Modified) automatic updater and package installer/remover for rpm systems. It automatically computes dependencies and figures out what things should occur to install packages. Packages also include a digital signature to identify their source. Software management utilities like yum and rpm verify these signatures using GPG public key. Yum and RPM …
Please refer to my post Build your own Red Hat Packages to set up the build environment Firestarter Firewall If you can not find the binary RPM for your distribution, please download the source rpm from http://www.fs-security.com/download.php You can check whether the required rpms installed on your machine or not, by issuing; Install the required …
Building Firestarter Firewall and Clam AntiVirus Packages Read More »
Build Directory To build RPMs as local user, you need to create rpm build directory in your home directory. I recommend creating a separate user for building RPMs. To create rpm directories, issue the following command; Macro Files You need to create .rpmmacros file in your HOME directory You can also add %debug_package %{nil} to …