DBORCLOUD Blog

Oracle VM 3.4.3

In recent weeks Oracle has released VM 3.4.3 The principal enhancements present in this release are: – Installation and Upgrades: – Simplified UEFI PXE Boot for Oracle VM Server – Infrastructure: – Support for Software RAID Devices with Oracle VM Server – Support for Microsoft Windows Server Failover Clustering – Update to Oracle VM Agent for SPARC – Update to the dom0 Kernel – Updates to Multipath Configuration for Oracle ZFS Storage Appliance – Performance and Scalability: – Improved Job completion performance – Improved Storage refresh performance – Improved Performance With Multiple Concurrent Connections to the Oracle VM Manager Command Read More

Interval Partitioning

Partitioning enables you to decompose very large tables and indexes into smaller and more manageable pieces called partitions. Each partition is an independent object with its own name and optionally its own storage. Now in 11g, Oracle introduced new partition type called INTERVAL PARTITIONING The INTERVAL clause of the CREATE TABLE statement establishes interval partitioning for the table. You must specify at least one range partition using the PARTITION clause. The range partitioning key value determines the high value of the range partitions, which is called the transition point, and the database automatically creates interval partitions for data beyond that Read More

Memory Resource Management for PDBs in Oracle Database 12c Rel.2 (12.2)

In the previous release there was no way to control the amount of memory used by an individual PDB. It could use up lots of memory and impact the performance of other PDBs in the same instance. Oracle Database 12c Rel.2 (12.2) allows to control the amount of memory used by a PDB. PDB Memory Parameters The following parameters can be set at the PDB level. DB_CACHE_SIZE : minimum buffer cache size for the PDB. SHARED_POOL_SIZE : minimum shared pool size for the PDB. PGA_AGGREGATE_LIMIT : maximum PGA size for the PDB. PGA_AGGREGATE_TARGET : target PGA size for the PDB. Read More

Oracle 12c release 2: new features

Oracle introduced the long awaited Database 12c Release 2 earlier this year at OracleOpen World. Oracle just released Oracle Database 12c Release 2 for on-premises Linux and Solaris. Find below an incomplete list of the main new features: 1. Multi-Instance Redo Apply : With Oracle 12c Release 2, you can apply redo logs to multiple instance at the same time to improve recovery time objective. 2. Oracle Database Sharding : With Oracle 12c Release 2, you can horizontally partitioned data across many databases and present them as a single logical database to application. 3. Creating Data Guard Standbys With Database Creation Assistant : You Read More

ORACLE: OVMM 3.4.2

Oracle VM Manager 3.4.2 supports current and previous Oracle VM Server releases. You can use Oracle VM Manager 3.4.2 to manage Oracle VM Server Release 3.4.x, 3.3.x, 3.2.10, or 3.2.11. If Oracle VM environment consists of Oracle VM Manager Release 3.4.2 and one or more instances of Oracle VM Server at a different release, you should review the list of supported and unsupported operations and features, as follows: Supported Operations Oracle VM supports most common operations when using Oracle VM Manager to manage an instance of Oracle VM Server that is at an earlier release, for example, creating virtual machines Read More

ORACLE: UTL_MAIL

The UTL_MAIL database package is used to manage email. It allows you to send an email message directly from the database server, with cc and bcc, and also catering for RAW attachments. This package is not installed by default due to obvious security reasons, but needs to be installed manually via two scripts: utlmain.sql and prvtmail.plb, both of which are in the rdbms/admin directory under the Oracle Home. sqlplus / as sysdba SQL> @?/rdbms/admin/utlmail.sql SQL> @?/rdbms/admin/prvtmail.plb However, in the case of an Oracle 12c Database, it is not enough to run these scripts in the root container. You need to Read More