Oracle

Exadata Customer Case Study at Oracle OpenWorld

As I work on putting together slides, I’d like to remind you all of my Oracle OpenWorld 2010 presentation, a customer case study migrating a complex data warehouse environment to Exadata. I’ll be presenting along with Michael Aldrich of LinkShare and Aiman al-Khammash of Oracle, and focusing on our own experience with Exadata, lessons learned, and advice for others choosing to implement Exadata.

How to GNS process log level for diagnostic purposes?

I was troubleshooting a new GNS (Grid Name Services) functionality and noticed a-trace-level parameter in the GNS process string. Unfortunately there is no description in the documentation or MOS on how to change it to generate invaluable diagnostic information. NOTE: I am sure the documentation will be updated in Database 12c version (c for Cloud. For the time being the following should work for you.

Bloggers Meetup @ Oracle OpenWorld 2010

It’s that time of the year again — Oracle OpenWorld time — and it’s my pleasure to announce our regular Oracle bloggers meetup again this year. We all know that Oracle community has grown this year so we expect to see folks from all the different technologies including MySQL, Java, Sun hardware folks in addition to the core Oracle database and apps crowd.

Michigan OakTable Symposium (MOTS)

Michigan OakTable Symposium (MOTS) is a unique event taking place just before Oracle OpenWorld — 16-17 September. Why unique? This is the first conference (is it not?) where all presenters are members of OakTable Network, a group that gathers number of like-minded IT professionals with scientific approach to Oracle database technology and to the life in general.

Exadata storage server software 11.2.1.3.1 released

As of this afternoon, version 11.2.1.3.1 of Oracle’s Exadata storage server software, is out in the wild. This is the first publicly available version of the 11.2.1.3 branch, a major release including a full OS image with an update to Oracle Enterprise Linux 5.5. A number of bugs causing cell server crashes and hangs have been fixed, including 9472035, 9870117, and 9722560.

Oracle feature request #94739: CTAS optimizer statistics

en creating an index, Oracle versions 10g and above automatically compute optimizer statistics. And even before that, 9i had a COMPUTE STATISTICS clause to accomplish the same thing. Not only does it save the time and effort of running DBMS_STATS, but it also saves the disk I/O involved in such an operation, since all rows are available in the course of index creation.

Designing for Exadata: Maximizing Storage Indexes Use

Oracle Exadata V2 is a very well balanced database machine combined with smart and innovative software. One of these innovative features is the Storage Index – a game changing feature in my opinion.As with any feature, there are intended use cases, limitations and caveats. Use it right, and amazing performance gains can be achieved. Use it wrong, and nothing will happen. This is what is great about storage indexes in particular. They are there, without any overhead. It’s only a question of how to leverage them, in addition or combination withevery other feature that Oracle Exadata has to offer.

Page 64 of 140« First Page...10...6263646566...70...Last Page »