In this video, explained in details all about Oracle 19c database performance issues, how to analyze in a single command through TFA – Trace File Analyzer.
./tfactl diagcollect -srdc dbperf
WARNING – TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
Enter the Database Name Required for this SRDC : srlab
Do you have a performance issue now YyNn]Y: Y
As you have indicated that the performance issue is currently happening,
will be collecting snapshots for the following periods:
Start time when the performance was bad: Feb/13/2021 07:24:50
Stop time when the performance was bad: Feb/13/2021 08:24:50
For comparison, it is useful to gather data from another period with similar load where problems are not seen. Typically this is likely to be the same time period on a previous day. To compare to the same time period on a previous day enter the number of days ago you wish to use. RETURN to provide other time range : 1
Start time when the performance was good Feb/12/2021 07:24:50
Stop time when the performance was good Feb/12/2021 08:24:50
If any particular SQL causes the Database to be slow enter the SQL_ID ?Refer to Doc 1627387.1 for more information on how to determine SQL_ID RETURNNO_SQL_ID :
Found 1 snapshot for Bad Performance time range in srlab
Found 0 snapshot for baseline range in srlab
Error: No snapshots exist for baseline time range in database srlab, Please select a time AWR snapshots exist for the baseline Good Performance time range.
/”Automatic Workload Repository AWR is a licensed feature.Refer to My Oracle Support Document ID 1490798.1 for more information/”
Scripts to be run by this srdc: orachk_dbperf ipspack dbslow srdc_db_lfsdiag.sql
Components included in this srdc: OS CRS DATABASE CHMOS
Collecting data for all nodes
Collection Id : 20210213083052srlabrac1
Follow Me On:
DBA Blog: https://www.oralgwr.com
Facebook Page: https://www.facebook.com/oraclef1
Take the opportunity to connect and share this video with your friends and family if you find it useful.