Yet another great TROUG Oracle Day

I had great time in Oracle Day . Had 2 presentations and met great people. The guests on our TROUG activity shows that we have the potential to achieve  everything on our user group. Great days are coming.  Stay tuned. Below you may also find our exadata presentation in Turkish. Turkcell Exadata OracleDay_TürkçeMore

Experience gained after upgrading “simple” everything

On our previous system before exadata, if we had said that we would upgrade the sun machine, the storage boxes, the network switches and also the oracle software at the same time,  the change management team would have only laughed at us. But this is exactly what we have done last Friday. We have upgraded…More

How to open files starting with + (plus) using vi

Oracle names the ASM trace files with the instance name. If you try to open a file whose name starts with + (plus) ,  you cannot use quotes or  escape character. Instead you have to use — in order to get rid of options. vi — +ASM8_s001_8349.trcMore

Getting the most from hybrid columnar compression

I wasn’t very willing to make tests on the effects of sort order to the compression ratio in hybrid columnar compression. Having consequent same values should increase the compress ratio but we could only sort the data in order of just one column.  I thought that the gain could not be significant.  But after the…More

11gr2 linux 8080 port used by XDB and APEX has lost after reboot

On my RAC system , port 8080 does not open after the reboot of the machine.  The listener endpoint for APEX is lost. All that needs to be done to re-establish the dropped listener endpoint for APEX is to toggle the APEX port using EXEC DBMS_XDB.SETHTTPPORT to a free port, then back to the defined…More