Re: How DBA stuff should a Developer learn?

What's the definition of a transaction?

Surely it goes along the lines of: a series of DML statements either all of which succeed, or none of which succeed, because if only some of them succeed, we have logical corruption of the data.

Based on that definition, the developer may have been perfectly correct in leaving the final commit until the end -in which case, its the DBAs fault for not resourcing the transaction properly. Sometimes, I think there's a legitimate need for a thread here that reads, 'How much developer stuff should a DBA learn?'.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Kai Yuen Kiang" <kai_kiang_at_cytecht.com> wrote in message
news:a61mki$ffc3_at_imsp212.netvigator.com...


> I've seen developer only commit after a very very long transaction which

> hangs the production DB because it simply hold the rollback segment for

> ages! So do you say some knowledge of DB would help that kind of

developer?


>

> --

> Best Regards,

> Kai Yuen Kiang

>

> MIS Analyst

> Cytech Technology Ltd.

> Tel:  (852) 2378-2225

> Fax: (852) 2375-7700

> http://www.cytecht.com

> "Ryan Gaffuri" <rkg100_at_erols.com> ¼¶¼g©ó¶l¥ó

> news:a60u6k$apv$1_at_bob.news.rcn.net...

> > Posted this on .misc by accident. There are alot more DBA's here... so

> > decided to try here...

> >

> > I have been a developer for about 18 months now and Ive started delving

> into

> > the DBA side of Oracle. I have read the concepts manual and am now

reading


> > the manual on performance tuning. Ill have to read both of those atleast

> > twice to really pick up all the information. Im slowly reading Tom

Kyte's


> > book as well. Its slow going since most of it is new information.

> >

> > Ive noticed that many "senior" developers do not bother to learn this

side


> > of it. What Im learning now is really opening my eyes to alot of things

> that

> > I just took for granted. I open a cursor, ok it does what I want. Its

> pretty

> > useful to know what is going on and how its being processed.

> >

> > I dont think I want to become a DBA. Ill probably head down the data

> > modelling/business rules route in time, however, I think that in order

to


> be

> > an elite professional in Oracle I should learn more about the database

> side.

> >

> > Howard Rogers recommended Practical 8i. Does anyone have any other

> > recommendations on specifics of what I should learn?

> >

> > Also, Im leaning towards getting a Masters in Software Engineering at

> George

> > Mason... how useful is a Masters in this business? I dont have a CS

degree


> > and I have found that that limits my options.

> >

> > Thanks,

> >

> > Ryan Gaffuri

> >

> >

>

>