Tag: Technical Blog

A quick look at table-level recovery with Database 12c including sample script and output.

Oracle E-Business Suite Release 12.2.2 is out! Big times ahead of us folks! My team is planning to blog about it a lot. Stay tuned. This is my prediction: Online patching a game-changer in Oracle E-Business Suite 12.2 Oracle Press Release Steven…

I am happy to announce that, thanks to all the volunteers’ hard work and Oracle Technology Network’s support, RAC Attack is going to be part of the Oracle OpenWorld 2013 conference in less than a month’s time.

Oracle Data Pump appeared with release 10gR1 and has been a best friend for Oracle techs ever since. It offers so much more than traditional export/import, but do not let it detract you from its predecessors for even a second. This article offers an introduction to some of the new stuff in 2cR1.

Data Guard Broker in #DB12c introduced a new command, VALIDATE DATABASE, which tremendously lightens the process of information gathering to make sure role change operations succeed. It is very helpful in the case of RAC database usage in Data Guard configuration.

Over the past 8 months, I have had the pleasure of working on a soon-to-be-released update for our popular Beginner’s Guide for Oracle Database 12c. Many of the new 12c features have fascinated me and my peers. I have thirsted in particular for the following handful of rman enhancements that are bundled with Database 12c…

We were using a 10.2.0.3 database, and it had been running without any issues for several years. What could possibly go wrong? Anything!

Security! This is a top-of-mind word for every concerned person when it comes to storing,  accessing, and sharing data, databases, or database servers. When applications are running in a restricted area, they are less likely to be exploited. However, with the increasing popularity of the…

I’m sure one of the most popular scripts for Apps DBAs on My Oracle Support is cmclean.sql from MOS Article ID 134007.1 “Concurrent Processing – CMCLEAN.SQL – Non Destructive Script to Clean Concurrent Manager Tables”. DBAs usually use the script…

A few of my friends asked me to assist them with getting up to speed with SLOB2 testings. I have decided to publish this quick blog post and give people to a few hints. Additional Scripts Here are some of…