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

The Database Handyman

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

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

Generate Meta Data Since Last Restore Point

February 28, 2016March 12, 2016 Aamir

I was asked if it was possible to generate all ddl since last restore point. I came up with following script. It might help others

Read More
OEM Cloud Control 12c Oracle Database 11gR2

Oracle Database Service

January 29, 2016January 29, 2016 Aamir

Recently at my work place for the first time, I planned and executed QA environment failover test to standby database and was asked how come

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
OEM Cloud Control 12c

Important Steps Before Upgrading OMR database to 12c PDB

November 21, 2015 Aamir

Here are some important steps that needs to be done before you upgrade Oracle Managed Repository (OMR) database to 12c PDB. First you have to

Read More
Oracle Database 11gR2

How to Clone Oracle Grid Infrastructure / Restart and database Home

November 14, 2015 Aamir

Following instructions can be used to clone Oracle Grid Infrastructure Restart from already working Oracle Linux Server to another new server.  This method can save

Read More
OEM Cloud Control 12c

Can’t access Weblogic Console | ERR_SSL_WEAK_SERVER_EPHEMERAL_DH_KEY

October 29, 2015November 30, 2015 Aamir

When accessing WebLogic Console for OEM Cloud Control using Chrome, I received following error. I knew nothing has changed, no new patches were applied. So

Read More
Oracle Database 11gR2

ORA-01180: can not create datafile 1 during restore

October 18, 2015 Aamir

I came across this error at work and thought it was worth blogging. Maybe someone else can benefit from it and not spend hours looking

Read More

Posts navigation

Previous 1 2 3 Next

About Me

I am a Principal Database Engineer. I like working on query performance tuning, database optimization and new challenges. I also architect database designs and help developers build efficient applications.

  • facebook
  • twitter
  • linkedin

Recent Posts

  • 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
  • Unified Auditing November 4, 2020
  • Before Upgrading to 19c November 2, 2020
  • LinkedIn
  • twitter
  • facebook
All Rights Reserved 2021.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.