I have an issue with performance of oracle, the db sits on EBS volumes on and aws EC2 instance. I have captured the iostat data and feed it to iostat_plotter to forward it to the DB administrators. However what I'm trying to understand is the variable avgrq-sz, it is quite in consistent.
The system is running RHEL 6.4 64 bit, Oracle 11g. The block size is 4K .Following is the extract for two devices which are of interest
and
These samples are one sec apart. My first guess is that the data sets which are being processed by oracle need reindexing.
Hi
I am using HP - UX...
When I execute the below commands I get these results...
Why do i get a different shell value when i run echo $SHELL?
# echo $0
ksh
# echo $SHELL
sh
# ps -p$$
PID TTY TIME COMMAND
4013 pts/7 0:00 ksh (2 Replies)
I am using a piece of code which is working fine in some cases and is not working in some other instances. All I am doing is grep'ing and concatenating.
Below is a working scenario.
$ echo $var1
REPLYFILENAME=Options_NSE1.txt.enc
$ FILE_NM=`echo ${var1##*=}`.gz (Take everything after... (1 Reply)
Hi
I'm executing a menu script in which I `cat a file` but it's giving different output some times. Following is the code fragment taken from my script.
while true
do
cat procs.configured
echo ---------separator--------------
sleep 3
done
when I execute this code fragment, `cat` outputs... (2 Replies)
The command ps -eaf gives inconsistent result when executed on XYZ server (the command shows 1, 2 or 3 instances of the process. Ideally it should show only 1). I have attached the script file that was executed and the corresponding output. When the same script was executed on ABC server it gave... (1 Reply)
I have an input list of:
I am just trying to turn this list into its seconds since epoch "+%s" time equivalent. I'm trying to use the following, but every time I run the command it gives me different answers, they are close, but never the same... any clues as to why?
xargs -I{} date -j -f... (3 Replies)
Hi,
I have a file that has inconsistently numbered columns.
Like row1 has 23 columns, and row 2 has 34 columns etc.
I would like to re-order the first 8 columns as required and from the 9th column till the end, I would like to print it as it is.
I tried to read the re-ordered 8 columns... (7 Replies)
I'm trying to sort the list below, so that multiple instances of the form
pass=i_d=j
are contiguous. Curiously, the standard sort command to do this works some of the time (it produced the output below) but not all of the time.
the command I used was
cat fileName | sort -k1.26,1.26n... (3 Replies)
On one of the Unix server B.11.31. a disk that has been provisioned from the VMAX, but according to the diskinfo its show coming from clarion.
sudo /opt/emc/SYMCLI/bin/symvg sho /dev/vg_<name>
Volume Group Name : /dev/vg_<name>
Volume Group Type : HP-UX LVM
Volume Group State ... (0 Replies)
Could you please advise on the following: I have two space-delimited files with 9 and 10 columns, respectively, with exactly the same values in column 1. However, the order of column 1 differs between the two files, so I want to sort both files by column 1, so that I can align them and... (6 Replies)
Discussion started by: aberg
6 Replies
LEARN ABOUT BSD
iostat
IOSTAT(1) General Commands Manual IOSTAT(1)NAME
iostat - report I/O statistics
SYNOPSIS
iostat [ drives ] [ interval [ count ] ]
DESCRIPTION
Iostat iteratively reports the number of characters read and written to terminals per second, and, for each disk, the number of transfers
per second, kilobytes transferred per second, and the milliseconds per average seek. It also gives the percentage of time the system has
spent in user mode, in user mode running low priority (niced) processes, in system mode, and idling.
To compute this information, for each disk, seeks and data transfer completions and number of words transferred are counted; for terminals
collectively, the number of input and output characters are counted. Also, each sixtieth of a second, the state of each disk is examined
and a tally is made if the disk is active. From these numbers and given the transfer rates of the devices it is possible to determine
average seek times for each device.
The optional interval argument causes iostat to report once each interval seconds. The first report is for all time since a reboot and
each subsequent report is for the last interval only.
The optional count argument restricts the number of reports.
If more than 4 disk drives are configured in the system, iostat displays only the first 4 drives, with priority given to Massbus disk
drives (i.e. if both Unibus and Massbus drives are present and the total number of drives exceeds 4, then some number of Unibus drives will
not be displayed in favor of the Massbus drives). To force iostat to display specific drives, their names may be supplied on the command
line.
FILES
/dev/kmem
/vmunix
SEE ALSO vmstat(1)4th Berkeley Distribution April 29, 1985 IOSTAT(1)