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
Do not have to wake up in order to get a trace
oradebug dumo processstate More
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
To show NLS parameters for session-database-instance together by Pivot and Listagg on 11gr2
I’ve always confused and needed to check for the nls parameters. I thing it’s a good chance to play around with the pivot function on 11gR2 in order to show all of them together. The pivot function seems to be used only with aggregate functions. How can the text values be aggregated? At this point…More