SQL Performance (MOSC)

MOSC Banner

how to cancel a sql tuning set captured from cursor cache

edited Jan 18, 2020 4:04AM in SQL Performance (MOSC) 5 commentsAnswered

For the past 2 months I have been capturing SQL workload using the DBMS_SQLTUNE.CAPTURE_CURSOR_CACHE_SQLSET.   This data was used for 11G to 12C upgrade/tuning.  Now that we are in production I need to cancel execution of this task but it does not show up as a tasks in dba_advisor_tasks, dbms_scheduler, etc..  I see no API that will allow me to cancel this task.

I've read the API docs and do not see anything that addresses this but assume I must be missing something obvious.  My call to create the STS task was:

DBMS_SQLTUNE.CAPTURE_CURSOR_CACHE_SQLSET(

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center