Where All Oracle Professionals Should Be Between June 26-30 2011
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:
- Calendar: Use the rich calendaring syntax of the Scheduler to enable you to define simple and complex schedules.
- Chains: Implement dependency based scheduling, in which jobs are started depending on the outcomes of one or more previous jobs.
- Resource Manager: Get the best out of your system by combining the Scheduler and the Resource Manager.
- Events: Learn how to schedule jobs based on events and how to listen and react to raised events.
- 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: kscope, odtugOracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms
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.Comments Off | Filed in Links, Oracle | Tags: adf, apex, EBS, oaf
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.
Shell Script Output to Oracle Database Via External Table
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.
Sometimes code written in PL/SQL needs to test values in the operating system. However, Oracle tools such as sys_context do not support every possibility: you could not (for example) use sys_context or utl_inaddr to discover if the Internet Time Protocol was enabled.
Fortunately, there is a way to get the output of a shell script into an Oracle external table.
Here is an example with a trivial shell script. It is based on a Sun environment (and DB 10gR2) but could easily be adapted to Linux or another Unix. The steps are:
- Set permissions on some files in Oracle bin.
- Write a shell script in the right style.
- Create some Oracle objects, mainly an external table and a Scheduler job.
Here goes.
Comments Off | Filed in Oracle | Tags: dbms_scheduler, unix
