Oracle Database Tools for Day to Day Activities
OdbTools – Product Description
odbTools is easily
accessed via a menu structure as well as via a set of icons divided into
six major sections: This section allows you to
view and maintain virtually all database objects, including partitioned
tables and materialized views. It also includes a function to view
inter-dependency between objects. This section allows you manage
users and security. It also includes functions to map objects for each
user. You can also view all SQL statement issued by a user since the
instance started. This section allows you to
monitor virtually all the database components as well as incorporating
user-defined statistics. This section allows you to
define preferences and attributes for odbTools. It also include setup for
used-defined statistics as well as for the alert function. This sections comprises a
simple ad-hoc query generator, an SQL worksheet for non select statements
and an interface for analyzing SQL statements. This section allows you to
generate various SQL and OS scripts from creating a database to creating a
table. It also includes a graphical interface to Oracle Logminer and
generating, designing and maintaining ER diagrams.
Database Objects
Database Information
This function displays database main information such SGA main
components and current release.
System Global Area
This function displays SGA detailed information.
Initialization
Parameters
This function is used to maintain instance in idealization
parameters including NLS parameters. It
also used to maintain pfile and spfile functions.
Maintain Rollback
Segments
This function is used to maintain and monitor the database
rollback segments for both manual and auto undo management.
Maintain Redo Log Files
This function is used to maintain and monitor the database redo
log files.
Maintain Tablespaces
This function is use to maintain the database tablespaces. It
includes all required function to maintain and monitor the tablespaces as well
as the data files such as CREATE TABLESPACE, DROP TABLESPACE, RESIZE DATAFILE,
AUTOEXTEND DATAFILE.
Create New Table
This function is used to help create a new table manually or by
selecting a definition from another table. It also support creation of
temporary table as well as index organized table.
Maintain Tables
This function is used to view and maintain database tables
information. In addition to the standard table functions, it also includes a
function to display table contents as well as generating a script to create the
table.
The following types are supported:
Regular Tables
Partitioned Tables
Index Tables
Log Tables
Materialized Views
Materialized Index Views
Temporary Tables
Maintain Indexes
This function is used to view and maintain database indexes for
regular and portioned tables.
Maintain Database Views
This function is used to view and maintain views. It includes functions such as CREATE VIEW, DROP VIEW,
COMPILE …
Maintain Stored Objects
This function is used to view and maintain all stored objects such
as packages, functions, types and procedures.
Maintain Database
Triggers
This function is used to view and maintain all database triggers.
Maintain Database
Synonyms
This function is used to view and maintain all database synonyms.
Maintain Database
Sequences
This function is used to view and maintain all database sequences.
Maintain Database Links
This function is used to view and maintain all database links.
.
Maintain Database Shared
Pool Cached objects
This function is used to view all current stored objects in the
shared pool. It is also used to keep or free an object in the SGA.
Display Object
Dependencies
This function is used to display object dependencies. It lists all
objects referencing and referenced by a selected object.
Maintain Materialized
Views
This function is used to create a materialized view.
Maintain Materialized
View Log
This function is used to create a materialized view log.
Users and Security
Maintain Users
This function is used to view and maintain all database users. It
include options to generate a script to create a user as wel as creating a new
user having the same attributes and privileges as a given user.
Maintain Profiles
This function is used to view and maintain user profiles.
Maintain Roles
This function is used to view and maintain all database roles.
Maintain System Privileges
This function is used to view and maintain all system privileges
Maintain Object Privileges
This function is used to view and maintain all object privileges.
Map Owner Objects
This function is used to map a schema or a tablespace to view all
objects in the schema or tablespace.
Map Owner Data Files
This function is used to map a schema or a datafile to view all
objects in the schema or datafile.
Manage Database Auditing
This function is used to view and maintain all audit trail report.
Display User SQL History
This function is used to view stored SQL trace history.
Monitoring and Performance Tuning
Monitor Library Cache
This function is used to monitor the library cache hit ratio.
Monitor Dictionary Cache
This function is used to monitor the dictionary cache hit ratio.
Monitor Buffer Cache
This function is used to monitor the buffer cache hit ratio.
Monitor System Statistics
This function is used to monitor the library cache hit ratio.
Monitor Session Statistics
This function is used to monitor system statistics. It also
features the option to monitor a comination of statistics based on a formula.
Monitor System Events
This function is used to monitor database system events.
Monitor Latch Statistics
This function is used to monitor database current latches
Monitor Table Locks
This function is used to monitor current database locks. It also
highlights shared locks as well as held and blocked locks.
Monitor Top Sessions
This function is used to monitor top statistics from all possible
system statistics.
Monitor Database Transactions
This function is used to monitor active database transactions.
Monitor Active Users
This function is used to monitor current active session. Long
lasting queries are easily spotted graphically as well as recorded in a file.
Monitor Users Activity
This function is used to monitor general instance activity.
Monitor Waits Statistics
This function is used to monitor database wait statistics.
Monitor Data File I/O Statistics
This function is used to monitor file I/O statistics for a data
file.
Monitor Data File I/O Activity
This function is used to monitor I/O activity for one or more
data files.
Monitor Data Files Space Allocation
This function is used to monitor data file storage activity.
Monitor Imminent Storage Allocation Failure
This function is used to monitor imminent storage allocation
failure for manually managed tablespaces.
Monitor Sessions
This function is used to monitor current database activity.
Monitor Alert
Events
This function is used to monitor database events.
Manage In-Doubt Transactions
This function is used to monitor pending transactions.
Monitor SGA Free Memory
This function is used to monitor SGA free memory
Monitor Redo Log Files
This function is used to monitor redo log files activity.
Monitor Alerts
This function is used to monitor pre-defined alerts and notify the
DBA by email when a threshold is reached.
Setup and Preferences
Maintain Local Database
This function is used to manage the MS Jet based database.
Set Options and Preferences
This function is used to set option and preferences for odbTools.
Event Monitoring Alert Setup
This function is used to setup the list of alerts to monitor.
User Defined Statistics
This function is used to add user-defined statistics to the
regular Oracle system statistics,
User Defined
Statistics
This function is used to setup operating system files size to
monitor space allocation.
SQL
Execute SQL DDL and
DML Commands
This function is used to execute DDL and DML scripts.
Perform Ad-Hoc Queries
This function is used to build and execute ad-hoc queries.
Analyze SQL Statement
This function is used to analyze and tune SQL statements.
Tune SQL Statement
This function uses Oracle sqltune to generate a report to tune an
SQL statement.
Display
User SQL History
This function is used to display SQL history.
Manage Scripts
This function is used to manage odbTools user’s scripts.
Tools
Create Control File Script
This function generates the script to create the control file.
Create Database Script
This function is used to generate the init.ora file and the
complete shell or BAT script to create a database.
Duplicate Database Script
This function is used to generate a script to clone a given
database.
Manage Job Queue
This function is used to manage Oracle job queues.
File Transfer
This function is used to display SQL history.
Process Hot Backup
This function is used as a simple FTP interface.
Generate Hot Backup Script
This function is used to generate a script for database hot
backup.
Monitor Hot Backup
This function is used to monitor hot backup in process.
Schema Compare
This function is used to compare objects in two schemas. It is
also used to comare data in tables from different schemas.
Generate Create Script
This function is used to generate a script to create database
objects.
Logminer Interface
This function is a GUI interface to Oracle logminer.
Delete Database Script
This function is used to generate a script to remove a database
and its data files.
Process ERD
This function is used to produce an entity relational diagram from
a given schema.
View Instance Log File
This function is used to view instance alert log files.
Load Data File Into Table
This function is used to quickly load small tables data.
Maintain Oracle Recycle Bin
This function is a GUI interface to Oracle recycle bin.
Perform FK/Indexes Analysis
This function is used to generate a script to create indexes
related to foreign keys constraints.