Re: How do you feel about allowing non-DBA's on your database servers?

Which is an argument for contracting the developers to do the on-going support as well. We manage a lot of applications which produce a right-royal verbal diarreah of trace info, and they are all apps that were written by companies that were contracted beforehand to do the on-going app support as well. That gave them an incentive to put effort into understanding their application and what would be useful in troubleshooting and build a good trace facility in. We don't give them prod access (or acceptance test even) as a rule - they've got to use their app.
Unfortunately they tend to leave the tracing running in maximum verbosity mode.. 

Cheers,
Tony

Around 29/07/2009 7:14 AM, Niall Litchfield said:

that'll generally be because of economics - no really.
a trace facility is of interest to those who primarily troubleshoot systems - the people who ask "what happened?, when? for how long? why?" These people are not generally developers. arguably they should be, but they aren't and the likelihood of them being so is reducing over time. The people who can effectively implement a trace/debug facility are in fact developers. They however, are rightly, interested in what they are employed for which is delivering 'features' fast and cheap. trace costs development effort and doesn't reward anyone involved in the development. of course offloading responsibility for production performance issues to developers may not be especially popluar with this group, but I bet the resultant systems would be. Niall On Tue, Jul 28, 2009 at 7:14 PM, Jared Still <jkstill@xxxxxxxxx <mailto:jkstill@xxxxxxxxx>> wrote: 

    On Tue, Jul 28, 2009 at 4:00 AM, Nuno Souto <dbvision@xxxxxxxxxxxx
    <mailto:dbvision@xxxxxxxxxxxx>> wrote:


            Has anyone seen a development implementing really useable
            trace environments?


        No.  And it shuts them off real quick!
        ;)


    That's something I just can't understand.

    How do they develop software without a decent trace built in?
Implementing a trace system with different levels of verbosity isn't very difficult. 

    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist





--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: