84. Exhibit:
View the Exhibit and examine the characteristic of the USERS tablespa
ce. You observe that a large volume of inserts and deletes are happen
ing on the TRANS table in the USERS tablespace and you suspect that t
he TRANS table is fragmented. Which advisory component would you refe
r to, in order to find information about table fragmentation?
A. Memory Advisor
B. Segment Advisor
C. SLQ Tuning Advisor
D. SLQ Access Advisor
E. Automatic Database Diagnostic Monitor (ADDM)
Answer: B
你怀疑你的一个表中有碎片(fragmented),你可以使用段指导(Segment
Advisor)来获取信息段指导:监视对象空间问题并分析增长趋势。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/11312660/viewspace-717984/
,如需转载,请注明出处,否则将追究法律责任。