TruTek TruTalk Newsletter for Oracle Professionals

TruTek Snowman

 

December, 2009
Greetings!
 
Brrrrrr, it's cold outside. At least, it sure is here in Utah. So break out your skis and snowboards and plan a trip to scenic Salt Lake City, Utah. We've got great training here, and in other locations as well, including Utah, New York, Washington, Nevada, Colorado, Massachusetts and California. And if you're not ready to hit the icy streets, we can bring our classes to you.
 
Tilt your chair back and relax as we offer our first TruTek Online Training classes. That's right, you no longer have to schedule classes around the ski season in Utah... you can enjoy our classes from the comfort of your own desk!
 
If you've started thinking about upgrading from Release 11i to Release 12, check out my Oracle E-Business Suite R11i to R12.1 Technical Upgrade class. This is a no holds barred, hands on class. This class offers an essential practice run at doing this upgrade. Plus, you'll perform the upgrade using my new book, the little r12.1 upgrade guide.
 
And if you're ready to do the database upgrade, but not the Apps upgrade, we've created a special hands-on class: Oracle RDBMS 11gR2 Upgrade. Learn how to do the upgrade so your company can take advantage of 11gR2's performance and cost savings features. 

Check out our schedule, because our best trainers are coming to town, including Scott Spendolini, Robert Freeman, Tanel Poder, Christian Antognini, and Jonathan Lewis. Don't miss out on this terrific lineup of classes with the best trainers in their fields!

Sincerely,

Mike Swing
TruTek

IN THIS ISSUE
What We Do
the NEW little r12.1 upgrade guide is HERE!
Oracle E-Business Suite R11i/R12 Technical Upgrade Training
Onsite & Online Training
We Do More Than Just Training!
New Upgrading to RDBMS 11g Class
RMOUG Training Days
Patch 'til there's nothin' left to fix...
Binding Sparse Arrays in a FORALL Statement
Instance Caging
Finding the Reasons for Excessive Logical IOs
Robert Freeman
Confio
Your Claim to Fame!
Blocking Locks Script
TruTek Training Schedule
QUICK LINKS
What We Do
TruTekTruTek is a national leader in technical and functional Oracle training and consulting. We also offer permanent placement services for part-time and full-time employees. We offer Oracle database and E-Business Suite consulting, training and remote services. We have a state of the art training facility in Salt Lake City, Utah.
 
If you have 5 or more people interested in a class, we can also bring classes to your company if you would like onsite training. And if you've wanted to take a training class, but were intimidated by the crowds, we also offer "Personal Training" for certain classes, as well as online training. 
the NEW little r12.1 upgrade guide is HERE!
girl with hose Oh yeah, we know how it feels. Sometimes, you need to learn a lot in a hurry. And sometimes, you need someone to provide a little guidance about which information is the right information, and which step goes first, and what to do when you see a particular error message. And sometimes it all gets just a little bit overwhelming.
 
Mike Swing's latest book, the little r12.1 upgrade guide, is the book to help you with your first salvo into the E-Business Suite upgrade. That's right, one of the first steps you should take is to actually try the upgrade. If you haven't already installed the Release 11.5.10.2 Vision Instance on a test environment, go ahead and do it. And then use Mike's guide to ugprade that instance to Release 12.1. Surprisingly, even the Vision Instance doesn't upgrade flawlessly. Mike includes pointers to additional patches and steps that you'll need to take to make your upgrade a success.
 
the little r12.1 upgrade guideThis edition is bigger and better than the last, as Mike continues to add information about patches and bugs and features that you need to understand to upgrade to E-Business Suite Release 12.1.
 
Are you looking for a guided tour? Don't worry, Mike uses this book as the basis for  TruTek's Oracle E-Business Suite R11i to R12.1 Technical Upgrade class.  He's also available to chat if you'd like to discuss your upcoming upgrade plans - just give him a call at 801 486-6655 or send him an email at [email protected].        
 
Looking for a sneak peek into what you need to know? Check out Mike's presentation "Upgrading to Release 12 is Easy" at the RMOUG Training Days, February 12-13. Or make an appointment to meet with Mike at Collaborate 2010.

 

