OCP-1Z0-053-V13.02-701题
701. A user receives the following error while performing a large volume of inserts into a table:
The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user
may perform such transaction in the future. You w ant to ensure that the command waits rather than
produce an error when such an event occurs the next time.
What can you do to achieve this before running the command in the future?
A.Set RESUMABLE_TIMEOUT for the instance.
B.Set the RESOURCE_LIMIT Parameter to TRUE.
C.Enable the database instance to use asynchronous commit.
D.Set the LOG_CHECKPOINT_TIMEOUT parameter to a nonzero value for the database instance.
Answer: C
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11584
根据官方文档，此题选A
[oracle@rtest ~]$ oerr ora 1536
01536, 00000, "space quota exceeded for tablespace '%s'"
// *Cause: The space quota for the segment owner in the tablespace has
// been exhausted and the operation attempted the creation of a
// new segment extent in the tablespace.
// *Action: Either drop unnecessary objects in the tablespace to reclaim
// space or have a privileged user increase the quota on this
// tablespace for the segment owner.
How Resumable Space Allocation Works
The following is an overview of how resumable space allocation works. Details are contained in later sections.