# 1366133.1 SQLHC 23.1 Report: sqlhc_20240418_0914_8tyvq2bp8xkfy_1_health_check.html

    License    : T
    Input      : 8tyvq2bp8xkfy
    SIGNATURE  : 407805424935029650
    SIGNATUREF : 17968218173887074447
    RDBMS      : 19.0.0.0.0
    Platform   :
    Database   : absdb
    DBID       : 3340965127
    Host       : absracprd13
    Instance   : 3
    CPU_Count  : 192
    Num CPUs   : 192
    Num Cores  : 96
    Num Sockets: 4
    Block Size : 8192
    OFE        : 19.1.0
    DYN_SAMP   : 2
    EBS        : ""
    SIEBEL     : ""
    PSFT       : ""
    Date       : 2024-04-18/09:14:10
    User       : SYS

- Observations
- SQL Text
- Tables Summary
- Indexes Summary

## Observations

Observations below are the outcome of several heath-checks on the schema objects accessed by your SQL and its environment. Review them carefully and take action when appropriate. Then re-execute your SQL and generate this report again.

# | Type | Priority | Name | Observation | Details
--- | --- | --- | --- | --- | ---
1 | CBO PARAMETER | 35 | OPTIMIZER_SECURE_VIEW_MERGING | Review the non-default CBO initialization parameter "optimizer_secure_view_merging" with a value of "false" for correctness. | Review the correctness of this non-default value "false" for SQL_ID 8tyvq2bp8xkfy.
2 | CBO PARAMETER | 35 | _PGA_MAX_SIZE | Review the non-default CBO initialization parameter "_pga_max_size" with a value of "2097152 KB" for correctness. | Review the correctness of this non-default value "2097152 KB" for SQL_ID 8tyvq2bp8xkfy.
3 | DBMS_STATS | 66 | DBA_AUTOTASK_CLIENT | Disable this job immediately and gather statistics using the appropriate method. | Be aware that small sample sizes could produce poor quality histograms, which combined with bind sensitive predicates could render suboptimal plans. See 465787.1.
4 | DBMS_STATS | 33 | SYSTEM STATISTICS | Workload CBO System Statistics are not gathered. CBO is using default values. See MOS Note How to Collect and Display System Statistics (CPU and IO) for CBO use (Doc ID 149560.1). | Consider gathering workload system statistics using DBMS_STATS.GATHER_SYSTEM_STATS. See also 465787.1.
5 | PLAN | 71 | OPTIMIZER_ENV | Check the applicability of having multiple CBO environments set up for one SQL. There are (3 distinct CBO Environments for this one SQL). See https://docs.oracle.com/database/121/REFRN/GUID-2B9340D7-4AA8-4894-94C0-D5990F67BE75.htm#REFRN30246 | Distinct CBO Environments may produce different Plans.
6 | PLAN | 71 | OPTIMIZER_ENV | Check the applicability of having multiple CBO environments set up for one SQL. (Currently refernces 3 distinct CBO Environments for this one SQL) See https://docs.oracle.com/database/121/REFRN/GUID-2B9340D7-4AA8-4894-94C0-D5990F67BE75.htm#REFRN30246 | Distinct CBO Environments may produce different Plans.
7 | PLAN | 72 | OPTIMIZER_ENV | Check the applicability of having multiple CBO environments set up for one SQL. (Currently references 2 distinct CBO Enviornments for this one SQL.) See https://docs.oracle.com/database/121/REFRN/GUID-2B9340D7-4AA8-4894-94C0-D5990F67BE75.htm#REFRN30246 | Distinct CBO Environments may produce different Plans.
8 | TABLE | 1 | ABSSOLUTE.PRODUCT | Table has 2 index(es) with DOP different than its table. | Table has a degree of parallelism of "1". Review index properties and fix degree of parallelism of table and/or its index(es).
9 | TABLE | 20 | ABSSOLUTE.PRODUCT | Check the applicability of bugs 1386119, 4406309, 4495422, 4567767, 5483301 or 6082745. Table contains 7 column(s) referenced in predicates where the number of buckets is 1 for a "FREQUENCY" histogram. | Review column statistics for this table and look for "Num Buckets" and "Histogram". Possible Bugs 1386119, 4406309, 4495422, 4567767, 5483301 or 6082745. If you are referencing in your predicates one of the missing values the CBO can over estimate table cardinality, and this may produce a sub-optimal plan. You can either gather statistics with 100% or as a workaround: ALTER system/session "_fix_control"='5483301:OFF';
10 | TABLE | 20 | ABSSOLUTE.PRODUCTLISTPERCUSTOMER | Check the applicability of bugs 1386119, 4406309, 4495422, 4567767, 5483301 or 6082745. Table contains 10 column(s) referenced in predicates where the number of buckets is 1 for a "FREQUENCY" histogram. | Review column statistics for this table and look for "Num Buckets" and "Histogram". Possible Bugs 1386119, 4406309, 4495422, 4567767, 5483301 or 6082745. If you are referencing in your predicates one of the missing values the CBO can over estimate table cardinality, and this may produce a sub-optimal plan. You can either gather statistics with 100% or as a workaround: ALTER system/session "_fix_control"='5483301:OFF';
# | Type | Priority | Name | Observation | Details

