Oracle 12C: Full Database Caching

This feature is available starting with Oracle Database 12c Release 1 ( When to use it: when you have enough memory to keep all segments in memory when you are limited by I/O system and response time Full database caching can be used to cache the entire database in memory. It should be used when the buffer cache size of the database instance is greater than the entire database size. In Oracle RAC systems this feature can be used when the combined buffer caches of all instances, with some extra space to handle duplicate cached blocks between instances, is greater Read More

ORACLE DATABASE 12C: New Features for Oracle Database File System

Oracle Database File System (DBFS) was introduced in 11g R2 release on top of the XML DB (shortly, XDB) features. The concept is simple: DBFS is a tablespace whose contents are documents (specifically LOB columns) directly accessible (i.e. mounted) as an external file system. In Oracle 11g R2 the only way to do it is via FUSE (Filesystem in Userspace) software, only available for Linux and Solaris platforms. Moreover, the DBFS configuration and mount was a bit complex. Oracle 12c introduces support for HTTP, FTP and WebDAV protocols, simplifying the setup process and widening its accessibility. The DBFS creation process Read More