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.

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.

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 operation?

Creating Multiple AWR reports

Analyzing AWR (Automated Workload Repository) is a common operation while doing a performance and tuning sessions on a database instance.

Oracle – Running sqlplus From UNIX bash Scripts

Today we’re going to see how to connect and run queries on a database from a UNIX bash script.

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 changing data. This tip contains a script that will help you to find useful information about index usage in your database.