[wildmXranat]

What part of parent has not been your experience ?

I have experience parent's woes and more. That includes having Oracle staff in house doing in-person knowledge transfer. Experience says that Oracle will not provide a qualified person if we call for one as well. Sourcing from their own consultant pool is also a black box crap-shoot.

We also involved Dell and their support team to provide feedback and second opinion on Oracle CBO, query optimization and overall needed knowledge to use their Toad for Oracle performance tools. They literally stopped short of saying: yeah, you need people smarter than us for that.

I still think Oracle is a great product, but it's only fit for large organizations with bottomless budgets. I think we spent something north of $100K on Oracle's E-learning and that was probably the cheapest item on the list.

[needusername]

> What part of parent has not been your experience ?

We have several people in house (I know of 6) who can troubleshoot performance issues. For them the CBO is not a black box and they can explain what is happening and why.

I know of a local consulting company that has several very good people that you can "order". Said consulting company also offers very good CBO courses/workshops.

[chris_wot]

Really? I have a book on CBO performance troubleshooting from the foremost expert and even he says that he can't fully understand why the CBO does the things it does.

I doubt your in house experts fully understand the Oracle CBO. They may claim they do, but unless they have access to material that isn't public they can't possibly be able to diagnose the CBO fully.

You realise there are over a thousand hidden database parameters, right?