Installing Oracle ASM 11gR2

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

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.

Parallel New Features in Oracle 11gR2

Oracle 11gR2 brings us new features related to parallelism.
The new features are controlled by the PARALLEL_DEGREE_POLICY initialization parameter. Learn how to use these new features to leverage your needs.

Oracle 11g Performance Features

Oracle 11g brings us many performance related features. In this article we will cover several of these features.

Oracle – Writing into the Alert.log file

The Alert.log file is a log that chronological records important information about error messages and exceptions during daily database operations, learn how to insert a manual records into this useful file.

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.

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.

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.

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 main wait events.

Determine query for Linux process

In this article we will demonstrate how to retrieve the SQL statement of the most CPU consuming process in Linux/Unix