Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
Oracle 11g brings us many performance related features. In this article we will cover several of these features.
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.
db file sequential read is an important and common wait event in Oracle databases. We’ll try to understand what it means.
db file scattered read is an important and common wait event in Oracle databases. We’ll try to understand what it means.
This is the first post related to analyzing AWR reports. We will focus on the “top 5 events” of the page, what is the importance of this part and understanding some of the main wait events.
In this article we will demonstrate how to retrieve the SQL statement of the most CPU consuming process in Linux/Unix
In this article we’ll see a script that will help developers to kill applicaitions orphan sessions, even on RAC environment.
Analyzing AWR (Automated Workload Repository) is a common operation while doing a performance and tuning sessions on a database instance.
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.
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?