Oracle E-Business Suite R11i to R12.1.1 Technical Upgrade Training
If your company is starting to think about upgrading to Release 12, one of the most important first steps is to try out the upgrade. TruTek's Oracle E-Business Suite R11i to R12.1 Technical Upgrade class is a 5 day hands-on class where you'll upgrade the Release 11.5.10.2 Vision instance to Release 12.1. Mike Swing does his best to make it look easy, but in reality, a good upgrade takes a lot of planning and preparation.
 
TruTek SurgeonHow hard can it be? We'd like to think we've taken some of the agony out of upgrading by publishing a book, the little r12.1 upgrade guide, that takes you through the steps. Our guide - and the class - include additional patches that you'll need to apply, plus an assortment of "gotchas", with their solutions.

The class size is limited to 4 to 6 students to allow plenty of instructor attention for dealing with problems that arise, and questions that students have. Each student uses a quad core Linux server with 4-8 GB of memory and 1 TB of disk space to perform the upgrade.
 
Here's some feedback from a recent student:
Great Class.  Teacher was very informative and let you work at your own pace.  My company was upgrading to 12.1.1 and Mike let me try the upgrade during class instead of the 12.0.4 upgrade.  Best part of the class was each student was able to do their own upgrade.  That way if one upgrade failed all other students could keep working at their own pace.  Can't wait to take another class with Trutek.
Learn the Way that Suits You!
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you choose. You're on your own. And you know what you know. You are the guy who'll decide where to go.
Dr. Seuss

TruTek Training in Progress

In these tight economic times, finding a way to get the training you need can be tough. Perhaps you've got training budget, but not travel dollars? If that's the case, we'd just like you to know that our instructors are willing to pack up their hardware and bring the class to you. And if that doesn't work for you, we're also offering some of our classes as online classes. That's right, relax, sit back in the comfort of your own office, and listen to the not-so-soothing tones of our instructors.

If you're ready to start learning about Release 12, give us a call at 801 486-6655 or drop us a line. If you have a location in mind, we can track down additional students to help fill the class. And if there's a class you'd like to see offered online, let us know that too!
Did You Know? We Do More Than Just Training!
At TruTek, we offer training classes, remote database and applications administration support, on-site consulting, and permanent placement services for part-time and full-time employees. And in the next month, a few of our top resources will be rolling off of projects, so check them out:

Mike Swing - Besides teaching many of our E-Business Suite technical classes, including several of our DBA classes, Mike has extensive experience implementing, upgrading and maintaining various Oracle RDBMS versions and the E-Business Suite. Mike teaches our classes on installing and upgrading to Release 12, so if you need someone with plenty of hands on experience, he is one of our best resources. Mike also has experience supporting RAC implementations and has a deep understanding of parallel concurrent processing, load balancing and failover. 
 
Eric - Eric has a very deep understanding of both Unix and Oracle DBA technical material, and is a solid, very experienced Oracle Applications DBA. His strong analytical skills make him a valuable member of any team.
 
Dennelle - It's always good to have a skilled financials functional expert in your corner. Dennelle specializes in General Ledger, Fixed Assets, Purchasing, Payables, Receivables, Cash Management, Order Management, ADI, FSGs and UPK.  Dennelle is also a great trainer, so her hand-offs to clients go especially well.

Rick - With 15 years of manufacturing planning, forecasting and inventory management experience, and 10 years of functional Oracle ERP implementation experience, Rick is one of our top manufacturing experts for the E-Business Suite. Rick specializes in supporting the Oracle BOM, CST, EAM, ENG, INV, PO, MRP, MSCA and WIP modules.

Susan - Offering strong technical skills combined with excellent project management and team lead capabilities, Susan is an experienced ERP application designer and developer. Susan is a Certified Oracle Application Developer, and can resolve issues quickly due to her wide variety of experience and technical knowledge.

Fred - Fred has strong experience supporting large, worldwide Oracle E-Business Suite implementations and upgrades as a project manager, lead, and functional consultant. Fred's experience includes both Project Manufacturing and Oracle Financials. 

