New Features for Oracle Developer Tools for Visual Studio Release 11.1.0.7.20

Oracle Developer Tools for Visual Studio release 11.1.0.7.20 includes the following:

• Oracle Performance Analyzer

  Oracle Performance Analyzer examines an application’s use of Oracle Database over a specified period of time and provides tuning recommendations to improve application performance, for example, modifying SQL or adding indexes on a table. To perform this analysis, Oracle Performance Analyzer creates an Automatic Database Diagnostic Monitor (ADDM) task. Starting and ending times define the analysis time period, which is represented by 2 Automatic Workload Repository (AWR) snapshots. The results of the analysis are represented as ADDM Task nodes in Server Explorer. AWR Snapshot nodes have also been added to Server Explorer.

  See Also:

  • About Oracle Performance Analyzer

  • Oracle Performance Analyzer Interface

  • ADDM Tasks Node

  • AWR Snapshots Node

  • New ADDM Task Dialog

  • New AWR Snapshot Dialog

• SQL Tuning Advisor

  Developers can tune arbitrary SQL statements with SQL Tuning Advisor. Accessed through the Tune SQL button on the toolbar in the Oracle Query Window or from Oracle Performance Analyzer recommendations, this tool provides instant recommendations explaining how to improve the performance of Oracle SQL statements.

  See Also:

  • About SQL Tuning Advisor

• Advanced Queuing (AQ) Designers and Integration with Server Explorer

  Advanced Queuing Designers enable administration of AQ features in Oracle. Server Explorer now displays queues and queue tables.

  See Also:

  • About Oracle Streams Advanced Queueing

  • Queue Table Designer

  • Queue Designer

  • Advanced Queues Node

• Selection and operation on multiple Server Explorer nodes

  You can select multiple Server Explorer nodes and execute menu operations on them. Multiple SQL scripts, for example, can be generated for multiple schema objects or for entire classes of schema objects, such as all tables. Multiple PL/SQL Stored procedures or packages can be compiled at once. Multiple schema objects can now be dragged and dropped into a Oracle Database Project as well.

  See Also: Performing Operations on Multiple Database Objects at Once

• Collection Node Filtering

  Collection filtering enables you to display only those Oracle schema objects that you are interested in, using very flexible filter definitions. For example, the Tables collection can be filtered to show tables that begin with a certain character. Collection node filtering is enabled on the Filters tab in the connection dialog box.

  See Also:

  • Filters Tab

  • Filtering Collection Nodes

• User and Role designers and Users and Roles Server Explorer nodes

  These designers allow you to create and modify users and roles, which then appear as Server Explorer nodes.

  See Also:

  • About Users, Roles, and Privileges

  • User Designer

  • Users Node

  • Role Designer

  • Roles Node

• Grant/Revoke Privileges Wizard supports System Privileges and Roles

  Grant/Revoke Privileges Wizard now supports System Privileges and Roles and also allows users to grant privileges on more than one object at once, or to more than one user or role at once.

  See Also: Grant/Revoke Privileges Dialog

• PL/SQL Compiler Settings Options page

  The PL/SQL Compiler Settings Options page controls how Compile or Compile Debug operations are performed from Server Explorer or from the PL/SQL Editor.

  See Also: PL/SQL Compiler Settings Options Page

• Table designer enhancements

  The Table designer displays more information about the column data types.

  See Also: Table Designer

• Rename schema objects in Server Explorer

  You can rename Oracle database objects by clicking the object name in Server Explorer. You can rename tables, views, sequences, synonym, and indexes.

• Oracle Trigger Designer enhancements

  The Trigger Designer now supports multiple event types.

  See Also: Trigger Designer