Oracle Admin Interview Question and Answers

25. What is large pool?
  Oracle large pool is an optional memory component of the Oracle database SGA. This area is used for providing large memory allocations in many situations that arise during the operations of an Oracle database instance. Session memory for the shared server and the Oracle XA interface for distributed transactions
  • I/O server processes
  • Parallel query buffers
  • Oracle backup and restore operations using RMAN.
  • Large pools plays an important role in Oracle database Tuning since the allocation of the memory for the preceding components; otherwise, it is done from the shared pool. Moreover, due to the large memory requirements for I/O and RMAN operations, the large pool satisfies the requirements instead of depending on the Shared Pool Area.
  • Usage of a Large Pool Area allows the shared pool to primarily cache Structured Query Language (SQL) and avoid the overhead caused by shrinking the SQL Cache Area.
 
Your Name Your Email-ID
Your Answer
26. What are the advantages of using SPFILE?
 
  • SPFILE supports dynamic changes in parameter values. The changes in SPFILE can only be made by using the Oracle statements; therefore, there is no chance of accepting impossible changes as it will be checked by the system. As a result, chances of human errors are reduced.
  • Moreover, back up of SPFILE is possible through RMAN.
 
Your Name Your Email-ID
Your Answer
27. How do you determine the maximum number of data files in an Oracle database?
 
  • DB_Files initialization parameter determines the maximum number of data files. A change in this parameter requires the restart of the database.
  • The default value of DB_Files is operating system specific.
  • When determining a value for DB_Files, you should consider the following situations.
  • If the value of DB_Files is too low, you cannot and data files beyond the DB_Files limits without first shutting down the database.
  • If the value of DB_Files is too high, memory is unnecessarily consumed.
 
Your Name Your Email-ID
Your Answer
28. How do you control the number of data files in an Oracle database?
  The number of data files in an Oracle database is controlled by the initialization parameters DB_Files.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 7 of 10