msgbartop
News, views, tips and tricks on Oracle and other fun stuff
msgbarbottom

Five Features You Ought to Know About the Oracle Scheduler

I really enjoyed Kscope last week. It was educational, entertaining and social. Many thanks to ODTUG and the Oracle ACE program and to everyone who made it happen.

Check out Markus‘s awesome Flickr album to get a taste of how good the conference was, especially All Aboard The Queen Mary event. :)

My presentation went very well, judging from the postive feedback I got from the audience. Here is the paper that I submitted to Kscope:

Continue reading…

Comments Off | Filed in Oracle | Tags: ,


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:

Continue reading…

2 Comments | Filed in Oracle | Tags: ,


Oracle to announce big data accelerator that has something to do with Hadoop?

Mark Fontecchio:

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: ,


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: ,


For 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:


Gathering fixed object stats may reduce recompilation time post Oracle upgrade

Mike Dietrich:

In 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;
Comments Off | Filed in Oracle, Tips


Best Practices for Oracle E-Business Suite Performance Tuning

Steven Chan:

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: , ,


Oracle 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: ,


Where All Oracle Professionals Should Be Between June 26-30 2011

I'm speaking at ODTUG Kscope11

Kaleidoscope 2011, the Oracle Development Tools User Group‘s annual conference, is where you should be. It will be held in Long Beach, CA.

Register now to take advantage of 250+ technical sessions featuring top-notch speakers including 40+ Oracle ACEs.

I will be presenting about the Oracle Scheduler. Here are the details:

Title: Five Features You Ought to Know About the Oracle Scheduler (Abstract ID:239756)

Date and time: 06/29/2011, 11:15 AM-12:15 PM

Abstract:

DBMS_JOB was made available with Oracle 7.2 and has been superseded in 10g by the Oracle Scheduler. Oracle recommends that you switch from DBMS_JOB to Oracle Scheduler.

In this session we will explore the following five Scheduler features that make the Oracle RDBMS the most powerful scheduling tool ever existed:

  1. Calendar: Use the rich calendaring syntax of the Scheduler to enable you to define simple and complex schedules.
  2. Chains: Implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.
  3. Resource Manager: Get the best out of your system by combining the Scheduler and the Resource Manager.
  4. Events: Learn how to schedule jobs based on events and how to listen and react to raised events.
  5. External jobs: Schedule jobs that run operating system executable that runs outside the database.

I will also be participating in an Oracle RDBMS Database Development panel in a Lunch and Learn session on Tuesday, June 28.

Looking forward to seeing you at ODTUG Kscope11.

Comments Off | Filed in Oracle | Tags: ,


Oracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms

Andries Hanekom:

The E-Business Suite Technology Group recently released a whitepaper: Extending E-Business Suite 12.1.3 using Oracle Application Express. In summary, “This new whitepaper outlines how to extend Oracle E-Business Suite 12.1.3 (and higher) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail.” For some time now EBS customers have used APEX to extend EBS, with the release of this whitepaper the EBS Tech group has acknowledged the growing use of APEX to extend EBS and have provide recommendations and guidelines for integration.

What’s this all about some might ask, is Oracle moving to incorporate APEX as part of the standard EBS tech stack? What about OAF? Isn’t Fusion Applications build on ADF, so what’s up? Well when it comes to Oracle EBS extension and customization, OAF is till the top dog, the E-Business Suite Technology Group continues to recommend OAF for EBS extensions.
Comments Off | Filed in Links, Oracle | Tags: , , ,