Tip of the month – Magic for DBAs

Who never had a problem with a SQL that is killing your Database Performance and you can’t fix it because it’s running from an external closed application that you or your developers can’t touch? Since Oracle version 10 this is Continue reading Tip of the month – Magic for DBAs

LOGGING or NOLOGGING, that is the question – Part VIII

By Francisco Munoz Alvarez How to find Sessions Generating Lots of Redo To find sessions generating lots of redo, you can use either of the following methods. Both methods examine the amount of undo generated. When a transaction generates undo, Continue reading LOGGING or NOLOGGING, that is the question – Part VIII

Be a hero, be proactive!

Let start this New Year with a new mentality or a new resolution if you prefer call this way, let stop being reactive and start being proactive. Being proactive will reduce your database administration costs and increase your level of Continue reading Be a hero, be proactive!