Which three can be reasons for the slow response time o…

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.)

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.



Leave a Reply 4

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


vasya

vasya

Default for PCTFREE and PCTUSED are 10 and 40 respectively.
so D and E sounds wrong.
A,B,C – right

diablo

diablo

A,B,C
PCTFREE & PCTUSED in 12c aren’t used when ASSM is enabled.

job

job

pctfree is used but not pctused when assm is enabled.

Fonx

Fonx

Right : Default for PCTFREE and PCTUSED are 10 and 40 respectively.
Right : pctfree is used but not pctused when assm is enabled.

ABC