Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace space usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace space usage metrics for the APPS tablespace. What should you do?()
A、disable SQL tracing for theAPPS tablespace
B、disable logging attribute for the APPS tablespace
C、modify the tablespace to be a dictionarymanaged tablespace
D、increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace
E、increase the warning threshold value for the tablespace space usage metrics for the APPS tablespace
相关问题推荐
-
You are maintaining the SALES database of a company. You have never backed up the USERS tablespace that is currently offline. On Sunday, you issued the following commands: CONFIGURE DEFAULT DEVICE TYPE TO sbt; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE RETENTION POLICY TO REDUNDANCY 3; From Monday to Saturday, you performed the following actions: Day Action Monday BACKUP DATABASE Tuesday BACKUP DATABASE Wednesday BACKUP DATABASE Thursday BACKUP DATABASE Friday BACKUP DATABASE Saturday BACKUP DATABASE How many times will the backup of the USERS tablespace be performed?()
A、 The backup will not be performed at all.
B、 three times
C、 four times
D、 six times
-
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?()
A、 use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B、 restore the entire database from the most recent backup and open it
C、 recover the table by using the Flashback Table feature
D、 perform point-in-time recovery to recover the table
-
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employees table, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5: ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following: The data file should remain online. The mean time to recover (MTTR) should be minimal. You are not using a backup control file, and all the archived logs are accessible. Which option would you choose?()
A、flash back the corrupted blocks
B、use the DBMS_REPAIR package
C、use the RMAN TSPITR command
D、use the RMAN BLOCKRECOVER command
E、use the RESTORE DATABASE and RECOVER DATABASE commands
F、investigate the time at which the corruption occurred and perform a point-in-time recovery
-
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors, such as erroneously dropping users, tables, and important data, to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database, you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors, you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running?()
A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
-
You executed the following code: BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will be the result of executing the above code?()
A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks, if any, recorded in the view.
B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.
D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks, if any, recorded in the view.