Tag: Oracle

Log Buffer #202, A Carnival of The Vanities for DBAs

Welcome to Log Buffer, the weekly roundup of database industry news. We’re only a week or so away from Oracle OpenWorld. Everyone is buzzing with activity, promoting their speaking sessions and making last minute plans. For all of you bloggers who will be attending, don’t miss the annual Bloggers Meetup, announced recently by Alex Gorbachev. “Count yourself in” if you’ll be joining the gang so that accurate attendee numbers can be provided to Jillian’s to ensure everyone is well fed and watered ;)

Read More >

A Grand Tour of Oracle Exadata, Part 3

Welcome to the third installment of a series describing the Oracle Exadata platform. In part 1 we talked about hardware components, and in part 2 went on to discuss software. We now move on to how these components are packaged and licensed.

Read More >

EBS DBAs Be Warned! NOLOGGING Can Hit You Badly …

I’ve just come across an old known issue again today. Was working in the greatest and latest 12.1.2 Oracle e-Business Suite environment. Surprisingly, I face the old issue when WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES objects (among other objects) are set to NOLOGGING mode. The easiest solution is to switch the whole database to FORCE_LOGGING mode:

Read More >

Oracle Setting High Naming Standards

As part of my preparation for the Exadata OCP Exam, I was reading through the “Oracle® Exadata Storage Server Software User’s Guide”. I found the two famous events in the Exadata world, “db file scattered read” and “db file sequential read” that cause so much confusion, have been renamed to “cell multiblock physical read” and “cell single block physical read” accordingly. Hopefully Oracle will port those events’ names to the RDBMS world as well in version 12c.

Read More >

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.

Read More >

Ensuring Table With 1 Row in Oracle 11g Using Virtual Column

There was a discussion on the OTN General database forum, in which the OP asked creating a table with just one row and restricting that table to just one row. Here is my attempt at it.

Read More >

Oracle-Related Events in Sydney Area (September 2010)

If it happens and you are in and around the Sydney area 1-2 weeks from now then you might be interested in taking part in these events.

Read More >

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.

Read More >

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.

Read More >

Oracle Exadata HCC Removes the 255 Columns Limit

As a follow up from my previous post on Exadata Design, where I question the use of dimensions for certain attributes in data warehouses, I figured I should test whether HCC works with tables that have more than 255 columns, It does. Here’s my test case.

Read More >
Page 64 of 141« First Page...10...6263646566...70...Last Page »