## SQL Text

    select 1
    from PRODUCTLISTPERCUSTOMER PLPC
    join PRODUCT P
    on P.PRODUCT_ID = PLPC.PRODUCT_ID
    where PLPC.CUSTOMER_ID = :1
    and PLPC.PRODUCT_ID = :2
    and PLPC.SIZEDEFINITION_ID = :3
    and PLPC.FINISHINGMETHOD_ID = :4     and PLPC.DATEACTIVE <= :5
    and PLPC.DATEINACTIVE >= :6
    and P.TYPEOFMERCHANDISE in (:7 , :8 )
    and ((PLPC.BILLINGMETHOD = :9  and PLPC.CHARGEWASHESONLYFORCOG = :10 ) or
    (PLPC.BILLINGMETHOD = :11  and PLPC.CHARGEWASHESONLYFORCOG = :12  and
    PLPC.PRICEUSAGE <> :13 )
    )

## Tables Summary

Values below have two purposes:
1. Provide a quick view of the state of Table level CBO statistics, as well as their indexes and columns.
2. More easily allow the comparison of two systems that are believed to be similar.

# | Table Name | Owner | Num Rows | Table Sample Size | Last Analyzed | Indexes | Avg Index Sample Size | Table Columns | Columns with Histogram | Avg Column Sample Size
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | PRODUCT | ABSSOLUTE | 803004 | 803004 | 14-APR-24 07:29:47 | 42 | 420490 | 113 | 35 | 628236
2 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | 4296252 | 4296252 | 14-APR-24 07:29:59 | 43 | 1673287 | 153 | 46 | 3157140
# | Table Name | Owner | Num Rows | Table Sample Size | Last Analyzed | Indexes | Avg Index Sample Size | Table Columns | Columns with Histogram | Avg Column Sample Size

## Indexes Summary

Values below have two purposes:
1. Provide a quick view of the state of Index level CBO statistics, as well as their columns.
2. More easily allow the comparison of two systems that are believed to be similar.
This section includes data captured by AWR. If this is a stand-by read-only database then the AWR information below is from the Primary database.

