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... »
Latest Story
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... »
Comparing RPM’s between servers
Periodically, I will want to compare the RPM installations between two or more servers. Sometimes, I may not care about the specific versions of each RPM, but only that *some* version exists. To do this, I can use awk and print only the name... »
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... »
Getting DDL for a scheduler job
If you need to copy the DDL to create a scheduler job from one schema to another, what is below works well… 13:28:56 oracle@oh1xpwcdb01 ~ >./dynColumns.py "select dbms_metadata.get_ddl('PROCOBJ','CHECK_TEMP_FREE','HOWARDS') from... »
Standard exception pragmas
Oracle provides several standard exception pragmas (essentially, a compiler directive) for exceptions found on a fairly frequent basis. These are documented in the PL/SQL User Guide and Reference, but... »