Oracle

11.2.0.4 support? Don’t worry until 2017

By Franck Pachot . Customers reluctant to go to 12c before 12.2, in addition to Standard Edition contract changes when going to 12c, has lead to lot of upgrades to 11.2.0.4 but what about support? Don't worry. It's supported for(…)

Query V$UNDOSTAT for relevant time window

By Franck Pachot . When you have a query failing in 'ORA-01555: snapshot too old: rollback segment number ... with name ... too small' you have two things to do: Convince the developer that the rollback segment is not too(…)

SEVERE:OUI-10020:The target area /u01/app/oracle/oraInventory/ is being used as a source by another session

What to do if you get the above error when you try to install Oracle SE2 (did not test if the same issue is there with EE, but probably it is) in silent mode?: ./runInstaller oracle.install.option=INSTALL_DB_SWONLY ORACLE_BASE=/u01/app/oracle/ ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_2_4/ UNIX_GROUP_NAME=oinstall oracle.install.db.DBA_GROUP=dba(…)

Do you use SQL Plan Baselines?

By Franck Pachot . I can hear a lot of complaints about the instability coming from the adaptive features introduced into the optimizer logic at each release. Giving more intelligence to the optimizer is very good to improve the response(…)

You are in Standard Edition One? Don’t worry.

By Franck Pachot . You want the amazing features of Oracle SQL and PL/SQL with minimal cost. Your database is too large for Oracle XE edition, but not big enough to require the cost of Enterprise Edition. You accept to(…)

Waiting for row lock. But which row is locked?

By Franck Pachot . When you are waiting on a locked row, the locked resource is the transaction that has locked the row. We have no information about which row is locked. Here is how to get it from V$SESSION.

DataBase Cloud Service performance – Network

By Franck Pachot . In previous posts, I've installed SLOB on the Cloud Services, measured IOPS and(…)

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

This is the next post on this GoldenGate series: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with(…)

Measuring IOPS on XtremIO

By Franck Pachot . Today, we can put our database on very efficient storage. EMC XtremIO is one of them. In this blog post, I'll show how to look at the IO performance from Enterprise Manager, Orachrome Lighty, and XtremIO(…)

Using GoldenGate event actions to suspend replication for end of day reporting

The last post in this series outlined on how to do an initial load of the target database using the “expdp/impdp” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up(…)