APPS.MSC_CL_GMP_UTILITY dependencies on V$STATNAME

Line 2820: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

2816: END IF;
2817:
2818: dbms_session.free_unused_user_memory;
2819:
2820: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2821: WHERE st.STATISTIC# = sn.STATISTIC#
2822: AND sn.NAME in ('session pga memory max');
2823: log_message('Session pga memory max = ' || to_char(v_dummy) );
2824:

Line 2825: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

2821: WHERE st.STATISTIC# = sn.STATISTIC#
2822: AND sn.NAME in ('session pga memory max');
2823: log_message('Session pga memory max = ' || to_char(v_dummy) );
2824:
2825: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
2826: where st.STATISTIC# = sn.STATISTIC#
2827: and sn.NAME in ('session pga memory');
2828: log_message('Session pga memory = ' || TO_CHAR(v_dummy) );
2829:

Line 5905: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn

5901: COMMIT;
5902:
5903: CLOSE c_item_cursor;
5904:
5905: SELECT st.VALUE INTO v_dummy from V$MYSTAT st, V$STATNAME sn
5906: where st.STATISTIC# = sn.STATISTIC#
5907: and sn.NAME in ('session pga memory');
5908: log_message('After Item Cursor Session pga memory = ' || TO_CHAR(v_dummy) );
5909: