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 can used in association with global temporary table then its visibility is just for session.…
Leggi tutto
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…
Leggi tutto
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 unique and non-unique indexes. Advanced index compression improves the compression ratios significantly . Advanced Index…
Leggi tutto
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
Commenti recenti