Oracle - Database Specific Support

 DbVisualizer Logo
DbVisualizer 6.5
October 2008 		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
Export Schema, String Search
Tables
Create Table References, Table Comments, Tables
Table
Import Table Data, Create Trigger, Alter Table, Create Index, Analyze Table1, Comment Table, Copy Table, Drop Table, Empty Table, Grant Privilege, Rename Table, Script: CREATE TABLE, Script: DELETE, Script: INSERT, Script: SELECT, Script: UPDATE References, Navigator, Columns, Columns Comment, Constraints, DDL with Storage3, DDL2, Data, Dependencies, Grants, Indexes, Info, Primary Key, Row Count, Row Id, Triggers
Columns

Columns
Column

Column
Constraints

Constraints
Constraint

Columns, DDL3, Info
Column

Column
Indexes

Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL3, Index
Column

Column
IndexPartitions

Partitions
IndexPartition

Info, Sub-Partitions
IndexSubPartition

Info
Triggers

Triggers
Trigger
Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Partitions

Partitions
Partition

Info, Sub-Partitions
SubPartition

Info
Views
Create View View Comments, Views
View
Comment View, Compile View, Create Trigger, 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
Triggers

Triggers
Trigger
Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
Synonyms
Create Synonym Synonymed Objects, Synonyms
Indexes

Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL3, Index
Sequences
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence DDL3, Info
MaterializedViews

Materialized Views
MaterializedView
Drop Materialized View, Refresh Materialized View Columns, DDL3, Data, Indexes, Info, Row Count, Select SQL
Indexes

Indexes
Index
Compute Statistics for Index, Drop Index, Rebuild Index, Rename Index Columns, DDL3, Index
Column

Column
Functions
Create Function Functions
Function
Compile Function, Drop Function Function Editor
Procedures
Create Procedure Procedures
Procedure
Compile Procedure, Drop Procedure Procedure Editor
Packages
Create Package Packages
Package
Compile Package, Compile Package and Body, Create Package Body, Drop Package and Package Body Package Specification Editor
PackageBody
Compile Package Body, Drop Package Body Package Body Editor
PackageBodies
Create Package Body Package Bodies
PackageBody
Compile Package Body, Drop Package Body Package Body Editor
JavaSources3

Java Sources
JavaSource

Info, Source
JavaClasses3

Java Classes
JavaClass

Info
Triggers

Triggers
Trigger
Compile Trigger, Disable Trigger, Drop Trigger, Enable Trigger, Rename Trigger Trigger Editor, Info
ObjectTypes

Object Types
ObjectType

Attributes, DDL3, Info, Methods
RecycleBin4

Recycle Bin
RecycleBinTable
Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
Jobs
Create Job Jobs
Job
Disable Job, Enable Job, Remove Job, Run Job Info
Scheduler5

Scheduler Global Attributes
SchedulerChains

Scheduler Chain Rules, Scheduler Chain Steps, Scheduler Chains, Scheduler Chains Running
SchedulerChain

Scheduler Chain, Scheduler Chain Rules, Scheduler Chain Steps
SchedulerJobs

Scheduler Job Arguments, Scheduler Job Logs, Scheduler Job Run Details, Scheduler Jobs, Scheduler Jobs Running
SchedulerJob

Scheduler Job, Scheduler Job Logs, Scheduler Job Run Details
SchedulerJobArguments

Scheduler Job Arguments
SchedulerJobArgument

Scheduler Job Argument
SchedulerPrograms

Scheduler Program Arguments, Scheduler Programs
SchedulerProgram

Scheduler Program
SchedulerProgramArguments

Scheduler Program Arguments
SchedulerProgramArgument

Scheduler Program Argument
SchedulerSchedules

Scheduler Schedules
SchedulerSchedule

Scheduler Schedule
DatabaseLinks
Create Database Link Database Links
DatabaseLink
Drop Database Link, Test Database Link DDL, Info
InvalidObjects
Compile All Invalid Objects
Properties

Session Privileges, Session Properties3, Session Roles
DBA

DBA
Users
Create User Users
User
Change Password, Drop User, Expire Password, Lock User, Unlock User, Script: Clone User DDL6, Info, Roles, System Privileges, Table Privileges, Tablespace Quota
Roles

Roles
Role

DDL3, Info, Roles, System Privileges, Table Privileges, Users
Sessions

Active Sessions, Sessions, Traced Sessions5
Session
Disable Trace5, Enable Trace5, Kill Session Active SQL, Session
Locks

Blocking Locks, Locks 1, Locks 2
AllRecycleBin4

Recycle Bin
AllRecycleBinTable
Flashback to Before Drop, Purge from Recycle Bin Data, Recycle Bin Table
Storage

Data Files, Directories, Redo Logs, Rollback Segments, Tablespaces, Temp Files
Tablespaces

Datafile IO, Objects, Tablespaces, Usage By User
PermanentTablespaces
Create Tablespace Datafile IO, Objects, Tablespaces, Usage By User
PermanentTablespace
Add Datafile, Remove Tablespace, Rename Tablespace4, Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL3, Datafile IO, Objects, Tablespace, Usage By User, User Quota
PermanentDataFile

Data File, Objects
TemporaryTablespaces1

Tablespaces
TemporaryTablespace

DDL3, Tablespace, User Quota
TemporaryTempFile

Temp File
UndoTablespaces3

Datafile IO, Objects, Tablespaces, Usage By User
UndoTablespace

DDL3, Datafile IO, Objects, Tablespace, Usage By User
UndoDataFile

Data File, Objects
TablespaceFiles

Data Files, Temp Files
PermanentDataFile

Data File, Objects
PermanentTablespace
Add Datafile, Remove Tablespace, Rename Tablespace4, Tablespace Offline, Tablespace Online, Tablespace Read/Write Mode DDL3, Datafile IO, Objects, Tablespace, Usage By User, User Quota
TemporaryTempFile1

Temp File
TemporaryTablespace

DDL3, Tablespace, User Quota
UndoDataFile3

Data File, Objects
UndoTablespace

DDL3, Datafile IO, Objects, Tablespace, Usage By User
RollbackSegments
Create Rollback Segment Rollback Segments
RollbackSegment

DDL3, Rollback Segment
RedoLogs
Force Log Switch Redo Log Activity, Redo Logs
RedoLog

Redo Logs
Directories3
Create Directory Directories
Directory
Drop Directory, Grant Privileges Directory, Directory Privileges
DirectoryPrivilege
Revoke Privileges
Scheduler5

Scheduler Global Attributes
SchedulerJobClasses

Scheduler Job Classes
SchedulerJobClass

Scheduler Job Class
SchedulerWindows

Scheduler Window Details, Scheduler Window Log, Scheduler Windows
SchedulerWindow

Scheduler Window, Scheduler Window Details, Scheduler Window Log
SchedulerWindowGroups

Scheduler Window Groups
SchedulerWindowGroup

Scheduler Window Group
SchedulerWindowGroupMembers

Scheduler Window Group Members
SchedulerWindowGroupMember

Scheduler Window
Statistics


InstanceInfo

Instance Info
InstanceSummary

Instance Summary
Latches

Latches
ObjectCount

Object Count
Waits

Waits
SGA
Flush SGA Object Cache, Poorly performing SQL's, SGA
1)Oracle 8.1 and later
2)Oracle 8 and later
3)Oracle 9 and later
4)Oracle 10 and later
5)Oracle 10.1 and later
6)Oracle 7 and later



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 © 2008 Onseven Software AB. All rights reserved.