Oracle DB 12c runs best on Sparc
By Adina K-Oracle on Apr 04, 2014
Independent Software Vendors (ISV) who are developing applications using both Oracle DB 12c and Solaris are taking advantage of one core technology, one operating system, one virtualization tool for all the range of SPARC servers. An ISV application can boost its performance, flexibility and security just by using SPARC high numbers of cores and big memory, combined Oracle 12c/Solaris/SPARC multi-tenancy, zones and LDoms light-weight virtualization technologies, SPARC and Solaris build-in encryption, etc.
Let’s take a look at how all this is translated into technical features. What makes Solaris and SPARC servers the best infrastructure for Oracle 12c enterprise databases?
- Oracle Solaris Dtrace is integrated into Oracle 12c and provides end-to-end view for I/O operations taking too long. This way, a database administrator can trace I/O requester, I/O device and the exact time spent in each layer: database, OS and the storage device. This is an ideal tool when the storage is a raw device. During runtime, data is collected and stored into V$KERNEL_IO_OUTLIER. With simple queries, any DBA can get information if there is a problem with the storage device or the HBA connector. These are the fields of V$KERNEL_IO_OUTLIER:
Column Description TIMESTAMP Number of seconds elapsed since 00:00 UTC, January 1, 1970 IO_SIZE Size of the I/O, in KB. IO_OFFSET Offset into the device of the I/O DEVICE_NAME Name of the device to which the I/O was targeted PROCESS_NAME Name of the process that issued the I/O TOTAL_LATENCY Total time in microseconds the I/O spent in the kernel SETUP_LATENCY Time in microseconds spent during initial I/O setup before sending to SCSI target device driver QUEUE_TO_HBA_LATENCY Time in microseconds spent in the SCSI target device driver before being sent to the Host Bus Adaptor TRANSFER_LATENCY Time in microseconds spent in the Host Bus Adaptor and physically transferring the I/O to the storage device CLEANUP_LATENCY Time in microseconds spent freeing resources used by the completed I/O PID Process ID that issued the I/O
- SGA online resizing without reboot is new with Oracle Database 12c and only on Solaris 11.1. Combined with Solaris zones and resource management, this feature allows fast start-up of Oracle instance and dynamic memory resize. When running in a complex, virtualized environment like cloud, this feature helps avoiding disruptions of database services and easy SGA adjustment when database is under heavy use. Solaris 11.1 has implemented a new Optimized Shared Memory (OSM) interface which replaces DISM.
- Oracle 12c new multi-tenancy feature running over Solaris virtualization (Zones or/and LDoms) is a powerful and dynamic infrastructure for cloud. You can install and run multiple versions of database and OS on the same server. What an economical architecture to support old and new versions of different applications! And if you have Solaris ZFS as the underlined filesystem, you can take advantage of its snapshot capabilities and easily move zones, in just few seconds, to a different server. Due to Solaris 11 network virtualization, complete isolation is guaranteed between applications running on different zones even if the zones are using the same NIC of the server. This way you get maximum consolidation! This architecture is ideal for a development environment when multiple customer configurations should be supported. Solaris network virtualization can help to mimic complex customer network configurations, all in just one box.
- End-to-End Encryption with No Additional Costs when running Oracle 12c on Solaris SPARC. SPARC servers like T5, have an encryption engine on each core that will accelerate all of the most common bulk encryption ciphers like AES and DES. SPARC T5 also supports asymmetric key exchange with RSA and ECC and authentication or hash functions like SHA and MD5. ZFS encryption is supported from Solaris 11 and when running on SPARC T5-2 achieves ZFS File System Encryption Benchmark World Record. Oracle 12c is using Fast Oracle Database Advanced Security Transparent Data Encryption (TDE) and Oracle Database 12c Release 1 (12.1) introduces a unified key management interface for Transparent Data Encryption (TDE) and other database components. This eases key administration tasks, provides for better compliance and tracking, and improves separation of duty between the database administrator and security administrator.
- Oracle has a strong Solaris SPARC roadmap investing in silicon leadership. Next generation of SPARC servers will have software-on-silicon capabilities that will dramatically improve database performance. Due to Oracle Solaris commitment to application backward compatibility, ISV applications will improve their performance just by supporting Solaris SPARC.
Oracle’s SPARC Servers with Oracle Solaris
Co-Engineered for Performance and Efficiency