In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
You want execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600.
Which two statements are true?
A.Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session
B.Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C.A resumable statement can be suspended and resumed only once during execution.
D.A suspended statement will report an error if no corrective action has taken place during a timeout period.
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
Answer: AD
[analysis]
Recoverable space allocation works as follows:
The statement executes in recoverable mode only if recoverable space allocation is enabled for the session of the statement by one of the following operations:
The ALTER SESSION ENABLE RESUMABLE declaration is that the RESUMABLE_TIMEOUT initialization parameter is set to a non-zero value during the meeting before the statement execution.
The ALTER SESSION ENABLE RESUMABLE TIMEOUT timeout_value statement is issued in the session before execution, and timeout_value is a non-zero value.
Recoverable statements are suspended when one of the following occurs (these conditions cause non-recoverable statements to be sent a corresponding error signal):
Lack of space
Conditions for reaching the maximum range
Space quota condition exceeded.
When aborting the execution of recoverable statements, there are mechanisms that can perform user-provided operations, record errors, and the status of query statement execution. After pausing the recoverable statement, the following actions are performed:
The error is reported in the alert log.
The system issues a "recoverable session suspended" alert.
If the user registers the trigger on the AFTER SUSPEND system event, the user trigger is executed. The user-provided PL / SQL procedure can access error message data using the DBMS_ Resumble package and the DBA_ or USER_RESUMABLE view.
Suspending statements automatically cause transactions to be suspended. Therefore, all transaction resources are reserved through statement aborts and restores.
After the error condition is resolved (for example, due to user intervention or the sort space released by other queries), the suspended statement automatically resumes execution and clears the recoverable session suspended alert.
You can use this DBMS_RESUMABLE.ABORT () procedure to force a paused statement to throw an exception. DBA or the user who issued the statement can call this procedure.
The pause timeout interval specified by the RESUMABLE_TIMEOUT initialization parameter or the timeout value in the ALTER SESSION ENABLE RESUMABLE TIMEOUT statement is associated with the recoverable statement. If the error condition is not resolved within the timeout interval, the recoverable statement paused during the timeout interval is paused and the exception is returned to the user.
Recoverable statements can be suspended and restored multiple times during execution.
[official manual]
Https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-space-for-schema-objects.html#GUID-46AE3FD8-95D4-4CFA-9F3C-B80C5AFDE75B
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.