Method and system for faster instance startup for large resource configurations

Abstract

A method for starting up a database system, comprising allocating memory spaces for three buffers; initializing two of the buffers; partially initializing the third buffer where the third buffer is larger than the other two; instructing the memory manager to initialize the remainder of the third buffer in the background process; performing recovery operations; and opening the database system for use. The database is operated in an open phase while the remainder of the third buffer is initialized in the background and ran in parallel to the recovery operation that may extend beyond the completion of opening the database. Thus opening the database prior to completion of full initialization and initializing the third buffer in the background improves the startup time of the database which becomes significant when the size of the third buffer is very large (e.g., 500 GB+).

1. A method of starting up a database system, said method comprising:
 allocating memory spaces for first, second and third buffers for use by said database system; 
 initializing said first and second buffers; 
 partially initializing said third buffer, wherein said third buffer is larger than said first and second buffers; 
 instructing a memory manager to initialize a remainder of said third buffer in a background process; 
 performing recovery operations in parallel; and 
 opening said database system for use. 
 
   
   
     2. The method as described in  claim 1  further comprising:
 operating said database system in an open phase; and 
 initializing said remainder of said third buffer in said background process, wherein said background process and said recovery operations of said database system occur in parallel. 
 
   
   
     3. The method as described in  claim 1  wherein said first buffer is a shared pool, said second buffer is a large pool and said third buffer is a buffer cache. 
   
   
     4. The method as described in  claim 1  wherein an operating system performs said allocating memory. 
   
   
     5. The method as described in  claim 1  wherein said recovery operations comprise transaction recovery and instance recovery. 
   
   
     6. The method as described in  claim 1  wherein said partially initializing said third buffer initializes approximately 2 granules of memory per processor of said database system. 
   
   
     7. The method as described in  claim 1  wherein said initializing comprises:
 performing metadata formatting; and 
 defining reserved user data memory space. 
 
   
   
     8. A system for starting up a database system, said system comprising:
 a memory allocator for allocating memory spaces for first, second and third buffers used by the database system; 
 a startup program for fully initializing said first and second buffers and for partially initializing said third buffer, wherein said third buffer is larger than said first and second buffers; 
 a memory manager in communication with said startup program, wherein upon completion of partial initialization said memory manager initializes a remainder of said third buffer in a background process wherein a portion of said background process operates during a period wherein said database system is open for use; and 
 a recovery unit. 
 
   
   
     9. The system as described in  claim 8  wherein said database system is open for use in an open mode with said memory manager concurrently initializing a remainder of said third buffer in said background process. 
   
   
     10. The system as described in  claim 8  wherein said recovery unit operates in parallel to said memory manager. 
   
   
     11. The system as described in  claim 8  wherein said memory allocator is an operating system. 
   
   
     12. The system as described in  claim 8  wherein said startup applies to medium selected from a set comprising: non-volatile media, volatile media, and transmission media. 
   
   
     13. The system as described in  claim 8  wherein said first buffer is a shared pool, said second buffer is a large pool and said third buffer is a buffer cache. 
   
   
     14. The system as described in  claim 8  wherein said recovery unit further comprises:
 a transaction recovery unit; and 
 an instance recovery unit. 
 
   
   
     15. A computer-useable medium having computer-readable program code stored thereon for causing a computer system to execute a method for starting up a database system, said method comprising:
 allocating memory spaces for first, second and third buffers for use by said database system; 
 initializing said first and second buffers; 
 partially initializing said third buffer, wherein said third buffer is larger than said first and second buffers; 
 instructing a memory manager to initialize a remainder of said third buffer in a background process; 
 performing recovery operations; and 
 opening said database system for use. 
 
   
   
     16. The computer-useable medium as described in  claim 15  further comprising:
 operating said database system in an open phase; and 
 initializing said remainder of said third buffer in said background process, wherein said background process and said operating said database system occur in parallel. 
 
   
   
     17. The computer-useable medium as described in  claim 15  wherein said first buffer is a shared pool, said second buffer is a large pool and said third buffer is a buffer cache. 
   
   
     18. The computer-useable medium as described in  claim 15  wherein an operating system performs said allocating memory. 
   
   
     19. The computer-useable medium as described in  claim 15  wherein said recovery operations comprise transaction recovery and instance recovery. 
   
   
     20. The computer-useable medium as described in  claim 15  wherein said partially initializing said third buffer initializes approximately 2 granules of memory per processor of said database system. 
   
   
     21. The computer-useable medium as described in  claim 15  wherein said initializing comprises:
 performing metadata formatting; and 
 defining reserved user data memory space.