Hello Apps DBA,
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. Strictly speaking, the LOGGING attribute was set to YES at the table [...]
As part of my preparation for the Exadata OCP Exam – Oracle Exadata 11g Essentials (1Z1-536), I was reading through the “Oracle® Exadata Storage Server Software User’s Guide” (not available publicly at the moment as far as I know). I found that in the Exadata world the two famous events “db file scattered read” and “db file sequential read” [...]
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 [...]
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.
I created a table with two columns, and the second column is a virtual column and [...]
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 the following events:
The first event is organized by Oracle Community in Sydney (sponsored by Pythian), during the next Sydney Oracle Meetup. The good news is that you can have [...]
This is one of my fist posts under Pythian’s blog. I will try to keep those short and simple at the beginning.
Recently I was troubleshooting a new GNS (Grid Name Services) functionality.
For more information please see here: Oracle Clusterware Network Configuration Concepts.
I have noticed that there is a-trace-level parameter in the GNS process string.
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 [...]
[yanick@enkidu shuck]$ perl -V:news
Do you regularly scuba dive in a motley sea of other peeps’ codebase, trying to bring on surgical changes without doing too much collateral b0rking on the code formatting? If so, Steffen Mueller has a nifty trick to share with you. Using Text::FindIndent, he shows how to configure Vim such that it [...]
Log Buffer is the DBA community’s Carnival of the Vanities-style blog of blogs about the database world. It is the source DBAs and others interested in databases count on for weekly news of industry happenings, and what their colleagues around the world are working on.
This week’s edition, Log Buffer #201 has been compiled and [...]
There is a little know fact that Oracle table compression doesn’t work with tables that have more than 255 It’s has been reported here and compression limitations in general here.
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 [...]