Yesterday I returned from a trip to Amsterdam where I presented about Grid Infrastructure 11.2 as part of Logica’s Guru 4 Pro series. I have to say it has been a very pleasant experience! And it marked the first time I presented outside the UK as well. Logica Holland runs a series of events where [...]
Previous to Oracle 11g Rel 2, two very common and useful features previously worked well together, they being fast refreshable materialized views and the introduction of virtual columns due to the creation of function-based indexes. To illustrate, we create and populate a little demo table: SQL> create table bowie (a number, b number, c number); [...]
In answer to a friend request, just two pointers:
Lucas Jellema rss feed reader with several commentaries to improve the code
Tyler Muth rss producer
Do you know of others?
Just a quick note about the Oracle Database 11g Interactive Quick Reference That was released today to the public. This Interactive Quick Reference, created by Oracle University and the Server Technology Curriculum group, is your Essential Guide to Oracle Database 11g Release 2. This interactive quick reference includes an architecture diagram, a comprehensive list of [...]
I have often said that the optimizer “forgets” that it is dealing with a distributed query once it has collected the stats that it can about the objects in the query, and that as a consequence the driving site for a distributed query will be the local database unless you use the /*+ driving_site */ [...]
Very often in these forums I get asked the question regarding data types which GoldenGate supports or Oracle software versions or questions like can it work with a database running in NOARCHIVELOG mode or does it support Partitioned and Index Organised tables and so forth.
I have included some snippets taken from the official documentation as well as some of my own experiences and hopefully it will help answer many of the those frequently asked questions.
What Oracle Versions are supported?
Oracle 9.2 and above, Oracle 10.1 and 10.2 and Oracle 11gR1 and 11gR2
A lot of people have started seeing “asynch descriptor resize” wait event in Oracle 11gR2. Here’s my understanding of what it is. Note that I didn’t spend too much time researching it, so some details may be not completely accurate, but my explanation will at least give you an idea of why the heck you [...]
Any DBA worth the time of day knows how important having solid statistics is to a database. This is how the cost based optimizer is able to make solid decisions about the best path to take when performing a table scan, choosing an index, the amount of resources required to perform a task and so [...]