Oracle Team

Oracle cloud control / SQL Details / Statistics

By Franck Pachot . A question that I had several times: in Enterprise Manager, in the screen about one SQL statement, the ‘statistics’ tab shows the number of executions, elapsed time, etc. Question is: which time window does it(…)

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(…)

Oracle: an unexpected lock behavior with rollback

By Franck Pachot . Here is an odd Oracle behavior I observed when a transaction that acquired a lock is rolled back. Note that this is related to a specific combination of locks that should not be encountered in(…)

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(…)

Oracle system statistics: Display AUX_STATS$ with calculated values and formulas

By Franck Pachot . System statistics can be gathered in NOWORKLOAD or WORKLOAD mode. Different values will be set depending on that and the others will be calculated – derived from them. We can see defined values from SYS.AUX_STATS$(…)

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(…)