Database management

Using tmux for semi-interactive demos

By Franck Pachot . You are a speaker and like to show some demos. Which kind of demo do you do? you script everything so that you just have to press ‘enter’ during the demo you prepare everything in(…)

The future of SQL*Plus and some oddities

By Franck Pachot . Rumors are coming after OOW14. Oracle is working on a new SQL*Plus version. Not only a new version. It’s a completely new development. Here is what we know currently about the future of sqlplus an(…)

How to disable all database links

By Franck Pachot . A frequent scenario: you refresh test from production with a RMAN duplicate. Once the duplicate is done, you probably change dblinks so that they address the test environment instead of the production one. But are(…)

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

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