Tag: DBA Lounge

getMOSPatch.sh – Downloading Patches From My Oracle Support

How to download patches from My Oracle Support (MOS) directly to the server? This has bothered me since the ftp access was closed a few years ago. Of course, I’ve been given some options by Oracle, like, I could access…

Read More >

Column Store Indexes in SQL Server 2012

Introduction: We will discuss Column Store Index and will try to understand the performance improvements of the same query by multiple times using column store index. What is Column store Index: Column Store Index is a feature introduced in SQL Server 2012…

Read More >

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful information to answer these questions. The data is there, but it not always easy to retrieve it, especially if…

Read More >

Simple and Quick Way to Get SQL_ID of Query in Oracle

If you need to get SQL_ID of a query from a busy system, which has similar queries scattered all around, it becomes a hassle to get what you are looking for. If the query for which you are getting SQL_ID…

Read More >

Troubleshooting Transactional Replication Latency Using Agent Statistics

In this blog post, we will look at how you can leverage the Agent statistics to troubleshoot the replication latency issues. Before understanding how to decode the agent statistics, let’s take a look at the some of the basic things…

Read More >

Table recovery with rman in Database 12c

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

Read More >

Not so good news for MCM Aspirants

A few days back, late Friday (30th August 2013) MS has made an announcement – that they are cancelling the MCM Certification, not so good news for MCM aspirants. This announcement has upset many in the SQL Community including myself….

Read More >

The death of the MCM Program

In case you’re unaware, Microsoft sent a late night email on Friday August 30th announcing it would kill off the MCM, MCSM and MCA certifications as of October 1, 2013. These are top level certifications, requiring candidates to do more…

Read More >

RAC Attack at Oracle OpenWorld 2013 (Operation Ninja)

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.

Read More >

Database 12c: What’s New with Data Pump? Lots.

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.

Read More >