Category Archive: Oracle Database 12 c

Create Sequence-Oracle Database 12c
  • 1
    Mar

Create Sequence-Oracle Database 12c

Database version : from Oracle Database 12cR1 Create sequence with session or global option When a sequence number is generated, the sequence is incremented, independent of the transaction committing or rolling back. SESSION option makes opportunity to create sequence that...

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

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

Read More
Memory Resource Management for PDBs in Oracle Database 12c Rel.2 (12.2)
  • 13
    Giu

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

Read More