Feed items
EBS DBAs be warned! NOLOGGING can hit you badly …
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 [...]
Oracle Setting High Naming standards (EVENTS “multiblock physical read” & “single block physical read”)
Hello Folks,
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” [...]
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 [...]
Ensuring Table With Only One 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.
I created a table with two columns, and the second column is a virtual column and [...]
Oracle-related events in Sydney area (September 2010)
Hello folks,
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 [...]
How to GNS process log level for diagnostic purposes (11G R2 RAC / SCAN / GNS) ?
Hello Everyone,
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.
# [...]
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 [...]
Shuck & Awe #11: Hunting for Perl
[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 #201, A Carnival of the Vanities for DBAs
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 [...]
Oracle Exadata HCC (Hybrid Columnar Compression) removes the 255 columns limit
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 [...]
