2 PLSQL Performance Tuning Bulk Collect Part 1

2 PLSQL Performance Tuning Bulk Collect Part 1
Oracle PLSQL records and collections at • oracle plsql records a...
-----------------------------------------------------------------------------------
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...

[@jrdesaria]

Siva wonderful teaching method!!!

[@SivaAcademy]

Thank you 🙏

[@jmejias12]

Thank you, Siva, for your great content!

[@SivaAcademy]

My pleasure, thank you

[@Cosmic_shivprasad]

as always very awesome 🦁

[@aabha21aug]

Super as always!!👍👍 Looking forward to videos on topics like subprograms, sequence, analytical functions.. Keep up the good work! 🙏

[@SivaAcademy]

Thank you...🙏🙏....Sure, please stay tuned.

[@shrikantjoshi3174]

Very nicely explained. Thank you, sir.

[@SivaAcademy]

Welcome 🙏💐

[@ramanipriya3917]

Good teacher. Clear,neat,Can understand easily

[@SivaAcademy]

Thank you! 😃

[@kumar-bi1to]

Thank you very much. Explained very clearly

[@SivaAcademy]

You are welcome!

[@aravindrajendran581]

Nice one..as usual Good effort...

[@SivaAcademy]

@Aravind, 🙏 thanks bro

[@sophiajose1797]

Awesome video 👌 sir much liked

[@SivaAcademy]

Thank you 💐💐🙏

[@vivektarab1959]

0:06 - What is Bulk Binding 1:23 - Lets see an Example now 2:51 - Now let us look into a 4:02 - From Interview point of View 4:52 - Bulk Binding Definition 5:22 - Three Types of Binding 5:42 - Out Binding 6:09 - Key learning here 6:36 - This is called Bulk Binding 6:58 - Example 10:06 - Summarize 10:55 - As I already mentioned

[@infinitypi5569]

super explanation .. a big 👍

[@SivaAcademy]

Welcome bro

[@seetamajhi9934]

Appreciate the way you are explaining.its really helpful.

[@SivaAcademy]

It's my pleasure

[@naveenp1843]

thankyou siva sir really very very well explained

[@SivaAcademy]

My pleasure 🙏 thank you

[@KrishnaPaneri]

Nice explanation. Could you please tell me about the limit clause in bulk collect and how to decide the limit number?

[@Mohanraj-li9ff]

Thanks for describing the context switching and bulk binding in short. Have doubt in bulk collection... If there is no records available while using "bulk collect into" clause, will it raise the exception.

[@SivaAcademy]

@Mohan, thanks for your comment. No data found exception won't get raised while doing as part of bulk collect clause.

[@jsanjayb]

Nice information.. thanks

[@SivaAcademy]

Welcome

[@shreelekhamandhare7750]

Could you please explain hints and how parallel hint work?

[@surendharm2520]

we are awaiting for your bind variable videos. when shall we expect that videos in your playlist?

[@SivaAcademy]

As soon as possible bro, please stay tuned

[@deepakjagdale6215]

Thank you ..!! Very good video.. pls upload part2 video

[@SivaAcademy]

Welcome 🙏, please stay tuned for next part

[@juno7893]

Thank you 🙏

[@SivaAcademy]

Welcome 🙏

[@junkingjunking8477]

Nice explanation. Thank you :)

[@SivaAcademy]

You are welcome!

[@ramchinthakayala2092]

Great 👌👌👌👌. Pls make a video on collection exceptions.

[@SivaAcademy]

Sure Ram, please stay tuned for more videos on collections

[@prathameshkhot5717]

Good one

[@SivaAcademy]

Thanks

[@vaniganapathi830]

Is it possible to load selected columns alone into a nested table through bulk collect

[@munadakua4210]

Please make one video about no copy clause in real time scenario.

[@SivaAcademy]

Sure, please stay tuned

[@asadbelali43]

Supper

[@iswaryarajendran2022]

Awesome explanation.. can u please explain detail about bulk collect and forall...

[@SivaAcademy]

Sure, please stay tuned

[@enjoyfriends873]

Hi Siva Please explain - synonym with examples

[@WorldEye88]

Very useful. Thank you sir.

[@SivaAcademy]

Welcome

[@ramnagireddy4261]

What an explanation brother... Awesome 👌👌 Can you please do an video :diff b/w ForAll and Bulk collection(asked in my one of the PLSQL interview)

[@SivaAcademy]