Joe - Joe is an Oracle developer with over 12 years of experience in designing, building, maintaining and enhancing both ERP and custom applications across a variety of business sectors. 

Bob - Bob is an accomplished Oracle DBA with extensive experience as an Oracle Apps DBA. Bob's E-Business Suite experience includes installing, updating and cloning environments.

Nathan - Nathan has both functional and technical expertise, which makes him a valuable asset in supporting the E-Business Suite. Nathan has worked as both an Oracle Database Analyst and Oracle Financial Applications specialist, responsible for implementing Oracle Accounts Payable, Oracle Purchasing, Order Management, Fixed Assets, Cash Management, Accounts Receivable and Oracle General Ledger. Nathan has performed data conversions as well as Oracle database installation, reorganization, tuning, and instance recovery on various Linux, Unix, NT, and VAX/VMS platforms. Nathan's technical skills include RMAN backup and recovery, RAC on AIX, Oracle Warehouse Builder, Workflow and XML Publisher.

Jim - Jim is one of our best manufacturing consultants. His experience includes full life cycle implementations in manufacturing management, purchasing management, production planning, and materials control. Jim has worked as a Project Manager, Team Leader, and as a Functional Application Implementer.

Craig - Craig's most recent assignment had him multi-tasking as a Unix System Administrator, Oracle Database Administrator, Applications System Administrator and E-Business Suite Developer. Craig's solid technical background makes him an excellent candidate for any E-Business Suite team.

Also, if you're looking for a developer to design custom software or programs for your company, we have a Java team ready to roll!  We have other consultants with E-Business Suite, DBA and developer skills available as well.

Contact us if you'd like to see more resumes.
A New Class from TruTek - Upgrading to RDBMS 11gR2
Perhaps you're not ready to upgrade your E-Business Suite of Applications, but you are ready to upgrade your RDBMS? The word is out that 11gR2 has a lot to offer E-Business Suite users, so we've decided to offer a hands-on  "RDBMS Upgrade Only" class. The class is intended for DBAs and Apps DBAs - you don't have to be running the E-Business Suite to take this class; we just want to make sure we cover Apps-specific topics in addition to doing the upgrade.
 
Here's the class agenda:
 
Day 1
            Database Upgrade Overview
            Install 9.2.0.6 instance

            Upgrade RDBMS Version 9.2.0.6 to Version 10.2.0.3
Day 2
            Complete the Database Upgrade to 10.2.0.3
            Daylight Savings Time patch 4
            Install 11.1.0.7 Oracle Home
            Upgrade RDBMS Version 10.2.0.3 to Version 11.1.0.7
Day 3  
            Finish RDBMS Version 11.1.0.7 Upgrade
 
Check out our class schedule. We'll offer this class online, onsite and at locations around the country. Also, we cover the 11gR2 upgrade in the little r12.1 upgrade guide.
 

RMOUG Training Days

RMOUG Training Days
Check out the RMOUG Training Days Schedule for February 17-18 - several of the people we love to bring in as instructors will be presenting. In fact, you can dip your toe into the water to see what their teaching style is like, and then sign up for a TruTek training class to experience the full monty:
 
Mike Swing
Patch 'til there's nothin' left to fix...
Steven Chan's Oracle E-Business Suite Technology blog included a number of interesting articles last month, including several OpenWorld 2009 recaps. 
 

Pearls of Wisdom From Our Favorite Instructors

TruTek Pearls of Wisdom

Binding Sparse Arrays in a FORALL Statement by Steven Feuerstein
Steven Feuerstein is a noted (and prolific) author, instructor, and an Oracle ACE. We received such good feedback from his last training class that we're bringing him back! Steven will be presenting The Best of Oracle PL/SQL Seminar in December in New Jersey and Dallas. Don't miss it!
 
In the meantime, we have Steven's insights about the use of the FORALL statement: 
 
