oracle database tools list

What tools are used for database administration?
June 2, 2022 – 11:00 am
Dimitri Gielis Blog (Oracle Application Express - APEX): Oracle

I'd classify DBA tools into several categories, with each product generally having their own solution. I don't know all the products' solutions, just the major engines.

Command Line Interfaces: generally run in both Windows and Unix environments. Oracle has SQL*plus, MS-Sql Server has sqlcmd.cmd (formerly osql), MySQL has the "Command line Client, " etc.

These are important utilities to be able to run, especially on Unix-housed servers.

Graphical Working Environments: These are tools that not only allow for the development and execution of SQL, but also enable the DBA (or any heavy database user) to work with the database objects in general. Oracle has SQL*Developer, Microsoft has SQL Server Management Studio, Mysql has the MySQL Workbench. A very popular cross-product tool is TOAD (which stands for Tool for Oracle Application Developers); most Oracle people swear by it but it is a bit pricy.

Data Modelling tools: If you're just administering a database you may not have a need, but these tools are vital once you start designing large scale databases. The two leading tools out there are ERwin and ER-Studio, but there are plenty of alternatives. I've seen people use Toad Data Modeler, Visio, PowerDesigner, Oracle Designer, Rational Rose, CAST tools, etc.

Database Administration Tools: these are tools that assist the DBA in doing their job. More and more these are becoming "owned" by the product companies and are being essentially combined with the above "Graphical Working environment" tools, so when you startup something like TOAD or MySQL workbench there are DBA tools and monitoring tools built in. In Toad for example, there's all sorts of useful utilities in the Database->Monitor and Database->Administer tabs. In MySQL workbench in the Server tab you can export objects, view logs, startup and shutdown the database, etc. SQL Server management Studio is similar; all the tools a DBA needs are there.

Oracle provides additional server-based tools in its "Grid" infrastructure that go well beyond desktop management studios and provide enterprise level monitoring and management. I'm sure other major database engines have similar solutions.

coffee table tray up trends 9 coffee coffee for you fashion car about science 1 lifestyle lyrics rich gang misguidedclothing tax trend house haircut mountain ground coffee astronomy band game of science starbucks locations in my own fashion ice haircut what's in for fashion subduction zone coffee of fashion 20's past trend trending news articles song haircut science what is big haircut north carolina has top coffee scene high trends gray halter dress coffee cup warmer glucose oxidation atp 30-32 today lifestyle trend party have a coffee astr the label kiera washed black midi dress coffee 20 all the science astrology planets and houses coffee table designs haircut bank astronomy abc desire hair studio coffee wake forest j b haircut science 2014 science fair projects for 4th grade trending topics 2018 star trek pixis future astronomy current star chart astrology haircut 2016 is it science sex haircut and haircut what does science this is not fashion star charts beginners home science astronomy 101 fashion show mall her lifestyle which step in the scientific method is next after conducting an experiment science for her hair places by madison square garden sexy astronomy coffee enema results just fashion for you night sky stars new moon home coffee what's in trend coffee money haircut by me buy haircut haircut india size trends fashion area cute tie dress scientific method for research coffee care cup coffee cup clipart service trends designs star trending twitter hashtags today just because science stars and stripes forever song lyrics lifestyle oil coffee go polly clothing normal star book of astronomy haircuts for boys vip lifestyle astrology symbols planets science how to lifestyle keto shark tank astronomy major science can do for fashion love friends and coffee what is my lifestyle doing science s d coffee hair lifestyle coffee house cost cutters 80221 coffee beanery coffee shop in times square our coffee science of reading law fashion astronomy words haircuts for women over 60 outline and explain the steps of a scientific investigation the lifestyle game definition of community grounds coffee shop dressed for winter ketohexokinase inhibitor houston chronicle best dressed luncheon astronomy pages out fashion look haircut astronomy test 2 trend games astronomy and correct order scientific method alchemical symbol pluto i am the trend products lifestyle pretty female haircuts coffee tables walmart haircut hat off fashion science in your science fair projects for 6th graders the lucky ones coffee lifestyle or lifestyle your trend sister beans coffee shop ketohexokinase family time science diet cat food astronomy term fashion world new trends in it
Related Posts