TOCPREVNEXTINDEX

Lund Performance Solutions


Index of Data Items

C

CPU

CPU Summary

busy percentage 1

context switch management 1

cpu identification number 1

high priority process execution 1

idle time 1

interrupt execution 1

negative nice process execution 1

nice process execution 1

real-time process execution 1

system process execution 1

total busy time 1

trap processing 1

user process execution 1

utilization percentage 1

virtual memory management 1

Miscellaneous Statistics

context switches per second 1

forks per second 1

interrupts per second 1

system calls per second 1

traps per second 1

Run Queue Statistics

1/5/15 minute averages 1

run queue average 1

run queue occupancy percentage 1

D

Device Configuration

Device Configuration Summary

class 1

driver name 1

hardware path 1

hardware type 1

instance number 1

software state 1

Disk

Disk I/O Summary

average physical read size 1

average physical write size 1

average queue length 1

average service time 1

average wait time 1

device identification number 1, 2

device utilization percentage 1

disk utilization percentage 1

I/O percentage 1

I/Os per second 1

physical reads per second 1

physical writes per second 1

Disk Controller

Disk Controller I/O Summary

device identification number 1

I/O percentage per disk controller 1

physical reads per second 1

physical writes per second 1

raw memory reads per second 1

raw memory writes per second 1

system reads per second 1

system writes per second 1

user reads per second 1

user writes per second 1

virtual memory reads per second 1

virtual memory writes per second 1

Disk Detail

Disk Detail

device identification 1

I/O percentage 1

logical average read size 1

logical average write size 1

logical read rate 1

logical write rate 1

physical average read size 1

physical average write size 1

physical read rate 1

physical write rate 1

queue length 1

raw average read size 1

raw average write size 1

raw read rate 1

raw write rate 1

service time 1

system fs average read size 1

system fs average write size 1

system fs read rate 1

system fs write rate 1

user fs average read size 1

user fs average write size 1

user fs read rate 1

user fs write rate 1

utilization percentage 1

virtual memory average read size 1

virtual memory average write size 1

virtual memory read rate 1

virtual memory write rate 1

wait time 1

F

File System I/O

File System I/O Summary

file system mount points 1

logical reads per second 1

logical writes per second 1

physical reads per second 1

physical writes per second 1

File System Space

File System Space Summary

file system block size 1

file system fragment size 1

file system mount point 1

free space available to non-super users 1

free space available to super users 1

number of free inodes 1

overall file system size 1

percentage of file system space used 1

total number of inodes 1

G

Global

CPU

cpu percentage 1

high priority percentage 1

read hit percentage 1, 2

run queue length 1

total busy percentage 1

write hit percentage 1

CPU Miscellaneous

5/15 minimum run queue average 1

capture ratio 1

run queue average 1

run queue busy percentage 1

CPU Utilization

context switches 1

high priority percentage 1

idle percentage 1

interrupt percentage 1

negative nice percentage 1

nice percentage 1

real percentage 1

system percentage 1

total busy percentage 1

trap percentage 1

user percentage 1

virtual memory 1

Disk

disk drive 1

disk I/O queue length 1

I/O percentage 1

I/Os per second 1, 2

queue length 1

Extended Process Line

cpu time 1

current wait state 1

Memory

deactivated bytes per second 1

page outs per second 1

Memory/Virtual Memory

deactivated bytes 1

memory used percentage 1

page outs 1

read hit percentage 1

virtual memory percentage 1

write hit percentage 1

Miscellaneous

average response time 1

number of active processes 1

number of active sessions 1

number of deactivations 1

number of processes 1

number of processes waiting for I/Os 1

number of sessions 1

number of transactions 1

Process Summary

cpu percentage 1

current wait state 1

device file 1

nice value 1

number of physical reads 1

number of physical writes 1

process identification number 1

process name 1

process priority 1

resident set size/size of process 1

response time 1

user name 1

Workload Summary

cpu percentage 1

disk I/O percentage 1

response time 1

transactions per minute 1

