Syllabus
© 2007 by Donald K. Burleson
DAY ONE – UNIX server basics
CHAPTER 1 –
Introduction to UNIX
-
Overview of UNIX evolution
-
Introduction to the UNIX architecture
UNIX shells
Case sensitivity
Building UNIX commands
-
Kernel parameters and Oracle
-
UNIX monitors
-
top
-
glance
-
sar
- Monitoring UNIX with vmstat
CHAPTER 2 –
Server monitoring UNIX
RAM memory in UNIX
-
Virtual memory in UNIX
Paging
Swapping
Swap disk definition
-
Overview of RAM uses by Oracle
-
Monitoring RAM usage in UNIX
-
Adjusting the RAM demands of Oracle
SGA components
Using the MTS
CPU usage and Oracle in UNIX
-
The basics of UNIX process scheduling
UNIX task dispatching
Using the nice command
-
Determining the number of CPUs on your server (from bookunix)
-
Viewing the UNIX run queue in vmstat
A run queue alert report
Semaphores and UNIX
CHAPTER 3 –
Extending STATSPACK for server statistics
- Creating
STATSPACK Tables
CHAPTER 4 –
Disk I/O monitoring in UNIX (bookstat material)
-
Extending STATSPACK for UNIX I/O statistics
-
Measuring disk I/O within STATSPACK
-
Using raw devices in UNIX
CHAPTER 5 –
UNIX Network considerations (from bookstat)
-
UNIX networking basics
-
Net8 and network traffic
-
Monitoring the network with the UNIX netstat utility
DAY TWO - The interaction between Oracle
and the UNIX server
CHAPTER 6
– Oracle interfaces to the server
-
Oracle background processes
Monitoring DBWR
Monitoring OPQ
-
Dynamic RAM allocation and UNIX
CHAPTER 7 –
Oracle sessions and the UNIX server
-
Dedicated connections and UNIX
Using the ps command to count sessions
-
Monitoring UNIX activity at the session level
Connecting UNIX sessions to Oracle sessions
UNIX interaction with MTS connections (mts.sql)
CHAPTER 8
– Building a server monitor with STATSPACK
-
Monitoring UNIX file systems
-
Monitoring trace, log and dump files
-
Monitoring the alert log
-
Scheduling UNIX monitoring tasks
CHAPTER 9
– Creating server exception reports and alerts
-
Interfacing server reports with STATSPACK extension tables
Scripts for vmstat_alert
-
Reporting on the status of UNIX file systems
Details on server monitor script
Day Three – UNIX Administration for the
Oracle DBA
CHAPTER 10
– UNIX administration for the Oracle DBA
-
Areas of UNIX administration
o
Standard UNIX prompt
o
Creating Oracle aliases
o
Changing UNIX environment for
multiple instances
o
File cleanup
o
Scheduling UNIX jobs with crontab
o
Monitoring UNIX file systems with
scripts
-
Setting Oracle file permissions
UNIX basics of file permissions
Default file permissions
Sticky bits
-
Creating ancillary Oracle directories with OFA standard
Udump
Bdump
Cdump
-
Using umask in UNIX
-
Identifying log and trace file directories from the data dictionary (from
script)
-
Monitoring Oracle file systems
Use with autoextend on option
Using the df and du commands
CHAPTER 11
– Oracle job scheduling in UNIX
-
When to schedule jobs in UNIX
-
When to schedule jobs with dbms_job
-
Typical hourly, daily and weekly tasks
-
Interfacing jobs with e-mail and pagers
CHAPTER 12
– Advanced UNIX administration for Oracle
-
Writing UNIX script to access Oracle
-
UNIX script to access remote Oracle databases
-
UNIX scripts to perform enterprise-wide audits
-
UNIX scripts to perform enterprise-wide changes
This
is a BC Oracle training course (c) 2002
