BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation








An Introduction to the EnterpriseDB Toolset

Oracle Tips by Burleson Consulting

The EnterpriseDB Toolset comprises six main components: Database Server, Developer Studio, PL Debugger, Remote DBA Management Server, Replication Server and Migration Toolset.  In this section, I will introduce each component and describe some of their more important functions.   

I will cover each topic in greater detail in later chapters.  I am not going to discuss the database server at this point.  All of the components that I discuss in this section run on top of the database server.  Everything up to this point, and everything after this point, is really all about the database server. 

This section is not going to go into the fine details of how each component works.  It is just meant to outline the major functionality of each component. 

EnterpriseDB Developer Studio

Developer Studio, Figure 2.21, is an IDE for EnterpriseDB developers.  Developer Studio allows a developer to browse databases, write and tune SQL and EnterpriseDB SPL code and perform some limited system administration functions (such as backup and restore).

Developer Studio is an Open Source Java program.  You can download the source code from EnterpriseDB.com.  Because it is a Java program, the program works, and looks, the same on each platform supported by EnterpriseDB.

Developer Studio can connect to Oracle databases, EnterpriseDB databases and PostgreSQL databases.  Using Developer Studio, a developer also has the ability to view PL/SQL (in Oracle), write and compile EnterpriseDB SPL (in EnterpriseDB) and PL/pgSQL (in EnterpriseDB and PostgreSQL).  Developers can also write and tune SQL statements.

The main areas of Developer Studio (Figure 2.21) are the menu and toolbar (area 1), the navigator pane (area 2), the properties pane (area 3), the SQL pane (area 4), the SQL Interactive window, and Visual Explain.  Less used areas are EnterpriseDB PSQL, a SQL*Plus-like command line SQL editor, backup and restore and the connection configuration screen.  The PL Debugger is integrated into Developer Studio but is a separate component.

NOTE:  Visual Explain, the PL Debugger and EnterpriseDB PSQL cannot be used with Oracle. 

Figure 2.21: Developer Studio Main Window

Area 1 of Figure 2.21 displays the Main Menu and the Toolbar. 

Under the File menu options are: Add Server – adds a new database server; and Exit.

Under the SQL Menu Options are: the SQL Interactive tool (Figure 2.23) – allows a person to enter and run queries, and write and compile code; SQL Terminal – run the command line SQL Editor; Visual Explain – allows a developer to see a graphical explain plan for performance tuning; and View Data – which uses the SQL Interactive tool to run a SELECT query against a specific table.

Under the Tools Menu Options are: Backup and Restore; options to run the debugger and set debugger break points; and Preferences – set the default exit behavior of SQL Interactive (commit, rollback, or always ask) and configure the command to start the SQL Terminal.

Under the Help menu options are options to connect to the EnterpriseDB web site and view the online help or view an About box.

On the toolbar, Figure 2.22, are several icons:  Server – add, edit, copy or remove a server connection, Refresh – requery the navigator and repaint the screen, Create Object – create a new object of the type highlighted in the navigator pane, Drop Object – drop the object highlighted in the navigator pane, SQL Interactive – launch the SQL Interactive tool, SQL Terminal – Launch the SQL Terminal, Visual Explain – launch the Visual Explain tool, and the an icon for the debugger and an icon for setting a debug breakpoint.

This is an excerpt from the book "EnterpriseDB: The Definitive Reference" by Rampant TechPress.

Expert Remote DBA

BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call
BC Remote DBA today.



Remote DBA Service

Oracle Tuning Book


Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software







BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright ฉ 1996 -  2013 by Burleson. All rights reserved.

Oracleฎ is the registered trademark of Oracle Corporation.

Hit Counter