To investigate the slow response time of queries on theTRANStable, you gathered the table
statistics and executed the query:
The table is stored in a tablespace that has Automatic Segment Space Management (ASSM)
enabled. The tablespace is created with a standard block size of 8192 bytes. Which three can
be reasons for the slow response time of the queries?(Choose three.)
A.
Row size is too large to fit into a single block during insert operations.
B.
Row moves from one data block to another data block because the row grows too large to
fit in the original block.
C.
The table is subject to frequent insert, update,and delete DML activity leading to sparsely
populated blocks.
D.
The value ofPCTUSEDis set to a value lower than the default, causing row changing.
E.
The value ofPCTFREEis set to a value lower than the default, causing row chaining.
Default for PCTFREE and PCTUSED are 10 and 40 respectively.
so D and E sounds wrong.
A,B,C – right
A,B,C
PCTFREE & PCTUSED in 12c aren’t used when ASSM is enabled.
pctfree is used but not pctused when assm is enabled.
Right : Default for PCTFREE and PCTUSED are 10 and 40 respectively.
Right : pctfree is used but not pctused when assm is enabled.
ABC