Tag Archive: Oracle Database 12c

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 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
ORACLE 12C :  Advanced Index compression
  • 7
    Gen

ORACLE 12C : Advanced Index compression

Oracle 12c rel.1 (12.1.0.2) introduced a new method for index compression called "advanced index compression" which is more effective in index compression than available methods in Oracle 11g . Creating an index using advanced index compression reduces the size of...

Read More
Create Oracle Database 12c
  • 18
    Lug

Create Oracle Database 12c

Below are described installation step of Oracle Database Database 12c on Oracle Enterprise Linux 6. New Pluggable Database Features is chosen below. Install_Oracle_database12c  

Read More