Author: admin

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 other attributes specific to a partition segment. Using Reference Partitioning: Range partitioning is useful when you have distinct ranges of data you want to store together. The classic example of this is the use of dates. Here an example: Creates a table of four partitions,...

Oracle Database

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 tablespaces. The only attribute you can specify for hash partitions is TABLESPACE. All of the hash partitions of a table must share the same segment attributes (except TABLESPACE), which are inherited from the table level. Using Reference Partitioning: Hash partitioning is useful when there is...

Oracle Database / Oracle VM

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 Line Interface Usability:...

Oracle Database

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 for the button As we developed the following Download the script that contains: – create job – enable the job created Out of scope: – Create scenario propaedeutic for the job, in this case the scenario calls PKG_ALLINEA_CASSE (see ScenarioName tag)

Oracle Database / Oracle VM

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

Oracle Database

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

Cloud / Oracle Database / Oracle Database 12 c

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

Oracle Database

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

Oracle VM

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

Oracle Database

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