There are situations where approximate results are superior than exact results. Typically, this is the case when two conditions are met. First, when the time and/or resources needed to produce exact results are much higher than for approximate results. Second, when approximate results are good enough. Approximate results are for example superior in case of exploratory queries or when results are displayed in a visual manner that doesn’t convey small differences.
Version 12.1.0. (more...)
This is the fifth part of this installment, and before coming to comparisons to other cloud providers, in this part I show the results of the read-only test that I've already described in part three
of this series, but repeated at a later point in time. The test setup was identical and can be checked in the mentioned previous part.
The reason for running the test again was the fact that I was informed during (more...)
The aim of this post is to summarize the knowledge about the 12.1 and 12.2 adaptive query optimizer configuration that, as far as I know, is spread over a number of (too many) different sources.
First of all, let’s shortly review which adaptive query optimization features exist:
- Adaptive plans, which are only available in Enterprise Edition, include adaptive join methods (the ability to switch the join method from a nested
loops to a (more...)
This is the fourth part of this installment, comparing the performance consistency of the DBaaS cloud offering with a dedicated physical host. This time the previous read-only test was modified to be a 100% update read-write test. So every row read was updated in the following way:begin loop for rec in ( select /*+ index(t_o) (more...)
This is the second part of this installment, comparing the performance consistency of the DBaaS cloud offering with a dedicated physical host. This time instead of burning CPU using a trivial PL/SQL loop (see part 1
) the test harness executes a SQL statement that performs logical I/O only, so no physical I/O involved.
In order to achieve that a variation of Jonathan Lewis' good old "kill_cpu" script got executed. In principle each thread performed (more...)
You can use the Oracle Documents ipad app to interact with the Documents Cloud Service. Go to the app store and search for ‘Oracle Documents’, you will find the Oracle Douments application, get and install the app to your ipad.
The app would like to send you notifications, after that you will also have to accept the License Agreement.
When the app starts up, you will get a quick tutorial to tell you the basics (more...)
The process of requesting a Cloud product is pretty straight forward, however, you can experience some hiccups as well. So for my future self and anyone wondering about this process here is what to do. First of all, decide what product you want to request after going to the Oracle Cloud page
I am requesting a Platform (PaaS) Service, so Sites will be visible under the Platform Section. You can either click Sites or Documents, (more...)
In October after OOW15 I wrote in one of my blogs about Microsites with SCS on top of DCS
. Now that both Documents and Sites are available for trial, I thought it was time to give it a try and start building a microsite.
The plan is to create a series of blogs about both Document Cloud Services (DCS) and Sites Cloud Services (SCS). From requesting the product, to building the microsite.
In the first (more...)