Liron Amitzi Oracle ACE
Oded Raz Oracle ACE Director
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.
Today we’re going to see how to connect and run queries on a database from a UNIX bash script.
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