Oracle system statistics

Oracle System Statistics When I look at the system statistics I’m not really getting any wiser. There a re really a lot of statistics: SQL> select count(*) from v$sysstat; COUNT(*) ———- 2252 SQL> Above from a Oracle 21c instance. I do not want to see them all. I would like to see the change in […]

Continue Reading

sar usage

I like to use the linux utility sar (system activity reporter (?)) I gives a fast and quite complete overview over the performance of a linux system. SAR has a lot of possibilitys. I just highlight a few of them to remember how the syntax is 🙂 CPU information of today oracle@lqas4342:~$sar Linux 4.18.0-425.13.1.el8_7.x86_64 (lqas4342.mod.nl) […]

Continue Reading