martes, 21 de julio de 2015

By Craig Shallahamer OraPub: Do Active Oracle Database Background Processes Have A SQL_ID?

orapub_logo_white_h200
Here's the latest and greatest from the OraPub research desk.

should I upgrade
Do Oracle BACKGROUND processes play a part in a blank, empty or null SQL_ID saga? If so, it would help us separate foreground (application) activity from the Oracle background process activity.

This would help us more quickly zero in on solid performance improving solutions! In a nutshell, reduce distractions.
In this post I reference an entire day of ASH/AWR data from a large production Oracle Database system. I also purposely used my free BloodHound Toolkit and ordered script execution so you can do the same thing I do!
What I learned was fascinating and helped me clarify why so many active sessions do NOT have a SQL_ID.
Enjoy the read!

Read Full Article >>

No hay comentarios:

Publicar un comentario en la entrada

Te agradezco tus comentarios. Te esperamos de vuelta.