Session ID: 618


Many database administrators are enslaved by their consoles, completely dependent on GUI-based database management tools not only for modifications but for all diagnostics.

This session is about breaking away from that trap, getting into the Linux/UNIX shell, and finding out what is really going on within the operating system. It explores the basic architecture of Oracle Database and the TNS Listener within a Linux, AIX, Oracle Solaris, or HP-UX environment and demonstrates the command line tools of the operating-system used in displaying operating system processes and structures.

The session also covers viewing system information, process information, and debugging using diagnostic tools such as strace and dtrace.

Objective 1: 1. Understand why the operating-system command-line is important even if you already have a graphical management utility

Objective 2: 2. Explain the available Linux/UNIX commands first from a high-level (i.e. system level) down to a more granular level for processes and threads

Objective 3: 3. Explain underlying subsystems such as virtual memory and inter-process communication so that attendees understand what the command-line utilities are displaying, and why

Audience: In-Depth