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 […]
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 […]
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. […]
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 […]
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, […]
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 […]
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 […]
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.. […]