AWR Report Analysis - How to read AWR Report - Oracle Performance Tuning
Вставка
- Опубліковано 22 лип 2024
- Learn how to read AWR report - Oracle Performance Tuning Tutorials
AWR Report Analysis. Learn How to read AWR report to troubleshoot oracle database performance issues. AWR Report Analysis in detail.
Oracle Database Performance Tuning Tutorial.
In this tutorial, we have covered how to generate an AWR report and how to modify the AWR retention period and AWR intervals. And Later we will look at in-depth understanding and learning of various AWR report sections.
Real-time AWR report analysis
how to analyze awr report
how to change awr snapshot interval in Oracle
how to change awr report interval
how to change awr report retention period
############ Watch out for Previous Tutorials Related to Performance Tuning ##################################
1. Oracle database wait events - Oracle Database Performance Tuning tutorial:
• Oracle database wait e...
2. Oracle Database Architecture - Oracle 19c database tutorial:
• Oracle Database Archit...
##################################################
######################################################
Make your PC faster by adding this below highlighted component for faster performance
1. Corsair Vengeance LPX 16GB (1x16GB) DDR4 3200MHZ UDIMM C16 Desktop RAM Memory Module(Buy 2 RAM of 16GB):
amzn.to/3vfMBY0
2.Seagate Barracuda Q5 1 TB Internal SSD - M.2 NVMe PCIe Gen3 ×4, 3D QLC for Desktop or Laptop, 1-Year Rescue Services (ZP1000CV3A001)
amzn.to/2TiDyHX
3.AMD Ryzen 5 3600 Desktop Processor 6 Cores up to 4.2 GHz 35MB Cache AM4 Socket (100-000000031)
amzn.to/2TeCxR3
4.Gigabyte B450M DS3H (AMD Ryzen AM4/M.2/HMDI/DVI/USB 3.1/DDR4/Micro ATX/Motherboard)
amzn.to/2Sp59q5
5.Ant Esports ICE-300TG Mid Tower Gaming Cabinet Computer case Supports ATX, Micro-ATX, Mini-ITX Motherboard with Transparent Tempered Glass Side Panel, 4 x 120 mm Fan (3 Rainbow Front/ 1 Black Rear)
amzn.to/2RKJ6u5
6.LG 22 inch (55cm) IPS Monitor - Full HD, IPS Panel with VGA, HDMI, DVI, Audio Out Ports - 22MP68VQ
amzn.to/3vfOnZa
Mic Used for Recording this video:
Boya BYM1 Omnidirectional Lavalier Condenser Microphone with 20ft Audio Cable (Black)
amzn.to/3bSiM8a
###########################################################
oracledatabase #OracleDBAOnlineTraining #oracle19c #oracle12c
######################ABOUT OUR CHANNEL:##########
Our channel is about Oracle DBA Online Training. We cover lots of cool stuff such as Oracle Database architecture, installation, database up-gradation, administration, Data Guard, RAC database architecture, golden gate, and many more.
Check out our channel here:
/ @oracledbaonlinetraining
Don’t forget to subscribe!
##########CHECK OUT OUR OTHER VIDEOS############
1) How to Create Physical Standby Database manually: • create physical standb...
2) Oracle Data Guard Switchover Manual Steps Using SQLPLUS
• Oracle Data Guard Swit...
3)Oracle 19c Active Data Guard DML Redirection
• Oracle 19c Active Data...
4)Oracle 19c Database - Active Data Guard (ADG)
• Oracle 19c Active Data...
5) Oracle Enterprise Manager Cloud Control 13c Installation Guide:
• Oracle Enterprise Mana...
6) Oracle 19c RAC installation on Linux step by step complete guide
• Oracle 19c RAC install...
7) create a physical standby database step by step oracle 19c
• create physical standb...
8) Apply latest patches on Oracle 19c RAC database
• Applying Latest patch ...
9) Oracle 19c RAC database software Installation & database creation using DBCA on Linux step by step:
• Oracle 19c RAC databas...
10) Oracle Linux Installation on VirtualBox || How to install Linux on VirtualBox
• Oracle Linux Installat...
11.Oracle 12c to 19c database upgrade using DBUA tool
• Oracle 12c to 19c data...
12.Oracle 12c to 19c manual upgrade steps - Oracle Database Upgrade:
• Oracle 12c to 19c manu...
13.Oracle 12c to 19c upgrade using AutoUpgrade Method
• Oracle 12c to 19c upgr...
----------------
🌐 Find Us At: Oracle DBA Online Training: www.oracledbaonlinetraining.com/
📧 Get in Touch: Email: support@oracledbaonlinetraining.com
🌐 Connect with Us:
- WhatsApp: WhatsApp Now wa.me/918169158909
- Facebook: Follow Us / oracledbaonline
- Telegram: Join Our Channel t.me/joinchat/nWHoPJ9C27BjMmI1
- LinkedIn: Connect / oracle-dba-online-trai...
- Twitter: Follow @online_dba / oradbaonline
- Blogger: Read Our Blog oracledbatrainingexperts.blog...
💰 Support Us on PayPal: Donate Now: www.paypal.me/oracledbatraining
Thank you for being part of our community! Your support drives us to create valuable content for Oracle DBAs and enthusiasts.
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.
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
excellent presentation.
Thank you glade you like it. Keep watching 😍😍
Super bro
Thank you for watching keep learning
Awesome Explanation , Sir can you please share the doc for the PPT?
can you give me the exact path from which to download the slides? thank you
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
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
can you please do a video on tuning of SGA/PGA components?
Thank you for your request..i will make video
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 😃
is it possible to have the slides?
Yes.. you can take all the documents from our website
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