view counter

ORA-13757: “SQL Tuning Set” “string” owned by user “string” is active.

Thanks to Robin Moffatt for this story

I’ve been playing around with SQL Tuning Sets, and was trying to clear up my mess.

view counter
To list all the tuning sets:

SET WRAP OFF
SET LINE 140
COL NAME FOR A15
COL DESCRIPTION FOR A50 WRAPPED

select name,created,last_modified,statement_count,description
from DBA_SQLSET

NAME CREATED LAST_MODI STATEMENT_COUNT DESCRIPTION
--------------- --------- --------- --------------- ----------------------------------------------------------------------------------------
sts_test_02 [...]

Read the entire article at its source

view counter