dbsnaps | database video tutorials

Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Oracle 11g Linux Installation

In this video we will demonstrate Oracle 11g installation on Linux.

When installing Oracle on Linux, there are several prerequisites steps that needs to be completed before the installation process ifself.

The installation GUI is identical to other operating systems, but the steps we need to complete before starting the installation are different.

This video will show you how to install Oracle 11gR1, step by step.

This video shows Oracle 11gR1 installation on Linux Cent OS 5 (which is similar to RedHat 5), but can be used to understand the general Oracle installation on Linux.

You can download the Oracle Database software from OTN:

Jan 30 2010 / 4 comments / Read More »

Tips & Tricks

» 06:42 Oracle 11g Performance Features
» 04:12 Replicating virtual machines with Oracle databases
» 07:35 Oracle Wait Event – db file sequential read
» 07:35 Oracle Wait Event – db file scattered read
» 07:34 Analyzing Oracle AWR reports – top 5 events
» 07:29 Determine query for Linux process
» 13:14 Oracle – How to kill orphan sessions easily
» 01:29 Creating Multiple AWR reports

Oracle - Latest Articles

Data Masking – JumbleDB

JumbleDB is a simple to use yet very powerful and complete data masking suite. See how it works...

Apr 5 2012 / No comment / Read More »

Installing Oracle ASM 11gR2

In this movie-clip we will show you how to install oracle 11g ASM filesystem ...

Nov 13 2011 / No comment / Read More »

Oracle 11gR2 New Feature – Deferred Segment Creation

In this DBSNAPS tutorial video we will present you a new feature of Oracle database 11gR2: Deferred segment creation. ...

Dec 6 2010 / No comment / Read More »

SQL Server - Latest Articles

SQL Server 2008 – Using Query Hashes and Query Plan Hashes

In this post we will discuss SQL tuning methods by using DMV (sys.dm_exec_query_stats and sys.dm_exec_requests) and how to use Query Hashes and Query Plan Hashes...

Dec 5 2010 / No comment / Read More »

Rolling back TRUNCATE statements in SQL Server

There are two main ways to delete all records from a table - DELETE and TRUNCATE commands, but if we do, can we rollback the...

Jul 28 2010 / No comment / Read More »

SQL Server – How to determine instance uptime

In this article we will demonstrate how to retrieve the startup time of SQL Server...

Jul 9 2010 / No comment / Read More »

Replicating virtual machines with Oracle databases

Virtual machines are used in many organizations due to the simplicity of administration, especially in development environments. This post will describe how to configure the new replicated machine to work with the Oracle database....

Aug 23, 2010 / More »

Oracle Active Standby Database tutorial

A physical standby database could always be opened in "read only" mode. The problem was that it didn't apply any archived logs at that time. It could only apply logs when mounted. Then came...

Feb 7, 2010 / More »

SQL Server 2008 – Using Query Hashes and Query Plan Hashes

In this post we will discuss SQL tuning methods by using DMV (sys.dm_exec_query_stats and sys.dm_exec_requests) and how to use Query Hashes and Query Plan Hashes in SQL Server 2008....

Dec 5, 2010 / More »

Data Masking – JumbleDB

JumbleDB is a simple to use yet very powerful and complete data masking suite. See how it works...

Apr 5, 2012 / More »