Database Hosting: Oracle Database Hosting Features
OIT has implemented Exadata Database Machines which are a complete package of servers, storage, networking, and software that is massively scalable, secure, and redundant specifically designed for Oracle database applications. As part of that implementation, OIT has consolidated many applications that had previously existed within separate databases into a far fewer number of ‘shared’ databases to better utilize the high performance features of Exadata and to increase operational efficiencies. We refer to these ‘shared’ databases as our Exadata ‘hotel’ databases. We are now expanding the use of these ‘hotel’ databases to include departmental applications. Here are the highlights of using the ‘hotel’ databases to house departmental applications.
1. Production database with:
- Oracle RAC (Real Application Cluster) – high availability, scalable
- Oracle Dataguard (Standby database) – DR, second level of high availability
2. Test Database Suite (up to 3 database types)
- SDLC (System Development Life Cycle): 3 levels of testing for those applications that warrant it
- DEV – Development
- TST – Test (code and bug testing)
- ENT – “Enterprise Testing” (Integration/performance/staging)
3. Departmental Tablespace
- Up to 100GB useable space in each Database
4. Departmental Application Schema(s)
- Schema User Accounts – one or more to meet departmental need
- All department schemas share department tablespace
- Each schema has authority to create any type schema object
5. Service level availability:
- PRD: 24x7x365 with scheduled Sunday maintenance
- DEV/TST/ENT: available M-F 7am to 5pm (maintenance scheduled outside of above hours weekdays and on weekends)
6. Utilize the Exadata hardware (delivers outstanding I/O, response time, performance, etc.)
7. Back-end support provided by OIT, including management of the infrastructure, operating system, hardware, database software, backups, and security.
Oracle Database Hosting - Information Sharing
The OIT Database Hosting Services team will provide information to Departmental Application Administrators to assist them in how they can manage their schemas within the Exadata hotel databases. The manner in how this information will be shared is yet to be determined. We would also like to provide a means to have Application Administrators share information with one another.