I was doing an Oracle database 11g release 2 upgrade for a client at the weekend. As part of this process there is a pre-upgrade script you have to run called “utlu112i.sql”. When I ran the script, I got a warning message saying: WARNING: –> There are materialized view refreshes in progress… Ensure all materialized … Read more
As described in the first article in this Oracle DBA 101 series (which you can read here), an Oracle instance consists of the background processes and the Oracle memory structures used when the database is running. In this article, we’ll go into more detail about the memory structures. The Oracle Memory Structures There are two … Read more
If you asked a selection of people, “What is an Oracle database?” you’d probably get a range of answers as there is some confusion about what exactly it is and people often mix up their terminology. Oracle Database Tutorial In this article, the first in a series of introductory Oracle training articles that will eventually … Read more
I got a support call late last Friday afternoon (why do most call seem to come on a Friday afternoon just before you finish for the weekend?) about bad performance on one of our applications we host for a customer.
When I logged into the server and took a look at what it was doing, the CPU was getting hammered by the Oracle SMON process.