Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

[raj_dreamers]

Thank you so much Siva, for your valuable time and knowledge. Keep up this good work, I'm learning a lot from your tutorials

[ravindherjangaigar]

Hi Siva Garu
Thank you very much for all your video's which are very informative and easy to understand ..
I am learning alot with you video

[bharathibalakrishnan]

Nice video. Learning lot in short time just watching your videos. Thank you

[sangamithiranmass]

Siva...really appreciated such a high quality explanations...The rare topics available now with best examples 💥👌🎊

[prashantmate]

It is being observed that after DB upgrade there are guaranteed performance issues occur. @siva bro, could you please tell what actually causes the performance issues in terms of parameter change or something else.

[AaryaAyaan]

What happens to rowid of a record moved(updated) from one partition to another ?

[biswabibekjena]

hi Siva, could you explain the statement " analyze <tablename>" ?what does it signify ?

[ketankbc]

hi Siva.. one of procedure is taking less time on DEV but taking long time on prod. data size is same on both the instances, but execution speed is less. now new prod clone is also having low execution speed. What could be the reason? indexes are same.

[shobharani]

Siva,

Really it is good video.One point I would like to add, if table holds any locks, then also there will be chance of taking too much time.

[antonyjayaraj]

This is required for me. Thank you for the tutorial

[abinashdas]

Sir, really appreciating your work to explain the topic in such a lucid way .Request you to make a video on explain plan and performance tunning???

[ernestbal]

Hi Siva Academy, may I know what is Ordinate Index in oracle and what are different types of index. Thanks.

[prathapreddy]

Thank you so much for upload, good information

[munakumar]

Can you make one video like one table column we are joining multiple time with other table multiple columns it degrades the more performance in this case how to improve the performance tunning

[shaikrasheed]

Sir please let me know What is impact Analysis in pl sql

[swethaveluguri]

I have been asked this question in many interviews, can you explain with the real time scenario for this question to arise?

[nagaa]

Hi Siva,
My query slow due to sequential read instead of multiblock read.
I am not sure why it is taking sequential read suddenly.

[someswarak]

Superb it's a big help to everyone 😊😊

[abhi]

Use enable row movement and use shrink clause

[SriLife]

How can i know which SQL statement is taking long time in a session.