If you read my post Restoring Standby Database, you know that one of the problems I had was that the new control file refused to open the database with resetlogs
If you read my post Restoring Standby Database, you know that one of the problems I had was that the new control file refused to open the database with resetlogs
One of my clients is restoring their database backup to another server for some testing. They do it periodically so we can also verify that the backup is good (which
Even after years of working with something, you can always learn new stuff. Today I tried to create a standby database using the duplicate command. When you duplicate a database
Every day you can learn something new, even after 20 years in the field. For some reason, I was always under the impression that within a single schema, objects must
During OOW17 a customer ran into a wrong result issue in 11.2.0.4, which is very bad. I diagnosed this and found out that it happens because of bloom filter, so
When Oracle are adding a new feature to the database, they usually add a parameter to control it. Sometimes, after adding feature and the parameter, they realize that the parameter
Starting with Oracle 12.1 we can export views as tables. This means that the export will contains a “create table” command and its data, while the original object was actually
The LIKE operator is a very useful one. It is used to match strings with partial match while using the underscore (‘_’) as a single character wildcard and the percentage sign
When writing a query with order by, we can use the column position instead of its name. This order by”trick” is easy to use, but should be handled carefully as
Many people are using DBMS_STATS to gather optimizer statistics. This package has many different options, and I wanted to tell you about one option for disabling automatic statistics gathering. When we