Which three parameters are ignored when creating an automatic space management segment?

Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

A.
PCTFREE

B.
PCTUSED

C.
INITRANS

D.
MAXTRANS

E.
FREELISTS change it to FREELIST

F.
FREELIST GROUP

Explanation:
Automatic segment-space management in locally managed tablespaces eliminates the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters. If possible, switch from manual space management to automatic segment-space management (ASSM).
REF.: Oracle(r) Database 10g Performance Guide , 10-19



Leave a Reply 0

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