Blog

LIST-PARTITIONED
  • 7
    Feb

LIST-PARTITIONED

Introducing the topic: In list partitioning, the database uses a list of discrete values as the partition key for each partition. You can use list partitioning to control how individual rows map to specific partitions. By using lists, you can group and organize related sets of data when the key used to identify them is not conveniently ordered....

Read More
ORACLE 12 rel.2 – Partitioning new features
  • 5
    Gen

ORACLE 12 rel.2 – Partitioning new features

In Oracle 12c rel.2 a great number of enhancements to the Oracle database Partitioning option have been introduced. These include: Automatic List Partitioning Filtered Partition maintenance operations Multi-Column List Partitioning Online conversion of non-partitioned to partitioned table Read-only Partitions Partitioned External Tables Automatic List Partitioning: The ability to partition a table based on distinct values in a column...

Read More
ORACLE 18C – Autonomous Database Cloud
  • 6
    Dic

ORACLE 18C – Autonomous Database Cloud

At Oracle OpenWorld 2017, Oracle Chairman of the Board and CTO Larry Ellison unveiled his vision for the world’s first autonomous database cloud. Powered by Oracle Database 18c, the next generation of the industry-leading database, Oracle Autonomous Database Cloud uses ground- breaking machine learning to enable automation that eliminates human labor, human error and manual tuning, to enable unprecedented...

Read More
ORACLE 12C M.T.S. model
  • 22
    Nov

ORACLE 12C M.T.S. model

Until Oracle Database 12c, Oracle processes did not run as threads on UNIX and Linux systems. Every dedicated connection was represented by an operating system process. In systems where high workload was an issue, the only way to reduce CPU and memory usage was to switch from dedicated connections to shared connections using the multithreaded server (MTS) feature....

Read More