Printable View
Hi gurus
Now That various tools of database administration are available, OEM, ERWIN, DBAARTISAN, STATSPACK ,Quest Tools with all GUI features and very Simple User Features ( click the menus u can have every ojects created in database / Tablespace/ Users/Roles/ Schema Objects etc.
so just wanted to know with the introduction of GUI tools for DBA Activities, whether the role of the dba remains the same or life is easier now with the use of such tools
-- Gayatri
80% of the DBAs do not use the tools you mentioned with the exception of ER-WIN which is a case tool.
The reasons are:
1 All the DBA tools are very slow.
2 They will work with NT/Windows 2000 machine.
3 Security is lacking in the DBA tools.
4 Most of the tools do not take care of the new features of Oracle.
I use Staspack which is not a "Administrative" Tool
I use Toad because I can read the whole rows in any query while with sql*plus I haveto format blah blah
I dont create objects with these tools because many time they dont do what you really want
I never use OEM because it toasts my PC
I dont use ERWIN because it is not a 100% DBA Tool, it is an analyst tool, however I use it soetimes just to reverse engineer the database
I dont use DBArtisan because it is slow as OEM
in resume my daily tools:
secure crt to logon on server and lovely unix commands
sql*plus for small queries, small reports, scripts
toad for large queries and to see objects and because toad is fast
vi and ultra edit
I install statspack once and schedule it to gather statistics, then truncate it once every month
I dont use anything else
i agree with tamilselvan. even i never used OEM tools and others. what all these tools do. they just query the same dictionaries to get the output. the same whatever we do from sql plus prompt. but they utilise more memory. unnecessary. so i think best tool is sql plus. ya ofcourse u should know some of these tools just for info sake.Quote:
Originally posted by tamilselvan
80% of the DBAs do not use the tools you mentioned with the exception of ER-WIN which is a case tool.
The reasons are:
1 All the DBA tools are very slow.
2 They will work with NT/Windows 2000 machine.
3 Security is lacking in the DBA tools.
4 Most of the tools do not take care of the new features of Oracle.
i want to know what JULIAN and JURIJ think about these tools.
I do not use TOAD, OEM, etc. I use the command line :-) SQL*Plus is my favourite. If you know the Oracle DD, you don't need 3rd party tools.Quote:
want to know what JULIAN and JURIJ think about these tools.
OK, we have Patrol on our production DBs but almost all alarms are false.
Command line is the only way to go when doing DBA activities. Right a script an run it. You will get the results back in a fraction of the time it would take you even load a GUI.
Ok, as I was chalanged directly, I'll participate in this. Partly also because it seems that I'm one of the few DBA's here who is not affraid to admid that I use various GUI tools for my work. ;)
I use TOAD all the time. Primarilly because much of my work is not actually DBA stuf, but server side PL/SQL developement. I also use OEM ocasionally. Hovewer I allways press "Show SQL" button before I submit any action that creates or modifies database structures in OEM. Partly because I don't want any surprises, I want to double check that I didn't mess something or that OEM didn't mess something. I also find this a great way to refresh and strengthen my knowladge of SQL syntax.
Oh, and yes, I also use SQL*Plus, mainly to copy-paste snippets of code and their results when answering questions in this forum. :D
I have grown up with oracle using nothing but SQL*Plus and vi editor. And I'm gratefull for those times. But I would quit my job first thing tommorow if my employer decided that from now on we'll only use SQL*Plus and simple editor for our development! Not because I would be affraid that I could not do same thing using those ancient tools that I do now using GUI. I'm enough experienced to know that I can do anything with SQL*Plus, but I would still quit my job, simply because I would know that by not using available GUI tools I'll be just wasting my time! I find it particulary amusing to see such an argument as "GUIs are so slow" or "They lack security". Come on , you must be realy supersonic typist to type same commands inro SQL*Plus that I do by clicking couple of buttons and dropdown lists! And what superior security features has SQL*PLus built in that GUI tools hasn't got?
I have couple of favorite Oracle authors and gurus, and one of them is of course Steven Feurenstein. In his booklet "PL/SQL Best Practices" one of his first advices goes something like this: "Forget about SQL*Plus and a text editor as your main developing environment. Adopt some of the available GUI (and RAD) tools to improve your efficiency by an order of magnitude".
And let me ask you all: how many databases have you created recently (say in last two years) by manually typing scripts with "CREATE DATABASE etc etc" commands? Have you never used Database Configuration Assistant to create those scripts for you? I do it all the time (although those generated scripts almost allways need some manual corrections, unfortunatelly).
But don't get me wrong. If one is not capable of performing same actions in SQL*Plus that he/she is doing using using GUI, I don't consider him/her as a competent DBA or developer!
yeah i agree, sometimes its easier (and faster) to use GUI tools. with GUI tools Junior Oracle DBAs can also start helping out in light DBA administration. But ofcourse nothing will beat SSH + SQL*Plus.
I haven't used it but there is an interesting thing called pocketDBA and PocketSA by ari kaplan that will enable you to administer and monitor your Oracle Databases and Unix servers using a PDA. check out http://www.xb.com.
More than 20 databases. Yes, I do create databases via SQL*Plus.Quote:
And let me ask you all: how many databases have you created recently (say in last two years) by manually typing scripts with "CREATE DATABASE etc etc" commands?
But since I do a lot of PL/SQL work too, well then I forget about SQL*Plus. I use Procedure Builder or SQL Navigator.
Julian, that means you don't create the unnecesary tablespace created by DB Assistant viz. tools, indx, etc if you are creating another tablespaces for your stuff.
is there any way to skip this while installation using DB Assist. if not is it really necessary. cause at least i never make use of these tablespaces.
in case of Jurij, i agree with him. as i've mentioned in my previous post that i never use the gui tools . i was wrong. actually i use db assist for creation of database nowadays. sometimes i use sqlplus. but as far as tuning and other stuffs are concern . i prefer sql plus. ofcourse i still love to learn the new things about gui. at least to know it . know the features.