TFA - Trace File Analyzer - Oracle 19c Database Performance Analyze in Single Command - Explained!
Hello All,
login as: oracle
oracle@192.168.58.102's password:
Last login: Sat Feb 13 07:56:31 2021
[oracle@srlabrac2 ~]$ ps -ef |grep pmon
oracle 20196 19556 0 07:56 pts/1 00:00:00 grep --color=auto pmon
oracle 22686 1 0 06:17 ? 00:00:01 asm_pmon_+ASM2
[oracle@srlabrac2 ~]$
[oracle@srlabrac2 ~]$
[oracle@srlabrac2 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM2
The Oracle base has been set to /u01/app/oracle
[oracle@srlabrac2 ~]$
[oracle@srlabrac2 ~]$
[oracle@srlabrac2 ~]$
[oracle@srlabrac2 ~]$ crsctl check cluster -all
**************************************************************
srlabrac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
srlabrac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[oracle@srlabrac2 ~]$ srvctl status database -d srlab
Instance srlab_1 is running on node srlabrac1
Online relocation: INACTIVE
[oracle@srlabrac2 ~]$ srvctl config database -d srlab
Database unique name: srlab
Database name: srlab
Oracle home: /u01/app/oracle/product/19.0.0/db_1
Oracle user: oracle
Spfile: +DATA/SRLAB/PARAMETERFILE/spfile.277.1058789021
Password file: +DATA/SRLAB/PASSWORD/pwdsrlab.256.1058774767
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services: srlabsvc
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: srlab
Candidate servers: srlabrac1,srlabrac2
OSDBA group: asmdba
OSOPER group: asmoper
Database instances: srlab_1
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@srlabrac2 ~]$ cd $TFA_HOME
[oracle@srlabrac2 bin]$ pwd
/u01/app/19.0.0.0/grid/tfa/bin
[oracle@srlabrac2 bin]$
[oracle@srlabrac2 bin]$ ./tfactl version
TFA Version : 183300
TFA Build ID : 20190315044534
[oracle@srlabrac2 bin]$ ./tfactl status
WARNING - TFA Software is older than 180 days. Please consider upgrading TFA to the latest version.
.------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+-----------+---------------+------+------+------------+----------------------+------------------+
| srlabrac2 | RUNNING | 2575 | 5000 | 18.3.3.0.0 | 18330020190315044534 | COMPLETE |
| srlabrac1 | RUNNING | 2505 | 5000 | 18.3.3.0.0 | 18330020190315044534 | COMPLETE |
'-----------+---------------+------+------+------------+----------------------+------------------'
[oracle@srlabrac2 bin]$
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRLABPLUG READ WRITE NO
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlabrac1 bin]$
[oracle@srlabrac1 bin]$
[oracle@srlabrac1 bin]$
-rwxr-xr-x. 1 root root 2552 Dec 5 15:45 tfactl
[oracle@srlabrac1 bin]$
[oracle@srlabrac1 bin]$
[oracle@srlabrac1 bin]$
[oracle@srlabrac1 bin]$ ./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 [Y|y|N|n] [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) [<RETURN>=NO_SQL_ID] :
Found 1 snapshot(s) for Bad Performance time range in srlab
Found 0 snapshot(s) 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
Detailed Logging at : /u01/app/oracle/tfa/repository/srdc_dbperf_collection_Sat_Feb_13_08_30_52_IST_2021_node_all/diagcollect_20210213083052_srlabrac1.log
2021/02/13 08:31:55 IST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom
2021/02/13 08:31:55 IST : Collection Name : tfa_srdc_dbperf_Sat_Feb_13_08_30_52_IST_2021.zip
2021/02/13 08:32:01 IST : Collecting diagnostics from hosts : [srlabrac2, srlabrac1]
2021/02/13 08:32:03 IST : Scanning of files for Collection in progress...
2021/02/13 08:32:03 IST : Collecting additional diagnostic information...
2021/02/13 08:38:39 IST : Getting list of files satisfying time range [02/12/2021 20:31:55 IST, 02/13/2021 08:38:39 IST]
2021/02/13 08:49:52 IST : Collecting ADR incident files...
2021/02/13 09:01:45 IST : Completed collection of additional diagnostic information...
2021/02/13 09:01:51 IST : Completed Local Collection
2021/02/13 09:01:51 IST : Remote Collection in Progress...
.--------------------------------------.
| Collection Summary |
+-----------+-----------+------+-------+
| Host | Status | Size | Time |
+-----------+-----------+------+-------+
| srlabrac2 | Completed | 22MB | 1067s |
| srlabrac1 | Completed | 25MB | 1789s |
'-----------+-----------+------+-------'
Logs are being collected to: /u01/app/oracle/tfa/repository/srdc_dbperf_collection_Sat_Feb_13_08_30_52_IST_2021_node_all
/u01/app/oracle/tfa/repository/srdc_dbperf_collection_Sat_Feb_13_08_30_52_IST_2021_node_all/srlabrac2.tfa_srdc_dbperf_Sat_Feb_13_08_30_52_IST_2021.zip
/u01/app/oracle/tfa/repository/srdc_dbperf_collection_Sat_Feb_13_08_30_52_IST_2021_node_all/srlabrac1.tfa_srdc_dbperf_Sat_Feb_13_08_30_52_IST_2021.zip
[oracle@srlabrac1 bin]$
Post a Comment: