May 28, 2012February 9, 2016 Alex Lima

How to get dump or list parameters set at session level?

May 27, 2012February 9, 2016 Alex Lima

How to see current utilization of processes/sessions and max utilization?

July 10, 2011February 9, 2016 Alex Lima

How to list current active roles for a user in a session?

July 7, 2011February 9, 2016 Alex Lima

Global temporary tables

March 28, 2011February 9, 2016 Alex Lima

Tom Kyte’s utility to collect statistics

October 4, 2010February 9, 2016 Alex Lima

List locks held by a session

August 27, 2010February 9, 2016 Alex Lima

How to find the last time a session performed any activity?

July 15, 2010February 9, 2016 Alex Lima

How to suspend/resume a process using oradebug?

June 15, 2010January 14, 2019 Alex Lima

How to monitor temp tablespace usage?

May 14, 2010February 9, 2016 Alex Lima

How to check/find session information (wait, io, lock, time)