Archive for the ‘ORACLE Database’ Category

Oracle Database – total size of the database

Dienstag, Januar 1st, 2019

Oracle Database – consists of data files, redo log files, control files, temporary files and the size of the database actually means the total size of all these files

select
( select sum(bytes)/1024/1024/1024 data_size from dba_data_files ) +
( select nvl(sum(bytes),0)/1024/1024/1024 temp_size from dba_temp_files ) +
( select sum(bytes)/1024/1024/1024 redo_size from sys.v_$log ) +
( select sum(BLOCK_SIZE*FILE_SIZE_BLKS)/1024/1024/1024 controlfile_size from v$controlfile) „Size in GB“
from
dual

Oracle Database 18c Express Edition (XE) 18.4.0.0.0 – is a free community supported edition of the world’s most popular Database

Montag, Dezember 31st, 2018

Oracle Database 18c Express Edition (XE) – CPU and memory limits have doubled to 2 CPUs and 2 GB of RAM and is the ideal way to get started

Oracle Cloud ‚Pricing Calculator‘ – estimate your monthly usage with the cost estimator

Mittwoch, Dezember 12th, 2018

Oracle Cloud ‚Pricing Calculator‘

Oracle Lifetime Support Policies – October, 2018 for Database Releases

Dienstag, Oktober 30th, 2018

Oracle Database 12c 12.1 – the Extended Support fee has been waived to July 31, 2019

Dienstag, Oktober 30th, 2018

Oracle Software Technical Support Policies (Effective Date: 04-October-2018) – the Extended Support fee has been waived for the period of August 2018 – July 2019

Oracle Executive Chairman & Chief Technology Officer Larry Ellison – Oracle OpenWorld 2018

Freitag, Oktober 26th, 2018

Oracle Database 18c (18.3) – technical architecture

Mittwoch, September 26th, 2018

Oracle Database 18ctechnical architecture

Oracle Cloud Infrastructure for Enterprise – provides optimized solutions for disaster recovery, data protection, and an ability to more effectively access critical data for Oracle and non-Oracle workloads

Mittwoch, September 26th, 2018

Oracle Database 12c Release 2 – with the Cluster Health Advisor (CHA) that continuously analyses database ASH/AWR data and network, storage and O/S metrics to provide early warning and targeted resolution to over a hundred database issues

Samstag, August 11th, 2018

Oracle Database 12c Release 2 – to run Oracle RAC Databases in Docker Containers and why it was chosen over other virtualization technologies

Samstag, August 11th, 2018

Oracle Database 18c – Autonomous Transaction Processing (ATP)

Freitag, August 10th, 2018

Oracle Database 12c – converting a Two-Way Mirrored Storage Pool to a Three-way Mirrored Storage Pool

Freitag, August 10th, 2018

A Three-way Mirror adds additional IOPS per stored block and higher level protection against failures

calibrate_io.sql – attempts to measure random I/O performance with two numbers: maximum number of IOPS and average latency at which it is measured

ORADATA with Three-way Mirror
Max IOPS=212717
Max MBps=1371
Latency =1

ORADATA with Two-way Mirror
Max IOPS=178370
Max MBps=1278
Latency =1

Oracle Database – Release and Patching Model

Freitag, Juli 13th, 2018

Oracle Database 18c – is the first version of the product to follow a yearly release pattern

Samstag, Juli 7th, 2018

Oracle Private Cloud Appliance (PCA) – die Installation für die Universitätsklinik Essen

Samstag, Juni 30th, 2018