TruTek TruTalk Newsletter for Oracle Professionals

TruTek New Year

January, 2010
It's a new year, the recession is over (right?), and TruTek is bringing in our favorite experts for some terrific training. You won't want to miss the opportunity to learn from Jonathan Lewis, Christian Antognini, Robert Freeman, Tanel Poder, and Steven Feuerstein. 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.
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.
If you've been waiting for the chance to learn OBIEE, don't miss 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 and New York City 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 Robert Freeman will be teaching database classes in March, April and May in Salt Lake City and Boston. And Jonathan Lewis is coming to Boston in May with two one day seminars, Writing Optimal SQL and Troubleshooting and Tuning Oracle - we sold these seminars out the last time we offered them, so don't miss your chance to attend!
EARLYBIRD DISCOUNT ALERT! Save 10% on Jonathan Lewis, Tanel Poder and Christian Antognini classes if you sign up by January 31st! Just use coupon code TENPERCENT.
Don't miss out on this terrific lineup of classes with the best trainers in their fields!


Mike Swing

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!
Your Claim to Fame!
Oracle Applications 11.5.10 Tips, Tricks and Features
Patch 'til there's nothin' left to fix...
How to Reference IN Argument Values
Join Elimination
Troubleshooting Mantras
Robert Freeman
RMOUG Training Days
Upcoming Oracle Training
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!
I have heard there are troubles of more than one kind. Some come from ahead and some come from behind. But I've bought a big bat. I'm all ready you see. Now my troubles are going to have troubles with me!
                                                                                                                                                                                                          Dr. Seuss
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 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.


Oracle E-Business Suite R11i to R12.1.1 Technical Upgrade Training
TruTek Mine DetectionIf 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 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.
How 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 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.
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 January 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!
Oracle Applications 11.5.10 Tips, Tricks and Features by Jeff Mick
This month Jeff Mick, of Midmark, submitted the winning article. We've added the full article to our website, but check out these top tips for helping users navigate more easily through the Oracle Applications:

I found many users, especially new users to Oracle Applications, do not always discover many of the standard features of the Application until much later down the road. Here is a list of 15 or so tips for "new" or "not so new" Oracle application users.

Tip #1    Multiple  - You can have multiple different forms open at the same time, or the same form open multiple times, from the same Oracle Application login session. 

Tip #2    Export - Any form that displays its data in a grid format, such as the example below, can have that data automatically exported to Excel.

Tip #3    Default Responsibility/Form - You can have your Oracle Application Login take you directly into a particular responsibility and form automatically.

Tip #4    Default Printer/Copies - You can set/change your default printer that is used when running reports in the application. You can also set/change the default number of copies that will print.

Tip #5    Change Password - You can change your Oracle Application password whenever you choose

Tip #6    Menus - The menu within each responsibility can be configured to fit your needs. If you have to switch responsibilities or find yourself logging in to multiple sessions to get to multiple forms on a regular basis, a System Administrator can combine those menus so that they are accessible from a common responsibility.  Any form or menu from the same area or even cross functional areas can be combined to create a menu that suits your job's role.

Tip #7    Top Ten - You can put frequently used menu items in your Top Ten List for quick and easy access. Each responsibility has its own top ten lists that you can configure and access by choosing them with your mouse or by typing the short cut number key that they are assigned to.

Tip #8    Scheduling Reports - You can schedule your reports to run periodically on a schedule you specify.

Tip #9    Copy Reports - If you are running the same report multiple times, but not changing any parameters, or only changing  a few of the parameters, there is an option on the report submission form that can speed up the process.

Tip #10  Folders - Most Oracle forms allow you to personalize the form to fit your needs and preferences. The method that allows this is called Folders.  Folders allow you to decide which fields are displayed on the form and the order that they appear.  You can also rename fields to fit terminology that is used in your department.  Many forms have additional fields that are not displayed by default; using folders allows you to access some additional information or fields that you may not have known were available. 

Tip #11  Place on Navigator (Documents) - If you are working on an Oracle record and you are interrupted with a more important task, or simply wish to return to this record in the future, Oracle has a feature that lets you save a link directly to the Oracle record you are currently viewing.  Keep in mind, this feature is not available on every form.  Oracle has only implemented it on key records in the application. 

Tip #12  Edit Field - The Application has a button to allow you to expand fields so that you can see the entire contents of data that is taller or wider then the field allows for display.

Tip #13  Other Profiles - Each application within Oracle has dozens of profile options that can be defined to change the functionality or suit personal preferences for each user or groups of users by responsibility.  Due to the large volume of options, we only will detail a subset of the profiles that have had the widest impact on our users' productivity.

Tip #14  Short Cut Keys - Each form in the Oracle Application has short cut keys that help speed up repetitive tasks or allow those who are better with the keyboard than with the mouse an equivalent key stroke option.

Tip #15  Request Sets  Do you have multiple related concurrent reports that you run as a series? You can have those multiple reports or requests grouped together into a Request Set, so that you only need to submit 1 job to run, and it will spawn the additional requests automatically.  Those child reports can be set to run at the same time, or they can be set up to complete one after the other.

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 certification of RDBMS 11gR2 with E-Business Suite Release 12, the arrival of AMP and ACM Pack 3.1, and the newest E-Business Suite release, 12.1.2.
  • Deploying E-Business Suite on Amazon Elastic Compute Cloud
  • Oracle Internet Directory 11g ( Certified on Seven New Platforms for EBS
  • AppsDataSource and Java Authentication and Authorization Service for Oracle E-Business Suite
  • Critical Patch Update for January 2010 Now Available
  • EBS 11i Certified on Windows Itanium (2003) and 10gR2 Database
  • Mini-Review: Oracle E-Business Suite Development & Extensibility Handbook
  • Application Management Pack and Application Change Management Pack 3.1 Now Available
  • New Minimum Patching Baselines for E-Business Suite 11i Extended Support
  • On Clouds and Virtualization in EBS Environments (OpenWorld 2009 Recap)
  • New Whitepaper: Symmetrical Network Acceleration with EBS 12
  • Year In Review: Top EBS Techstack Developments of 2009
  • EBS 11i Applications Desktop Integrator (ADI) Certified on 11gR1 Database
  • Oracle Internet Directory 11g ( Certified with E-Business Suite
  • 11gR2 Database Certified with E-Business Suite 12
  • Using Oracle VM with Oracle E-Business Suite Virtualization Kit
  • E-Business Suite Release 12.1.2 Now Available

    Pearls of Wisdom From Our Favorite Instructors

    TruTek Pearls of Wisdom

    How to Reference IN Argument Values in Outcomes by Steven Feuerstein
    Steven Feuerstein is a noted (and prolific) author, instructor, and an Oracle ACE. You can see Steve at the RMOUG Training Days conference in Denver, February 16-18. In the meantime, we have Steven's insights about how to reference IN Argument Values in Outcomes:
    Sometimes you need to reference the value of an IN argument (an input, in Code Tester terminology) in your outcome. For example, under certain circumstances, the string returned by your function should be the same as the input value. Or perhaps the out value should be some part of the input value.

    You could hard-code the same value you supplied in the Input Grid, but then if you change the input value, you have to change the outcome value as well. That's not a great solution.

    Code Tester instead gives you two different ways to reference the input value indirectly:
    1. Functions in the qu_result_xp package that accept the name of the argument and returns it value
    2. Reference the name of the variable that Code Tester will declare and then assign the IN value to it before the program is run.

    Let's take a look at both these techniques for a very simple example. Suppose I want to test this function:

    FUNCTION first_three (string_in IN VARCHAR2) RETURN VARCHAR2
    string_in, 1, 3);

    I start up Test Builder and create a new test case. I enter "abcdefg" in the input grid for string. I will also open up the Properties Window for that input.

    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:
    Join Elimination 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 this very popular book.
    Following is an article by Christian about Join Elimination capabilities in RDBMS 10gR2 and 11gR2:  
    In some specific situations the query optimizer is able to completely avoid executing a join even if a SQL statement explicitly calls for it. Two are the cases currently covered by this optimization technique, which is called join elimination. The first one was introduced in Oracle Database 10g Release 2, the second one in Oracle Database 11g Release 2. Let's take a look at two cases to illustrate how join elimination works.

    Case #1

    Up to Oracle Database 11g Release 1 join elimination is especially useful when views containing joins are used. Note, however, that join elimination does not work only with views. It can be applied to SQL statements without views as well. The following SQL statements define two tables and one view. Notice that between table T1 and table T2, there is a master-child relationship. In fact, table T2, with its column T1_ID, references the primary key of table T1.

      2    id NUMBER NOT NULL,
      3    n NUMBER,
      4    pad VARCHAR2(4000),
      5    CONSTRAINT t1_pk PRIMARY KEY(id)
      6  );
      2    id NUMBER NOT NULL,
      3    t1_id NUMBER NOT NULL,
      4    n NUMBER,
      5    pad VARCHAR2(4000),
      6    CONSTRAINT t2_pk PRIMARY KEY(id),
      7    CONSTRAINT t2_t1_fk FOREIGN KEY (t1_id) REFERENCES t1
      8  );
      2  SELECT AS t1_id, t1.n AS t1_n, AS t2_id, t2.n AS t2_n
      3  FROM t1, t2
      4  WHERE = t2.t1_id;

    When all the columns are referenced, as shown in the following example, the join is regularly executed. No surprise here.

    SQL> SELECT * FROM table(dbms_xplan.display(NULL,NULL,'basic'));
    Plan hash value: 3114288414
    | Id  | Operation                    | Name  |
    |   0 | SELECT STATEMENT             |       |
    |   1 |  NESTED LOOPS                |       |
    |   2 |   NESTED LOOPS               |       |
    |   3 |    TABLE ACCESS FULL         | T2    |
    |   4 |    INDEX UNIQUE SCAN         | T1_PK |
    |   5 |   TABLE ACCESS BY INDEX ROWID| T1    |

    However, as illustrated in the next example, when only columns defined in the child table are referenced, the query optimizer is able to eliminate the join. It can do so because there is a validated foreign key constraint that guarantees that all rows in table T2 reference one row in table T1. 

    My Troubleshooting Mantras 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 and March, 2010, Advanced SQL Tuning and Advanced Oracle Troubleshooting. Check out Tanel's blog, Core IT for Geeks and Pros. 
    Cary Millsap's recent post prompted me to write down some of the related thoughts in my head.

    Here are few of my mantras for systematic troubleshooting and performance tuning, which have materialized in my head over the years of work:

    • Picking the right starting point to troubleshooting and performance tuning is the most important decision in that process.
    • Pick the wrong starting point and you end up going in circles.
    • The scope of your performance data needs to match the scope of your problem, otherwise you end up going in circles.
    • If you don't measure what matters, you may end up fixing what doesn't matter.
    • If you're not systematic in your troubleshooting, you may get lucky, but you don't want to be dependent on luck! Moreover, you wont't need to be lucky if you are systematic in your work!
    • Performance tuning is overrated. Fixing fundamental design and coding flaws via changing a magic configuration parameter is a dream just like is getting slim and healthy via eating magic diet pills bought from TV commercials.
    • Your response times are too long for only two reasons:
    1. You are doing too much work
    2. You are waiting for too much

    ...both of the above things can be measured in Oracle...

    Learn From the Master: Robert Freeman
    Yes, 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: Backup and Recovery using Oracle 11g RMAN, Oracle Database Performance Tuning, and  Oracle 11g DBA Boot Camp I.           .
    Creating VMWARE and RAC on Windows - Part II
    TruTek karate kidThis is part two of my series on installing RAC on Windows using VMWare and Oracle Unbreakable Linux. I will be presenting a 1/2 day university session on this topic at the RMOUG Training Days, February 16-18 in Denver. I hope you will come.

    Why Win/Vmware/Linux/RAC on a laptop? Many DBA's 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 VM's 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 your 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 your 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's 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 like 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 Setup 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

    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
    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!
    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                                              

    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               ONLINE

    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 I with Scott Spendolini                SLC, UT

    Jun 17-18    Introduction to Oracle APEX II with 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                                                            

    Feb 22-24    Advanced Oracle Troubleshooting with Tanel Poder                   SLC, UT

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

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

    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                                                                        

    Feb 10-12    Advanced SQL Tuning with Tanel Poder                               SLC, UT

    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

    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 1-3      Oracle Release 12 New Features (Functional)                        SLC, UT

    Feb 9-12     Oracle R11i/R12 Financials Business Process Overview               SLC, UT

    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    RMOUG Training Days                                                Denver, CO

    Apr 18-22    Collaborate 10                                                     Las Vegas, NV

    May 12-13    UTOUG Training                                                     SLC, UT

    Contact us for Group Discounts and Additional Offers 801-486-6655