PL/SQL Profiler Requirements
Modules, Windows And Dialogs > PL/SQL Profiler > PL/SQL Profiler Requirements
Required Oracle Conditions
|
To run the PL/SQL Profiler |
The DBMS_PROFILER package needs to be installed under SYS.
This is does not happen by default on a new instance. |
|
To collect session statistics |
The users need access to V$SESSION, V$SESSTAT and V$STATNAME.
This condition is satisfied when the users have SELECT privilege on system views V_$SESSION, V_$SESSTAT and V_$STATNAME. |
|
For schemas that use the PL/SQL Profiler |
The profiler server side objectsInstalling_server_side_objects (tables and sequences) need to be installed. |
Profile Manager
Modules, Windows And Dialogs > Profile Manager
Profiles saved in SQL Navigator can be:
- Re-used in other versions of SQL Navigator.
- Made available to other users of SQL Navigator.
- Used on other computers.
- Made available to support staff to help resolve issues.
To backup a profile
- Open the Profile Manager: Windows Start | All Programs | Quest Software | SQL Navigator | Profile Manager
- Select Backup User Profile.
- Select the version of SQL Navigator which has the preferences you want to save.
- Select the directory into which the backup file is to be saved.
- Enter a name for the backup file, or accept the name displayed.
- Click Backup.
|
|
Note: The file is saved into the designated folder and has an extension of .prof. |
To restore a profile
-
Open the Profile Manager: Windows Start | All Programs | Quest Software | SQL Navigator | Profile Manager
- Select Restore User Profile.
- Select the directory from which the backup file is to be restored.
- Select the file containing the backed-up profile file. Click Next.
- Select the version of SQL Navigator that you want the backed-up to replace. Click Restore.
Project Manager
Modules, Windows And Dialogs > Project Manager
The Project Manager provides instant access to your frequently used database objects and connections. Projects are holding areas where you can store shortcuts to things that you frequently need to work with instead of searching for them in various lists and directories.
Project Manager Toolbar
Manage Your Projects
|
File Menu | New Project  |
Create a project. |
|
File Menu | Rename Project  |
Rename the current project.
|
|
TIP: Change the current project in the Project Manager window. | |
|
File Menu | Delete Project  |
Delete the current project. |
|
Drag and drop into the Project Manager window. |
Add items to the current project:
These items can include:
- schemas (in particular connections)
- schema objects
- code location bookmarks within stored programs
- schema object templates
|
Actions on Items in the Project Manager
Select an object in Project Manager and ...
|
Preview the source code of text objects |
Source Preview |
|
To connect to a database from the Project Manager |
You can select a database object in your Project Manager and open it for viewing or editing. SQL Navigator automatically opens the required database connection and displays the object’s properties in an object editing window. Double click on the shortcut to open the connection. |
|
Code Location shortcuts |
Drag the selection from the result list in Database Source Code Search to the Project Manager. |
|
Drop an object |
- Select the object in the Project Manager window.
- Locate the object in DB Navigator.
- Drop the object in DB Navigator.
|
Keyboard Shortcuts In The Project Manager Window
|
|
TIP: Right click in the Project Manager window to see all options available. |
|
Ins |
Add Objects in Project Manager. Open Select DB Object Dialog. |
|
Shift+Ins |
Add Files in Project Manager |
|
Ctrl+H |
Hide items of the selected type (Requires you to select an object in the Project Manager). |
|
Ctrl+U |
Go up one level (Requires you to have navigated to a sub-folder in the Project Manager window). |
Project Filter Dialog
Select the object types you want to display in the project manager window.
