InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Use Of Large Pool, Which Case You Need To Set The Large Pool? |
|
Answer» You need to set large pool if you are using: MTS (MULTI thread server) and RMAN Backups. Large pool prevents RMAN MTS from competing with other sub system for the same memory. RMAN uses the large pool for backup restore when you set the DBWR_IO_SLAVES or BACKUP_TAPE_IO_SLAVES parameters to simulate asynchronous I/O. If neither of these parameters is enabled, then Oracle ALLOCATES backup buffers from local PROCESS memory rather than SHARED memory. Then there is no use of large pool. You need to set large pool if you are using: MTS (Multi thread server) and RMAN Backups. Large pool prevents RMAN MTS from competing with other sub system for the same memory. RMAN uses the large pool for backup restore when you set the DBWR_IO_SLAVES or BACKUP_TAPE_IO_SLAVES parameters to simulate asynchronous I/O. If neither of these parameters is enabled, then Oracle allocates backup buffers from local process memory rather than shared memory. Then there is no use of large pool. |
|