@Ram, sure, will post in the same video series, please stay tuned.

[@oyevamsikrishnareddy2446]

In the bulk collect example, you declared lv_postal_code_rec variable but didn't use and why

[@XtremeAladdin]

Please do a video on bulk collect ,for all and explain plan

[@SivaAcademy]

Sure, Please stay tuned, i will post in the same series

[@shripadkulathe5002]

Please upload a videos on partition .

[@SivaAcademy]

Sure, Please stay tuned.

[@PrayasDhanbadBasicBuilder]

Could you please help one video on additional features added to oracle higher than 11g version

[@devikas1125]

If employee table has 1 million records,will it make any difference in the below 2 queries:1.select * bulk colllect into from employee...2. select * bulk collect into from employee limit 1million;

[@MrSunnychadha]

Instead of loading the data from the rowtype into collection why dont you load the data directly to collection ? Is there any specific reason for that. Because here the processing for oracle enginee is increased by storing in rowtype scalar varialbe and then to collections !

[@rounakmangroliya3797]

Please make more videos on Performance tuning

[@SivaAcademy]

Sure, please stay tuned for more videos

[@bharadwajgand9532]

Can we give tablename % row type while defining nestedtable type It should be of same data type like scalar or it can be composite also?

[@SivaAcademy]

It can be composite also

[@svanaja331]

No words to say

[@SivaAcademy]

Thank you

[@itsmeutkarsh]

Hi Shiva, Your Video is Super informative as always. Kindly clarify a point, not related to Bulk Binding, but Binding Variable in general- Are all variables declared in a procedure treated as 'Bind Variable' ? If no, can you specify where all in a procedure should we explicitly define a variable as a bind variable. Thanks

[@balramreddy1651]

As far as i know Bind variables should be declared at session level....Please do double check on this.....sorry if i am wrong....

[@manjanathnaik8670]

Nice explanation but I could see only 2 videos on performance tuning... can you please point me if any other videos

[@SivaAcademy]

i am working other videos, please stay tuned

[@venkatamaddina196]

Super

[@SivaAcademy]

Welcome bro

[@AliBaba-mx8of]

Sir,please make video on hints

[@SivaAcademy]

sure, please stay tuned

[@sumetasingh8233]

Nice video, when is the next part coming ?

[@SivaAcademy]

@sumeta, mostly by next month, i will try to post the next part of performance tuning video, please stay tuned.

[@saiswaroop3570]

how to display and access records by storing in collections type

[@tejupansare4947]

Difference between bulk collect and bulk binding

[@SivaAcademy]

Sure, Please stay tuned, will be posting soon

[@patinoricardo]

por favor podrias habilitar subtitulos para este capitulo, el video 2,3,4 y 5 no lo tienen. gracias.

[@SivaAcademy]

Gracias por tus comentarios, incluiré subtítulos para los próximos videos.

[@devikas1125]

In addition to context switching reduction, undo,redo log file entry also can be reduced by bulk binding. Is that right sir?

[@MrPrakasamm]

Hi Sir... One interviewer asked to write a code for to get all details from one table using bulk collect and insert into another table which will be insert 20,20 records... please do video for this...

[@SivaAcademy]

Sure please stay tuned, I will post soon

[@govindugovindu617]

U can use limit clause in bulk collection you will get 20,20 records

[@mythilis688]

Can you please upload video for function and bulk collect

[@SivaAcademy]

@mythili, sure.. Please stay tuned

[@nivaskotha107]

When will you do part2 sir

[@SivaAcademy]

Will try to soon bro, please stay tuned

[@venkatv2973]

When will you do part2

[@SivaAcademy]

Will try to get post by next Month, please stay tuned

[@deviparameshwarimuthuraj4559]

Hi Sir, in PLSQL collections videos all of with particular column to select and load the data to collection, so thought collection will store more rows with same datatype. But in this video we are storing different datatypes. Can you please explain?

[@SivaAcademy]

Collection of rowtype variable can store multiple rows of same rowtype value, is it clear??

[@sivac5102]

Can upload function and stored procedure

[@munibhadranaidu3057]

sir is there any more videos for pl/sql performance tuning

[@SivaAcademy]

Posted only two videos till now, please stay tuned for more videos

[@munibhadranaidu3057]

@@SivaAcademy ok thank you sir

[@PSA134]

Could you please make a video on object type

[@SivaAcademy]

Sure please stay tuned