379.Users notify you that their application is failing every time they try to add new records. Because of poor application design, the actual ORA error message is unavailable. What might be the problem?(Choose the best answers.)
A. The application user has exceeded their undo quota.
B. The FLASHBACK GUARANTEE option is set on the undo tablespace.
C. The table is currently being queried by a Flashback Transaction Query operation.
D. The table is currently being queried by a Flashback Versions Query operation.
E. The RETENTION GUARANTEE option is set on the undo tablespace.
Answer: AE
用户通知你,每一次尝试添加新记录时,他们的应用程序运行都失败了。由于低劣的应用程序设计,实际ORA错误消息是难以获得。这可能是由于什么原因?
A、应用程序的用户已经超出他们撤消配额。
E、保留担保选项设置在撤消表空间
The likely causes are that the RETENTION GUARANTEE option has been set on the undo tablespace and there are no expired transactions to remove to make room for new transactions, or that the user has exceeded the undo quota that has been set by the database resource manager. FLASHBACK GUARANTEE is not a valid option, so option B is incorrect. Flashback queries would not interfere with transactions entering the system, so options C and D are incorrect.
可能的原因是保留保证选项已设置在撤销表空间上,没有过期的事务删除以为新的事务腾出空间,或用户已经超过了数据库资源管理器已设置的撤销配额。
闪回担保不是有效的选项,所以选项B不正确。
闪回查询不会干扰事务进入系统,所以选项C和D是不正确的。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2123821/
,如需转载,请注明出处,否则将追究法律责任。