user cpu percentage 1

workload group name 1

workload group number 1

Global I/O

Global I/O Summary

local logical average read size 1

local logical average write size 1

local logical reads per second 1

local logical writes per second 1

local physical average read size 1

local physical average write size 1

local physical reads per second 1

local physical writes per second 1

local raw average read size 1

local raw average write size 1

local raw reads 1

local raw reads per second 1

local raw writes 1

local raw writes per second 1

local system FS average read size 1

local system FS average write size 1

local system FS reads per second 1

local system FS writes per second 1

local user file system average read size 1

local user file system average write size 1

local user file system reads per second 1

local user file system writes per second 1

local virtual memory average read size 1

local virtual memory average write size 1

local virtual memory reads 1

local virtual memory reads per second 1

local virtual memory writes 1

local virtual memory writes per second 1

remote logical average read size 1

remote logical average write size 1

remote logical reads per second 1

remote logical writes per second 1

remote physical average read size 1

remote physical average write size 1

remote physical reads per second 1

remote physical writes per second 1

total local logical reads 1

total local logical writes 1

total local physical reads 1

total local physical writes 1

total local system FS reads 1

total local system FS writes 1

total local user file system reads 1

total local user file system writes 1

total remote logical reads 1

total remote logical writes 1

total remote physical reads 1

total remote physical writes 1

M

Memory

Memory Management Configuration

desfree (lower threshold for paging) 1

lotsfree (upper threshold for paging) 1

minfree (out of memory threshold) 1

page size 1

umem (unlockable memory) 1

Memory/Virtual Memory Allocation

memory statistics 1

virtual memory statistics 1

Page Scanner

pages reclaimed per second 1

pages scanned per second 1

Paging

deactivated page statistics 1

fork statistics 1

page fault statistics 1

page statistics 1

virtual memory I/O statistics 1

Process Memory Status

deactivated memory statistics 1

loaded memory statistics 1

System Buffer Cache

maximum size of dynamic buffer cache 1

minimum size of dynamic buffer cache 1

number of headers 1

read cache hit percentage 1

size of buffer cache 1

write cache hit percentage 1

N

Network

Network Interfaces

collision percentage 1

error in percentage 1

error out percentage 1

interface name 1

packets in per second 1

packets out per second 1

Network Summary

errors in percentage 1

network protocols 1

packets in per second 1

packets out per second 1

NFS

NFS Summary

client network time 1

client or server name 1

client read calls per second 1

client service time 1

client write calls per second 1

server read calls per second 1

server service time 1

server write calls per second 1

O

Oracle

Detail Cache

data dictionary cache statistics 1

library cache statistics 1

redo buffer cache statistics 1

row cache statistics 1

waits 1

Detail Database Activity

current locks 1

enqueue releases 1

enqueue requests 1

enqueue timeouts 1

enqueue waits 1

gets 1

number of long tables scanned 1

number of rows sorted 1

number of short tables scanned 1

opened cursors 1

sorts done in disk 1

sorts done in memory 1

user commits 1

user rollbacks 1

waits 1

writes 1

Detail Datafiles

block reads 1

block writes 1

reads 1

size of datafile 1

writes 1

Detail DBWR

background checkpoints completed 1

background checkpoints started 1

buffers scanned 1

checkpoint buffers written 1

checkpoints 1

dirty buffers 1

forced writes 1

free buffer requests 1

free buffers 1

free buffers found 1

LRU scans 1

make free requests 1

physical writes 1

revisions written to the buffer 1

sum of the dirty LRU queue lengths 1

sum scans depth 1

transaction table block writes 1

undo block writes 1

Detail Events

control file statistics 1

db file statistics 1

file statistics 1

log file statistics 1

net events data 1

Detail Latches

cache buffer chain 1

cache buffer LRU chain 1

gets 1

immediate gets 1

immediate misses 1

misses 1

redo log buffer latches 1

Detail Memory and Network

bytes received from client 1

bytes received from dblink 1

bytes sent to client 1

