You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area (PGA): SORT_AREA_SIZE = 150M HASH_AREA_SIZE = 150M BITMAP_MERGE_AREA_SIZE = 150M CREATE_BITMAP_AREA_SIZE = 150M WORKAREA_SIZE_POLICY = AUTO You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area (SGA) is currently sized at 4G. What is the total PGA memory allocated across all database server processes?()
The SPFILE for your database contains the following parameter settings: SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components?()
You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter?()
Your SPFILE contains the following parameter settings: SGA_TARGET = 8G DB_CACHE_SIZE = 4G SHARED_POOL_SIZE = 2G LARGE_POOL_SIZE = 512M JAVA_POOL_SIZE = 512M LOG_BUFFER = 100M SGA_MAX_SIZE = 10G You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G, but instead of specifying a value of 10G for the SGA_TARGET initialization parameter, you erroneously execute the following statement: SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH; What is the result of this statement?()
Which three statements regarding the server parameter file (SPFILE) are true()
The database instance is currently using SPFILE. View the Exhibit and examine the error that youreceived while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order: 1: Shut down the instance, if not already done. 2: Copy one of the remaining control files to a new location. 3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files. 4: Start up the database instance to the NOMOUNT stage. 5: Recover the database to the point of failure of the control file. 6: Open the database. Identify the correct sequence of steps( )
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order: 1)Shut down the instance. 2)Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3)Execute the ALTER DATABASE FLASHBACK OFF command. 4)Start up the instance and mount the database. 5)Execute the ALTER DATABASE FLASHBACKON command. 6)Open the database. Select the correct order in which these tasks need to be performed. ()
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of yourdatabase to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order: 1.Shut down the instance. 2.Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value. 3.Execute the ALTER DATABASE FLASHBACK OFF command. 4.Start up the instance and mount the database. 5.Execute the ALTER DATABASE FLASHBACK ON command. 6.Open the database. Select the correct order in which these tasks need to be performed.()
The database instance is currently using SPFILE. View the Exhibit and examine the error that you receivedwhile running the DB Structure Integrity check. Given below are the steps to recover from the error in randomorder: 1.Shut down the instance, if not already done. 2.Copy one of the remaining control files to a new location. 3.Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of thecontrol files. 4.Start up the database instance to the NOMOUNT stage. 5.Recover the database to the point of failure of the control file. 6.Open the database. Identify the correct sequence of steps()
Which statements regarding the server parameter file (SPFILE) are true()