DBA Hub

📋Steps in this guide1/1

drop a sql profile

BEGIN DBMS_SQLTUNE.drop_sql_profile ( name => '&sql_profile', ignore => TRUE); END; /

oracle configurationintermediate
by OracleDba
19 views
1

drop a sql profile

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
BEGIN
DBMS_SQLTUNE.drop_sql_profile (
name => '&sql_profile',
ignore => TRUE);
END;
/
You can get the respective sql_profile of a sql_id from below:
select distinct
p.name sql_profile_name,
s.sql_id
from
dba_sql_profiles p,
DBA_HIST_SQLSTAT s
where
p.name=s.sql_profile and s.sql_id='&sql_id';

Comments (0)

Please to add comments

No comments yet. Be the first to comment!