请教高手plsql_memory.show_memory_usage怎么用啊
如何解析这个过程返回的结果
------解决方案--------------------
spool aa_vs_nt.log
connect hr/hr
set serveroutput on
DECLARE
  TYPE employees_aat IS TABLE OF employees%ROWTYPE
                           INDEX BY PLS_INTEGER;
  l_aat   employees_aat;
  TYPE employees_nt IS TABLE OF employees%ROWTYPE;
  l_nt    employees_nt;
  PROCEDURE start_test (t VARCHAR2)
  IS
  BEGIN
     DBMS_OUTPUT.put_line (t);
     DBMS_SESSION.free_unused_user_memory;
     plsql_memory.start_analysis;
     sf_timer.start_timer;
  END;
BEGIN
  start_test ('Associative memory');
  SELECT e1.*
    BULK COLLECT INTO l_aat
    FROM employees, employees, employees e1;
  DBMS_OUTPUT.put_line (l_aat.COUNT);
  sf_timer.show_elapsed_time;
  plsql_memory.show_memory_usage;
  l_aat.delete;
END;
/
connect hr/hr
set serveroutput on
DECLARE
  TYPE employees_aat IS TABLE OF employees%ROWTYPE
                           INDEX BY PLS_INTEGER;
  l_aat   employees_aat;
  TYPE employees_nt IS TABLE OF employees%ROWTYPE;
  l_nt    employees_nt;
  PROCEDURE start_test (t VARCHAR2)
  IS
  BEGIN
     DBMS_OUTPUT.put_line (t);
     DBMS_SESSION.free_unused_user_memory;
     plsql_memory.start_analysis;
     sf_timer.start_timer;
  END;
BEGIN
  start_test ('Nested table');
  SELECT e1.*
    BULK COLLECT INTO l_nt
    FROM employees, employees, employees e1;
  DBMS_OUTPUT.put_line (l_nt.COUNT);
  sf_timer.show_elapsed_time;
  plsql_memory.show_memory_usage;
END;
/
spool off
/*
First run:
SQL> @c:\work\demo-seminar\aa_vs_nt
Connected.
Associative memory
1225043
- Elapsed CPU : 2.46 seconds.
Change in UGA memory: 65512 (Current = 373096)
Change in PGA memory: 485556224 (Current = 487133412)
PL/SQL procedure successfully completed.
Connected.
Nested table
1225043
- Elapsed CPU : 2.59 seconds.
Change in UGA memory: 65512 (Current = 373096)
Change in PGA memory: 485490688 (Current = 486150372)
Second run:
SQL> @c:\work\demo-seminar\aa_vs_nt
Connected.
Associative memory
1225043
- Elapsed CPU : 3.02 seconds.
Change in UGA memory: 65512 (Current = 373096)
Change in PGA memory: 485490688 (Current = 486150372)
PL/SQL procedure successfully completed.
Connected.
Nested table
1225043
- Elapsed CPU : 2.82 seconds.
Change in UGA memory: 65512 (Current = 373096)
Change in PGA memory: 485490688 (Current = 486150372)
*/