Problem :
set autotrace traceonly;
Execute above query on sql developer.
If you are looking for traceonly option in sqldeveloper then answer is no , they query you executed on oracle CMD will not work on SQL Developer.
Instead you can write the query on SQL Developer whose xplain plan your trying to get.
It is more simple in SQL Developer , see below how
1. Write a SQL query on SQL Developer
2. Select query
3. Click on third icon (right to "Execute statement") "Explain Plan) or Press F10
4. On Pressing third icon click on , it will generate the query and
5. Execute it
set autotrace traceonly;
Execute above query on sql developer.
If you are looking for traceonly option in sqldeveloper then answer is no , they query you executed on oracle CMD will not work on SQL Developer.
Instead you can write the query on SQL Developer whose xplain plan your trying to get.
It is more simple in SQL Developer , see below how
1. Write a SQL query on SQL Developer
2. Select query
3. Click on third icon (right to "Execute statement") "Explain Plan) or Press F10
4. On Pressing third icon click on , it will generate the query and
5. Execute it
No comments:
Post a Comment