Using Oracle utilities


Warning

This feature is no longer supported by any of the KM's supported versions. From version 9.7.11.01, the feature is no longer available. For more information see, 9.7.11.01: Fix pack 1 for PATROL for Oracle Database.

You can access and use the following Oracle ® utilities from PATROL for Oracle:

  • Server Manager
  • SQL*Plus
  • Explain Plan
  • SQL command 
  • SQL task

You can also manage Oracle's job queue from PATROL. For more information, see  Managing Oracle's job queue from PATROL.

Using Server Manager

Access Server Manager by choosing Oracle Server Admin > Server Manager from the INSTANCE menu. You must enter the user name and password of a valid account for the instance. 

After you have entered the user name and password, you can use any valid Server Manager commands in the xterm window that opens. To close the window, type exit at the Server Manager prompt.

Note

Server Manager is not accessible on a Microsoft Windows local instance.

Using SQL*Plus

Access SQL*Plus by choosing Oracle Server Admin > SQL*Plus from the INSTANCE menu. You must enter the user name and password of a valid account for the instance. You can use any valid SQL*Plus commands in the xterm window. After the session is completed, you can exit SQL*Plus and close the xterm window.

Note

SQL*Plus is not accessible on a remote Oracle instance or on a Microsoft Windows local instance.

Using Explain Plan

You can run the Explain Plan utility from PATROL to review how the Oracle optimizer intends to process a specific SQL statement. This information predicts the performance of the SQL statement. 

Access the Explain Plan utility by choosing  Oracle Server Admin > Explain Plan  from the INSTANCE menu. You can then enter the SQL statement and any arguments into the command dialog box. You can also use any of the tools on the command dialog box toolbar. On Microsoft Windows, click  Help  for instructions for using the command dialog box. Click  Apply  to submit the SQL statement to the utility. The resulting report appears in a task output window.

Issuing SQL commands to Oracle

Select Oracle Server Admin > SQL Command from the Instance menu, enter a user name and password for an account on the instance. After the account is accepted, a command dialog box appears. 

When you enter the SQL command into the dialog box, the command is sent to the instance where it is executed. Any output appears in the system output window, and the dialog box is closed.

Issuing an SQL Task

Select Oracle Server Admin > SQL Task from the INSTANCE menu, enter a user name and password for an account on the instance. After the account is accepted, a command dialog box appears. 

When you enter the SQL task into the dialog box, the command is sent to the instance where it is executed. An icon is displayed on the navigation area that shows the total execution time. Any output from the statement is displayed in the task output window, and the dialog box is closed. 

You can repeat the SQL task by right-clicking on the task output window icon and choosing Repeat. You can choose Destroy to delete the task output window.


Was this page helpful? Yes No Submitting... Thank you

Comments