Excellent documentation for installing Oracle VM Server.
Read MoreA Backup for My Brain!
Excellent documentation for installing Oracle VM Server.
Read MoreIf you have two associative arrays (PL/SQL tables), and want to copy the contents of one to another, rather than
Read MoreHere is an excellent article on how to send email through PL/SQL, using Gmail as the smtp server.
Read MoreDispatcher process taking 99% of CPU on Oracle XE after an Apex request
A dispatcher process was hogging 100% CPU although there was no activity on the database. I almost chose to bounce the database when I came across this post. It explains how to bounce the dispatcher process only.
Read More
DBMS_RESOURCE_MANAGER and Apex
Here is an excellent post by Joel Kallman on how to use DBMS_RESOURCE_MANAGER to control the impact Apex has on the database.
Read More
Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:
Read MoreThis regular expression will parse out numbers with or without decimals. In this case, the number has to be surrounded
Read MoreQuick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating
Read MoreWhen My Oracle Support (MOS) moved to a Flash-only interface in 2009, I was excited and scared. Excited because I
Read More