FORALL was introduced into PL/SQL in Version 8i. It is a fantastic feature; you should use it in place of all loops that contain DML statements performing row-by-row processing. You will generally see performance improvements of at least an order of magnitude. 
If you are not familiar with FORALL, make it a priority to get familiar. You can start with my brand new 5th edition of Oracle PL/SQL Programming, complemented by the Oracle documentation. Follow up with a perusal of my 21st Century PL/SQL course materials.
 
I assume a working knowledge of FORALL for the remainder of this post.
 
The typical (and, in Oracle8i and Oracle9i, the only) way to construct a FORALL statement is to use a header that is very similar to a numeric FOR loop. Here is an example:
DECLARE
   TYPE
namelist_t IS TABLE OF employees.first_name%TYPE;
   l_enames   namelist_t := namelist_t ('ABC', 'DEF', 'SMITHIE');
BEGIN
   FORALL
indx IN 1 .. l_enames.COUNT
      UPDATE employees
         SET first_name = l_enames (indx);
END;
More generally, the FORALL header looks like this:
FORALL integer_index IN low_value .. high_value
where integer_index is an implicitly declared integer iterator, low_value is the low end of the integer range and high_value is the high end. Each integer between low and high must reference a defined index value in any of the collections that are bound into the FORALL's DML statement (in the above case, there is just one: l_enames).
In other words, the binding array must be densely filled between the low and high values.
 
 
Oracle PL/SQL Programming by Steve FeuersteinBooks by Steven Feuerstein:
 
Be sure to check out Steven's latest book, Oracle PL/SQL Programming. This edition covers: 
 
  • Optimize PL/SQL performance with the aid of a brand-new chapter in the fifth edition;
  • Understand and use new Oracle Database 11g features, including the edition-based redefinition capability, the function result cache, the new CONTINUE statement, fine-grained dependency tracking, sequences in PL/SQL expressions, supertype invocation from subtypes, and enhancements to native compilation, triggers, and dynamic SQL;
  • Use new Oracle Database 11g tools and techniques such as PL/Scope, the PL/SQL hierarchical profiler, and the SecureFiles technology for large objects.
 
 
Check out Steven's latest papers:
 
Instance Caging by Christian Antognini
Troubleshooting Oracle Performance by Christian AntogniniWe're excited to announce that Christian Antognini will be conducting a class for us in March! Christian wrote the very popular book Troubleshooting Oracle Performance, and will be teaching a class based on the book.
 
Following is an article by Christian about instance caging in RDBMS 11gR2:  

Instance caging is another small but useful feature of Oracle Database 11g Release 2. Thanks to it the database resource manager is able, for the first time, to limit the number of CPUs that can be used by a given instance. (By the way, note that this limit has no "impact" on the number of CPUs that have to be licensed.)

Using instance caging requires only two simple configurations from our part:

  • Enable the resource manager by assigning a resource plan (e.g. DEFAULT_PLAN)
  • Set the number of CPUs through the CPU_COUNT initialization parameter

To illustrate how it works, let me show you what I observed on my small test server with 4 cores.

To burn all the available CPU resources, I started four sessions executing the following PL/SQL block:

Finding the Reasons for Excessive Logical IOs by Tanel Poder
Tanel Poder, an Oracle ACE Director and Oracle Certified Master, is one of our most popular instructors. He'll be teaching two classes in February, 2010, Advanced SQL Tuning and Advanced Oracle Troubleshooting. Check out Tanel's blog, Core IT for Geeks and Pros. 

There's another interesting thread going on in Oracle-L, about understanding logical IOs and drilling down into their reasons. Of course sometimes (or rather usually) the excessive logical IOs come from a bad execution plan (when a nested loop loops over lots of datablocks again and again or a wrong index is used for driving a query etc), but sometimes the excessive LIOs are caused by some internal issues, like space management etc.

A convenient tool I use for reporting logical IO reasons is (again) my Snapper! It has  an option "b" for reporting Buffer get reasons or as I use below - option "a" shows All information Snapper can show.

