Thanks Arun, appreciate your effort to explain AWR Report, It was very helpful for me for job responsibility, but at the same time expectation is more, pls create more session on AWR and most optimize oracle database configuration.
I was thinking that generating and understanding the AWR report is very difficult and complex. But, this video made me very clear in one shot. I have a request for you. Kindly upload videos for performance tuning. I got stuck in every interview when they ask about the performance tuning. Can you please guide step step from where to start the tuning of an existing code or sql. The various techniques that can be applied to solve a problem. Thank you in advance.
Hi Arun: I have a Question! Like I got a perf issue where a migration script command was run in Dev env and it ran for almost 1 hrs and completed successfully. Now the same command was run on Staging (with the same infra configuration and indexes), it got stuck and took more than 10+ hrs and isn't getting completed. Checking Locks, ASH, and AWR didn't find a solution. What could be the possibilities for this issue?
when talking about increasing instance(as you check whether or not the instance needs to be tunned)....what specific parameter are you referring to? Thank you.
Instance is nothing but sga +bg process so there should be sga size to increase or decrese depentents on the statistics of awr analysis he mean to say i guess
Hey can you explain a bit about DB CPU wait event and what to do to fix it. It is coming at the top of the Top 10 Foreground Events by Total Wait Time with 46.6K Total Wait Time (sec)
My tomcat server is slow since few days now. I have the awr report.. i am just a beginner can you please help me. Which part of report i should take a look at in order to find root cause of slowness
Hi, very clean explanation. I have a question, if in Top 10 Foreground Events by Total Wait Time, my first event is DB CPU with %DB TIME 69.2 and total wait time (sec) is 55.3k, should I consider a problem? In the second event is latch free with %DB Time 7.7 and total wait time (sec) is 6187.6. What should I do with latch free, please?
Are you comparing my WINDOWS machine time with AWR time? The AWR report will be generated as per the Linux server time. Probably Linux machine time might be different, in my case.
In the video, at times 56:00 and 1:05:00, your interpretation of %CPU is incorrect and misguiding. You are meaning, %CPU of 95 is a problem, which is not correct. Ideally a good query should have %CPU as 100. Queries running without any waits will have %CPU as 100 which is perfect from the database instance configuration. Usually queries blocked due to "row lock contention" will have the %CPU as almost zero which is a problem.
You should have had a real report, atleast from Perf env, and explained it, instead of showing a dataless report. I am grateful for the series but hearing that guy asking you for more info and you shutting him down makes me wonder, you could have explained it simply in the time you spent convincing him.
Wow..What a wonderful way AWR report explained here.. Excellent..!!!
Very well explained. Ur way of explaining things are really appreciable.
Thanks a lot 😊
thank you very much. The examples and explanations were awesome. expecting more video and webinar
We are all geared for same!
Thanks Arun, appreciate your effort to explain AWR Report, It was very helpful for me for job responsibility, but at the same time expectation is more, pls create more session on AWR and most optimize oracle database configuration.
Noted
This guy is very good in this analysis! Thank You!
I appreciate that!
Excellent Explanation ,Crystal clear.
Glad it was helpful!
Awesome ❤️❤️❤️❤️. You have lots of patience.. 🙏🙏🙏. Thank you for your time. 🙏
Thank you! Cheers!
I am totally impressed by this explanation. Thank you guys
Our pleasure!
Nice explanation 👌 I have one doubt let consider if in my db lot of schams are thare how can I find who running that huge query?
Toad is there for you my friend.
Your videos give confidence.
Thank you, Keep Watching!
Thank you So much...very clean explanation on how to analyse AWR reports..
Thank you keep watching!
Excellent, Excellent and Excellent, please keep continue sir
Thank you we will!
Very good insightful
Its very useful to understand AWR Report.
Thank you so much!
Excellent explanation, you are awesome. Keep it up
Thanks a lot!
Excellent Explanation with patience...
Glad you liked it
crystal clear explanation
Thank you Keep watching
Great people's are born in the woombs the great ones
Glad to hear that!
Awesome, very helpful. Thank you😊
Thank you, Keep watching!
Thank you so much for all....
Thank you!
Thank you Very much for sharing knowledge. It’s very helpful .
My pleasure
Great 👍 , good explanation
Glad it was helpful!
Thank you... Good information which will surely help
Glad to hear!
Excellent. I became your fan with this video.
Many many thanks
I was thinking that generating and understanding the AWR report is very difficult and complex. But, this video made me very clear in one shot.
I have a request for you. Kindly upload videos for performance tuning. I got stuck in every interview when they ask about the performance tuning. Can you please guide step step from where to start the tuning of an existing code or sql. The various techniques that can be applied to solve a problem.
Thank you in advance.
Very helpful, thanks
Thank you, Keep watching!
Very informative..!!
Glad it was helpful!
Thanks for the informative video
Glad it was helpful!
Great, Arun, awesome,
Keep watching
I have one question. If DB chache size is 2gb and i want to update 10gb data in DB , will the job be successsfull ???
You must have space in tablespace to accommodate new data you loading.
Very nicely explained..👏
Thank you !
Hi Arun: I have a Question!
Like I got a perf issue where a migration script command was run in Dev env and it ran for almost 1 hrs and completed successfully. Now the same command was run on Staging (with the same infra configuration and indexes), it got stuck and took more than 10+ hrs and isn't getting completed. Checking Locks, ASH, and AWR didn't find a solution. What could be the possibilities for this issue?
when talking about increasing instance(as you check whether or not the instance needs to be tunned)....what specific parameter are you referring to? Thank you.
The instance specific %'s define if instance needs to be tuned.
Instance is nothing but sga +bg process so there should be sga size to increase or decrese depentents on the statistics of awr analysis he mean to say i guess
Hey can you explain a bit about DB CPU wait event and what to do to fix it. It is coming at the top of the Top 10 Foreground Events by Total Wait Time with 46.6K Total Wait Time (sec)
Facing same issue any solution
Soo good analysis 👍
Thanks!
My tomcat server is slow since few days now. I have the awr report.. i am just a beginner can you please help me. Which part of report i should take a look at in order to find root cause of slowness
awesome explanation..Thank you
please make video about statspack for oracle SE.
Noted
Hi, very clean explanation.
I have a question, if in Top 10 Foreground Events by Total Wait Time, my first event is DB CPU with %DB TIME 69.2 and total wait time (sec) is 55.3k, should I consider a problem?
In the second event is latch free with %DB Time 7.7 and total wait time (sec) is 6187.6. What should I do with latch free, please?
Why is AWR Report time late than system time? how many hours it will be late than system time?
Are you comparing my WINDOWS machine time with AWR time? The AWR report will be generated as per the Linux server time. Probably Linux machine time might be different, in my case.
@@dbagenesis
how to generate AWR report with 30 min interval?
Really good! Informative
Glad it was helpful!
Thank you.
You're welcome!
Great. Very useful. Thank you!
Glad it was helpful!
DBA Genesis, best ever! Thanks:)
Glad you like it!
In the video, at times 56:00 and 1:05:00, your interpretation of %CPU is incorrect and misguiding. You are meaning, %CPU of 95 is a problem, which is not correct.
Ideally a good query should have %CPU as 100.
Queries running without any waits will have %CPU as 100 which is perfect from the database instance configuration.
Usually queries blocked due to "row lock contention" will have the %CPU as almost zero which is a problem.
Thanks so much awesome explanation
Which version of linux it is and can we also generate in ms dos command prompt? Please answer .
its a great explanation
Thank you!
beautiful.. thanks a ton
Most welcome 😊
Thank you 🙏 it really helped
Most welcome!
thanks a million, sir.
Thank you so much!
thank you very much
Thank you!
Like the Video.
Thanks!
Thanks! It is helpful.
Glad to hear!Keep watching.
You should have had a real report, atleast from Perf env, and explained it, instead of showing a dataless report. I am grateful for the series but hearing that guy asking you for more info and you shutting him down makes me wonder, you could have explained it simply in the time you spent convincing him.