Category Archives: Oracle Database

orasetup

Posted on November 6, 2023 by andy.rivenes

orasetup is one of the first utilities that I wrote when I started out working with Oracle databases. oraenv, in my opinion, just doesn’t have the flexibility to accommodate all of the the different environment variables for the various Oracle … Continue reading →

Posted in Oracle Database | Comments Off on orasetup

SQL Monitor Active Reports

Posted on June 29, 2023 by andy.rivenes

In Oracle Database SQL Monitor is an easy to use tool for getting details about SQL statement execution. We use it all the time for Database In-Memory queries. I even wrote a technical brief to explain how to create and … Continue reading →

Posted in Oracle Database, Performance Tuning | Tagged , , , | Comments Off on SQL Monitor Active Reports

Oracle Logging Framework (OLF)

Posted on May 14, 2018 by andy.rivenes

The Oracle Logging Framework (OLF) is an Oracle PL/SQL based logging and debugging utility that supports “levels” similar to Log4J. The key feature of the OLF is the ability to dynamically set a logging level based on almost any combination … Continue reading →

Posted in Oracle Database | Comments Off on Oracle Logging Framework (OLF)