AWR Report - Oracle
Vložit
- čas přidán 5. 09. 2024
- Enroll to the Oracle DBA real time interview Question
====================================================
learnomate.org...
WhatsApp me for Training - wa.link/gi7fv2
Starting new Oracle DBA batch in next week.
Please connect with me if you are interested.
Batch will start from next week
Time - 9am ist (11:30 PM EST)
Duration - 45 days
Daily one hour
Contact - +91 9960262955
Email - ankush.thavali@gmail.com
Fees - 15k (300$)
Two installments can be available
Syllabus -
www.learnomate...
Review -
www.learnomate...
CZcams Channel
• Starting NEW REAL TIME...
Registration
https:www.learnomate.org/register
WhatsApp me
wa.link/usfz52
Facebook Page
/ learnomate
LinkedIn
/ ankushthavali Oracle have provided many performance gathering and reporting tools over the years. Originally the UTLBSTAT/UTLESTAT scripts were used to monitor performance metrics. Oracle 8i introduced the Statspack functionality which Oracle 9i extended. In Oracle 10g statspack has evolved into the Automatic Workload Repository (AWR).
#awr
#oracle
#ankushthavali
Please post videos on detailed analysis of reports
Clear explanation for freshers. Thanks
Can you please explain how to analyse the issue what data we should check on priority.
Excellent!!!!!!!! thx for help me! 👍
Amazing performance
We need detail analysis of awr report not generation that we can find anywhere
Ok Madam 😊
Explain about wait events please sir.
well said.... 👍
Please post performance tuning videos
Nice video sir.
Pls post detail analysis.
Please interpret the AWR report
Tkproof tool used for? Reading awr reports is it right?
Why would you grep to list a file? Otherwise it’s a nice video.
Hello NKUSH THAVALI,
in case of my database not open achivelog mode
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /Bkup/RMAN_BKP/ARCH_APP
Oldest online log sequence 14242
Current log sequence 14245
SQL>
so. can I generate AWR report?
There is nothing to do with archives. Please check my video once
how to solve it?
Using the report name awrrpt_1_51_55.html
SP2-0606: Cannot create SPOOL file "awrrpt_1_51_55.html"
select output from table(dbms_workload_repository.awr_report_html( :dbid,
*
ERROR at line 1:
ORA-00904: : invalid identifier
not spooling currently
Report written to awrrpt_1_51_55.html
post performance tuning videos
How to do session monitoring.
where we can find inactive sessions/blocking sessions/ long running jobs in the generated awr report?
Boss apne awr report generation to sikha dia but usko pdna nhi shikaya
It can possible in 10g
This video do not justify the topic or caption for the video
Sir do u know Telugu language