Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

Month: April 2012

Oracle Developement 

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.

 

Read more
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.

 

Read more
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”]

Read more
Oracle Developement 

Oracle Virtualization

April 3, 2012 cruepprich

Oracle Virtualization

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

 

Read more
Oracle ACE
Copyright © 2022 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.