NOTE:

All the videos in this blog are High Definition Videos most with Audio. The videos are best watched in full screen with "HD option enabled". You would also find screenshots and some handy scripts for DBAs.
Showing posts with label Videos. Show all posts
Showing posts with label Videos. Show all posts

Wednesday, November 22, 2017

Oracle Database Patches




This video gives an introduction to Oracle Database patches. 



Tuesday, January 12, 2010

Cold backup of a database using rman

There were many requests made to me for covering some backup recovery videos through rman..

In this video I would be demonstrating a simple cold backup of a database using rman.

Friday, December 11, 2009

Introduction to Shell Scripting - II

Here is the second video..

Tuesday, December 8, 2009

Introduction to Shell Scripting

In these videos I would be covering the basics of shell scripting.
The videos are split into 3 parts, Here is the 1st video



The topics covered in this tutorial are:


1. A simple hello world.
2. A script to add two numbers
3. A script to add two numbers passed as command line parameters.
4. Understanding the Exit status $?
5. Demonstrating through practical example: Check if a listener is up. If it is not then display a message that the listener is down.
6. Executing sql queries from shell script- In the example we check if the database is up or not.
7. Using cut, awk to find specific fields in an output.
8. How to read contents of a file line by line and evaluating each line for a specific string.
9. Using this for finding mountpoints above 90% used.
10. Sending attachments through emails.

Tuesday, November 10, 2009

Using TKPROF

In this presentation I would be covering a practical example of using tkprof to find out the problem query from a raw trace file.