Tagged: Oracle 12c

Oracle 12C: Full Database Caching

This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2) 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...

Setup Oracle 12c Enterprise Manager Express for a PDB

There are many articles on the web explaining how to create, duplicate or plug/unplug a Pluggable Database (PDB) into a Container Database (CDB), e remarkable new feature in Oracle 12c Database. A few of them show how to open and use the Oracle 12c Enterprise Manager Express, the new web graphical administration application created “out-of-the-box” in every Oracle 12c database. When you create a CDB during SW installation or using DBCA, Oracle automatically configures Oracle EM Express on port 5500, so you can access it typing in your browser: https://porfirio.localdomain:5500/em where “porfirio.localdomain” is the name of your host. Well, although...

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...

SQL DEVELOPER 4: NEW FEATURES FOR DBAS

The new Oracle SQL Developer 4.0 (released on december 2013) has some great new features for DBAs, as it becomes the main administration platform instead of Oracle Enterprise Manager Database Control for Oracle Database 12c. OEM Database Control is actually disappeared in Oracle Database 12c, because it is substituted by: – Oracle Enterprise Manager Express, web-based basic administration tool completely integrated into the DB – Oracle SQL Developer 4.0, java client full administration tool, automatically installed in any Oracle client and server installation Oracle SQL Developer 4.0 has a new DBA tab (Menu View -> DBA) from which you can...

Oracle 12c

Talking about Cloud means talking about consolidation. This process started with Oracle release 11g   virtualization that  allowed to share  servers and their resources. When the company will shift their mind from a traditional management  concept  to the Cloud, Oracle 12c with the new multitenant architecture will supply this requirement based on  reliability and scalability. The multitenant architecture simplifies  consolidation process in the Cloud. Starting from Oracle 12c it is possible to manage many  databases  as one, without any change in the application management. Perform an upgrade or database patching has the advantage of being able to be made one for...