Monthly Archives: January 2014

Getting List of Users and Roles on Oracle DB

Posted on January 24, 2014 by SoCRaT

This is a simple SQL statement to get you a list of all users and their roles in the Oracle DB: “SELECT * FROM DBA_role_privs;” And if you want to get the list of users related to a specific role, … Continue reading →

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

Knowing when you should be concerned about your Linux CPU Load Average

Posted on January 22, 2014 by SoCRaT

This is one of the most important things to learn by any System Admin.; the CPU Load Average. You can get the value simply by running the command “top” to get you the average value in the last 1 min, … Continue reading →

Posted in Uncategorized | Tagged , , , , | Leave a comment

How to get number of cores on your Linux Box

Posted on January 22, 2014 by SoCRaT

cat /proc/cpuinfo | grep “model name” | wc -l example output: 24 This means that you have 24 cores on your server.

Posted in Linux | Tagged , , , , , , , | Leave a comment