Oracle_scripte/Tanel/tools/sesspack_truncate.sql
2014-09-17 13:23:48 +02:00

16 lines
274 B
SQL

define spuser=&1
prompt Truncating &spuser SAWR$ tables...
set echo on
truncate table &spuser..SAWR$SNAPSHOTS;
truncate table &spuser..SAWR$SESSIONS;
truncate table &spuser..SAWR$SESSION_EVENTS;
truncate table &spuser..SAWR$SESSION_STATS;
set echo off
undefine spuser