16 lines
274 B
SQL
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
|
|
|