SQL Performance (MOSC)

MOSC Banner

Query not using plan baseline

edited May 30, 2017 12:10PM in SQL Performance (MOSC) 9 commentsAnswered ✓

Hello experts,

                       Recently we identified one query which takes an hour to complete in production and 2-3 mins in a reporting db instance which gets refreshed every night.So I thought to migrate the plan from reporting to non-prod instance for testing purpose.Unfortunately that did not work.Please find the steps I followed

1.Create SQL tunning set
EXEC dbms_sqltune.create_sqlset('a4xnhf9jzgyjm_cisrptp');
DECLARE
cur sys_refcursor;
BEGIN
open cur for
select value(p) from table(dbms_sqltune.select_cursor_cache('sql_id = ''a4xnhf9jzgyjm''')) p;
dbms_sqltune.load_sqlset('a4xnhf9jzgyjm_cisrptp', cur);

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