Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hello all,
I am trying to document things that need to be monitored on our database
(7.30.UC3 on HP-UX 10.20) and I am wondering if anyone has any more
suggestions for things to look at. Here is what I have so far.
Locking number of currently held locks - (onstat -u)
locks with waits (onstat -u)
ovlock increase.(onstat -p)
locks held excessive amount of time (onstat -u)
Logging
Logical logs filling up (onstat -d)
Physical logs filling up (onstat -d)
LRU usage (onstat -R)
Shared Memory
Read/Write Caching percentage low (onstat -p)
FG Writes (onstat -F)
Checkpoint waits (onstat -p)
Read Ahead usage (onstat -p)
Buffer Waits (onstat -p)
Checkpoint duration (onstat -m)
Checkpoint frequency (onstat -m)
Virtual Segments being dynamically added. (onstat -g
seg)
Table spaces
number of extents (oncheck -pe)
I/O Balancing (onstat -dD)
DBSpace utilization (onstat -dD)
VPs
AIO VP usage high/low (onstat -g iov)
Number of Cleaners ( = #LRUS)
CPU VP usage high/low (onstat -g glo)
Archiving
Backups done?
If you have any suggestions/additions I would be grateful to hear them.
I may not have these classified properly. Feel free to suggest a
different or new category if I am in error here. Once I have completed
my documentation I would be glad to post it if anyone would be
interested.
TIA
James
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.