January 24, 2017May 29, 2023 Alex Lima

How to disable parallel query at a session level?

May 28, 2012February 9, 2016 Alex Lima

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

January 7, 2012February 9, 2016 Alex Lima

Example of using tracefile_identifier

January 3, 2012February 9, 2016 Alex Lima

How to use dbms_xplan to display execution plan?

January 1, 2012February 9, 2016 Alex Lima

How to check if auditing is turned on and privilege auditing is turned on?

May 15, 2011February 9, 2016 Alex Lima

How to get current session id, process id, client process id?

March 28, 2011February 9, 2016 Alex Lima

Tom Kyte’s utility to collect statistics

March 19, 2011February 9, 2016 Alex Lima

How to enable auditing?

December 26, 2010February 9, 2016 Alex Lima

How to generate systemdump when the instance is hung?

August 27, 2010February 9, 2016 Alex Lima

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