2601: END IF;
2602:
2603: dbms_session.free_unused_user_memory;
2604:
2605: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2606: WHERE st.STATISTIC# = sn.STATISTIC#
2607: AND sn.NAME in ('session pga memory max');
2608: log_message('Session pga memory max = ' || to_char(v_dummy) );
2609:
2606: WHERE st.STATISTIC# = sn.STATISTIC#
2607: AND sn.NAME in ('session pga memory max');
2608: log_message('Session pga memory max = ' || to_char(v_dummy) );
2609:
2610: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2611: where st.STATISTIC# = sn.STATISTIC#
2612: and sn.NAME in ('session pga memory');
2613: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
2614: