SQL Navigator for Oracle 8.0 - Release Notes

Server side support

The PL/SQL Profiler and Java->PL/SQL Publisher requires server-side support, which is installed on demand.

To install support for PL/SQL Profiler

The PL/SQL Profiler (Oracle 10g and above) requires server-side support provided by Oracle.

Follow these steps:

1. Install Oracle's DBMS_PROFILER package as the SYS user.
2. To collect statistics, grant users SELECT privilege on the following system views:

   V$SESSION

   V$SESSTAT

   V$STATNAME

To install SQL Navigator-specific support for a single schema

1. Start SQL Navigator.
2. Connect to the instance containing objects you wish to profile.
3. Use DB Navigator to select a stored program to profile.
4. Execute. (Click Session | Execute or press F9)
5. Progress through execution wizard, selecting "Enable Profiling" on the profiling tab.
6. Perform one of the following:
   • When prompted to install Profiler support, click Yes.
   • Connected as user for schema containing objects you wish to profile, run the script PROF_INSTALL.SQL

To install support for Java Publisher

To publish a Java class to PL/SQL the following are required in the user's schema:

• A Java class (com/quest/sqlnav/reflector)
• An Oracle package (SQLN_JAVA)

These objects are installed on demand in a similar manner to the Profiler objects.

Recommended configuration for PL/SQL Debugger

Oracle for Windows version10g or higher

SQL*Net 32-bit to connect to the database

Refer also to the online help for details about Oracle support for the SQL Navigator Debugger.

Recommended configuration for Oracle Web Development support

Install Oracle Web Toolkit version 2 or higher on database.