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

00:00

Video quality	The size	Download

Информация о Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

Название	:	Oracle PL SQL interview question Query was running fine yesterday but its very slow today \| Tuning
Продолжительность	:	5.32
Дата публикации	:
Просмотров	:	93 rb

Кадры Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

Описание Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

Коментарии Oracle PL SQL interview question Query was running fine yesterday but its very slow today | Tuning

Use enable row movement and use shrink clause
Comment from : Abhishek Sant

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

plan may be changed check
Comment from : Ramkumar Lastname

I have an application which is run slowly at a perticular time like 12pm to 1pm daily but after that one hour everything will work fine what is the reason how will you analyze ? could you pls answer this sir
Comment from : pally raju

Can you make a video of learning explain plan of a sql query?
Comment from : Sreerupa Das

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
Comment from : MUNA KUMAR

Good points to start of the discussion
Comment from : monuvishwe

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
Comment from : Ketan Chavan

This is required for me Thank you for the tutorial
Comment from : antony jayaraj

Thanks Siva :)
Comment from : GS Raj

hi Siva, could you explain the statement " analyze " ?what does it signify ?
Comment from : Biswabibek Jena

Sivareally appreciated such a high quality explanationsThe rare topics available now with best examples 💥👌🎊
Comment from : sangamithiran mass

I am practicing about sql and plsql since last one year and face 8 interview i got positive response in 4 interviews but didnt get any job because everyone said to me you have learn a langugage also with oracle in these days oracle is nothing and in oracle interviews everyone require experienced person and someone want oracle app knowledge or form and reporrs d2k etc as like this ek fresher ki hope tutne lg jati h or uske lie aage survive krna muskil ho jata h ya phr usko kisi dusre technology m jana pdta h jisme uska mn he na ho
Comment from : Vishal Saxena

It looks like uninformed guessing :)
Comment from : Yuri Pedan

Really your videos are very usefull
Comment from : Manicka Praveen

Hi Please post videos about Oracle optimiser joins and scans for sample query and please explain the execution plan for sample complex query
Comment from : Manicka Praveen

but teching skills wounderfully bro
Comment from : V V N CREATION

Hi Siva GarubrThank you very much for all your video's which are very informative and easy to understand brI am learning alot with you video
Comment from : ravindher jangaigar