carlos-sierra / edb360 Goto Github PK

Just running edb360 on a solaris box and just noticed this error right at the beginning

cat: cannot open /proc/cpuinfo: No such file or directory

Obviously there is no /proc/cpuinfo on Solaris. One could get that information from prtdiag instead. But then one would have to check for the OS first and possibly create yet another script. Or simply live with an empty output file for cpuinfo_model_name.txt. I guess this is not a big issue as long as nothing else depends on the output of this check being not empty

cheers
bjoern

Using the same environment SQL Health Check is working perfectly fine.

However, edb360 Jan 15, 2018 version is not doing much, and showing lot of errors.

Now zip file seems to be generated.

See attachment for the shell output when executing sqlplus without any user prompt.

executions1787237285448039367 2.txt

I am unable to find information related to MVIEWS and their refresh times. I think it would be a nice idea to include them in this health check.

please take a look at

https://blogs.oracle.com/smartscan-deep-dive/double-counting-of-hcc-stats-prior-to-next-major-release

the below used stats names are not at 19c anymore
SUM(CASE stat_name WHEN 'EHCC Analyze CUs Decompressed' THEN value ELSE 0 END) "Analyze CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Archive CUs Compressed' THEN value ELSE 0 END) "Archive CUs Compressed",
SUM(CASE stat_name WHEN 'EHCC Archive CUs Decompressed' THEN value ELSE 0 END) "Archive CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Check CUs Decompressed' THEN value ELSE 0 END) "Check CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC CUs Compressed' THEN value ELSE 0 END) "CUs Compressed",
SUM(CASE stat_name WHEN 'EHCC CUs Decompressed' THEN value ELSE 0 END) "CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC DML CUs Decompressed' THEN value ELSE 0 END) "DML CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Dump CUs Decompressed' THEN value ELSE 0 END) "Dump CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Normal Scan CUs Decompressed' THEN value ELSE 0 END) "Normal Scan CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Query High CUs Compressed' THEN value ELSE 0 END) "Query High CUs Compressed",
SUM(CASE stat_name WHEN 'EHCC Query High CUs Decompressed' THEN value ELSE 0 END) "Query High CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Query Low CUs Compressed' THEN value ELSE 0 END) "Query Low CUs Compressed",
SUM(CASE stat_name WHEN 'EHCC Query Low CUs Decompressed' THEN value ELSE 0 END) "Query Low CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Rowid CUs Decompressed' THEN value ELSE 0 END) "Rowid CUs Decompressed",
SUM(CASE stat_name WHEN 'EHCC Turbo Scan CUs Decompressed' THEN value ELSE 0 END) "Turbo Scan CUs Decompressed"