What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

A.
TEST_TBS is a small file tablespace.

B.
TEST_TBS is a bigfile tablespace (BFT).

C.
TEST_TBS is the default temporary tablespace.

D.
TEST_TBS is the dictionary-managed tablespace.

E.
Threshold values for the TEST_TBS tablespace are not explicitly specified.

Explanation:
Space management within a tablespace involves keeping track of free and used space, so that space is allocated efficiently during data insertion and deletion.Oracle recommends creating locally-managed tablespaces over dictionary-managed tablespaces. Locally-managed tablespaces keep the space allocation information within the tablespace, not in the data-dictionary, thus offering better performance. By default, Oracle sets all newly created tablespaces to be locally-managed with automatic segment management, a feature that further improves performance. When you create a table in a locally managed tablespace and use automatic segment space management, you should allow Oracle to build the table using its own storage algorithms. If you need to store a table in a dictionary-managed tablespace, then you can set the storage characteristics for the table.

REF: Oracle(r) 2 days DBA, 6-5



Leave a Reply 0

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