calculate Table size usage in Oracle Database

This script shows able size usage in Oracle Database

select TABLE_NAME, ROUND((AVG_ROW_LEN * NUM_ROWS / 1024), 2) SIZE_KB from USER_TABLES order by TABLE_NAMEView Blog

Solution for Check_nrpe Timeout issue

I have been struggling to figure out solution each time when i encounter the error"CHECK_NRPE: Socket timeout after 60 seconds."

Here are the solution that worked so far.

Solution 1

 * check the windows time service and it is syncing with NTP via Active Director or NTP server

Solution 2

 * Sometimes, this error occurs when using an IP address to connect to a device. Try using the hostname or FQDN (Fully Qualified Domain Name) instead. In PRTG, please enter this information in the device's settings (section "Credentials for Windows Systems").

Follow here if need more infor and error about WMI services

http://www.paessler.com/knowledgebase/en/topic/1073-what-are-the-most-common-errors-when-monitoring-wmi

Tools 

wmi tester indeed helped me to figure the issue with WMI service on remote hosts

http://www.paessler.com/tools/wmitester