Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: bulk collect paper reviews

Re: bulk collect paper reviews

From: Yongping Yao <yaoyongping_at_gmail.com>
Date: Wed, 16 Nov 2005 21:07:11 +0800
Message-ID: <706468990511160507i4bfacfb2v8276c2199b301096@mail.gmail.com>


I agree. And I think Expert One-on-One Oracle has an example on BULK COLLECT too. You can download and try it out.

On 11/16/05, Chris Stephens <cstephens16_at_gmail.com> wrote:
>
> i would imagine there are some quick reads on asktom that would suffice.
>
> On 11/16/05, Yasin Baskan <yasbs_at_kocbank.com.tr > wrote:
> >
> > Hi,
> >
> > Developers in my company tend to use cursors and loops to fetch data
> > and process them in plsql. Either they are not aware of the bulk collect
> > feature or they do not prefer it i do not know why.
> >
> > I have advised to modify some programs to use bulk collects to decrease
> > the number of logical reads and we had huge performance improvements. Also
> > they tend to fetch rows from cursors and process them, instead of using a
> > simple select statement to do the same job. I am trying to change this
> > coding behaviour also, but that's another story.
> >
> > I have prepared a small document that explains the bulk collect feature
> > simply. If anyone is interested in the subject and also have time, i would
> > be pleased if you can review it and share your opinions and corrections with
> > me. Before i send it to the developers i would like it to be reviewed.
> >
> > So, if anybody is interested can you send me an email so i can send you
> > the document for review.
> >
> > Thanks.
> >
> > <http://www.spreadfirefox.com/?q=affiliates&id=105360&t=70>
> >
> >
> >
> > Bu mesaj ve onunla iletilen tum ekler gonderildigi kisi ya da kuruma
> > ozel ve Bankalar Kanunu geregince, gizlilik yukumlulugu tasiyor olabilir. Bu
> > mesaj, hicbir sekilde, herhangi bir amac icin cogaltilamaz, yayinlanamaz ve
> > para karsiligi satilamaz; mesajin yetkili alicisi veya alicisina iletmekten
> > sorumlu kisi degilseniz, mesaj icerigini ya da eklerini kopyalamayiniz,
> > yayinlamayiniz, baska kisilere yonlendirmeyiniz ve mesaji gonderen kisiyi
> > derhal uyararak bu mesaji siliniz. Bu mesajin iceriginde ya da eklerinde yer
> > alan bilgilerin dogrulugu, butunlugu ve guncelligi Bankamiz tarafindan
> > garanti edilmemektedir ve bilinen viruslere karsi kontrolleri yapilmis
> > olarak yollanan mesajin sisteminizde yaratabilecegi zararlardan Bankamiz
> > sorumlu tutulamaz.
> > This message and the files attached to it are under the privacy
> > liability in accordance with the Banking Law and confidential to the use of
> > the individual or entity to whom they are addressed. This message cannot be
> > copied, disclosed or sold monetary consideration for any purpose. If you are
> > not the intended recipient of this message, you should not copy, distribute,
> > disclose or forward the information that exists in the content and in the
> > attachments of this message; please notify the sender immediately and delete
> > all copies of this message. Our Bank does not warrant the accuracy,
> > integrity and currency of the information transmitted with this message.
> > This message has been detected for all known computer viruses thence our
> > Bank is not liable for the occurrence of any system corruption caused by
> > this message
> >
>
>

--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog: http://blog.csdn.net/ern
http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 16 2005 - 07:09:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US