April 2012 – Christoph's 2 Cents

Christoph's 2 Cents

A Backup for My Brain!

April 23, 2012 cruepprich

Dispatcher 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.

Oracle Developement PL/SQL

April 18, 2012 cruepprich

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.

Oracle Application Express (Apex)Oracle Developement PL/SQL

April 16, 2012 cruepprich

Quick Look: How to loop through an associative array indexed by varchar2.

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:

Oracle Developement

April 3, 2012 cruepprich

Oracle Virtualization

Here is an excellent article on Oracle virtualization by Jerry Ireland.