tag:blogger.com,1999:blog-12459003.post3429631782988379515..comments2023-08-03T09:19:28.438-04:00Comments on So What Co-operative: Point & Click DBAsJeff Hunterhttp://www.blogger.com/profile/15701602600662849251noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-12459003.post-18973305456789495402009-05-20T19:15:57.735-04:002009-05-20T19:15:57.735-04:00Until you make one little configuration change in ...Until you make one little configuration change in EM to get rid of an annoying spurious "your tablespace is full" mail, and start getting ORA-600's every 15 minutes... grrrrrrr.... (hit bug 5727166 in 10.2.0.4 yesterday).<br /><br />word: antingJoel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-51073927179469339742009-03-17T12:45:00.000-04:002009-03-17T12:45:00.000-04:00Oracle EM Grid control is another great toolset DB...Oracle EM Grid control is another great toolset DBAs should take fully advantage of. Eventually they should make console-based tool extinct. Otherwise, Why do you think Oracle has put in a lot of $$$ to continue developing and supporting it? I am sadden to see that Oracle 10g Enterprise manager java console is no longer part of 11g. But I sure they keep it around. You can do the database Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-62075429948040254582009-02-24T13:18:00.000-05:002009-02-24T13:18:00.000-05:00For me, the GUIs are very helpful because they don...For me, the GUIs are very helpful because they don't force me to remember syntax. It would be one thing if I did it all the time, but I have to work in many different environments. Remembering SQL Server's syntax and Oracle's syntax after I have just finished a programming project that took a year is quite difficult.<BR/><BR/>You asked, What if the GUI went away? Well, Google would be my tool Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-25680666824468449552009-02-23T19:41:00.000-05:002009-02-23T19:41:00.000-05:00I think there should be a range of skill sets and ...I think there should be a range of skill sets and abilities, and organizations should explicitly recognize this and encourage continuous betterment.<BR/><BR/>Should you be asking "how to tune a statement without grid control?" or "would you want to figure out how to tune a statement without grid control?" If they go "oh yeah, to do that you..." even better.<BR/><BR/>That's how you distinguish Joel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-66726890485736756732009-02-14T22:06:00.000-05:002009-02-14T22:06:00.000-05:00Anonymous has a point, if your recruiting agent or...Anonymous has a point, if your recruiting agent or whoever is screening the resumes just looks for anyone over say 30 or has been a DBA since at least 1999-2000 you won't find this problem.<BR/><BR/>I am not saying younger DBAs won't be exposed to sqlplus. In fact if you do find a younger candidate, who has used sqlplus and grid control that would be much more interesting.<BR/><BR/>Oh yeh, didn'tAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-90085713041297811802009-02-13T18:38:00.000-05:002009-02-13T18:38:00.000-05:00Maybe if the dollars being paid to DBA candidates ...Maybe if the dollars being paid to DBA candidates matched better against the knowledge base requirements there would be less whining about things like this?<BR/><BR/>Just a thought ... <BR/><BR/>But of course your company is the exception to the rule and it is just everyone else trying to lowball qualified older candidates right?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-17616446960377120582009-02-13T01:01:00.000-05:002009-02-13T01:01:00.000-05:00I've been going around doing presentations and cou...I've been going around doing presentations and courses on Grid/DB Control performance screens. They're great, but if you're utterly dependant on *any* GUI, then you're lost as soon as you work at a site that doesn't use it.<BR/><BR/>I'm not sure it's GUI tools per se that are the problem, though. I see exactly what Gary described - a bunch of SQL scripts and some process documentation allowing Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-5843464710987453092009-02-12T21:19:00.000-05:002009-02-12T21:19:00.000-05:00I agree. But it isn't just the GUI. The same can h...I agree. <BR/>But it isn't just the GUI. The same can happen if they've inherited a bunch of SQL scripts from a previous DBA and are using them blindly.<BR/><BR/>Next time, ask them whether they are seeing the query plan that the instance actually used, or whether they've just asked the database to generate a plan for that query (and if so, how bind variable peeking might impact the generated SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.com