Explain the utilities which help the DBA to manage the database?

Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion within the field as to what, exactly, is a database utility. There are a many of definitions floating around out there. DBAs constantly refer to utilities, tools, solutions, and suites.

So, first of all, let's be clear on what a utility is and what is a "tool" or "solution." A utility is generally a single reason program for moving and/or verifying database pages; examples involves LOAD, CHECK, REORG, UNLOAD, COPY, and RECOVER. A database tool is a multi-functioned program designed to simplify database monitoring, management, and/or administrative tasks. A solution is a synergistic group of tools and utilities designed to work together to address a customer's business issue. A suite is a group of tools which are sold together, but are not necessarily integrated to work along with each other in any way. Of course, these are only my definitions. But there are meaningful definitions which creates it easier to discuss DBA products and programs

Posted Date: 5/10/2013 6:27:03 AM | Location : United States

Ask an Expert

Related Discussions:- Explain the utilities which help the dba to manage database, Assignment Help, Ask Question on Explain the utilities which help the dba to manage database, Get Answer, Expert's Help, Explain the utilities which help the dba to manage database Discussions

Write discussion on Explain the utilities which help the dba to manage database
Your posts are moderated

Write your message here..

Related Questions

How does the system cope up with a record crash, How does the system cope u... How does the system cope up with a record crash when recovery is going on after the first crash? Ans:  In a system the undo and redo operations are needed to be idempotent to c

What are object interaction diagrams, What are object interaction diagrams?... What are object interaction diagrams? Object interaction diagrams are the diagrams that used to describe order in which messages are communicated in execution of an operation,

What is a candidate key, What is a candidate key? Minimal super keys ar... What is a candidate key? Minimal super keys are known as candidate keys.

What is the difference between where and having clauses, What is the differ... What is the difference between WHERE and HAVING clauses?. Predicates in the WHERE clause applies to every tuple while the predicate in the HAVING clause applies to groups.

Erd, er diagram on cosmetics. er diagram on cosmetics.

Dml precompiler in database management system, DML Precompiler All th... DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b

Convert the erd into its relevant relational schema, Question: Describe... Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

Describe the primary key functions, Describe the primary key functions? ... Describe the primary key functions? Primary Key : The primary key is an attribute or a set of attributes in which uniquely identify a specific example of an entity. Every entit

What are the various states of transaction process, What are the various st... What are the various states through which a transaction passes through in its lifetime?  Briefly discuss all the events that causes transition from one state to another.   Ans:

Oracle, how oracle can be used how oracle can be used