Which advisory component would you refer to, in order to find information about table fragmentation?

View the Exhibit and examine the characteristics of the USERS tablespace.
You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented.
Which advisory component would you refer to, in order to find information about table fragmentation?
Exhibit:

View the Exhibit and examine the characteristics of the USERS tablespace.
You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented.
Which advisory component would you refer to, in order to find information about table fragmentation?
Exhibit:

A.
Segment Advisor

B.
SQL Access Advisor

C.
SQL Tuning Advisor

D.
Memory Advisor

E.
Automatic Database Diagnostic Monitor (ADDM)



Leave a Reply 0

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