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 and, 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.
Viewing entries tagged
Very often and for several diverse reasons, information should be considered as “inactive” instead of “deleted.” One of the new functionalities introduced in 12c release is the “In-Database Archiving” feature, allowing this type of functionality as a standard component of Oracle Database Information Lifecycle Management (ILM) strategy. Using this new feature you can store “deleted rows” online (inactive information) for a long time without compromising application performance.
DBMS_COMPRESSION is a package used to manage the Oracle Database table compression feature. This feature lets you compresses data by eliminating duplicate values in disk pages. As database grows in size, table compression saves resources, not only disk storage but also reduces memory use in the buffer cache. First introduced in 11g R2, this package has been evolving, and some very useful enhancements were introduced now in 12c release.
Introduced in Oracle 12c release, it is possible to create partial indexes on a partitioned table. While a full index includes all partitions in a given table, a partial index just includes only partitions which are mark to be indexed during table creation process. This new 12c feature provides more flexibility with index creation and reduce storage utilization.
Written by Daniel Vukasovich on January 10, 2015
In 12c, Oracle has improved the DBMS_SCHEDULER package functionality adding some interesting and useful new features. One of this new features is the capability to run external scripts as part of our job action or even better the capability to write our own custom scripts and run them by invoking the shell interpreter (in case of unix environments) or the command prompt (in windows environments). This custom script can be directly writed inside the job definition.