Database oracle

What is cloud computing?

Aspects and definition of the SaaS, PaaS, DaaS, IaaS platforms. What is cloud computing? Possibility of relying on a specialized provider for the management of one or more IT resources that, from that moment on, are provided via the Web through an outsourcing contract. All this, without the company having to bear the costs of purchasing licenses or machines to take advantage of services indispensable to the business. the supplier to maintain all the infrastructure necessary to manage and distribute the services based on the request (on demand) and with a pay per use formula. All with a subscription to Read More

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. Starting in Oracle Database 12c the multithreaded database model was introduced, enabling database processes to be executed as operating system threads and reducing the number of dedicated process necessary to manage database services. By default, every new 12c instance is created to Read More


PART 1 LINK Oracle VM 3-4-2 Oracle VM Manager 3.4.2 supports current and previous Oracle VM Server releases. Part 2 You can use Oracle VM Manager 3.4.2 to manage Oracle VM Server Release 3.4.x, 3.3.x, 3.2.10, or 3.2.11. If Oracle VM environment consists of Oracle VM Manager Release 3.4.2 and one or more instances of Oracle VM Server at a different release, you should review the list of supported and unsupported operations and features, as follows: Supported Operations Oracle VM supports most common operations when using Oracle VM Manager to manage an instance of Oracle VM Server that is at Read More

DB_ULTRA_SAFE parameter

DB_ULTRA_SAFE is a new parameter introduced in 11g. It provides an integrated mechanism to offer protection from various possible data corruptions. and provides critical high availability benefits for Oracle Database. Setting DB_ULTRA_SAFE initialization parameter will configure the appropriate data protection block checking level in the database. It will control DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, and DB_LOST_WRITE_PROTECT. DB_BLOCK_CHECKING controls whether or not Oracle performs block checking for database blocks. DB_BLOCK_CHECKSUM determines whether DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk. DB_LOST_WRITE_PROTECT enables or disables lost write detection. Read More

ORACLE – VM 3.4.2

During Oracle OpenWorld 2016, the company has announced new version (3.4.2) of their virtualization platform Some of the key new features that have been delivered include: Oracle VM Manager support for previous Oracle VM Server releases: – Manage Oracle VM Server for x86 – 3.4.x, 3.3.x or 3.2.10/11 releases. – Manage Oracle VM Server for SPARC – Agent 3.4.x or 3.3.x releases. Support for NVM Express (NVMe) devices: – Discover NVMe devices and present them to Oracle VM Manager – NVMe devices can be used to store virtual machine disks or create storage repositories. Extended SCSI functionality available for virtual Read More

ORACLE 12C : Extended Data Type

With the previous Oracle database release, long characters strings of more then 4000 bytes had to be handled using CLOB or LONG data types. Starting from Oracle 12c was introduced a new system parameter: MAX_STRING_SIZE. This parameter allows string data types to be much larger when the parameter is changed from its default value STANDARD to EXTENDED. New higher limits (in bytes) are available for following types: – VARCHAR2 – 32767 bytes – NVARCHAR – 32767 bytes – RAW – 32767 bytes To use extended version you need to set new initialization parameter MAX_STRING_SIZE and run sql script utl32k.sql. Set Read More