Category: Oracle

Database
Oracle
Oracle Cloud Infrastructure (OCI)
April 9, 2018

Oracle 18c: Larry Ellison and the Autonomous Database

Although Larry started his presentation last week with a small faux-pas and members of the audience had to wait for the correct slides, waiting is definitely not something customers can expect from the Oracle Cloud with the new 18c Database. Everything will be better, faster, and most importantly “self-driving”. Highlights of the launch featured the […]

Read More
Database
Oracle
Oracle Cloud Infrastructure (OCI)
December 14, 2017

Create a physical copy of your local database in Oracle Cloud Infrastructure with no backup.

The focus of this article would be cloud specific steps rather than repeating already well known steps in the net.Its purpose is only to give you an idea for an use case and should not be used in a production environment. The high level setup: Source:Two nodes (VirtualBox) Oracle Linux 7.Oracle Grid Infrastructure 12.2 .Oracle […]

Read More
Database
Oracle
November 24, 2017

Oracle Standalone DB -> RAC + Standby Migration

High Level Project description In this article we describe migration of Standalone Oracle DB to 2 Node RAC with Physical Standby, from one datacenter (DC1) into another datacenter (DC2) without direct connectivity between the datacenters. The goal is to switch to DC2, and in DC2 “RAC primary + standby” configuration needed to be activated immediately. […]

Read More
Oracle
Oracle Cloud Infrastructure (OCI)
November 14, 2017

OCI command line setup and some interesting features

This article shows how to install and configure OCI command line under Linux OS. It also covers some features that may ease your life when using the tool like: profiles, output filtering, generating and reusing templates for creating objects in the cloud. Install. The “new” OCI command line tool is actually a next version of […]

Read More
AWS
Benchmarking
Oracle
October 30, 2017

Oracle Cloud Infrastructure vs AWS. NVMe SSD test for MemSQL use case – 2

One of the big use cases for Oracle Cloud Infrastructure (OCI) formerly known as Baremetal Cloud is noSQL and newSQL. Oracle says what big advantage on storage layer would be PCIe based NVMe SSD with super low latency. And elimination of virtualization layer would let it shine at full. While MemSQL row store is in-memory, […]

Read More
Database
Oracle
November 20, 2016

How to make partition elimination/pruning to work

If you have situation when partition elimination/pruning does not work, here are couple effective tricks to fix it. 1. If query derives partition key from sub-query, for example (query where sale_date is a partition key): Replace sub-query with DETERMINISTIC function: In most cases it should not be differences between sub-query and function. But there are […]

Read More
Database
Oracle
October 25, 2014

ORA-01555 on standby

If you see “ORA-01555: snapshot too old” from Select what is been run on Physical standby, but same select runs on primary just fine, and all relevant init.ora parameters and undo tablespace are exactly identical between primary and standby,- its odd. But its easy to explain. First check if DB is below 11.2.0.3 DB it […]

Read More
Oracle
Performance Tuning
June 3, 2012

Index Clustering factor. One way how to avoid negative performance impact on joins which involves bad clustered indexes.

High Index Clustering factor is popular problem in SQL world.The most known solution for it – rebuild table ordering by columns what are in the index.But in real world, with table size growing exponentially its not always practical or possible to do it. Here is one way to avoid index clustering problem by SQL optimization.. […]

Read More