Monthly Archives: November, 2017

Oracle Database Cloud: Supported Database Editions and differences

Oracle cloud offers best-in-class services across

  1. Software as a Service (SaaS),
  2. Data as a Service (DaaS),
  3. Platform as a Service (PaaS), and
  4. Infrastructure as a Service (IaaS).

Oracle database cloud comes under oracle PaaS vertical.

Oracle Database cloud supports below database editions:

  1. Standard Edition (SE)
  2. Enterprise Edition (EE)
  3. Enterprise Edition – High Performance
  4. Enterprise Edition – Extreme Performance

Below is the difference between these 4 packages:

Standard Edition: Oracle Standard edition is offered as part of this

Enterprise Edition

  • Oracle Enterprise Edition
  • Data Masking and Subsetting Pack
  • Diagnostics and tuning packs
  • Real Application Testing (RAT)

Enterprise Edition – High Performance:

  • Enterprise Database +
  • Multitenant
  • Partitioning
  • Advanced compression
  • Advanced security
  • Label security
  • Database Vault
  • OLAP
  • Advanced analytics
  • Spatial & Graph
  • Database Lifecycle Management pack
  • Cloud Management pack for Oracle database

Enterprise Edition – Extreme Performance:

***This is the only choice for RAC instances in cloud.

  • High Performance Package +
  • RAC
  • In-memory database
  • Active Data Guard
Advertisements

query to find whether an object is table or view in postgresql

Postgresql has a default schema named information_schema, which consists of a set of views, that contain information about the objects defined in the current database.

Query:

select * from information_schema.tables where table_name like ‘%<object name>%’;

tables: This view contains all tables and views defined in the current database.