Taggato: Oracle 12c

Oracle Database 12 c

Oracle 12C: Full Database Caching

Questa funzione è disponibile a partire da Oracle Database 12c Release 1 (12.1.0.2) Quando usarlo: quando si dispone di memoria sufficiente per mantenere tutti i segmenti in memoria quando si è limitati dal sistema I / O e dal tempo di risposta La memorizzazione nella cache del database completo può essere utilizzata per memorizzare nella cache l’intero database. Dovrebbe essere usato quando la dimensione della cache del buffer dell’istanza del database è maggiore della dimensione dell’intero database. In Oracle RAC sistemi questa caratteristica può essere utilizzata quando il buffer combinato di tutte le istanze, con qualche extra lo spazio per...

Oracle Database 12 c

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 12 c

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

Oracle Database 12 c

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 Database 12 c

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