SQL Navigator for Oracle 8.0

Chatta subito con l'assistenza

Ottieni assistenza in tempo reale
Completa la registrazione

Accedi

Richiedi prezzo

Contatta il supporto vendite

SQL Navigator for Oracle 8.0 - Release Notes

Enhancements Resolved Issues Known Issues System Requirements Product Licensing Getting Started with SQL Navigator 8.0 Globalization Copyright

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:

Install Oracle's DBMS_PROFILER package as the SYS user.
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

Start SQL Navigator.
Connect to the instance containing objects you wish to profile.
Use DB Navigator to select a stored program to profile.
Execute. (Click Session | Execute or press F9)
Progress through execution wizard, selecting "Enable Profiling" on the profiling tab.
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

TIP: You can also install a central set of tables for storage of Profiler data, however this is not recommended, as these tables may grow quite large. To install, follow the steps above to install into any schema, then (connected as that user) run the script PROF_GLOBAL_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.

Note: To publish a Java class located in a different schema:

The 'publisher' user requires execute privilege on the class.
The public synonym must be created for that class.

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.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

SQL Navigator for Oracle 8.0 - Release Notes

Server side support