In this article you will learn how Oracle 12c dynamic sampling works. Cases where it helps the optimizer do good estimations as well as cases where it doesn’t will be presented. Only single table sele...
Role transitions are no more complicated starting from Oracle Database 12c. Role transition, basically, comprises switchover and failover. Using the previous release role transitions, in order to perf...
Introduction You’ve probably been reminded very often that force logging is important in a Data Guard configuration and have also been warned about the dramatic consequences that might happen in a dat...
There are mainly three problems that database SQL optimizer cannot find the best way to process your SQL statements. Cost estimation error The cost estimation error is not only caused outdated stat...
Some days ago Michael Abbey invited me to a dinner (René Antunez Oracle ACE, also was there) in his apartment in Ottawa. He is such an admirable person, he is also an Oracle ACE and he likes to share ...
In SQL Optimizer for SQL Server we have built a very useful test run wizard (see my blog post Test Running a Tuned SQL is Not An Easy Job”) to help users select the best SQL alternatives for their spe...
We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we came to the Provision Pluggable Databases page as seen below. Thi...
Some people still think that the ASM is which performs all IO activity of our database, I have seen several DBAs worried about to use ASM because of the database will have a new "IO Layer", that is a...
“Money is our madness, our vast collective madness. And of course, if the multitude is madthe individual carries his own grain of insanity around with him. I doubt if any man living hands out a pound ...
Learn how to query data in Oracle Business Intelligence Enterprise through Toad Data Point....
I have heard many times from many DBAs that when a data block corruption happen in a disk which is part of a Diskgroup using normal redundancy, only the mirror block will take care of the coming datab...
A junior developer came to me recently and asked me a SQL transformation question. He gave me an example of a SQL statement similar to this one: select * from TableA A where A.KeyCol/10 = 12345 The p...
