Monthly Archives: September 2011

How to peek into the alert.log file?

Following up on extended SQL and CBO trace retrieval you can also retrieve the alert.log file from a database through Mumbai if you have installed the Mumbai42 schema into the database as explained in my previous blog post. As you … Continue reading

Posted in Mumbai | Leave a comment

How to get an extended SQL (event 10046) or CBO (event 10053) trace file with a click of a button?

It’s often a chore to generate and fetch trace files. You usually have to enable the trace, run your SQL, then go to the DB server’s file system, locate the correct trace file and then find the relevant portion in … Continue reading

Posted in Mumbai | 1 Comment

How to change a DBMS job owned by another user as user sys?

Also: How to create or test a private DB link as user sys? Say we are logged in as user sys and need to change/delete/add a DBMS job owned by another user, e.g. we need to set it to BROKEN: … Continue reading

Posted in Mumbai | 7 Comments

Two annoyances fixed with Mumbai version 2.1.1.603

The last update broke retrieval of trace files from Unicode platforms and the host input field in the connection manager was a bit hidden (when using Easy Connect), so here is a small update to mainly fix these two problems: … Continue reading

Posted in Mumbai | 4 Comments

Ta Da… Mumbai version 2 available

Many functional changes and additions and an update of the underlying 3rd party components made me raise the major version number to 2. I’ll try to blog about some of the new (and some old) features over the next days … Continue reading

Posted in Mumbai | 1 Comment

Google Group about Mumbai

Since I think the WordPress commenting function isn’t the best tool for communication, I created a Google Group about Mumbai.

Posted in Mumbai | Leave a comment