DBA Data[Home] [Help]

APPS.GMP_BOM_ROUTING_PKG dependencies on V$MYSTAT

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

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:

Line 2610: 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:
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: