Oracle Wait Event – db file sequential read

db file sequential read is an important and common wait event in Oracle databases. We’ll try to understand what it means.

Oracle Wait Event – db file scattered read

db file scattered read is an important and common wait event in Oracle databases. We’ll try to understand what it means.

Analyzing Oracle AWR reports – top 5 events

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.

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

Oracle Active Standby Database tutorial

A physical standby database could always be opened in “read only” mode. The problem was that it didn’t apply any archived logs at that time. It could only apply logs when mounted.

Then came Oracle 11g…

Oracle Datafile High Watermark

Datafiles in Oracle can be resized to a smaller size only if there are no used blocks at the end of the file. If there is a used block at the end of the file we will not be able to reduce it size even if the rest of the file is empty

Creating an Oracle 11g Database tutorial

This video will show you how to create an Oracle 11g database