Re: SQL query
Date: Thu, 2 Dec 2010 03:55:09 +0000 (UTC)
Message-ID: <pan.2010.12.02.03.55.08_at_gmail.com>
On Wed, 01 Dec 2010 10:12:04 -0800, joel garry wrote:
> I disagree with Mladen as to the amount of information from Oracle
> dropping. It's always been difficult - I remember being amazed at a 7.1
> (I think) Installing Oracle on AIX manual having so much more than all
> the others. However nowadays there are a lot of people willing to
> invest time and energy to figure out a lot of complicated things.
> Postgres may seem more open in that sense because it is at a lower stage
> in its lifecycle and the people working on it are likely to be more
> homogenous bleeding edge types. That's cool and all, but it means some
> or many of the pilot projects may be dumped not long after
> implementation by COTS. Mladen, I hope you hang around, even if it is
> to show us things that are better.
Oh, I will be hanging around, Oracle is still my bread and butter, but I
started disliking the company.
There is no more sense of community, OUG meetings are now a sheer
marketing push, without any really useful technical information. I
disagree with your assessment that it was always this difficult to get
the relevant information. RBO was well explained and easy to understand.
Without buying Jonathan's book and reading articles from Richard Foote
and Wolfgang Breitling, one stands no chance of understanding CBO.
Processes are still not documented anywhere except in the book by Tom
Kyte. Nobody really bothered to explain what is going on with new RAC and
why are there several new processes.
In the old days, there was at least readiness to help you out. You could
talk to your rep and he or she would find someone who understands your
question and would try explaining it to you. I was once put in contact
with Ken Jacobs, no less.
I do have feeling that the information is doled out to the privileged few
and that there is no longer willingness to share the internal information
or to make necessary tools available without exorbitant fees. My pet
peeve is the AWR report.
As for Postgres, it is still very far from being a plug in replacement
for Oracle, but it is good enough for applications that are not large
scale. The community is vibrant and the overall experience is rather
good. I see more and more of rather distinguished Oracle hacks taking
part in the discussions on the PostgreSQL forums. Overall experience is
rather enjoyable.
-- http://mgogala.byethost5.comReceived on Wed Dec 01 2010 - 21:55:09 CST