DBA Hub

đŸ“‹Steps in this guide1/1

Create sql baseline from cursor cache

DECLARE

oracle configurationintermediate
by OracleDba
12 views
1

Create sql baseline from cursor cache

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
DECLARE
l_plans_loaded  PLS_INTEGER;
BEGIN
l_plans_loaded := DBMS_SPM.load_plans_from_cursor_cache(
sql_id => '&sql_id');
END;
/
-- Create baseline with a particular hash value
DECLARE
l_plans_loaded  PLS_INTEGER;
BEGIN
l_plans_loaded := DBMS_SPM.load_plans_from_cursor_cache(
sql_id => '&sql_id', plan_hash_value => '&plan_hash_value');
END;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!