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... »
Archive for February, 2012
Change the mount point for an ACFS filesystem
Tuesday, February 21st, 2012
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
Saturday, February 18th, 2012
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
Wednesday, February 8th, 2012
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
Tuesday, February 7th, 2012
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... »