January 2024 – DBA Notes

AWS Oracle

Alert Log file and Listener Log file in AWS RDS Oracle

In AWS RDS Oracle we can use Listenerlog and Alertlog data dictionary views to check errors and other related information. in sqlplus you can use…

Oracle

Guide to Java Versions and Features

Bulent Soylu January 27, 2024 Build (Game Engine)Distribution (Differential Geometry)Java (Programming Language)Java Development Kit Java Virtual Machine JRE OpenJDK Release (Agency)

Background Information First, let’s have a look at some common, practical questions that people have when trying to choose the right Java version for their…

Oracle performance

Index Skip Scanning

Bulent Soylu January 26, 2024 index index skip scan oracle performance

Index Skip Scanning In previous releases a composite index could only be used if the first column, the leading edge, of the index was referenced…