I have just finished a big project migrating four old Oracle SPARC servers to an x86 Linux-based RAC. Here are the performance results. Spoiler: the RAC cluster is faster. Much much faster.
How to resolve Intermittent ORA-12545 when trying to connect to a RAC database configuration.
A few days ago I've stumbled across an annoying problem with Oracle 10.2.0.1 (yep, need to patch it) RAC causing my OCI client fail to connect with an ORA-12520 error (ORA-12520: TNS:listener could not find available handler for requested type of server).
Use a simple one-liner to simulate load on your Linux/Unix server
Preliminary benchmarks of Intel's next-gen CPU - the Nehalem. It smokes.
Oracle Virtual Directory is a very cool Oracle product that allows for enterprise level LDAP without synchronization. Using OVD you can virtually unify all the different directories that exist in your organizations and expose them as a single LDAP tree without any sort of synchronization or moving data from its original source.
How to achieve a complete secure database using Oracle products. 360 degrees of protection.
Very interesting readup on the origins of the DUAL table in ORACLE plus a quick trivia question.
How to gather statistics and analyze tables when using MySQL with the InnoDB storage engine
A small PL/SQL procedure to help you search for a specific string in all columns of all tables owned by a user.
How to resolve and EXP-00056: ORACLE error 19206 encountered during and export
Materialized view will become invalid after a refresh – documented Oracle bug in older versions+ workaround.
A very annoying Oracle bug (2639679 ) in 8i and some 9i versions causing a Materialized View to become invalid right after a refresh. This is the workaround I found.
What to do if you receieve an “ORA-00600: internal error code, arguments: [keltnfy-ldmInit]” when creating a new database
What does the Oracle "ORA-00600: internal error code, arguments: [keltnfy-ldmInit]" error means. How to resolve it?
In case you ever need to perform a manual uninstall of an $ORACLE_HOME installation from a Linux server, you can do so by following these steps.
I was doing research for a client that is trying to replace old Sun UltraSparc Solaris servers with new, cheaper (and hopefully better performing), Linux x86 machines. I wanted to see if I can find any benchmarks that will help me compare the performance of SPARC servers to x86 machines when running Oracle Database. Here are the results.