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.

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

Oracle – How to kill orphan sessions easily

In this article we’ll see a script that will help developers to kill applicaitions orphan sessions, even on RAC environment.

Oracle Database Vault tutorial – Step By Step

Learn how to protect oracle database using ORACLE’s revolutionary feature – Database Vault.
In this first chapter we will show you how to install ORACLE Database Vault, and PROTECT schema objects using DV REALMS.

Shrink Oracle Tables Online

Oracle 10g Supply a new alter table option that enables online table reorganization, this option is shrink

Paging Oracle Query Result

Programmers often retrieve big result set using queries and need to split them up in order to display the result correctly. This tip shows you how to split oracle query result sets into pages.

Connect as an Oracle User Without Knowing the Password

In some cases we have to connect to the database as a specific user, but don’t know the password.

There are two ways to handle this problem:

SQL Server 2005 Log Shipping tutorial

Log shipping is the process of automating transaction log copy and apply in order to maintain identical database copy for high-availability or disaster recovery proposes.

SQL Server Login Audit tutorial

Learn how to audit sql server’s login, its simple and its quick.