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
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
Thank you so much..!!
Need this much detailed analysis on explain plan of queries as well.!
Glad you liked it, sue explain plan is on the list
ur doing amazing work...keep it up....High expectations from you now
Thank you.
excellent presentation.
Thank you glade you like it. Keep watching 😍😍
Examples are very good... thanks for covering most of the AWR report sections 🙏
looking forward for explain plan video... Hope you will post it soon
Thank you for your feedback... keep watching keep learning have a great day
Yes I will share it very soon
Very useful.
Thank you
Super bro
Thank you for watching keep learning
Awesome Explanation , Sir can you please share the doc for the PPT?
Wonderful dear, I really learned lots of things. could I ask about word file where written awr retention quries
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
good session bro. Do you have any blog site which has some useful queries and commands?
Thank you for your feedback... Very soon i will share my blog
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
Good question. If you have modified retention period Today so once you will reach 90 days then you can extract old awr snapshot.
@@OracleDBAOnlineTraining thanks Sir 😃
can you please do a video on tuning of SGA/PGA components?
Thank you for your request..i will make video
is it possible to have the slides?
Yes.. you can take all the documents from our website
can you give me the exact path from which to download the slides? thank you
Sir I ll pay u,can u pls share this doc sir..pls sir..such a nice video
Please reach me on my contact number for getting documents
I don't have ur number..pls share
Man great video but please don't drag one step for too long. It breaks the momentum of learning.
Thanks for the tip
where is the exact path?
www.oracledbaonlinetraining.com/oracle-dba-online-courses