April 2012 – Christoph's 2 Cents

Dispatcher process taking 99% of CPU on Oracle XE after an Apex request

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

DBMS_RESOURCE_MANAGER and Apex

April 18, 2012 cruepprich oracle, pl/sql, plsql

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

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

April 16, 2012 cruepprich apex, application express, array index, arrays, associative array, collections, loop, oracle, pl/sql, pls/sql, plsql, programming, sql, table

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2: [sourcecode language=”sql”]

Oracle Developement

Oracle Virtualization

April 3, 2012 cruepprich

Oracle Virtualization

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