Archive for the 'Uncategorized' Category

download OBIEE 11g NOW!!!

August 16th, 2010

Hello hello hello,
See here what we were waiting for, the new OBIEE 11g.

Time for some humor

July 31st, 2010

Q. What if your Dad loses his car keys?
A. ‘Parent keys not found!’
Q. What if your old girl friend spots you with your new one?
A. ‘Duplicate value on index!’
Q. What if the golf ball doesn’t get into the hole at all?
A. ‘Value larger than specified precision!’
Q. What if you try to have fun with somebody [...]

Nologging inserts generates no redo: WRONG!!!!!!!!!

April 23rd, 2009

In most case NOLOGGING generetaes no redo; true. But by adding a foreign key constraint to the table it disables direct mode inserts and resorts to conventional mode logging.
The direct load is also disabled for index organized table.

How does one blackout events and jobs during maintenance slots?

March 18th, 2009

Managemnet and data collection activity can be suspended by imposing a blackout. See here some examples:
agentctl start blackout # Blackout the entrire agent
agentctl stop blackout # Resume monitoring and management
agentctl start blackout ORCL # Blackout DB ORCL
agentctl stop blackout ORCL # Resume monitoring DB ORCL
agentctl start blackout -s jobs -d 00:20 # Blackout jobs for 20 min

Purge USER_TAB_MODIFICATIONS

October 30th, 2008

If you want to get rid of the content of USER_TAB_MODIFICATIONS or DBA_TAB_MODIFICATIONS then you have to execute dbms_stats.FLUSH_DATABASE_MONITORING_INFO
If that is taking a very long time then you might have hit the oracle bug 5709414

OWB roadmap

April 30th, 2008

If you want to know if OWB has a future (yes there is competition from ODI/sunopsis); click here.

Start & Stop an Oracle database service on Windows

April 29th, 2008

For people having an Oracle DB on their Laptop runing Windows. See here a cmd to stop and start the services. So if you boot (and put the service on manuel) it will take less resources of your laptop. Then just click the shortcut with the following command to activate your DB.
To stop: net stop [...]

Oracle Open World 2007 demo pack

April 21st, 2008

Download the demo material of Oracle Open World 2007 here.