May 15, 2009 Presentations

HP Scalable NAS for Oracle Solution

Don Sullivan, Hewlett Packard 

The HP Scalable NAS for Oracle Solution set consists of a variety of flexible configurations all of which simplify storage and server provisioning along with providing High Availability through a maximum of 16 NAS heads for storage access when running Oracle over NFS. The Enterprise Fileserving Cluster Gateway (EFS-CGW) includes Proliant servers, performing as the NAS heads, which run the HP Scalable NAS clustering software while allowing the customer to choose their own form of Storage. The NAS 4400 is an Oracle Ready storage appliance that includes Proliant Servers and an EVA 4400. Both of these solutions are managed through a single graphical user interface. The HP Scalable NAS software provides symmetrical multi-headed access to the entire logical storage array as opposed to the more well-known NAS paradigms, single-headed filers or asymmetrical multi-headed systems.  When using HP Scalable NAS the client system can access all data from all NAS heads at all times through customer defined virtual hosts. The administrator can create and extended volumes and filesystems in minutes through the GUI. Filesystems can be created to contain all Oracle related file types including database files, oracle binaries for the server and Oracle Applications, archive logs, RAC files, external tables, loader files and more.  The system supports both RAC and non-RAC implementations and is version independent. The use of Direct-NFS (DNFS) is also supported.

Conquering a Forest of Trees

Tammy Osborn

The presentation will provide a collection of tips and tricks gathered from various sources for developing Tree interfaces with JDeveloper 11G.  A step-by-step guide to “growing” a tree from a seed to a mature height will be included.

Migration of AOL objects using AppsMigrator GUI developed by iTerra Consulting for

FNDLOAD utility
Mark Mestetskiy,

AppsMigrator GUI tool offers Oracle APPS developers and analysts a convenient and efficient way to migrate AOL objects using Oracle FNDLOAD utility without the necessity to remember configuration files names/locations or FNDLOAD command syntax.

Oracle APEX / BI Publisher Quick Start

Ken Ramey,

Oracle Application Express (APEX) and Business Intelligence Publisher (BI Publisher) can be leveraged together for rapid development of user friendly applications with dynamic reporting.  While APEX provides an intuitive Rapid Application Development environment, BI Publisher provides the ability to create highly customized reports.  Combine the two and create robust applications.  Follow this guide to configure an APEX/BI Publisher environment and create an example application.

Can I Make XML Go Faster?

John King, King Training Resources

Oracle has been a leader in adding XML and XML processing to the database. In many cases XML performance is not what is desired. This session will discuss factors impacting Oracle XML performance and performance improvement. Topics include: choosing correct XMLType, SecureFile/BasicFile, XML indexing, XML document design, Insert/Update/Delete issues, SQLX functions, and PL/SQL functions.

De-supported Oracle Forms and Reports Puts Your Company at Risk

What version of Oracle Forms and Reports are you running your custom applications on?  If your answer is not 10g Release 2, then you are running on an unsupported technology stack.  This means that you are not getting support from Oracle on your software, but even worse you are not getting security patches applied to your environment.  This could mean you could be in violation of company or government mandates.

Unsupported Software Puts Your Organization at Risk €”Learn what it takes to get on a supported platform

New and Recent Features in Oracle Forms
Mike Mullennex, Oracle Corporation

You might be familiar with the new integration oriented features in Oracle Forms 11g such as support for Advanced Queuing, JavaScript and Proxy Users but did you know that you can perform remote debugging in Forms? Do you know about Form's support for Single Sign-on and Enterprise Manager? This session will go thru the very newest features in Oracle Forms 11g but also show the recently added features in 9i, 10g and 10gR2 that might have slipped you by.

Upgrade to Supported Version of Oracle Forms and Reports with PITSS.con

Come learn what it will take to get your application to supported Oracle Forms and Reports environment.  PITSS is the leader in Oracle Forms and Reports development and support.  Oracle considers PITSS the leader in Oracle Forms migration and maintenance.  Learn what you need to know about upgrading, and see how their tool, PITSS.CON can assist you in getting onto a supported environment in days.  

