remi's adventures in the database realm

./ oracle

Manually triggering Metric Collection (clearing -tablespace- Alerts)

oracle / grid  February 19th, 2008

Manually triggering metric collection in Oracle Enterprise Manager (GRID control)

read more →


Increase idle time for OMS frontend sessions

oracle / grid  January 28th, 2008

Some additional configuration directives. read more →


Batch SQL statements in parallel (multiple) sessions

oracle / dba util  January 18th, 2008

So it was decided ‘this batch’ had to be done ‘this weekend’. Thousands of SQL statements some of them would take minutes others hours… And MAKE SURE it’s finished monday. read more →


Really delete (’corrupt’) Agent from OMS repository

oracle / grid  January 17th, 2008

Here’s how to overcome ORA-20206 in Oracle GRID environment, agent status unclear… read more →


Clearing Alerts in Oracle GRID Control

oracle / grid  November 12th, 2007

Here’s how to clear alerts from the Oracle GRID manually. read more →


invalid objects after clean ctxsys installation (oracle text)

oracle  November 9th, 2007

The following objects are invalid after a clean ctxsys install. read more →


dbverify in nohup

oracle / scripts  October 9th, 2007

Suffering from corruption in your database, it is nearly just as challenging as in real life… read more →


Oracle Advisor - DBMS_ADVISOR

oracle / new features / 10g  September 5th, 2007

Some ADDM dumps. read more →


11g installation on Linux (Centos)

oracle / new features / 11g  August 25th, 2007

@wip read more →


new explain plan options (dbms_xplan)

oracle / new features / 10g  August 14th, 2007

I still need to upgrade to 10g … read more →