dbsnaps | database video tutorials

Liron Amitzi Oracle ACE

Oded Raz Oracle ACE Director

Oracle 11g Linux Installation

Oracle installation on Linux requires several pre-requirements and steps to complete.

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

This video will show you how it is done, step by step. We will start in checking the requirement for Oracle installation. Then we continue with the steps to complete before starting the installation. We will finish with some final tasks after the installation is complete.

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.

Jan 30 2010 / 7 comments / Read More »

Tips & Tricks

» 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
» 04:44 Oracle Associative Arrays

Oracle - Latest Articles

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 / No comment / Read More »

Oracle Wait Event – db file sequential read

db file sequential read is an important and common wait event in Oracle databases. We'll try to understand what it means....

Aug 17 2010 / 1 comment / Read More »

Oracle Wait Event – db file scattered read

db file scattered read is an important and common wait event in Oracle databases. We'll try to understand what it means....

Aug 17 2010 / No comment / Read More »

SQL Server - Latest Articles

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 / 1 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 »

SQL Server – Determining Index Usage

Indexes have large effect on each database. They can improve queries performance dramatically, but too many of them can cause performance degradation and overhead when...

May 4 2010 / 11 comments / Read More »

Replicating virtual machines with Oracle databases

Aug 23, 2010 / More »

Oracle Active Standby Database

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 »

Analyzing Oracle AWR reports – top 5 events

This is the first post related to analyzing AWR reports. We will focus on the "top 5 events" of the page, what is the importance of this part and understanding some of the...

Aug 17, 2010 / More »

Oracle Transparent Database Encryption

To comply with company and federal regulations, you need a solution immediately, without any complex coding. A new feature in Oracle Database 10g Release 2 lets you do just that: You can declare...

Jan 31, 2010 / More »