DBA Hub

📋Steps in this guide1/1

10053 OPTIMIZER TRACE

begin dbms_sqldiag.dump_trace(p_sql_id=>'dmx08r6ayx800', p_child_number=>0, p_component=>'Compiler', p_file_id=>'TEST_OBJ3_TRC'); END; /

oracle configurationintermediate
by OracleDba
12 views
1

10053 OPTIMIZER TRACE

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
begin
dbms_sqldiag.dump_trace(p_sql_id=>'dmx08r6ayx800',
p_child_number=>0,
p_component=>'Compiler',
p_file_id=>'TEST_OBJ3_TRC');
END;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!