Oracle datapump status
During a import run of a +100GB Oracle database I was curious what the current progress was. I discovered you can press Ctrl+C to go to an interactive command mode during a import …
Tag
Oracle
6 berichten
Oracle ASM lifesaver
I had a very nasty experience with Oracle ASM recently. A long story short, ASM crashed on both our RAC nodes when removing a corrupted archive file on file and incarnation number …
Oracle 11g ASM disk discovery
During the installation of Oracle 11gR2 on Red Hat Enterprise Linux 5 I stumbled upon a incorrect default setting for ASM disk discovery when using ASM lib. The discovery path is …
Delete rows from table where date
If you need to get rid of some table rows, in my case a Sun IDM logging table, you can use the following steps. 1. Create a backup in case you have done some thing wrong u can …
Oracle RAC connect string for JDBC
For a Tomcat installation I needed to connect to a Oracle RAC database backend. I figured out the correct connection string, shown below:…
tracing SQL in Oracle
If you want to know what SQL statements are actually being executed by an application because something goes wrong and there is no clear error message explaining what’s happening …