CHAPTER 3

image

Managing Processes and Users

Diagnosing and resolving availability and performance issues is a key part of every DBA’s job. When troubleshooting problems, DBAs often start by identifying the processes that are currently running and identifying details about users logged on to the server. It is critical to know how to extract process and user activity from the OS.

When you work with OS users and processes, some of your tasks require root privileges. For example, when you install database software on the server, one of the first steps is to create an OS user and group. Depending on your environment, you might not have a system administrator ...

Get Linux and Solaris Recipes for Oracle DBAs, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.