Oracle VM Consulting
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.

Oracle VM Site Review - Oracle VM Health Check
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