I'd say that knowledge of the transaction should help the dba size the
rollback segments appropriately in this instance. The developer is doing the
right thing, the rollback segments are not sized appropriately for the
transaction.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"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
> >
> >
>
>
Received on Tue Mar 05 2002 - 05:17:52 CST
