Database management

Oracle Grid Infrastructure: fixing the PRVG-10122 error during installation

Making errors is human and when you configure a new Oracle Grid Infrastructure environment (especially one with a large number of nodes), mistakes can happen when configuring ASMLIB on all nodes. If you get an error looking like”PRVG-10122 : ASMLib(…)

SQL Server & memory leak: Are you sure?

I have recently come across an issue with one of my customer that told me that their SQL Server 2008 R2 instance had a memory leak. These are strong words! The server has 64 GB of RAM and the(…)

From 8.0 extended rowid to 12c pluggable db: Why Oracle Database is still a great software

By Franck Pachot . Do you know why Oracle Database is a leader in the database market since 30 years? Do you know any other software that is still the leading solution after decades? I think that it is(…)

What about ALTER INDEX … SHRINK SPACE ?

By Franck Pachot . I have recently published a script to check index fragmentation. But then, do you COALESCE or REBUILD? Well, there also is another option: ALTER INDEX SHRINK SPACE. Let’s compare all those index defragmentation operations.

Oracle Cloud Control 12c: removing an agent is much easier in OEM 12.1.0.4

To remove an agent in the previous Oracle OEM Cloud Control 12c versions, you first had to delete its targets, stop the agent, and remove the host target. Only then were you able to remove the agent. In version 12.1.0.4,(…)

Oracle IOT: when to use Index Organized Tables

By Franck Pachot . When can we use IOT? That’s a question I had when giving recently the Oracle DBA essentials workshop. the DBA Essential is very dense and there is only half a day about performance. We(…)

How to measure Oracle index fragmentation

By Franck Pachot . At Oracle Open World 2014, or rather the Oaktable World, Chris Antognini has presented ‘Indexes: Structure, Splits and Free Space Management Internals’. It’s not something new, but it’s still something that is not(…)

Oracle OEM Cloud Control 12c upgrade to 12.1.0.4

In this blog post, I will describe how to upgrade from Oracle Enterprise Manager Cloud Control 12.1.0.3 to OEM 12.1.0.4.0. I have already described the main new features of Cloud Control 12.1.0.4 version in an earlier post (Oracle OEM(…)

How to measure Exadata SmartScan efficiency

By Franck Pachot . A thread on OTN Forum about Exadata came to the following question: “But how can I monitor if it is effectively used or not?”. This is a common question. There are 3 exclusive features coming(…)

Oracle OEM Cloud Control 12.1.0.4 – agent upgrade & patch

The new Oracle OEM Cloud Control 12.1.0.4 release migration makes it necessary for the DBA to migrate the old agent version to 12.1.0.4. If your infrastructure has a huge number of agents and if you want to apply the agent(…)