There are couple of gotchas though which make this approach imperfect:

  1. The X$ tables Snapper uses for LIO reason reporting contain instance-wide counters, not specific to a single testing session. Thus you either need to be the single user in your database when experimenting and even then the background activity may increment some counters while you are testing too. I have sometimes suspended all other processes (kill -STOP and kill -CONT to resume)  or used Flash Freeze (oradebug ffbegin and ffresumeinst) to hang the whole instance that there would be no other activity going on.
  2. These buffer get reason counters are not maintained properly in Oracle 11g, probably due an optimization effort and some changes for faster pinning of buffer cache buffers (there's a parameter called _fastpin_enable which is set to 1 in 11g and it enables so called fastpath buffer gets. If you see v$sesstat statistics such "consistent gets from cache (fastpath) or "db block gets from cache (fastpath)" being inremented, then fastpath buffer gets/pins are used. Note that I do have a script which works also on 11g but I'll write about that one some time in the future :)

Anyway, if you are testing in an environment exclusively used by you, on Oracle 10.2 or lower, then you can run snapper with the gather=a option to report a bunch instance-level statistics in addition to the standard session-level stats:

  1. BUFG - Buffer get reasons (both consistent and current mode gets)
  2. LATG - Latch gets (both willing to wait and immediate gets)
  3. ENQG - Enqueue gets

Here's an example, prepare for long output:

Learn From the Master: Robert Freeman
TruTek Karate KidYes, Grasshopper, you too can learn from the best - Robert Freeman, noted author, is also an Oracle ACE and a karate black belt. Don't miss Robert's upcoming classes: Oracle 11g DBA Boot Camp I, Backup and Recovery Using 11g RMAN, Oracle 11g DBA Boot Camp II, and Oracle Database 11g New Features.
 
Creating VMWARE and RAC on Windows
 
"Live life fully while you're here. Experience everything. Take care of yourself and your friends. Have fun, be crazy, be weird. Go out and screw up! You're going to anyway, so you might as well enjoy the process. Take the opportunity to learn from your mistakes: find the cause of your problem and eliminate it." - Anthony Robbins

So, with that quote in mind, I set out on my new venture, installing Oracle 11gR2 RAC on VMWare on MS Vista. Did I mention on 4gb?! I do this hopeful that I can use this configuration for my RMOUG class on creating a RAC cluster on Windows using VMWare.

Already I hear the collective gasp from the crowd. You are right, I must be mad.

I've installed RAC many a time, and in fact, I've successfully installed it on Win XP with 2GB using VMWare and 10GR2. It was slow, it was unusable but it would come up and I could access the SCOTT schema and query the EMP table. Thus, I called it a success and moved on.

Now the target is a much loftier one... This would be my first foray into the new 11gR2 RAC, believe it or not. Since R2 has come out, I've played with the database quite a bit, but not with a clustered version. It just has not been something I needed to do, and I'm also a bit of a manager type now.... so getting my hands dirty is only an occasional thing, I'm afraid.

So, let me first describe to you my environment. I'm running on a dual core Pentium, running Vista and 4GB. Now, already I know I'm in trouble because from all accounts 4GB is the bare bones minimum. But I am a manly DBA, and I face resource constraints and spit in the face of them. I can and will get this working.

Why Win/Vmware/Linux/RAC on a laptop? Many DBAs have not had an opportunity to experience RAC for themselves. This configuration is one way for them to do so with minimal cost.

So, I'm on a quest .... a quest to install RAC on VMs sitting on top of Windows. This isn't, shouldn't be, a quest that involves rabbits, holy hand grenades or needing the services of Tim the Enchanter.... But oh, how wrong I was. It seems that Vista was not the right place to be starting and indeed, I did need the services of Tim the Enchanter to even get VMWare 2 started on Vista.

I bought a brand new Dual core Dell Inspiron laptop with 4GB for the task. I can tell you right now that if you are installing 11gR2 RAC, you need all of that 4GB. I did 10gR2 RAC on 2 successfully (it was slow and painful)... there is no way you are doing that on this install!

