Skip to content
  • About Me
  • Buy Adspace
  • Search Results
  • LinkedIn
  • twitter
  • facebook

The Database Handyman

My notes about Oracle Database, APEX, OEM Cloud Control and whatever I learn

Category: Oracle Database 12cR1

Stuff about Oracle Database 12cR1

  • Home
  • Oracle Database 12cR1
Oracle Database 12cR1 Oracle Database 19c

Unified Auditing

November 4, 2020November 4, 2020 Aamir

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:

Read More
Photo by Einar Storsul on Unsplash
Oracle Database 11gR2 Oracle Database 12cR1 SQL Query performance

Apply Execution Plan From Graveyard

February 21, 2017December 25, 2020 Aamir

….yes, that is correct. 🙂 You can apply an execution plan even if it has been aged out from your local Automatic Workload Repository (AWR).

Read More
Oracle Database 11gR2 Oracle Database 12cR1

Advance Active Session History

September 20, 2016 Aamir

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

Read More
Oracle Database 11gR2 Oracle Database 12cR1 Shell Script

Variables: Shell Variables in SQL*PLUS

March 16, 2016March 15, 2016 Aamir

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

Read More
Oracle Database 11gR2 Oracle Database 12cR1 Shell Script

Variables: Shell, SQL*PLUS and PL/SQL

March 11, 2016March 15, 2016 Aamir

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.

Read More
Oracle Database 11gR2 Oracle Database 12cR1

How to Flush SQL Cursor Cache from Oracle Library Cache

December 5, 2015 Aamir

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

Read More

About Me

Welcome to The Database Handyman! I’m Aamir Haroon, a Senior Cloud Data Architect with over a decade of experience. I specialize in optimizing, managing, and migrating databases to ensure your data works smarter for you. With certifications such as Google Cloud’s Professional Cloud Database Engineer and AWS Certified Database – Specialty, I bring industry best practices to every project. Let’s tackle your database challenges together—reach out today!

  • facebook
  • twitter
  • linkedin

Recent Posts

  • Improve Reliability in PostgreSQL 17: Leveraging Logical Replication Failover January 28, 2025
  • Oracle Standby Database Parameters in PDB January 30, 2022
  • Upgrade Standby Database December 6, 2020
  • Patch Oracle GI and DB Software Only And Create Gold Image November 24, 2020
  • Enforce Execution Plan of “hinted” SQL To “non-hinted” SQL November 9, 2020
  • LinkedIn
  • twitter
  • facebook
All Rights Reserved 2024.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.