$TFA_HOME/bin/tfactl diagcollect -srdc dbperf -from "02/15/2025 22:00:00" -to "02/16/2025 10:00:00"
Enter the Database Name [Required for this SRDC] : EBSDE3
Is the issue related to a specific Plugable Database? [Y|N] [Required for this SRDC]: Y
Enter the PDB Name [Required for this SRDC] : DRAM5I
Start time when the performance was bad: 2025-02-15 22:00:00
Stop time when the performance was bad: 2025-02-16 10:00:00
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 02 days ago you wish to use. [<RETURN> to provide other time range] :
Start time when the performance was good 2025-02-13 22:00:00
Stop time when the performance was good 2025-02-14 10:00:00
Has any SQL been identified to contribute to the performance issue?[Y|N] [Required for this SRDC]: N
Do you wish to take an AWR Dump as part of this collection?
NOTE: AWR Dump Can add signification size to the collection and increase the time necessary for the collection to complete. [Y|N] [Required for this SRDC]: Y
Ending AWR snapshot not needed, existing AWR snapshot exists within time window.
Found 14 snapshot(s) in Bad Performance time range for database EBSDE3
Found 14 snapshot(s) in Baseline Performance time range for EBSDE3
"Automatic Workload Repository (AWR) is a licensed feature. Refer to My Oracle Support Document ID 1490798.1 for more information"
Components included in this collection: DATABASE CHMOS CHA OS INSIGHTS SOSREPORT
Preparing to execute support diagnostic scripts.
Executing DB Script srdc_db_lfsdiag.sql on EBSDE3 with timeout of 120 seconds...
No comments:
Post a Comment