Linux Tips, Tricks and Shortcuts for the Oracle Professional

Name: Linux Tips, Tricks and Shortcuts for the Oracle Professional
Rating: 4.1 (46 reviews)

How to use Linux to Troubleshoot Network, Memory, I/O, and Oracle Database Issues

Created byCory Holmes, MBA

Last updated 7/2018

English

What you'll learn

Perform basic commands in the shell
Use Linux to manage processes and users
Create and manage files and directories
Utilize basic shell scripting to perform Database Administration tasks
Analyze server performance
Automate Database Administration tasks
Use the shell to analyze database blocks for corruption

Course content

8 sections • 28 lectures • 1h 6m total length

Intro1:28
Learn shell scripting to level up your Oracle professional career, covering writing simple shell scripts, condition checks, parameters, repeated tasks, database commands, scheduling, and background jobs.

Introduction to Linux Commands0:21
Explore basic shell commands to execute, search history, pipe outputs, create aliases, run background tasks, and access command help, essential for Linux tips and Oracle professionals.
Finding Help in the Command LIne1:02
Master how to use man pages for command help, including ls, its description, and options. Learn to combine ls options like -l and -lt to sort by time.
Viewing Previously Run Commands1:03
Pipelining1:33
Creating an Alias3:15

Introduction to Analyzing the Linux OS1:20
Pinpointing System Bottlenecks2:22
Pinpoint bottlenecks quickly using vmstat to monitor time waiting for io, sleeping processes, and memory swap, then collect metrics every three seconds for five intervals to diagnose slow databases.
Monitoring Disk Space1:42
Learn to interpret free, used, and available disk space with human-readable percentages, identify when usage reaches a threshold (85-90 percent), and prevent database hangs from a full filesystem.
Pinpointing Memory Bottlenecks1:31
Use the free command in a human-readable format to monitor physical memory and swap on your database server, and examine /proc/meminfo for total, free, available memory to identify bottlenecks.
Identify what's consuming CPU3:23
Monitoring I/O2:55
Monitoring Network Traffic4:37

Requirements

Students should know the basic UNIX/LINUX commands
Students should have basic SQL Knowledge

Description

This course provides a Problem/Solutions based approach for Oracle professionals working in a Linux environment. We cover Linux topics as it pertains to Oracle Database and utilizing the operating system. This course is not meant for videos to be watched in order. Rather, each topic is a how-to guide for a particular problem.

Here's What People Are Saying About Cory and His Courses:

"Useful everyday commands. Great courses for starting dba's and system administrators." --Shaun Marquis, Udemy student

"So much great information and easy to understand!" --Renee’ Roberts, Udemy student

"Great course! A lot of important core knowledge to learn in each module." --Kendal Barlow, Udemy student

Who this course is for:

Students who want to become Oracle Database Administrators
Database Administrators who want to enhance their career as an Oracle Professional
IT professionals who work in Linux/Unix environments

Linux Tips, Tricks and Shortcuts for the Oracle Professional

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Basic Linux Commands5 lectures • 7min

Managing Processes and Users4 lectures • 5min

Creating and Editing Files1 lecture • 4min

Analyzing the Linux Operating System7 lectures • 18min

Basic Shell Scripting8 lectures • 26min

Identifying Corruption1 lecture • 3min

Summary1 lecture • 1min

Requirements

Description

Who this course is for: