TruTek TruTalk Newsletter for Oracle Professionals

TruTek Hearts You


February, 2010
Greetings!
 
Folks, romance is in the air. That's right, Valentine's Day is this month, and if you haven't already gone out and bought your favorite DBA, developer, or functional user a good book about Oracle, then you're just not romantic in our book. Have you considered sending a co-worker to a TruTek Training Class? We have the best trainers and the best donuts. Our students swoon after taking one of our classes. And our consultants? Well, they're the best. That's all I've got to say.
 
It's a new year, and we declare the recession is over. Break out your piggy banks, because TruTek is bringing in our favorite experts for some terrific training. We've got great training here in Salt Lake City, 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.
 
By the way, it's not too late to grab a seat at our 
Introduction to Oracle Business Intelligence EE (OBIEE) class. We're holding it in Salt Lake City on February 16-19.
 
The stars are aligning in the coming months - Tanel Poder will be teaching in Salt Lake City New York City, and San Francisco in February and March. Our newest guru, Christian Antognini, will be teaching Troubleshooting Oracle Performance in March, based on his terrific book by the same name, and Jonathan Lewis is coming to Boston in May with two one day seminars, Writing Optimal SQL and Troubleshooting and Tuning Oracle. We sold Jonathan's seminars out the last time we offered them, so don't miss your chance to attend!
 
EARLYBIRD DISCOUNT ALERT! Save 10% on Jonathan Lewis and Christian Antognini classes if you sign up by February 28! Just use coupon code TENPERCENT.
 
Don't miss out on this terrific lineup of classes with the best trainers in their fields!

Sincerely,

Mike Swing
TruTek

IN THIS ISSUE
We Want You!
What We Do
the NEW little r12.1 upgrade guide is HERE!
Onsite & Online Training
We Do More Than Just Training!
Application Performance Testing
Bind Variable Peeking
Jonathan Lewis is Coming!
Robert Freeman
Confio
Patch 'til there's nothin' left to fix...
RMOUG Training Days
Your Claim to Fame!
Upcoming Oracle Training
QUICK LINKS
Psssst... It's the Economy, It's the Economy!
TruTek Wants YouHere at TruTek, we have our own personal measure for the state of the economy. We call it the TEI, or TruTek Economic Index. And, good news, the TEI is showing a positive, upward trend. That's right, we've got jobs. Permanent placement jobs. Part-time jobs. Consulting gigs. Yep, we've got them all. The economy is looking up. So get out your resume writing books and let us know what you've got going for you.
 
We are looking for DBAs, Developers, and E-Business Suite Functional People. No E-Business Suite Dysfunctional People need apply. If you need a little help getting your resume in shape, let us know, we've got someone who can help with that.
 
Send your resumes to Tammy Myers at [email protected]. Give her a call at 801 486-6655.
 
 
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. 
Time is Running Out - Get Ready to Upgrade to Release 12
"Sometimes the questions are complicated and the answers are simple."   -- Dr. Seuss
 
Just Grab It
That's right. All you have to do is reach out and grab it. It looks good, doesn't it?
 
If you're getting ready to make the move to Release 12, we've put a lot of work into creating a book that shows you how to do it.
 
                                                                                           
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].   Best of all, Mike has the hands-on experience that you'll need for an upgrade, so consider TruTek for meeting your consulting needs.     
 
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 16-18. Or make an appointment to meet with Mike at Collaborate 2010.

 

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 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. 
 
Charlene - Charlene has over 18 years of experience with Oracle Applications, starting at Oracle Corporation in 1989 as one of the first Applications Support consultants and Training Managers. Charlene has implemented and upgraded Oracle Applications since 1999 as Application Consultant and Project Manager. She has worked on global implementations, with locations in North America, Europe, Mexico and Asia. Her specialties include functional analysis, project planning, design, configuration, conversions, account reconciliation, testing and training for Oracle Applications implementations.  Charlene worked as a liaison between functional and technical teams to build custom reports, interfaces, customizations, extensions and to convert historical data. 
 
Todd -  Todd has 10 years of experience in Oracle and SQL Server database development, design, and administration, with an emphasis on front-end development and system migrations. He is looking to re-enter the field in the capacity of testing, documentation, or general office/IT support.
 
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.

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.

Pearls of Wisdom From Our Favorite Instructors

TruTek Pearls of Wisdom

The Art of Application Performance Testing - Christian Antognini
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 from March 23-26 in Salt Lake City based on his book.
 
Christian will be presenting at the Hotsos Symposium 2010 on March 10. The presentation is entitled "Diagnosing Parallel Executions Performance". Here's his abstract: The purpose of parallel executions is to distribute the execution of a single SQL statement over several sessions executed by several CPUs. There are, naturally, advantages and disadvantages to this. The main advantage is related to performance. In fact, provided that necessary resources are available, response time might be dramatically reduced. The main disadvantage is that the diagnosis of performance problems is more difficult. This is mainly due to the fact that Oracle's instrumentation is mostly implemented at the session level. As a result, the challenge is to correctly aggregate information coming from several sessions in order to fully describe how a SQL statement is being executed.

The aim of this presentation is to describe how to find, aggregate and interpret execution plans and statistics coming from V$ views such as active session history and SQL trace.  
 
Following is an article by Christian about The Art of Application Performance Testing:  
 
If you are looking for a book that describes how to approach and carry out a performance testing project, don't look further. Get a copy of The Art of Application Performance Testing: Help for Programmers and Quality Assurance (O'Reilly, 2009). In it Ian Molyneaux manages to cover, in 160 pages, a crucial topic that is not only often forgotten in real projects, but also by authors. In fact, on the one hand, I know few companies that take performance testing seriously. What a shame! On the other hand, I am aware of few books that cover that particular topic. In my opinion, these two facts are not unrelated at all.

The Art of Application Performance Testing

 

Let me shortly describe the five chapters of the book. Chapter 1, even though it is entitled Why Performance Test?, it focuses on the most common reasons why projects fail because of bad performance. Chapter 2, The Fundamentals of Effective Application Performance Testing, describes the ten essential requirements to plan an effective performance testing strategy. Chapter 3, The Process of Performance Testing, introduces several checklists that describe which activities have to be carried out for every step of a performance testing project. To do so the author also introduces two case studies based on real projects. Chapter 4, Interpreting Results: Effective Root-Cause Analysis, shows how to use the information provided by a performance testing tool to do a root-cause analysis. Also in this chapter examples taken from real projects are used. Chapter 5, Application Technology and Its Impact on Performance Testing, gives some guidance on how to deal with technologies and products like AJAX, Citrix, HTTP, Java, SAP and SOA.

To have a detailed look at the content you can take advantage of Google Books.

As you can see, what it is not covered is a performance testing tool. In other words, only the methodology is fully described. This is, in my opinion, not a problem. Not only because it is clearly out of scope, but also because the documentation provided with the performance testing tool of your choice should provide that information.

 
All in all, a very good book. I wish I would have read it several years ago!
 
Are you wondering what Christian's book is all about? Take a look at this review that we snagged from Amazon by F. Stepanski:
 
Troubleshooting Oracle Performance by Christian AntogniniThe author Christian Antognini has done a wonderful job in writing a great book on how to systematically analyze issues with Oracle 11g. Let's be honest, Oracle 11g is a beast and take a very long time to master all areas of its core functionality. I have been using Oracle for only a few years and I sometime still consider myself a newbie.

The recent version of 11g has added lots of new functionality such as database replay, sql access advisor, sucurefiles, flashback data archiving, tablespace encryption, data masking and so much more. IT sometimes feels that version 11g is a totally new database compared to version 10.x.

The great thing about this book which others fail is that it covers all versions of Oracle from version 9i to 11gR1. So even if you are using an older version this book still is extremely valuable to own. It will actually save you money if you are using an older version of Oracle because it can be used as you gradually upgrade to newer versions of Oracle. Another reason to buy it!

This book assumes that you already have a good knowledge of using Oracle and goes right into many different scenarios of using different front-end technologies where performance issues can happen and hot to step-by-step figure out where your problem may be coming from.

The author focuses on tracing database calls, profiling PL/SQL code, how to review workload statistics and object statistics, how to configure your query optimizer, and one of the most useful sections of the book is Chapter 6 where the author focus on many different execution plans. I also liked Chapter 10 where the author goes through all the different types of SQL commands (joins, nested loops, merge joins, hash joins, etc.) and how they can be improved and optimized.

For the size of the book (500+), the author really gives you some great material that can be used for many years of using Oracle. It can be used for the beginner Oracle user (after they get their feet wet) for understanding how to write SQL the optimized way, for the Application Oracle developer and for the DBA as well.

I cant see how this book cannot be in your library. A must buy!

Bind Variable Peeking - Execution Plan Inefficiency - Tanel Poder
Tanel Poder, an Oracle ACE Director and Oracle Certified Master, is one of our most popular instructors. He'll be teaching  Advanced Oracle Troubleshooting in New York City March 3-5 and San Francisco March 15-17, Advanced Oracle SQL Tuning in Denver, April 27-29, and Parallel Execution & Partitioning for Performance in Denver on April 30. Check out Tanel's blog, Core IT for Geeks and Pros. 
 
Tanel will also be presenting at the Hotsos Symposium 2010 on March 10 Here are the abstracts for Tanel's two Hotsos presentations:
 
Session 1: Back to Basics: Choosing the Starting Point of Performance Tuning and Troubleshooting Wisely - Choosing the right entry point to performance tuning and troubleshooting is the most important prerequisite for getting reliable and consistent results. It is the first decision in problem solving process, which will direct you in the right (or wrong) direction. In this session we will cover how to define and "normalize" the problem statement, quantify the problem and where to go on from there.

This is not a deep internals session. Tanel will instead speak about his 14-year journey from a "desperate switch flipping"  DBA to a systematic problem troubleshooter, plus the most important lessons he has learned during this time.

Session 2: Understanding LGWR, log file sync Waits and Commit Performance - The commit's log file sync wait event is often misunderstood to be entirely an IO related wait. In reality there are more factors which affect your commit performance, such as the process scheduling latency and application commit rate. 

This session walks you through some redo generation and writing internals, how commits happen and how the LGWR process fits into all this. After this session, you will be able to easily determine whether your log writing wait events have anything to do with bad IO performance, CPU starvation or just bad application coding practices.

Bind Variable Peeking - Execution Plan Inefficiency
 
In my Beyond Oracle Wait interface article I troubleshot a test case where an execution plan somehow went "crazy" and started burning CPU, consumed lots of logical IOs, and the query never completed.

I have uploaded the test case I used to my new website, to a section where I will upload some of my demo scripts that I show at my seminars (and people can download and test these themselves too):

http://tech.e2sn.com/oracle-seminar-demo-scripts

Basically what I do is this:

  1. I run the query with bind variable values where only a handful of rows match the filter condition. Thus, Oracle picks nested loop join (and indexed access path)
  2. Then I run the same query with different bind values, where a lot of rows match the filter condition. Oracle reuses the existing execution plan (with nested loops!!!). Oracle ends up looping through a lot of blocks again and again (because nested loop visits the "right" side of the join once for every row coming from the "left" side of the join).

Using nested loops over lots of rows is a sure way to kill your performance.

And an interesting thing with my script is that the problem still happens in Oracle 11.1 and 11.2 too!

Oracle 11g has Adaptive Cursor Sharing, right? This should take care of such a problem, right? Well no, adaptive bind variable peeking is a reactive technique - it only kicks in after the problem has happened!

So feel free to download the script, review it and test it out!

Jonathan Lewis is Coming to Boston! Don't Miss Him!
It's always a pleasure to take a training class with Jonathan Lewis. He's put a lot of thought into understanding the internals of the Oracle database, and he has a wonderful teaching style. So we're very excited to have Jonathan coming to Boston in May. In the meantime, here's an article by Jonathan that explains why Oracle implemented undo and redo. 
 
 

"... since redo also has past and current information why can't redo logs be used to retreive that information? Why is undo required when redo already has all that information."

The thread has generated some interesting replies - but to a large extent they describe how the undo and redo work rather than explaining why the designers at Oracle Corp. chose to implement undo and redo the way they did. Since I'm sitting in an airport (Zurich) waiting for a plane I thought I'd use the time to share my thoughts on the why.

Redo gives us two things: recoverability and efficiency. If we record a description of every change we make to a database then we can take an old copy of the database and re-apply the list of changes to bring it up to date - that's recoverability. If we make that list the first point of protection for our data changes we need only keep writing a small volume of information to disc, rather than writing each data block to disc the moment we change it - that's an aid to efficiency. (Of course, although focusing all the changes into a small space gives us I/O efficiency, anything that focuses a lot of activity into a small space also gives us a point of contention).

Undo (in some form) has to exist if we want read-consistency. No-one else should be allowed to see our data changes until we commit them and our changes shouldn't even be visible to queries that started running before we committed them,  so we have to keep older versions of the data somewhere. This is where things get a little counter-intuitive (but very clever) with Oracle. Take a close look at the following redo record; it's a record generated in the middle of a transaction and it's the redo that Oracle generated as we changed the fourth column of a particular row in a table from the value 42 to the value 43.

Gone But Not Forgotten: Robert Freeman
Well, we all knew it had to happen sooner or later. Robert has left us. That's right, he's moved on to the land of Oracle. Yes, Grasshopper, Robert Freeman, noted author, Oracle ACE and karate black belt, now works for Oracle Corporation. The good news is, he's still blogging, so check out his latest musings on VMWARE and RAC:
 
Creating VMWARE and RAC on Windows - Part III
 
This is part three in my journey to installing Oracle 11gR2 RAC on Oracle Unbreakable Linux. In the last installment we got VMWare running after a few mis-steps... Now we are ready to install Oracle Unbreakable Linux. You can easily download and install Oracle unbreakable Linux from Oracle's Linux Download Page. I downloaded the individual CD ISO's (It's a habit), but they also offer a DVD image. One benefit of installing the CD ISO's is that you can download them in parallel, so it can speed up the time to download if you have a big pipe.

Having downloaded the CD ISO's you are ready to install Linux. Notice that I did not burn CD's. What I will do instead is point the VMWare CDRom Drive to the first ISO image, and start the install. What is nice is that as the install requires the next CD image, you can simply go to the VMWare console for that machine and repoint the virtual CDRom drive to the next ISO image. Since you can do this without restarting the machine, it makes installing from the CD ISO images much easier.

The install went well and after a short time I was up and running. Having completed the install, I proceeded to configure the Operating system. At this point, I just had one virtual machine setup, so all I needed to configure was the one machine. Once the configuration (ie: the hosts file, etc) is complete, we will clone the VM and create the second machine.

If you want a real handy guide to configuring Linux and Oracle RAC using VMWare, I highly recommend Tim Hall's Oracle Base site. Tim has done a great job detailing the steps required to create a RAC cluster on VMWare. While his page uses LINUX as the VMWare host, I can attest to the fact that it works with Windows running VMWare too.

Now that we have installed and configured Linux, we are ready to clone the VM. Tim's site does a great job of walking through this process. However there is one small issue to contend with here and I'm thinking this is a windows issue. In VMWare each VM has it's own GUID. The GUID of the VM's are used to assign the MAC addresses to the NIC's in the VM. This means that you have a problem when you bring the second machine up because it's NIC will have the same MAC address of the NIC in the first machine. I think that VMWare is supposed to correct this issue when you cope a VM, but it does not seem to work correctly. So, after cloning the VM, you will need to change the machine's GUID (they call it a UID) in the VMWare configuration file before you start the cloned VM. If you do not do this, you will find your two Linux boxes will not network correctly.

In the next installment we will start laying down Oracle Clusterware. Unfortunately that came with it's own set of problems, and the name of that problem was MS Vista... and it's one nasty problem. Nasty.... nasty.... nasty.

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


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. Note the new timezone patches and the article on switching to cumulative critical patch updates.
 
  • Premier Support for Oracle Application Server 10g ends December 2010
  • 11gR2 DB 11.2.0.1 Certified on Solaris 10 and E-Business Suite
  • What Are Your Plans for Retiring Internet Explorer or IE6?
  • Migrating E-Business Suite Application Tier Servers to Linux
  • Using Mobile Devices with Oracle E-Business Suite
  • Live Migration of EBS Services Using Oracle VM
  • Switching to Cumulative Critical Patch Updates for E-Business Suite 11i
  • Latest DSTv13 Timezone Patches Available for E-Business Suite
  • Firefox 3.6 Certified with Oracle E-Business Suite
  • Microsoft Office 2003 and 2007 Certified with Oracle E-Business Suite
  • BPEL 10.1.3.5 Certified for Prebuilt E-Business Suite 12 SOA Integrations
  •  
     

    RMOUG Training Days

    RMOUG Training Days February 17-18
    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
    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 February 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!
    Doesn't ANYBODY have ANYTHING to say about SOMETHING?
    Sadly, this month we didn't receive any submissions for our newsletter contest. Perhaps you all are heads down, working on wrapping up your Collaborate 10 presentations? Or maybe you're just distracted by the season. It is, after all, the season of love. Please, don't hold back. Write up a submission. It's your turn to shine.
    Upcoming TruTek Training 
    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 
     

     

                                                Oracle Apps Technical Classes                                              

    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        ONLINE

    Mar 8-12      Oracle 11i/R12 Applications DBA Concepts and Administration        Denver, CO

    Mar 22-26     Oracle E-Business Suite R11i-R12.1 Technical Upgrade               ONLINE

    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                                                             

    Feb 16-19     Introduction to Oracle Business Intelligence EE (OBIEE)            SLC, UT

    Jun 14-16     Introduction to Oracle APEX Iwith Scott Spendolini                 SLC, UT

    Jun 17-18     Introduction to Oracle APEX IIwith Scott Spendolini                SLC, UT

    Jun 21-23     Intermediate Oracle APEX with Scott Spendolini                     SLC, UT

    Jun 24        Troubleshooting & Debugging APEX with Scott Spendolini             SLC, UT

    Jun 25        APEX Installation and Administration with Scott Spendolini         SLC, UT

    Jul 12-13     Oracle Discoverer for End Users Training                           SLC, UT

    Jul 14-16     Oracle Discoverer for Administrators                               SLC, UT

     

                                              Oracle Database Classes                                                            

    Mar 3-5       Advanced Oracle Troubleshooting with Tanel Poder                   New York City

    Mar 15-17     Advanced Oracle Troubleshooting with Tanel Poder                   San Francisco

    Mar 9-11      Linux Administration Fundamentals for DBAs                         SLC, UT

    Mar 16-19     Relational Database Modeling                                       SLC, UT

    Mar 23-26     Troubleshooting Oracle Performance with Christian Antognini        SLC, UT

    Mar 30-Apr 2  Backup and Recovery using Oracle 11g RMAN                          SLC, UT

    Apr 12-16     Oracle Database Performance Tuning                                 SLC, UT

    May 17-21     Oracle 11g DBA Boot Camp I                                         Boston, MA

    May 17-20     Backup and Recovery using Oracle 11g RMAN                          Boston, MA

    May 17-21     Oracle 11g DBA Boot Camp II                                        Boston, MA

     

                                              Developer Classes                                                                        

    Feb 22-26     Introduction to SQL                                                ONLINE

    Mar 1-5       Oracle SQL Performance Tuning Tips and Techniques                  ONLINE

    Mar 8-12      Introduction to SQL                                                ONLINE

    Mar 29-30     Oracle SQL Performance Tuning Tips and Techniques                  SLC, UT

    Mar 31-Apr 2  Advanced PL/SQL Tips and Techniques                                SLC, UT

    Apr 5-9       Advanced PL/SQL Tips and Techniques                                ONLINE

    Apr 12-16     Introduction to SQL                                                ONLINE

    Apr 27-29     Advanced Oracle SQL Tuningwith Tanel Poder                         Denver, CO

    Apr 30        Parallel Execution & Partitioning for Performance with Tanel Poder Denver, CO

    May 3-7       Oracle SQL Performance Tuning Tips and Techniques                  ONLINE

    May 17        Writing Optimal SQL Seminar with Jonathan Lewis                    Boston, MA

    May 18        Troubleshooting and Tuning Oracle Seminarwith Jonathan Lewis       Boston, MA

     

                                                Functional Classes                                                                    

    Feb 22-25     Oracle Release 11i/R12 Procure to Pay                              SLC, UT

    Feb 22-23     Oracle Release 11i/R12 Accounts Payable                            SLC, UT

    Feb 24-25     Oracle Release 11i/R12 Purchasing                                  SLC, UT

    Mar 2-3       Oracle Release 11i/R12 Fixed Assets                                SLC, UT

    Mar 2-7       R12 AME                                                            Albany, NY

     

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

    Feb 16-18/10  RMOUG Training Days                                                Denver, CO

    Apr 18-22     Collaborate 10                                                     Las Vegas, NV

    May 5-6       UTOUG Training Days                                                SLC, UT

    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