Blog Archives

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

Posted in General, Oracle FAQ, Tuning, Tutorials

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,

Posted in General, Interview Tips, Monitoring, Questions, Redo Logs, Scripts, Tuning

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

Posted in DBA Career Tips, Monitoring, Oracle FAQ, Scripts, Tuning