nerdexam
Oracle

1Z0-052 · Question #223

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you…

The correct answer is F. Move the application tables to automatic segment space management tablespace. Automatic Segment Space Management (ASSM) tablespaces use bitmaps to manage free space automatically, eliminating the need to manually tune segment storage parameters.

Managing Database Storage Structures

Question

As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?

Options

  • ACoalesce the application tables at a regular interval.
  • BExport and Import the application tables a regular interval.
  • CDrop and recreate the application tables at a regular interval.
  • DMove the application tables to a tablespace with less space usage.
  • EDistribute the application tables across multiple tablespaces depending on usage.
  • FMove the application tables to automatic segment space management tablespace.

How the community answered

(34 responses)
  • B
    15% (5)
  • C
    3% (1)
  • D
    6% (2)
  • E
    3% (1)
  • F
    74% (25)

Why each option

Automatic Segment Space Management (ASSM) tablespaces use bitmaps to manage free space automatically, eliminating the need to manually tune segment storage parameters.

ACoalesce the application tables at a regular interval.

Coalescing a tablespace merges adjacent free extents but does not automate or eliminate the need to manually set storage parameters for individual segments.

BExport and Import the application tables a regular interval.

Exporting and importing tables reorganizes storage at a point in time but does not reduce ongoing overhead because storage parameters must still be managed manually afterward.

CDrop and recreate the application tables at a regular interval.

Dropping and recreating tables periodically is disruptive and does not automate segment storage parameter management in any way.

DMove the application tables to a tablespace with less space usage.

Moving tables to a tablespace with less space usage changes physical placement but does not automate segment storage parameter management.

EDistribute the application tables across multiple tablespaces depending on usage.

Distributing tables across multiple tablespaces based on usage adds management complexity rather than reducing the overhead of setting and monitoring storage parameters.

FMove the application tables to automatic segment space management tablespace.Correct

Moving tables to an ASSM tablespace removes the need to manually configure PCTUSED, FREELISTS, and FREELIST GROUPS parameters because Oracle uses bitmap blocks to track segment free space automatically. This directly reduces the DBA overhead of observing and tuning storage parameters for application tables. ASSM is the Oracle-recommended approach for simplifying segment space management in modern databases.

Concept tested: Oracle Automatic Segment Space Management (ASSM) tablespace

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tablespaces.html

Topics

#ASSM#segment space management#tablespace configuration#storage parameters

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice