TFA – Trace File Analyzer Oracle 19c Database Performance Analyze in Single Command Explained!

Channel Avatar
Comment
X
Share
TFA - Trace File Analyzer Oracle 19c Database Performance Analyze in Single Command Explained!
TFA – Trace File Analyzer Oracle 19c Database Performance Analyze in Single Command Explained!
#OracleF1 #TFA #Database_Analyze

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

Thanks
Ramesh

Follow Me On:

YouTube: https://www.youtube.com/oraclef1
DBA Blog: https://www.oralgwr.com
LinkedIn: https://www.linkedin.com/in/ramesh-kumar-krishnamoorthy-3a67ba69
Twitter: https://twitter.com/sachinrameshdba
Facebook: https://www.facebook.com/rameshkumar.krishnamoorthy.9
Facebook Page: https://www.facebook.com/oraclef1
Instagram: https://www.instagram.com/oraclef1_1

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *