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.

Bitwise Operators in Oracle

Working with bit size variables and bitwise operators is quite common in programming, but less common in databases. In Oracle, there is not even a bit datatype. How can we work with bits in Oracle?

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 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.

Oracle Temporary Tablespace Free Space

The temporary tablespace in Oracle is used to store data that is temporary and session specific (sort operations, hash joins, temporary tables data, etc.).
Once a session needs to perform a large sort operation

Oracle Temporary Tablespace Usage

The temporary tablespace in Oracle is used to store data that is temporary and session specific (sort operations, hash joins, temporary tables data, etc.).
Users use the same temporary segments in the temporary tablespace to perform the sort operation, joins, etc. How can we tell which users use the temporary tablespace and how much space they use?