Tag: Oracle

Purge statspack snaps of source db on test db having different DBID?

As most DBAs are aware, the clean deletion of the old statspack snaps is very difficult up to rdbms version 9i. Thanks to the statspack.purge procedure introduced by oracle from 10gR1 version, now it’s possible to purge un-referenced data too….

Read More >

Do AWR Reports Show the Whole Picture?

AWR report is a great source of aggregated information on top activities happening in our databases. I use data collected in AWR quite often, and obviously the easiest way of getting the data out from the AWR is by running the…

Read More >

Disabling Triggers in Oracle 11.2.0.4

Yes you can still disable triggers per-session in Oracle 11.2.0.4, but you have to have a GoldenGate license, set the enable_goldengate_replication parameter, use a program name that starts with replicat, and set your module to OGG.

Read More >

Statistics gathering and SQL Tuning Advisor

Our monitoring software found a long running job on one of our client’s databases. The job was an Oracle’s auto task running statistics gathering for more than 3 hours. I was curious to know why it took so long and…

Read More >

Do you have enough Redo?

The question of whether a database has enough redo logs available is quite common. The documentation suggests to use FAST_START_MTTR_TARGET and V$INSTANCE_RECOVERY.OPTIMAL_LOGFILE_SIZE to identify “the optimal” redo log size based on the target recovery time. I’ve never used it and…

Read More >

Troubleshooting Oracle’s Auto Service Request

I’ve spent the better part of the day troubleshooting an issue with Oracle’s Auto Service Request (ASR) and wanted to share my results in case if saves someone else some effort.

Read More >

Build An EBS 12.2.2 Sandbox Fast(ish) In Virtualbox from OVM templates

Update, 7 March 2014: I don’t often suggest this, but: stop reading this post! Oracle has (finally, yay!) released VM templates for EBS 12.2.3 that can be imported to Virtualbox directly! If you want an EBS 12.2 sandbox in Virtualbox,…

Read More >

Best Certificate Authority for Jar file signing in Oracle E-Business Suite

Most of you are already aware of the recent announcement on Steven Chan’s blog  about New JRE requirements that require EBS JAR files to be signed by a Code Signing Certificate. This requirement came in as Oracle is tightening up security…

Read More >

How to recover a subset of an Oracle database

Today’s blog post will discuss how to recover a subset of an Oracle database. Many of you would have come across different recovery scenarios, but I’ll be talking about a very different one that happened to me. The following are…

Read More >

Online Storage Migration without ASM

I recently blogged about Playing with ASM Online Migration and still soul searching from not having jumped on the ASM band wagon. How can online storage migration be performed before ASM came about? One option is using Logical Volume Manager…

Read More >