I then downloaded the new web-based version of VMWare and installed it. No problem there. However, when I click on the icon for VMWare I run into my first problem. It asks me for a username and password. Well, I have no idea what username and password it is expecting. After some research I find that it wants the username/password for the Windows session I'm logged in as. That's intuitive .... So, I enter the credentials. Next it throws a certificate exception at me which I approve, and then I get an error and it won't start the interface to VMWare. I should have taken a screen print of the error but it was a 404 or something....

Well this is a fine piece of junk!! I start doing some internet research and find that many people have run into the problem. One solution is to use the IP address in the URL that you use to bring up the VMWare console in the browser. I tried that and it worked fine. Still, it wasn't the way it was supposed to work. After reading through some more threads about this problem, I decided to de-install VMWare and re-install it using the administrator account. Of course, you have to enable the administrator account with the net user command first and then you also need to give it a password.

I then re-installed VMWare 2 under the administrator. Everything loaded great this time ... so now, I have my VM set up and I'm ready to move onto the next step - Installing Oracle Unbreakable Linux. In the next installment, I'll show you a little trick to making the install easier from VM. Rather than having to burn the Linux CD's or the DVD you can simply load directly from the ISO images.

Robert Freeman's OCP: Oracle Database 11g Certification KitRobert's latest technical book, the OCP Oracle Database 11g Certified Professional Study Guide, is available. It's a prep guide for the Oracle Database 11g OCP Exam (Exam 1Z0-053). Check out this and other great books on our books link.  
Other Papers by Robert Freeman:
Confio Igniter Suite

Confio builds performance management software that improves the effectiveness of IT systems and the people who run them. The Confio Igniter Suite currently includes products that help Oracle DBAs, managers, and developers continuously monitor the performance of databases and the applications that depend on them, isolate specific problems, and identify solutions in production systems.

Confio Ignite


Your Claim to Fame...
AmazonYou might argue that our newsletter staff weighs in more on the technical side than the functional side. Yes, we admit it, we're geeks. But that doesn't mean we don't want to include articles about the functional side of the E-Business Suite. Really, we do. So here's your chance to help us keep a balanced perspective in our newsletter. If you've got a good functional topic, please, let us know. Enter our writing contest!  If you'd like to enter, just write an article about Oracle or the Oracle E-Business Suite. Tell us about a technique that you've used that made your life easier at work. Or describe something you've learned from all those books on your bookshelf, and how it applied to your environment. If you're not sure if you've got a good topic, send us a note, and we'll help you figure it out. Go ahead, you know you want to!

Submissions should be sent to [email protected] by December 25th. We'll include the winning article in our next newsletter. And the winning author will win a very cool prize, a $50 Gift Certificate from Amazon!
Blocking Lock Script
This month Nels Quinn, of Concentra, submitted this winning article:
 
This script is very useful for finding database blocking locks that are "hanging up" running concurrent requests.   I came up with it in a shop that heavily used General Ledger and ran the Autopost program on a scheduled basis to pick up all manual journal entries. 
 
During month end close, users would frequently save a partially completed journal entry in the Enter Journals form (GLXJEENT), which would create a blocking lock on the GL_JE_BATCHES table, in turn preventing the Autopost program from completing.  This would lead to frantic calls from the GL admins to the DBAs wondering why the autopost requests that normally took a couple of minutes had been running for 45...

After I found the problem and devised the script, I was able to quickly identify the specific session blocking an autopost request, including the specific user (from the ACTION column) and form (from the MODULE) column.  With this info in hand - the GL admins were able to contact the owner of the blocking session and have them save their work (and listen to a lecture on journal entry procedure!)

Here was the script I originally used (for 11.5.8 on 9i) - it will find any session that's blocking any concurrent request in the "Running" phase:

SELECT sid blocking_sid, serial# blocking_serial, action blocking_action, module blocking_module
FROM v$session WHERE SID IN (
SELECT bvl.SID
FROM v$session vs, applsys.fnd_concurrent_requests fcr, v$lock vl, v$lock bvl
WHERE vs.PROCESS = fcr.OS_PROCESS_ID
AND vl.SID = vs.SID
AND vl.id1 = bvl.id1
AND vs.SID <> bvl.SID
AND fcr.phase_code LIKE 'R'
AND bvl.type like 'TX'
AND vl.type like 'TX'
AND vs.LOCKWAIT IS NOT NULL
AND vl.ID2 != 0
AND bvl.block > 0
)

