Database
Skipping a transaction in GoldenGate
We are the midst of a mission critical implementation that involves an active-active setup. We have chosen GoldenGate to manage the distribution of data between the two sites (soon to be three). This is the first of a series of articles and tips on our findings as we use the software. We have spent... »
SQL Patch
Oracle comes up with some cool tricks for fixing poorly performing SQL, especially code to which you have no direct access. If you absolutely know a given hint will always work, the Oracle optimizer blog recently posted a method for “sticking” a hint into the statement when it is executed. I wonder how long... »
Reverse engineering a SQL replay script from a 10046 trace file
This will be the coup de grâce (but in a good way:)) if I can ever finish it. I have wanted to do this for years, and keep getting closer. Search for awk 10046 in the search bar on this site for other articles as it relates to this. The awk script below will... »
Printing execution times with associated bind variables
In a previous post, we showed how you can extract the count of executions of a given SQL statement for a given bind variable. We recently found a need to print each execution a given SQL statement with the bind variables used for that execution and how many I/O’s and seconds it required. This... »
Change the mount point for an ACFS filesystem
Changing the mount point for an ACFS filesystem is not a straightforward process, and is not a well documented process. We found ourselves in this position after we misspelled the goldengate directory we wanted to use for the binaries and trail files in a RAC. We erroneously spelled it goldendate. We tried to use... »
Linux firewall rules for RAC
Most notes on the Oracle MOS support site suggest disabling the firewall supplied in most Linux distros as managed by the iptables program. I think this is a bit drastic, and results in lazy thinking at best, and an exposed database server subject to all sorts of hacker invasion at worst. If you don’t... »
Query SQL Server stored procedure text with JDBC
I needed to quickly print the text associated with several stored procedures across multiple database servers to individual files. I used what is below. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30... »
Poor man’s partitioning with instead of triggers – PART 1
The Enterprise Edition of Oracle Corp’s. flagship database has many features. One of these is partitioning. Partitioning allows a user to segment table rows into separate physical storage structures. This can improve things such as performance and manageability. Performance can be improved by utilizing what Oracle terms “partition pruning”. For example, let’s assume you... »
Connecting to SQL Server using internal authentication
We use java for a lot of our jobs, and using it to access SQL Server is no exception. We wanted to have controlled access, and avoid “user sprawl” across servers. As such, we use Windows authentication from our java programs. Below is an example: 1 2 3 4 5 6 7 8 9... »
Why won’t my VIP start?
After restarting a test server, I found the RAC VIP would not start. This post is just a quick note as to how I troubleshot the problem, as well as its ultimate resolution. I frequently use the find -mmin 5 -type f | xargs grep -i "whatever you want" command to find any recently... »