SQL Developer - The Universal Database Frontend

Oracle Extensions

SQL Developer on Oracle

Explain Plan

OracleExplainPlanSmall_en

With the Explain Plan extension you can analyze the execution plan of a query. Paste the statement to analyze from the clipboard into the SQL editor in the upper part of the dialog. You can also load a statement from a file using the Open function.

You can specify an optional ID for the statement to execute. In this case the query will be stored with the ID in the plan table, otherwise it will be stored as an anonymous query.

To build an execution plan you need a plan table. Please ensure that a plan table exists before the first attempt to build a plan. If no such plan table exists you can create one by using the Create button.

Use the Execute button from the tool bar to analyze the statement. The Execution plan will be displayed in a tree table in the lower part of the dialog.


Jobs

OracleJobsSmall_en

The Jobs extension shows all jobs of the current user. If your user account has appropriate permissions you can also show all All Jobs of the database instance.

Press the Run button to run the selected job directly. Use the Activate and Deactivate buttons to start and stop a selected job. With the Extract DDL button you can generate a creation script for the selected jobs. The Refresh button re-reads all information of all jobs.

Use the Filter field to select a filter criterion and specify a filter pattern in the like field. The filter works case insensitive and supports the wildcard character %. Press the Enter key or the Refresh button to activate the filter.

You can sort the table according to the values of a column by clicking the column's header with the mouse. Another click on the same column header reverses the order.


Oracle Text

OracleTextSmall_en

This extension shows information about Oracle Text (a part of Oracle interMedia).

On the left side a tree shows all schemas that are visible to the current user and are using Oracle Text. The child nodes of each schema node show detailed information about indexes, sections, stop word lists and preferences. For indexes there are additional functions available for synchronization, optimization and recreation.

The Refresh button re-reads all information in the tree.


Recycle Bin

OracleRecycleBinSmall_en

Since Oracle 10g database objects can be deleted by moving them to the recycle bin. With this extension you get access to the recycle bin of the current user or all users if you have sufficient privileges.


Sessions

OracleSessionsSmall_en

This extension shows all sessions running on the database for the currently selected adapter.

Use the Details button to show the last executed SQL command for the selected session. With the Kill session button you can terminate the selected sessions. The Refresh button re-reads all information of all sessions.

Use the Filter field to select a filter criterion and specify a filter pattern in the like field. The filter works case insensitive and supports the wildcard character %. Press the Enter key or the Refresh button to activate the filter.

You can sort the table according to the values of a column by clicking the column's header with the mouse. Another click on the same column header reverses the order.


Monitor

OracleMonitorSmall_en

With the Monitor extension you can monitor important values of an Oracle database instance periodically. If the auto refresh option is checked, new measured values are recorded repeatedly after the selected period (5 seconds to 10 minutes) has elapsed.

Note: Usually you need DBA privileges to access the system views required for monitoring.


Tablespaces

OracleExtensionTablespacesSmall_en

The tablespace analyser extension shows the block allocation of a tablespace.

Note: Usually you need DBA privileges to access the system views required for tablespace analysis.