Categoria: Oracle Database

RANGE-PARTITIONED TABLES

This topic contains RANGE-PARTITIONED TABLES that is available since Oracle 8i. 1. RANGE-PARTITIONED TABLES The PARTITION BY RANGE clause of the CREATE TABLE statement specifies that the table or index is to be range-partitioned. The PARTITION clauses identify the individual partition ranges, and the optional sub clauses of a PARTITION clause can specify physical and…
Leggi tutto


18 Settembre 2017 0

HASH-PARTITIONED TABLES

The PARTITION BY HASH clause of the CREATE TABLE statement identifies that the table is to be hash- partitioned. The PARTITIONS clause can then be used to specify the number of partitions to create, and optionally, the tablespaces to store them in. Alternatively, you can use PARTITION clauses to name the individual partitions and their…
Leggi tutto


5 Settembre 2017 0

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…
Leggi tutto


31 Luglio 2017 0

Calling an ODI Scenario from APEX

How to call scenario odi from apex application. Instead to open the client to execute the run of the scenario there is possibility to call odi scenario just using a button created into your application front-end apex. Objects to create – Job type PLSQL_BLOCK – Apex button to enable the job indicated Here the source…
Leggi tutto


17 Luglio 2017 0

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…
Leggi tutto


28 Giugno 2017 0

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…
Leggi tutto


20 Giugno 2017 0

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…
Leggi tutto


13 Giugno 2017 0

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…
Leggi tutto


26 Maggio 2017 0

ORACLE 12C: Dataguard Far Sync

Oracle Dataguard Far Sync instance is a new feature introduced in Oracle Database 12c, which simply works like a archive/redo repeater.. Far sync instance is something different than the Oracle Database instance, as its mission is accepting redo from the primary database and then shipping that redo to other members of the Oracle Data Guard…
Leggi tutto


9 Maggio 2017 0

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…
Leggi tutto


19 Aprile 2017 0