view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Logica Guru4Pro – Amstelveen

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 [...]

11g Virtual Columns and Fast Refreshable Materialized Views (What In The World)

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); [...]

RSS and PL/SQL

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?

Oracle Database 11g Interactive Quick Reference

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 [...]

Distributed Queries – 2

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 */ [...]

Warning about whitespace and to_timestamp_tz

Quick post prompted by a stackoverflow question.

select to_timestamp_tz('11-OCT-10 04.59.59.999999999 AM -05:00',
                        'DD-MON-RR HH.MI.SSXFF AM TZR') ws,

Also Blogging at Pythian

I am also blogging at the Pythian's blog and you can access my posts here.

GoldenGate – What is supported and what is not ….

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

Asynch descriptor resize wait event in Oracle

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 [...]

The Problem with the Automated Statistics Gathering

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 [...]

view counter