Symposium Sunday at ODTUG Kscope 11
I am currently in Long Beach, California for the Kaleidoscope 2011 conference. I attended the Database Development Symposium today (Sunday), which Chet volunteered to put together. It was an all day event and it was great. Here is a very brief summary of the presentations:
2 Comments | Filed in Oracle | Tags: kscope, odtugOracle to announce big data accelerator that has something to do with Hadoop?
CEO Larry Ellison added that Oracle plans announcements around Exadata this fall, presumably at Oracle OpenWorld. It seemed like Ellison couldn’t wait to spill some of the details. He said the company plans on announcing some kind of in-memory accelerator for Exadata in the fall, as well as a big data accelerator. From how Ellison was speaking, it seemed like the big data accelerator will have something to do with Hadoop.2 Comments | Filed in Oracle | Tags: hadoop, oow11
All you need to know about the Oracle ACE program
@LydiaSmyers interviews @oracletechnet about the Oracle ACE program (via @alexgorbachev)
Comments Off | Filed in Oracle | Tags: ace, videoFor those of you keeping the faith with Oracle EBS 11i, it’s time to upgrade
Floyd Teter on Oracle E-Business Suite:
Here’s the upshot for those of you “keeping the faith” with 11i. The iceberg is melting, the curtain is coming down, the lights are dimming, the fat lady is singing. The later versions of 11i were good things…we got bundles of value out of 11i…but, like it or not, it’s winding down in favor of a better product in R12.1.3. It’s time to upgrade. Frankly, the longer you keep the faith with 11i, the more you’ll miss out on the value of the new products…and the more it will cost when you do make the move.Comments Off | Filed in Oracle | Tags: EBS
Gathering fixed object stats may reduce recompilation time post Oracle upgrade
Comments Off | Filed in Oracle, TipsIn larger sized databases with many objects and components our recommendation is always to gather first fixed object stats prior to start the recompilation. Some time ago I’ve learned from to very different customer database projects that these stats will speed up the efficient job creation for recompilation. And last week I’ve got this feedback from an EBS 9.2.0.8 to 11.2.0.2 upgrade project:
- Approx 120,000 objects invalid post database upgrade
- Recompilation without fixed object stats: 14:44 hrs
- Recompilation with fixed object stats: 12:09 hrs
Time it took to gather fixed object stats: 00:07 hrs- Benefit: 7 minutes to gather fixed object stats decreased the recompilation time by 2:35hrs
(or by 18%)
- How to gather fixed object stats in Oracle 11g:
SQL> exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
Best Practices for Oracle E-Business Suite Performance Tuning
Isam Alyousfi and Lester Gutierrez are key members of our Applications Performance Group. They recently presented their popular session covering performance tuning tips for all layers of the E-Business Suite at OAUG/Collaborate earlier this year. [...] This presentation is chock full of tips, pointers, and hard-won knowledge. It represents the distillation of countless performance-related Service Requests and customer escalations. If you’re grappling with performance issues in your environment, or simply trying to squeeze more performance out of existing hardware, I’d strongly recommend downloading this presentation.
Tuning All Layers Of E-Business Suite – Performance Topics
Comments Off | Filed in Oracle | Tags: EBS, performance, presentationOracle Pre-Upgrade Utility
This is a guest post by David Clement, a veteran database engineer and a friend of mine. You can find him online at davidclement.org.
A handy feature that I’ve just found out about is that there is a link from Metalink document 884522.1 to the Oracle Pre-Upgrade Utility. You can get the utility without downloading the entire installation set and unpacking it.
For me, the easiest way to use the utility is to invoke the non-XML version from SQL Plus. For example:
SQL> conn sys/<password>@<tns_entry> as sysdba
SQL> spool utlu112_prereqs.out
SQL> @@utlu112i
....
SQL> spool off
The utility checks some interesting things:
- your core tablespaces, including System, Undo, Sysaux, and Temp;
- your init.ora parameters, to detect obsolete and deprecated parameters and hidden parameters;
- your timezone file;
- your dictionary statistics.
If you did unpack the entire installation set, the utility script is in rdbms/admin.
2 Comments | Filed in Oracle | Tags: 11g, upgrade
