Thanks, It would be very helpful if you could show and do the things practically on a server instead of orally......so that we can be understood easily....
Du -sk * | sort-n ( unix Comnad) Press command in any directory you will get highest occupied process. He is explaining very low level. L1 level can understand quickly
Thanks sir, Can you suggest me how can i get data within a second when selecting a particular column and not created index for it .Normally table takes 4 min to get data . Table contained 14 lakhs of data . query: SELECT DISTINCT COLUMN1 FROM TABLE1 WHERE COLUMN1 IS NOT NULL; how can i resolve this problem without index because column selections are dynamic hance we can't add index for each column.
Bhai 1 Query ki Performance aaj bhut slow hai and last week aachi thi uska kya solu hai ? Uski Performance Increase k liye kya kregeee ? kya hum old paln value ka use kr skte hai
check statistics of tables used in the query, if stats are stale then gather the same.. check execution plan of the query, if possible fix best execution plan. execute tuning advisor for that particular query. check what types of wait events occurs while execution.. work on that waits
How to check standard io for database and how can we identify io based slow SQL Sometimes query previous day works fine but suddenly working slow please guide me
Hi ankush, Well and lucid explained for performs tuning. it's really valuable. I need to suggest one technique we also resize redo group to enhance database performance..
Thanks,very helpful video
Thanks ankush.
Excellent!
Can you elaborate more real time examples with details.
your session was helpful make more videos please on tuning.
Thank you
Your Oracle Dba Videos are so much helpful .....Thank you Ankush
Thanks 😊
@@learnomate If you Have any videos about RAC ASM Dataguard Patching Links Please
Thanks, It would be very helpful if you could show and do the things practically on a server instead of orally......so that we can be understood easily....
Please make a video on oracle database configuration assistance and how its works to create new DB..
Sure 👍
Make it more videos on performance tuning bro its useful to every dba... need with practical.... Thank you😊
👍💯
Thanks for shareing your knowledge
Thanks
Good Explanation...
Thanks Buddy!!!
Please can you make a video for SQL tuning in Hindi please
Can you please make a practical video on it ?
Hi Ankush , are you providing any training on Oracle database performance tuning ?
Du -sk * | sort-n ( unix Comnad)
Press command in any directory you will get highest occupied process.
He is explaining very low level.
L1 level can understand quickly
Nicely explained
Sir any coaching for this please let me know
Training available for Oracle DBA. Reach out to us on +91 7822917585
Which book is best for oracle dba sir please🙏
awesome sir ...please provide more videos practically
Very Valued Information , Thank you.
Mujhe AWR report ko best way mein samajhne ke liye kya karna hoga plz suggest
Helpful much thanks
Thanks sir,
Can you suggest me how can i get data within a second when selecting a particular column and not created index for it .Normally table takes 4 min to get data . Table contained 14 lakhs of data .
query: SELECT DISTINCT COLUMN1 FROM TABLE1 WHERE COLUMN1 IS NOT NULL;
how can i resolve this problem without index because column selections are dynamic hance we can't add index for each column.
Can u please tell me the steps to troubleshoot my query is running fast yesterday and today my query is running slow
❤❤
I need oracle performances tuning training, how can i reach you
Very goods.
Explain on query execuation cost in details for optimization.
Hardware issue related to IO, ram etc
Bhai 1 Query ki Performance aaj bhut slow hai and last week aachi thi uska kya solu hai ?
Uski Performance Increase k liye kya kregeee ?
kya hum old paln value ka use kr skte hai
check statistics of tables used in the query, if stats are stale then gather the same..
check execution plan of the query, if possible fix best execution plan.
execute tuning advisor for that particular query.
check what types of wait events occurs while execution.. work on that waits
Sir,how mysql dba can enhance career growth, what is new technology I have learn.
wow sir
Thank you 🙏💕
Nice video
Good content
What is wait event and what is importance of wait event in Oracle DBA.
I will create video on this.
Sir please give 4 to 5 example and solve on system
How to check standard io for database and how can we identify io based slow SQL
Sometimes query previous day works fine but suddenly working slow please guide me
There is top command to check io
Provide solution for performance for SQL 2008 db.
Can you please uploaded your any videos in English.
Sure 👍
Sir plzz give information about banking project flow for pl/sql developer
Very good video I ever saw on performance tuning..👍
Thank you
English version?
Could you please make this video in English
Sure Mercy!!!
@@learnomate We are waiting for that sir please
Hi ankush,
Well and lucid explained for performs tuning. it's really valuable.
I need to suggest one technique we also resize redo group to enhance database performance..
Bakwas
Thank you nice explain.
Thanks for sharing your knowledge