The document provides a status update on the ABA-Exadata Migration Project. It details performance enhancement work that has been completed in the UAT environment, including SQL profile acceptance, gathering statistics, and allocating extents to address hardware contention. Testing of end-of-day performance shows improvement, with daily EOD processing times reduced to as low as 76.42 minutes compared to over 300 minutes for monthly EOD previously.
The document provides a status update on the ABA-Exadata Migration Project. It details performance enhancement work that has been completed in the UAT environment, including SQL profile acceptance, gathering statistics, and allocating extents to address hardware contention. Testing of end-of-day performance shows improvement, with daily EOD processing times reduced to as low as 76.42 minutes compared to over 300 minutes for monthly EOD previously.
The document provides a status update on the ABA-Exadata Migration Project. It details performance enhancement work that has been completed in the UAT environment, including SQL profile acceptance, gathering statistics, and allocating extents to address hardware contention. Testing of end-of-day performance shows improvement, with daily EOD processing times reduced to as low as 76.42 minutes compared to over 300 minutes for monthly EOD previously.
The document provides a status update on the ABA-Exadata Migration Project. It details performance enhancement work that has been completed in the UAT environment, including SQL profile acceptance, gathering statistics, and allocating extents to address hardware contention. Testing of end-of-day performance shows improvement, with daily EOD processing times reduced to as low as 76.42 minutes compared to over 300 minutes for monthly EOD previously.
gather stats dbms_stats.gather_fixed_objects_stats; Gather stats for All non-locked tables Module wise gather stats executed.
Gather stats for Module wise gather stats locked tables executed. All locked tables
enq: HW contention alter table fcchost.STTM_WITHDRAWABLE_HISTORY
allocate extent (size 100M); alter table fcchost.ICTB_ENTRIES_HIST_ZEROACCR allocate extent (size 100M); Move the below tables to FCCDATXXL and Indexes to FCCINXXXL tablespaces using the steps provided. ICTB_ENTRIES_HIST_ZEROACCR - Backup took 1h 22Mins with Parallel 32. Move table to FCCDATAXL 05:22.93 Mins. INDX - :04:17.14 STTM_WITHDRAWABLE_HISTORY - Backup took 33 Mins with parallel 32. Move to other FCCDATAXL took 4 Mins. INDX - 3:24.81
Created new tablespace with bigger size and moved
table to the new tablespace. EOD testing is in progress. EOD Performance Improvement
