Speeding up gathering statistics a bit in 11g.

By | November 23rd, 2009|Categories: Database|Tags: |

Something about running statistics. Got quite a large database of a few TB, and was curious how fast the statistics are running, and if I could speed it up a little.

Using http://localhost:8080 at APEX(11gr1), horrible performance

By | November 21st, 2009|Categories: Database|Tags: |

I had to install a 11g release 1 on Windows for demonstration purpose of APEX. APEX comes standard with 11g, so that's nice. When using Embedded PLSQL you don't even need Apache... But when I'm using http://localhost:8080/apex/apex_admin, the login-page popped up after a minute or two.And every page I use has the same horrible performance. Using the loopback by the way like on the server gives the same result.

Determining compression-factor 11g release 1

By | November 13th, 2009|Categories: Database|Tags: |

Working on 11g, release 1 (, managers wanted to know what kind of compression factor we achieved in the datawarehouse. Amount of (compressed) data: just about 1,5 TB. In all my naivity I thought Oracle delivered the package 'DBMS_COMPRESSION' which will show me the rate of achieved compression per table. But first of all, in 11gr1 there was no package like 'DBMS_COMPRESSION', this is only delivered with release 2.

PL/SQL Best Practices with Steven Feuerstein

By | November 5th, 2009|Categories: Oratube|

An old seminar from Steven Feuerstein httpvh://www.youtube.com/watch?v=nLZlR3nSrsc

Common Mistakes in Oracle PL/SQL Programming

By | November 5th, 2009|Categories: Oratube|

An old little seminar from Steven Feuerstein: httpvh://www.youtube.com/watch?v=ecNP8KBX_sc