Press Summary
Large SGA on 32-bit Redhat Linux
June 10th, 2010
Written by Centroid
Many DBAs are familiar with the SGA size limitations on 32-bit platforms. This post shows how to allocate a 3Gb buffer cache on 32-bit RHAS 3.
Step 1: Mount /dev/shm to as type ramfs. Edit /etc/fstab and add an entry like this:
none /dev/shm ramfs defaults,size=4G 0 0
Step 2: do a "mount -a" to mount /dev/shm. I use ramfs instead of tmpfs because it doesn't use swap; tmpfs does. With ramfs memory allocation will also grow dynamically, whereas when...
Receivable Commitments: Guarantee vs. Deposit
April 27th, 2010
Written by Centroid
I recently received a requirement to account for the entire deferred revenue amount of a sale, then recognize the revenue over time, based on consumption or clicks from a customer. Oracle Receivables has two "commitment" transaction classes to support this type of requirement.
The two commitment transaction classes are:
Guarantees: as you associate invoice transactions the amount due "moves" from the guarantee to the invoice associated to it.
Deposits: as you associate invoice transactions...
Using DBMS_SQLDIAG
March 3rd, 2010
Written by Centroid
As a DBA, have you ever had an issue you suspected may be a bug and have been asked to generate "test data" for Oracle development? We ran into this at a client recently and found a cool 11g utility (at least I *think* it's new :)) to get Oracle Support the data they need to reproduce the issue in-house.
The situation had to do with optimizer_features_enable being set to 11.1.0.7 in a database recently upgraded form 9.2.0.5 in an Oracle eBusiness Suite environment (11.5.10.2) that utilized...
Limiting Off-shore Outsourcing firms H-1Bs in the USA
June 9th, 2009
Written by Centroid
Recently "The Business Week" June 15, 2009 ran an article titled 'Taking AIM at outsourcers on US Soil' If passed, the bill would bar companies with more than 50 employees in the U.S. from landing any additional work visas if more than half their US workforce is made up of H-1B or L-1 visa holders. It definately appears there will be some controversy up on the hill. If acted upon it would put a stop to the addition of H-1B resources coming to the US. Senators Dick Durbin (D-Ill.) and Chuck...
Change Management
April 3rd, 2009
Written by Centroid
Change Management, the mere mention of these two words make people cringe.
To paraphrase Gordon Gekko,
Change is Good…Change Works.
In this bloggers' opinion, Change Management is a grossly misused, and misunderstood phrase.
At it’s core, Change Management should around change for the positive:
Does change Increase Revenue?
Does change Reduce Cost?
Does change Improve Efficiency?
Does it provide an environment for growth?
Etc.
Often during Oracle EBS implementations, we...