But if you're running database 10g (or greater) - the following simpler script will do the same job more quickly:

SELECT blkr.sid blocking_sid, blkr.serial# blocking_serial, blkr.action blocking_action, blkr.module blocking_module, fcr.request_id blocked_request_id
FROM v$session vs, applsys.fnd_concurrent_requests fcr, v$session blkr
WHERE vs.PROCESS = fcr.OS_PROCESS_ID
AND vs.blocking_session = blkr.sid
AND fcr.phase_code LIKE 'R'
AND vs.lockwait is not null

The same concepts can be used to find forms sessions blocking each other, etc.  Experiment and see what you can come up with!
TruTek Training Schedule
We're always open to adding new classes, so let us know your interests! We add new classes regularly, so be sure to check the latest version of the schedule on our website. 

*** Class Dates and Locations are Subject to Change
Time Zone for Online Classes is MST 
 

Date

Class

Location

 

Online Technical Classes

 

Jan 11-15

Oracle SQL Performance Tuning Tips and Techniques

    9:30 am-1:00 pm

Jan 11-15

Oracle Release R12 Applications System Administration

    9:00 am-12:00 pm

Jan 25-29

Oracle 11i/R12 Applications  DBA Concepts and Administration

    9:00 am-5:00 pm

Feb 8-12

Oracle E-Business Suite R11i-R12.1 Technical Upgrade

    9:00 am-5:00 pm

Feb 22-26

Introduction to SQL

    9:00 am-12:00 pm

Mar 1-5

Advanced PL/SQL Tips and Techniques

    9:30 am-1:00 pm

Mar 1-5

Oracle RDBMS 11gR2 Upgrade

    9:00 am-12:00 pm

Mar 8-12

Oracle 11i/R12 Applications  DBA Concepts and Administration

    9:00 am-5:00 pm

Mar 8-12

Introduction to SQL

    9:00 am-12:00 pm

Mar 22-26

Oracle E-Business Suite R11i-R12.1 Technical Upgrade

    9:00 am-5:00 pm

Apr 5-9

Oracle 11i/R12 Applications  DBA Concepts and Administration

    9:00 am-5:00 pm

Apr 5-9

Oracle E-Business Suite R11i-R12.1 Technical Upgrade

    9:00 am-5:00 pm

Apr 12-16

Introduction to SQL

    9:00 am-12:00 pm

 

Date

Class

Location

 

Live Technical Classes

 

 

          Oracle Apps Technical Classes

 

Jan 11-15

Oracle RDBMS 11gR2 Upgrade

SLC, UT

Jan 18-22

Oracle Release R12 Applications System Administration

Oakland, CA

Feb 1-5

Oracle 11i/R12 Applications  DBA Concepts and Administration

SLC, UT

Feb 8-12

Oracle E-Business Suite R11i-R12.1 Technical Upgrade

Denver, CO

Mar 1-5

Oracle Release R12 Applications System Administration

Washington, DC

Mar 1-5

Oracle RDBMS 11gR2 Upgrade

SLC, UT

Mar 8-12

Oracle 11i/R12 Applications  DBA Concepts and Administration

Washington, DC

Mar 8-12

Oracle 11i/R12 Applications  DBA Concepts and Administration

Denver, CO

Apr 5-9

Oracle E-Business Suite R11i-R12.1 Technical Upgrade

SLC, UT

Apr 5-9

Oracle 11i/R12 Applications  DBA Concepts and Administration

SLC, UT

May 17-21

Oracle E-Business Suite R11i-R12.1 Technical Upgrade

Boston, MA

May 18-20

Oracle Release R12 Applications System Administration

Boston, MA

May 17-21

Oracle 11i/R12 Applications  DBA Concepts and Administration

Boston, MA

 

          BI & Reporting Classes

 

Jan 18-20

Introduction to Oracle APEX I with Scott Spendolini

SLC, UT

Jan 21-22

