Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Cloud Architecture. Open-Source Databases. Data-Driven Solutions.
Stuff about Oracle Database 12cR1
In this blog post I am sharing my notes about Unified Auditing. It shows how to enable and purge Unified Audit data. From Oracle Documents: What Is Unified Auditing? In unified auditing, the unified audit trail captures audit information from…
….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR). But first you’ll need a graveyard 🙂 , in other words AWR Warehouse Repository. AWR…
I attended a session in Oracle Open World 2016 given by Kyle Hailey. In his presentation Kyle talked about how to measure database performance and what to look for when application is running slow. I am sharing few notes from…
This is the second part of my blog about Shell scripting with focus on Oracle database. Here is an example of how you can use shell variables in sqlplus to create dynamic sql. Shell to SQLPLUS Here I am using…
I am going to start blogging about shell scripting tips and technique focusing on database and how they can be used to make DBA life easier. Here is an example of how to save result from SQL query into Shell variable. Commands…
All most all of Oracle DBAs are familiar with command to flush shared pool: alter system flush shared_pool; This command clears all data from shared pool in system global area (SGA). The shared pool stores cached data dictionary information and…