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