DBA Hub

📋Steps in this guide1/1

create baselines for all sqls of a schema

DECLARE nRet NUMBER; BEGIN nRet := dbms_spm.load_plans_from_cursor_cache( attribute_name => 'PARSING_SCHEMA_NAME', attribute_value => '&schema_name' ); END;

oracle configurationintermediate
by OracleDba
12 views
1

create baselines for all sqls of a schema

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
DECLARE
nRet NUMBER;
BEGIN
nRet := dbms_spm.load_plans_from_cursor_cache(
attribute_name => 'PARSING_SCHEMA_NAME',
attribute_value => '&schema_name'
);
END;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!