Introduction to Oracle APEX II with Scott Spendolini

SLC, UT

Jan 25-27

Intermediate Oracle APEX with Scott Spendolini

SLC, UT

Jan 28

Troubleshooting & Debugging APEX with Scott Spendolini

SLC, UT

Jan 29

APEX Installation and Administration with Scott Spendolini

SLC, UT

Feb 16-19

Introduction to Oracle Business Intelligence EE (OBIEE)

SLC, UT

Feb 23-24

Oracle Discoverer for End Users Training

SLC, UT

Feb 25-26

Oracle Discoverer for Administrators

SLC, UT

 

          Oracle Database Classes

 

Jan 11-15

Oracle 11g DBA Boot Camp II with Robert Freeman

SLC, UT

Jan 11-15

Oracle RDBMS 11gR2 Upgrade

SLC, UT

Feb 22-24

Advanced Oracle Troubleshooting with Tanel Poder

SLC, UT

Mar 1-3

Advanced Oracle Troubleshooting with Tanel Poder

New York City

Mar 16-19

Relational Database Modeling with Robert Freeman

SLC, UT

Mar 23-26

Troubleshooting Oracle Performance with Christian Antognini

SLC, UT

Mar 30-Apr 2

Backup and Recovery using Oracle 11g RMAN with Robert Freeman

SLC, UT

Apr 12-16

Oracle Database Performance Tuning with Robert Freeman

SLC, UT

May 17-21

Oracle 11g DBA Boot Camp I

Boston, MA

May 17-20

Backup and Recovery using Oracle 11g RMAN with Robert Freeman

Boston, MA

May 17-21

Oracle 11g DBA Boot Camp II

Boston, MA

 

        Developer Classes

 

Jan 19-21

Introduction to SQL

Las Vegas, NV

Jan 25-26

Oracle SQL Performance Tuning Tips and Techniques

Denver, CO

Jan 27-29

Advanced PL/SQL Tips and Techniques

Denver, CO

Feb 10-12

Advanced SQL Tuning with Tanel Poder

SLC, UT

May 17

Writing Optimal SQL Seminar with Jonathan Lewis

Boston, MA

May 18

Troubleshooting and Tuning Oracle Seminarwith Jonathan Lewis

Boston, MA

 

        Functional Classes

 

Jan 12-15

Oracle Release 11i/R12 Procure to Pay

SLC, UT

Jan 12-13

Oracle Release 11i/R12 Accounts Payable

SLC, UT

Jan 14-15

Oracle Release 11i/R12 Purchasing

SLC, UT

Jan 26-27

Oracle Release 11i/R12 Fixed Assets

SLC, UT

Jan 26-28

R12 AME

Albany, NY

Feb 1-3

Oracle Release 12 New Features (Functional) 

SLC, UT

Feb 9-12

Oracle R11i/R12 Financials Business Process Overview

SLC, UT

 

Conferences and User Group Meetings - We'll Be There!

 

Feb 16-18

RMOUG Training Days

Denver, CO

Apr 18-22

Collaborate 10

Las Vegas, NV

 

Enough Already!
Our newsletter editor's dad, who is 82, likes to spend a little bit of time every day shredding his junk mail and then putting it into the pre-addressed stamped reply envelope and mailing it back in. That's one way to deal with too much information! We know how it is. You're on everybody's mailing list, and maybe you're just not interested in being there. Hey, we don't want to cram your mailbox unless you'd like to hear from us. So here's what you can do:

If you like our newsletter and think someone you know would like it as well, click on this box to forward it:
Forward to a Friend

And, if you're just not the right person for this newsletter, click on Safe Unsubscribe at the bottom of this newsletter and take yourself off the list.

And if you accidentally remove yourself from the list and want to be put back on, click here, enter your email and be sure to click Submit, then click Update Profile in the email that you receive.

And if we're just not hitting the topics that you want to hear about, either submit an article yourself, or click here and fill out our survey. We know people who know stuff - that's our claim to fame - and we'll get them to write about that stuff!
Contact us for Group Discounts and Additional Offers 801-486-6655