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..
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,very helpful video
Make it more videos on performance tuning bro its useful to every dba... need with practical.... Thank you😊
👍💯
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....
Can you elaborate more real time examples with details.
your session was helpful make more videos please on tuning.
Thank you
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
Please make a video on oracle database configuration assistance and how its works to create new DB..
Sure 👍
Very Valued Information , Thank you.
Excellent!
Very goods.
Explain on query execuation cost in details for optimization.
Hardware issue related to IO, ram etc
Please can you make a video for SQL tuning in Hindi please
Thanks ankush.
Thanks for shareing your knowledge
Thanks
awesome sir ...please provide more videos practically
Good Explanation...
Thanks Buddy!!!
Hi Ankush , are you providing any training on Oracle database performance tuning ?
Mujhe AWR report ko best way mein samajhne ke liye kya karna hoga plz suggest
Can you please make a practical video on it ?
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.
Helpful much thanks
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
Which book is best for oracle dba sir please🙏
Nicely explained
What is wait event and what is importance of wait event in Oracle DBA.
I will create video on this.
Sir,how mysql dba can enhance career growth, what is new technology I have learn.
Can u please tell me the steps to troubleshoot my query is running fast yesterday and today my query is running slow
Sir any coaching for this please let me know
Training available for Oracle DBA. Reach out to us on +91 7822917585
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
Very good video I ever saw on performance tuning..👍
Thank you
I need oracle performances tuning training, how can i reach you
Sir please give 4 to 5 example and solve on system
Nice video
Sir plzz give information about banking project flow for pl/sql developer
Provide solution for performance for SQL 2008 db.
Can you please uploaded your any videos in English.
Sure 👍
Good content
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..
English version?
Could you please make this video in English
Sure Mercy!!!
@@learnomate We are waiting for that sir please
❤❤
wow sir
Thank you 🙏💕
Bakwas
Thank you nice explain.
Thanks for sharing your knowledge