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.

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 Associative Arrays

Working with arrays in PL/SQL is not very complicated, this is a sequence of cells we can access by their index.

Sometimes, all we need is to get a value from an index we have, and this index is not a sequence number, but a number that has meaning or even text.

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.

Oracle – Monitoring Long Operations

There are several specific operations that are considered as long operations.
When performing one of these operations, we can follow the progress of the operation

Oracle Database Vault – Advanced Factoring tutorial

Learn how to fully utilize database vault factors to control access to your database objects.

Creating an Oracle Standby Database – Data Guard tutorial

Physical standby database is a common solution for DR. We can maintain it automatically using Data Guard, or manually by copying archived redo logs to the standby server and apply them to the database.