Oracle

Plan Table and methods for obtaining a formatted Explain Plan

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 »

Analyzing Database Server I/O Bottlenecks using IOSTAT

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 »

Identifying CPU and Memory Intensive processes on a database server using PS

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 »

Analyzing Database Server CPU/Processor Bottlenecks using MPSTAT

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 »

Prepare your Linux Server to install Oracle database using oracle-validated RPM

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 »

Analyzing Database Server Bottlenecks using VMSTAT

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 »

Managing Oracle database services

This post summarizes on how to start, stop and to check the status of Oracle database services. Oracle 10g Oracle Listener: To Start, execute the following command: $ su – oracle $ lsnrctl start To Stop, execute the following command: $ su – oracle $ lsnrctl stop Grid Control for Database Management: To Start, execute …

Managing Oracle database services Read More »

Removing Oracle 10g Software from Linux Server

This article briefs about the steps that are required to remove Oracle 10g software from Linux server using Oracle Universal Installer and manually. Removing Oracle 10g Software Using Oracle Universal Installer Identify all instances associated with the Oracle home: To identify all instances associated with the Oracle home that you want to remove, issue the …

Removing Oracle 10g Software from Linux Server Read More »