bytes sent to dblink 1

db block buffers 1

dictionary cache 1

free memory 1

library cache 1

log buffers 1

PGA memory 1

PGA memory maximum 1

roundtrips (client) 1

roundtrips (dblink) 1

SQL area 1

UGA memory 1

UGA memory maximum 1

Detail Rollback Segments

gets 1

hit ratio 1

waits 1

writes 1

Main

active sessions 1, 2

buffer hit percentage 1

commits 1

connection to instance 1

connections 1

dictionary hit percentage 1

instance 1

library hit ratio percentage 1

locks 1

opened cursors 1

rollbacks 1

P

Process Detail

CPU

context switches percentage 1

cpu percentage 1

cpu time 1

interrupts percentage 1

system percentage 1

user percentage 1

Disk

log reads 1

log reads per second 1

log writes 1

log writes per second 1

physical reads 1

physical reads per second 1

physical writes 1

physical writes per second 1

raw reads 1

raw reads per second 1

raw writes 1

raw writes per second 1

system reads 1

system reads per second 1

system writes 1

system writes per second 1

user reads 1

user reads per second 1

user writes 1

user writes per second 1

virtual memory reads 1

virtual memory reads per second 1

virtual memory writes 1

virtual memory writes per second 1

ID

process command 1

process group name 1

real user name 1

Memory

major page faults 1

minor page faults 1

number of deactivations 1

process memory state 1

resident set size 1

virtual set size 1

PID

parent process identification 1

process identification 1

Scheduling

process nice value 1

process priority 1

process scheduling policy 1

Terminal

chacter I/Os 1

terminal device file 1

terminal state 1

Process File Usage

Open Files

access type 1

file name 1

file type 1

number of references 1

offset 1

percentage completed 1

size 1

Process File Usage

device file 1

process identification 1

process name 1

user name 1

Process Memory Regions

Memory Regions

front store file 1

resident set size 1

type 1

virtual memory address 1

virtual memory set size 1

Process Memory Regions

device file 1

process identification 1

process name 1

user name 1

Region Types

data 1

I/O 1

memory map 1

other 1

shared memory 1

stack 1

text 1

total virtual memory used 1

Pulse Points

Pulse Points Summary

comments 1

green (acceptable range) 1

indicator name 1

red (unacceptable range) 1

yellow (questionable range) 1

S

Summed 1

Swap

Per Swap Utilization

device file of the swap device 1

file system swap space allocated 1

mount point of file system swap 1

priority of file system 1

priority of swap device 1

swap space configured for device 1

swap space configured for file system 1

swap space not used 1

swap space used in device 1

swap space used in file system 1

type of swap 1

Swap Summary

total swap space available 1

total swap space configured 1

total swap space reserved 1

total swap space used 1

System Configuration

File System Configuration

fs_async (asynchronous inodes) 1

nfile (entries in file table) 1

ninod (entries in the inode cache) 1

IPC Configuration

msgmap (message map entries) 1

msgmax (max size of a single message) 1

msgmnb (max length of message queue) 1

msgmni (message queue identifiers) 1

msgseg (message buffer cache segments) 1

msgssz (size of each message segment) 1

msgtql (message headers) 1

semaem (max undo value) 1

semmap (SYSV semaphore map entries) 1

semmni (SYSV semaphore identifiers) 1

semmns (SYSV semaphores available) 1

semmnu (number of undos) 1

semume (max undo entries per process) 1

semvmx (SYSV semaphore max value) 1

shmmax (max shared memory segment size) 1

shmmni (shared memory identifiers) 1

shmseg (max shared memory segments attached to a process) 1

Memory Management Configuration

desfree (lower threshold for paging) 1

lotsfree (upper threshold for paging) 1

out of memory threshold 1

page size 1

umem (unlockable memory) 1

Process Configuration

maxdsiz (max data segment size) 1

maxfiles (hard max open process files) 1

maxfiles (max open process files) 1

maxssiz (max stack segment size) 1

