A LinkedIn post on Hybrid Columnar Compression (HCC) for Oracle Exadata got me thinking on what it is. HCC can provide substantial space savings and improved performance, but its success depends on data access patterns. The post outlines compression options, types of HCC, and best practices for optimal use.
A few weeks ago I was working on a GI upgrade from 12.2 to 19.6, but after running the upgrade in node 1 +asm1(19c) does not see +asm2(12c) . Below you will see what I did and how it was fixed. I started running the
This technique will help you clone an ORACLE_HOME in 19c and onwards
How to fix the status of the Oracle GI crs when it is in UPGRADE FINAL after a failed upgrade from 12.1 to 18.5
Back in late June of 2015, Larry Ellison launched several public cloud services , and one of those who were included was the Public DBaaS , today I had the opportunity to try out this new service and here we will go into how to
This is going to be a short post as there wasn’t much information on this type of failure when searching for it. I was working on an Oracle EM13cR2 installation and when the installation reached 78% it failed on the BI Publisher configuration . I
I am mostly writing this so I don’t forget , it will be a small post. The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary I kept getting the
The other day I was doing an import using impdp in 12.1.0.2 , and got the following error ORA-30926: unable to get a stable set of rows in the source tables. While investigating, I found that the source database had OLAP option removed and found
Yesterday as I was running here in Lisbon, I found a sign outside the Teatro Nacional D. Maria II in Rossio Square that read “Parece Impossível” (Seems Impossible) and I thought that I couldn’t have found a better sign on the day that marked an anniversary
Currently I am an Oracle ACE ; Speaker at Oracle Open World, Oracle Developers Day, OTN Tour Latin America and APAC region and IOUG Collaborate ; Co-President of ORAMEX (Mexico Oracle User Group), Web Events Chair for IOUG Cloud Computing Special Interest Group (SIG) ; At the moment I am an Oracle Project Engineer at Pythian