# | Table Name | Table Owner | Index Name | Index Owner | In MEM Plan | In AWR Plan | Num Rows | Index Sample Size | Last Analyzed | Index Columns | Columns with Histogram | Avg Column Sample Size
--- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | ---
1 | PRODUCT | ABSSOLUTE | XAK1PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:51 | 1 | 1 | 6511
2 | PRODUCT | ABSSOLUTE | XIE11PRODUCT | ABSSOLUTE |  |  | 802966 | 802966 | 14-APR-24 07:29:51 | 1 | 0 | 802966
3 | PRODUCT | ABSSOLUTE | XIF14PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:48 | 1 | 0 |
4 | PRODUCT | ABSSOLUTE | XIF150PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:50 | 1 | 0 | 803004
5 | PRODUCT | ABSSOLUTE | XIF15PRODUCT | ABSSOLUTE |  |  | 5098 | 5098 | 14-APR-24 07:29:49 | 1 | 0 | 5098
6 | PRODUCT | ABSSOLUTE | XIF16PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:48 | 1 | 0 |
7 | PRODUCT | ABSSOLUTE | XIF17PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:49 | 1 | 0 |
8 | PRODUCT | ABSSOLUTE | XIF18PRODUCT | ABSSOLUTE |  |  | 802998 | 802998 | 14-APR-24 07:29:49 | 1 | 1 | 802998
9 | PRODUCT | ABSSOLUTE | XIF19PRODUCT | ABSSOLUTE |  |  | 802997 | 802997 | 14-APR-24 07:29:49 | 1 | 1 | 802997
10 | PRODUCT | ABSSOLUTE | XIF1PRODUCT | ABSSOLUTE |  |  | 89 | 89 | 14-APR-24 07:29:51 | 1 | 1 | 89
11 | PRODUCT | ABSSOLUTE | XIF20PRODUCT | ABSSOLUTE |  |  | 802997 | 802997 | 14-APR-24 07:29:48 | 1 | 1 | 802997
12 | PRODUCT | ABSSOLUTE | XIF21PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:50 | 1 | 0 |
13 | PRODUCT | ABSSOLUTE | XIF22PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:49 | 1 | 0 |
14 | PRODUCT | ABSSOLUTE | XIF23PRODUCT | ABSSOLUTE |  |  | 802998 | 802998 | 14-APR-24 07:29:51 | 1 | 1 | 802998
15 | PRODUCT | ABSSOLUTE | XIF24PRODUCT | ABSSOLUTE |  |  | 38 | 38 | 14-APR-24 07:29:49 | 1 | 0 | 38
16 | PRODUCT | ABSSOLUTE | XIF259PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:51 | 1 | 1 | 6510
17 | PRODUCT | ABSSOLUTE | XIF25PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:49 | 1 | 0 |
18 | PRODUCT | ABSSOLUTE | XIF260PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:50 | 1 | 1 | 803004
19 | PRODUCT | ABSSOLUTE | XIF261PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:50 | 1 | 1 | 6509
20 | PRODUCT | ABSSOLUTE | XIF262PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:51 | 1 | 1 | 803004
21 | PRODUCT | ABSSOLUTE | XIF264PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:51 | 1 | 1 | 803004
22 | PRODUCT | ABSSOLUTE | XIF265PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:49 | 1 | 1 | 803004
23 | PRODUCT | ABSSOLUTE | XIF266PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:50 | 1 | 0 |
24 | PRODUCT | ABSSOLUTE | XIF27PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:49 | 1 | 0 |
25 | PRODUCT | ABSSOLUTE | XIF28PRODUCT | ABSSOLUTE |  |  | 681861 | 681861 | 14-APR-24 07:29:50 | 1 | 1 | 5531
26 | PRODUCT | ABSSOLUTE | XIF29PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:51 | 1 | 0 |
27 | PRODUCT | ABSSOLUTE | XIF2PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:50 | 1 | 0 |
28 | PRODUCT | ABSSOLUTE | XIF30PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:51 | 1 | 0 |
29 | PRODUCT | ABSSOLUTE | XIF31PRODUCT | ABSSOLUTE |  |  | 16899 | 16899 | 14-APR-24 07:29:50 | 1 | 1 | 16899
30 | PRODUCT | ABSSOLUTE | XIF32PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:48 | 1 | 0 |
31 | PRODUCT | ABSSOLUTE | XIF392PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:50 | 1 | 1 | 803004
32 | PRODUCT | ABSSOLUTE | XIF3PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:49 | 1 | 0 |
33 | PRODUCT | ABSSOLUTE | XIF4PRODUCT | ABSSOLUTE |  |  | 55594 | 55594 | 14-APR-24 07:29:49 | 1 | 0 | 55594
34 | PRODUCT | ABSSOLUTE | XIF909PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:49 | 1 | 1 | 803004
35 | PRODUCT | ABSSOLUTE | XIF910PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:48 | 1 | 1 | 803004
36 | PRODUCT | ABSSOLUTE | XIF911PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:50 | 1 | 1 | 803004
37 | PRODUCT | ABSSOLUTE | XIF912PRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:49 | 1 | 1 | 803004
38 | PRODUCT | ABSSOLUTE | XIF913PRODUCT | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:29:49 | 1 | 0 |
39 | PRODUCT | ABSSOLUTE | XPKPRODUCT | ABSSOLUTE | YES | YES | 803004 | 803004 | 14-APR-24 07:29:49 | 1 | 0 | 803004
40 | PRODUCT | ABSSOLUTE | XSPEEDPRODUCT | ABSSOLUTE |  |  | 803004 | 803004 | 14-APR-24 07:29:48 | 3 | 1 | 537506
41 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | INDX_PLPC_ERP_EXPORTED_SC | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:09 | 1 | 1 | 5379
42 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | TIDXPRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:06 | 3 | 3 | 2865962
43 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XAK2PRODUCTLISTPERCUSTOMER | ABSSOLUTE | YES |  | 4296252 | 4296252 | 14-APR-24 07:30:08 | 5 | 4 | 2579904
44 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XAK3PRODUCTLISTPERCUSTOMER | ABSSOLUTE | YES |  | 4296252 | 4296252 | 14-APR-24 07:30:05 | 5 | 4 | 2579903
45 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIE24PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:08 | 2 | 0 | 4296252
46 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIE5PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:04 | 1 | 1 | 5381
47 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIE6PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:09 | 1 | 1 | 5380
48 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIE7PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:09 | 2 | 1 | 2208212
49 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIE8PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:08 | 5 | 4 | 2579904
50 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF10PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 196803 | 196803 | 14-APR-24 07:30:07 | 1 | 1 | 9199
51 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF12PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:06 | 1 | 0 |
52 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF13PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:06 | 1 | 0 |
53 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF14PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:09 | 1 | 0 |
54 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF159PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 116657 | 116657 | 14-APR-24 07:30:06 | 1 | 1 | 116657
55 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF15PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 2178207 | 2178207 | 14-APR-24 07:30:04 | 1 | 1 | 2178207
56 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF16PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:05 | 1 | 0 |
57 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF17PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:05 | 1 | 0 |
58 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF18PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 93464 | 93464 | 14-APR-24 07:30:10 | 1 | 1 | 93464
59 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF19PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 3555 | 3555 | 14-APR-24 07:30:08 | 1 | 0 | 3555
60 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF1PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:09 | 1 | 0 |
61 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF20PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:10 | 1 | 0 |
62 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF21PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:10 | 1 | 0 |
63 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF22PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 749888 | 749888 | 14-APR-24 07:30:05 | 1 | 1 | 749888
64 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF23PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 2895802 | 2895802 | 14-APR-24 07:30:09 | 1 | 0 | 2895802
65 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF24PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:09 | 1 | 0 |
66 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF25PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 37364 | 37364 | 14-APR-24 07:30:05 | 1 | 0 | 37364
67 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF26PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:08 | 1 | 0 |
68 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF27PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:09 | 1 | 0 |
69 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF2PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:08 | 1 | 0 |
70 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF3PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:09 | 1 | 0 |
71 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF734PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 353 | 353 | 14-APR-24 07:30:06 | 1 | 1 | 353
72 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF841PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 601608 | 601608 | 14-APR-24 07:30:09 | 1 | 1 | 601608
73 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF842PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 116485 | 116485 | 14-APR-24 07:30:07 | 1 | 1 | 5476
74 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF843PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 517390 | 517390 | 14-APR-24 07:30:06 | 1 | 1 | 517390
75 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF85PRODUCTLISTPERCUSTOMER | ABSSOLUTE | YES | YES | 4296252 | 4296252 | 14-APR-24 07:30:10 | 1 | 1 | 4296252
76 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF86PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:05 | 1 | 1 | 5381
77 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF87PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:07 | 1 | 1 | 4296252
78 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF88PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:07 | 1 | 0 | 4296252
79 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF973PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:07 | 1 | 1 | 5379
80 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF974PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 1 | 1 | 14-APR-24 07:30:10 | 1 | 0 | 1
81 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF975PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 1 | 1 | 14-APR-24 07:30:09 | 1 | 0 | 1
82 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XIF976PRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 0 | 0 | 14-APR-24 07:30:06 | 1 | 0 |
83 | PRODUCTLISTPERCUSTOMER | ABSSOLUTE | XPKPRODUCTLISTPERCUSTOMER | ABSSOLUTE |  |  | 4296252 | 4296252 | 14-APR-24 07:30:06 | 1 | 0 | 4296252
# | Table Name | Table Owner | Index Name | Index Owner | In MEM Plan | In AWR Plan | Num Rows | Index Sample Size | Last Analyzed | Index Columns | Columns with Histogram | Avg Column Sample Size

1366133.1 SQLHC 23.1 2024-04-18/09:14:10 tool_date: 2024/04/11 executed by: SYS