Unsupported Software Puts Your Organization at Risk €”Learn How PITSS Can Get You Supported in Days.

PITSS can assist you if you are going to ADF, APEX, or SOA Enabled application

One of the most difficult obstacles when migrating from Oracle Forms to another technology like APEX or ADF is moving the Business Logic.  This is the code used for validation and apply business rules.  Most of this code is embedded in triggers and program units within your Forms application.

If this code was located on the Database as Packages, Functions, or Procedures, this would not be a problem.  ADF and APEX can easily access these DB Objects.  With PITSS.converter €™s Application Engineering module you can relocate this code to the Database automatically.  This will eliminate the troublesome conversion of PL/SQL to Java or APEX €™s inability to pull out the Business Logic.  And once the code is converted into a DB object, it can be SOA enabled.

Retain your applications Business Logic - Learn How PITSS Can extract your Business Logic

Integration with Java, ADF and Web Services
Mike Mullennex, Oracle Corporation

This session shows you more of the integration oriented features Oracle has put into Forms. You will see how to accomplish two-way asynchronous communication with Web services with the help of an Advanced Queuing queue, how to have Forms create and send an SMS text message with the help of Java and how to control JavaScript based UI widgets with very rich, Web 2.0, functionality from Oracle Forms.

Making the Business Case for Migrating to Java
Jennifer McNeill, CipherSoft, Inc

November 20, 2009 Presentations

All the Free Stuff from Oracle Corp

Dan Hotka

Dan has used a variety of SQL tuning tools thru the years. This presentation will include a live demonstration on various available tools from Oracle Corp. including SQL Developer, TKProf, the new Trace Analyzer, and undocumented explain plan tools. This presentation is packed full of tips and techniques, including scripts that help find offending SQL statements.

Dan will cover these topics:

SQL Developer SQL*Plus Autotrace
SQL*Plus Explain Plan Scripts
SQL*Plus undocumented Explain Plan features
TKProf (Oracle Trace Facility)
New Oracle10g Trace Analyzer (SQLT)
PL/SQL Profiler
JSAnalyzer - a freeware trace file tool that runs TKProf and Trace Analyzer
JSTuner - a freeware explain plan tool that shows the 'where clause' predicates, includes index stat information, hints, etc

SQL Developer Data Modeler: First Impressions

Kent Graziano

Oracle has recently release a new light weight data modeling tool called SQL Developer Data Modeler. It will run on multiple platforms and generate DDL for Oracle and non-Oracle databases. It can do logical and physical data models and can reverse engineer. I will show you what I have learned in a very short time on how to install and configure the tool and then use it. There will of course be a live demo.

Automatic SQL Tuning in Oracle 10g

Lucy Feng

Automatic SQL tuning is a new feature in Oracle Database Release 11g. Using dbms_sqltune package, you can achieve similar tuning automation in Oracle 10g. Learn to use SQL tuning set to capture TOP queries and to use SQL tuning advisor to recommend SQL profiles. Automate it through a PL/SQL package.

Oracle ADF & JDeveloper for Forms Developers

John King

Oracle Forms is a strong and viable product with years of future left. However, Oracle has "bet the farm" on the success of Fusion; Oracle's rewrite of its Application stack using Java EE and Service-Oriented Architecture. A key tool in this development effort has been the JDeveloper tool and the Oracle Application Development Framework (ADF). Forms Developers wanting to "catch the new wave" are interested in adding JDeveloper and ADF to their repertoire. JDeveloper has come a long way from the tool that crashed during every Oracle demo session and has become a robust development tool for Java and more. ADF likewise has become a useful application development tool that is reminiscent of the simplicity of developing with Oracle Forms (reminiscent; still not all the way there, but much closer...). This session will illustrate the ease with which Oracle Forms Developers can use JDeveloper and ADF can be used to create Java-based web applications.