Best Tools for Oracle Database Administrators


TOAD for Oracle


Tool for Oracle Application Developers, a very popular tool with a large user base. Includes SQL Editor, Schema Browser, Procedure Editor, SQL Modeler.


Knowledge Base for Oracle Administration



A must have online reference/companion for any Oracle DBA. Saves time searching books for syntax, troubleshooting and research. Great error message guide for developers, plus a comprehensive study guide for Oracle7, 8, & 8i OCP exams with test questions.


SmartDBA Cockpit


SmartDBA Cockpit (previously known as WebDBA) helps you manage your Oracle databases from the convenience of your Web Browser. It allows you to interactively access and administer your databases remotely, and has almost all the features for the day to day working of DBAs.

Keeptool


KeepTool's tools are a suite of user-friendly, well-architected, resource-frugal components designed to fit your enterprise's Oracle-centric roles, be they modellers, architects, developers, DBAs or even data operators.

DB Tools


A comprehensive set of 22 tools. Included are a PL/SQL Editor and Debugger, SQL and application profiler, user and storage management tools, Oracle capacity and resource plans management, test data generation, benchmarking, scheduled job management and profiling and so on. DB Tools for Oracle latest version is 6.1.0.2

ManageIT

ManageIT improves database management productivity by the use of a common graphical interface. It streamlines administration tasks like object, user and space management. Supports Oracle v7.2 and later, Microsoft SQL Server, Sybase, Informix and UDB databases.

DBDiff for Oracle

DBDiff for Oracle is a database utility that performs a comparison between two Oracle databases. DBDiff for Oracle latest version is  3.0.



Comments

  1. sap upgrade toolsOctober 31, 2011 at 10:51 PM

    Oracle is widely used in business purposes hence its important to know about Oracle tools. This post explain some very important tools for Oracle. TOAD is the one which is very popular. Carefully read the description of every tool and see the difference.

    ReplyDelete

Post a Comment

Popular posts from this blog

What is Oracle Integration Cloud Service - ICS?

Image
Oracle Integration Cloud Service (ICS) is a solution that enables you to simplify integrations between cloud applications, and between cloud and on premises applications. It helps you create connections to well-known and less-known SaaS and PaaS applications, using the available cloud adapters, publish or subscribe to the Messaging Cloud Service, or use industry standards such as SOAP, REST, FTP, File, and JMS. For more information watch this Oracle video.
Read more

How to Create Packages in Oracle Database using TOAD for Oracle

Image
What are Packages in Oracle Database A package is a group of procedures, functions, variables and SQL statements created as a single unit. It is used to store together related objects. A package has two parts, Package Specification and Package Body. Package Specification Package Specification acts as an interface to the package. Declaration of types, variables, constants, exceptions, cursors and subprograms is done in Package specifications. Package specification does not contain any code. Package Body Package body is used to provide implementation for the subprograms, queries for the cursors declared in the package specification.
Read more

How to create a Simple Scheduler Job in Oracle Database using Toad

Image
Scheduler is a process which runs programmed jobs at scheduled times. This process wakes up at the specified time and runs automatically. The basic elements of the scheduler are: Jobs Schedules Programs A job specifies what needs to be executed and when. A program is a collection of metadata that will be executed by the scheduler. It contains the name of the program (a procedure or an executable, the type of the program (pl/sql block, shell script etc). A schedule specifies when and how many times a job is executed. 1. Login to the database using Toad, and create a Scheduler Job as follows;
Read more