call_stack.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

--* File Name    : Call_Stack.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays the current call stack.
--* Requirements : Access to DBMS_UTILITY.
--* Call Syntax  : @Call_Stack
--* Last Modified: 15/07/2000
SET SERVEROUTPUT ON
DECLARE
  v_stack  VARCHAR2(2000);
BEGIN
  v_stack := Dbms_Utility.Format_Call_Stack;
  Dbms_Output.Put_Line(v_stack);
END;
/