maxtsiz (max text segment size) 1

maxuprc (max processes per user) 1

nproc (entries in process table) 1

timeslice (timeslice scheduling interval) 1

Swap Configuration

nswapdev (max swap devices) 1

nswapfs (max swap file systems) 1

System Configuration

boot time 1

cpu type 1

operating system version 1

run level 1

system name 1

system serial number 1

SYSV Buffer Cache Configuration

bufpages (pages in buffer cache) 1

dbc max (max page size of DBC) 1

dbc min (min page size of DBC) 1

nbuf (buffer cache headers) 1

System Table/Cache Configuration

System Table/Cache Summary

DNLC cache entries 1

DNLC cache hit percentage 1

file lock table entries 1

file lock table used percentage 1

file table entries 1

file table used percentage 1

inode cache entries 1

inode cache used percentage 1

message buffer cache entries 1

message buffer cache used percentage 1

message table entries 1

message table used percentage 1

process table entries 1

process table used percentage 1

pseudo tty table entries 1

pseudo tty table used percentage 1

semaphore table entries 1

semaphore table used percentage 1

shared memory entries 1

shared memory table entries 1

shared memory table used percentage 1

shared memory used percentage 1

SysV buffer cache entries 1

SysV buffer cache hit percentage 1

SysV buffer cache used percentage 1

SysV buffer header entries 1

SysV buffer header used percentage 1

T

Terminal

Terminal Summary

attached processes 1

characters read per second 1

characters written per second 1

idle time 1

login time 1

name of user at terminal 1

terminal device file 1

U

User

User Summary

cpu resources consumed by user 1

physical I/Os associated with user 1

processes owned by user 1

RAM consumed by user 1

sessions opened by user 1

terminal I/Os associated with user 1

user identification number 1

user name 1

virtual memory consumed by user 1

V

Volume

Volume Summary

logical reads per second 1

logical volume special device file 1

logical writes per second 1

physical reads per second 1

physical writes per second 1

volume group directory 1

Volume Detail

Mapping Information 1

Volume Detail

logical average read size 1

logical average write size 1

logical read rate 1

logical write rate 1

MWC hits 1

MWC misses 1

MWC queue length 1

MWC size 1

physical average read size 1

physical average write size 1

physical read rate 1

physical write rate 1

raw average read size 1

raw average write size 1

raw read rate 1

system fs average read size 1

system fs average write size 1

system fs read rate 1

system fs write rate 1

user fs average read size 1

user fs average write size 1

user fs read rate 1

user fs write rate 1

virtual memory average read size 1

virtual memory average write size 1

virtual memory read rate 1

virtual memory write rate 1

volume device file 1

W

Workload Definitions

Worklaod Definitions

name of workload group 1

number of workload group 1

type of workload group 1

workload group specifications 1

Workload Detail

CPU Usage

cpu percentage 1

Disk I/O Usage

logical reads 1

logical reads per second 1

logical writes 1

logical writes per second 1

physical reads 1

physical reads per second 1

physical writes 1

physical writes per second 1

raw reads 1

raw reads per second 1

raw writes 1

raw writes per second 1

system reads 1

system reads per second 1

system writes 1

system writes per second 1

total logical disk I/Os 1

total physical disk I/Os 1

total raw memory I/Os 1

total system I/Os 1

total user I/Os 1

total virtual memory I/Os 1

user reads 1

user reads per second 1

user writes 1

user writes per second 1

virtual memory reads 1

virtual memory reads per second 1

virtual memory writes 1

virtual memory writes per second 1

Memory

context switch percentage 1

cpu time 1

deactivations per second 1

interrupts percentage 1

major page faults per second 1

minor page faults per second 1

resident set size 1

system percentage 1

user percentage 1

virtual memory set size 1

Process Summary 1

Wait States 1

Workload Detail

process count 1

workload group name 1


Lund Performance Solutions
www.lund.com
Voice: (541) 812-7600
Fax: (541) 81207611
info@lund.com
TOCPREVNEXTINDEX