AWR Report Analysis - How to read AWR Report - Oracle Performance Tuning

[@Sushil2874]

Thank you so much..!!
Need this much detailed analysis on explain plan of queries as well.!

[@OracleDBAOnlineTraining]

Glad you liked it, sue explain plan is on the list

[@amandeepgera4109]

ur doing amazing work...keep it up....High expectations from you now

[@OracleDBAOnlineTraining]

Thank you.

[@bharathkumar-ds8cd]

excellent presentation.

[@OracleDBAOnlineTraining]

Thank you glade you like it. Keep watching 😍😍

[@VibhuKiBaatein]

Examples are very good... thanks for covering most of the AWR report sections 🙏

[@VibhuKiBaatein]

looking forward for explain plan video... Hope you will post it soon

[@OracleDBAOnlineTraining]

Thank you for your feedback... keep watching keep learning have a great day

[@OracleDBAOnlineTraining]

Yes I will share it very soon

[@ziadfawzi]

Very useful.
Thank you

[@TejaG0904]

Super bro

[@OracleDBAOnlineTraining]

Thank you for watching keep learning

[@shbhmgpt48]

Awesome Explanation , Sir can you please share the doc for the PPT?

[@MuhammadBilal-fx7ii]

Wonderful dear, I really learned lots of things. could I ask about word file where written awr retention quries

[@OracleDBAOnlineTraining]

Hi Please refer below command
##################################
column awr_snapshot_retention_period format a40
SELECT EXTRACT(day from retention) || ':' ||
EXTRACT(hour from retention) || ':' ||
EXTRACT (minute from retention) awr_snapshot_retention_period,
EXTRACT (day from snap_interval) *24*60+
EXTRACT (hour from snap_interval) *60+
EXTRACT (minute from snap_interval) awr_snapshot_interval
FROM dba_hist_wr_control;
exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS(retention=>43200, interval=>30);
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot;
select snap_id,BEGIN_INTERVAL_TIME,END_INTERVAL_TIME from dba_hist_snapshot where BEGIN_INTERVAL_TIME > systimestamp -1 order by BEGIN_INTERVAL_TIME desc;
#############################
I hope this is helpful

[@bharathkumar-ds8cd]

good session bro. Do you have any blog site which has some useful queries and commands?

[@OracleDBAOnlineTraining]

Thank you for your feedback... Very soon i will share my blog

[@dotagamer5925]

Very nice explanation Sir ...❤️❤️👍🏻👍🏻
Sir i have a small question....
Yesterday the database is running with AWR Retention of 8 days ..... Today i changed the AWR Retention to 90 days ....... So now will i be able to extract the AWR Report for the (sysdate-85) day ??? (I suppose not thinking that currently i dont have very old snap because today only i changed the AWR Retention to 90 days .. once the Snaps are generated from today... Only these snaps will be retained for 90 days ) i gave this answer.. i may be wrong .. please guide Sir ...
Interviewer asked almost the same question

[@OracleDBAOnlineTraining]

Good question. If you have modified retention period Today so once you will reach 90 days then you can extract old awr snapshot.

[@dotagamer5925]

@@OracleDBAOnlineTraining thanks Sir 😃

[@ganeshg4038]

can you please do a video on tuning of SGA/PGA components?

[@OracleDBAOnlineTraining]

Thank you for your request..i will make video

[@susannapaparella6042]

is it possible to have the slides?

[@OracleDBAOnlineTraining]

Yes.. you can take all the documents from our website

[@susannapaparella6042]

can you give me the exact path from which to download the slides? thank you

[@ramyasubramanian6207]

Sir I ll pay u,can u pls share this doc sir..pls sir..such a nice video

[@OracleDBAOnlineTraining]

Please reach me on my contact number for getting documents

[@ramyasubramanian6207]

I don't have ur number..pls share

[@jawadahmed6530]

Man great video but please don't drag one step for too long. It breaks the momentum of learning.

[@OracleDBAOnlineTraining]

Thanks for the tip

[@susannapaparella6042]

where is the exact path?

[@OracleDBAOnlineTraining]

www.oracledbaonlinetraining.com/oracle-dba-online-courses