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?