PROCEDURE: SYS.RESET_UNDO_STAT

Source

1 PROCEDURE reset_undo_stat
2 IS
3   resetsql varchar2(1024);
4   val     number;
5   cid     number;
6   rows    integer;
7 BEGIN
8   val := 2;
9   resetsql := 'alter system set "_undo_debug_usage" = ' || val;
10   cid := dbms_sql.open_cursor;
11   dbms_sql.parse(cid, resetsql, dbms_sql.native);
12   rows := dbms_sql.execute(cid);
13   dbms_sql.close_cursor(cid);
14 END reset_undo_stat;