While working on a project I had a need to subtract 1 hour from the current time. We are running Python 2 on linux and I could not quite find a function that did what I wanted. Continue reading “Subtract 1 hour from the current time”
Month: November 2016
Display comparison of paging
Displays comparison of paging; 1 second apart; 2 times.
[prodsrvr] sar -p 1 2 Linux 2.6.32-642.3.1.el6.x86_64 (prodsrvr) 11/22/2016 _x86_64_ (24 CPU) 01:50:21 PM CPU %user %nice %system %iowait %steal %idle 01:50:22 PM all 1.43 0.00 0.97 4.16 0.00 93.44 01:50:23 PM all 1.26 0.00 1.35 0.97 0.00 96.43 Average: all 1.35 0.00 1.16 2.56 0.00 94.93
mpstat command – activities for each available processor
The mpstat command display activities for each available processor, processor 0 being the first one. Global average activities among all processors are also reported. It also shows the linux version.
[prodserver] mpstat -P ALL Linux 2.6.32-642.3.1.el6.x86_64 (prodsrvr) 11/22/2016 _x86_64_ (24 CPU) 01:43:12 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 01:43:12 PM all 10.29 0.05 1.68 5.06 0.00 0.09 0.00 0.00 82.83 01:43:12 PM 0 14.39 0.22 3.17 24.52 0.00 0.40 0.00 0.00 57.30 01:43:12 PM 1 13.98 0.20 3.42 24.63 0.00 0.56 0.00 0.00 57.22 01:43:12 PM 2 12.93 0.07 2.64 25.44 0.00 0.25 0.00 0.00 58.68 01:43:12 PM 3 12.78 0.07 2.10 2.03 0.00 0.04 0.00 0.00 82.98 01:43:12 PM 4 13.17 0.04 1.70 1.93 0.00 0.06 0.00 0.00 83.11 01:43:12 PM 5 12.06 0.03 1.61 0.91 0.00 0.03 0.00 0.00 85.37 01:43:12 PM 6 8.90 0.02 1.43 2.79 0.00 0.12 0.00 0.00 86.73 01:43:12 PM 7 9.85 0.03 1.83 24.87 0.00 0.19 0.00 0.00 63.24
SQL to check space issues
The below SQL reports on the space usage by table space along with details on each data file. Additionally, it identifies if a physical standby exists. Continue reading “SQL to check space issues”
Checking the status of RMAN backups
I find the below SQL useful when I want to check when
- the last backup ran
- how long the backup takes
ORA-17629: Cannot connect to the remote database server on resync catalog from a physical standby database
On the standby database we were getting the below error. Both the primary and standby are 4 node RACs.
Pictures from Lincoln meet and Museum
Some pictures from previous meetings of the Lincoln and Continental Owners Club.