You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead?()
A recycle buffer cache
B large pool
C streams pool
D keep buffer cache
E redo log buffer
正确答案
答案解析
相似试题
(多选题)
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
(单选题)
In which situation are you NOT required to perform an incomplete recovery?()
(单选题)
You want the size of the tablespace to increase when it is full. Which option would you use?()
(单选题)
You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?()
(单选题)
You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2) 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2) 00 p.m.?()
(多选题)
You notice that your RMAN script used to copy the datafiles, control files, and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands?()
(单选题)
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
(单选题)
You took the DATA1 tablespace offline at 10:00 A.M. At 12:30 P.M., a schema of a user is dropped and purged from the Recycle Bin. You noticed this at 2:00 P.M. and decided to perform an incomplete recovery. Which datafiles will you recover?()
(多选题)
You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this?()