Oracle - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.0
July 2007 		http://www.dbvis.com
support@dbvis.com

[ Master documentation index ]

Introduction

In addition to the standard feature set in DbVisualizer this document briefly covers the database specific support in DbVisualizer for the Oracle RDBMS.

Database Objects Tree

The following table shows what objects DbVisualizer handles for an Oracle database. The first column list the structure and the object types. The actions column lists all actions that are associated with the object types and the last column shows all viewers that appear when selecting an object in the tree.

The screenshots illustrates the visual representation of the objects tree.  

Object Type Actions Viewers
Schemas
Schemas
Schema
Tables
Create Table References, Table Comments, Tables
Table
Alter Table, Comment Table, Copy Table, Create Index, Drop Table, Empty Table, Import Table Data, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Columns Comment, Constraints, Data, Grants, Indexes, Info, Navigator, Primary Key, References, Row Count, Row Id, Triggers
Columns
Columns
Column
Column
Constraints
Constraints
Constraint
Columns, DDL1, Info
Column
Column
Indexes
Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL1, Info
Column
Column
Triggers
Triggers
Trigger
Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger DDL1, Info, Source
Views
View Comments, Views
View
Comment View, Compile View, Drop View, Rename View, Script: CREATE VIEW, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE Columns, Columns Comment, DDL, Data, Grants, Info, Row Count, Triggers
Columns
Columns
Column
Column
Synonyms
Create Synonym Synonymed Objects, Synonyms
Indexes
Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL1, Info
Sequences
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence DDL1, Info
MaterializedViews
Materialized Views
MaterializedView
Drop Materialized View, Refresh Materialized View Columns, DDL1, Data, Indexes, Info, Row Count, Select SQL
Indexes
Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL1, Info
Column
Column
Functions
Create Function Functions
Function
Compile Function, Drop Function DDL1, Function
Procedures
Create Procedure Procedures
Procedure
Compile Procedure, Drop Procedure Procedure
Packages
Create Package Packages
Package
Compile Package, Compile Package and Body, Create Package Body, Drop Package and Package Body DDL1, Package Specification
PackageBody
Compile Package Body, Drop Package Body Package Body
PackageBodies
Create Package Body Package Bodies
PackageBody
Compile Package Body, Drop Package Body Package Body
JavaSources
Java Sources
JavaSource
Info, Source
JavaClasses
Java Classes
JavaClass
Info
Triggers
Triggers
Trigger
Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger DDL1, Info, Source
ObjectTypes
Object Types
ObjectType
Attributes, DDL1, Info, Methods
RecycleBin2
Recycle Bin
RecycleBinTable
Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
InvalidObjects
Invalid Objects
Properties
Session Privileges, Session Properties, Session Roles
DBA
DBA
Users
Create User Users
User
Change Password, Drop User, Expire Password, Lock User, Unlock User DDL1, Info, Roles, System Privileges, Table Privileges, Tablespace Quota
Roles
Roles
Role
DDL1, Info, Roles, System Privileges, Table Privileges, Users
Sessions
Sessions
Session
Kill Session Session
Locks
Locks 1, Locks 2
AllRecycleBin2
Recycle Bin
AllRecycleBinTable
Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
Storage
Data Files, Rollback Segments, Tablepaces
TableSpaces
Tablespaces
TableSpace
DDL1, Tablespace, User Quota
DataFile
Data File
DataFiles
Data Files
DataFile
Data File
TableSpace
DDL1, Tablespace, User Quota
RollbackSegments
Rollback Segments
RollbackSegment
DDL1, Rollback Segment
Statistics
InstanceInfo
Instance Info
InstanceSummary
Instance Summary
Latches
Latches
ObjectCount
Object Count
Waits
Waits
SGA
Flush SGA Poorly performing SQL's, SGA
1) Oracle version 9 or later
2) Oracle version 10 or later


Application Object Support (PL/SQL)

DbVisualizer includes special support to manage application objects such as package, package body, procedure and function. These objects can be created, edited and compiled. The editor reports errors and highlights the corresponding problems in the editor.
1 2

DBMS_OUTPUT Support

The DBMS Output tab (in SQL Commander) for Oracle is used to enable and disable capturing of messages produced by stored procedures, packages, and triggers. These messages are typically inserted in the code for debugging purposes. For SQL*Plus users the corresponding feature is enabled via the set serveroutput on command. To enable display of DBMS messages in DbVisualizer select the DBMS Output tab and press the Enable button.
1

Explain Plan

Explain Plan executes your query and records the plan that the database devises to execute it. By examining this plan, you can find out if the database is picking the right indexes and joining your tables in the most efficient manner. The explain plan feature works much the same as executing SQLs to present result sets, you may highlight statements, run a script or load from file. The explain plan results can easily be compared by using the pin feature in combination with window style presentation.
1 2

Data Type support

In addition to the standard data type support in DbVisualizer there is also support for the following Oracle specific data types:
  • XMLTYPE
  • TIMESTAMPTZ
  • TIMESTAMPLTZ
  • Automatic conversion of DATE data type to TIMESTAMP (configure in Connection Properties)
(For XMLTYPE you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit available from Oracle Corp.).
1

Copyright © 2007 Onseven Software AB. All rights reserved.