TruTek TruTalk Newsletter for Oracle Professionals
 TruTek Dog Days of Summer
.
August, 2009
Greetings!
 
The dog days of summer are here; the hottest of the season. Maybe it's time to take a break from your work and check out some mind-broadening training classes with TruTek.
  • We have some exciting classes coming up in August that you won't want to miss. We have an Oracle BI Publisher and Intro to SQL class coming to Salt Lake City. We also have several functional classes coming to San Diego, CA - R11i/R12 Financial Business Overview, R11i Fixed Assets, and Release 12 New Features.
  • We're hitting the streets! Take a look at our upcoming training classes. We're offering classes in Utah, New York, New Jersey, Washington, Nevada, Arizona, Colorado, Massachusetts and California.
  • If you've started thinking about upgrading from Release 11i to Release 12, check out my Oracle E-Business Suite R11i to R12 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 upgrade guide.
  • If you've been looking for a class that will really teach you what you need to know to be a great DBA, then sign up for Robert Freeman's upcoming Oracle 10g DBA Boot Camp I.
  • Get ready for another visit from Steven Feuerstein. His last seminar went over so well that we've decided to bring him back, this time for The Best of Oracle PL/SQL, in September in Fullerton, CA, and then in November in New Jersey.

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 little r12 upgrade guide
What's New in PL/SQL in Oracle Database 10g?
We Do More Than Just Training!
WAIT #x Lines Troubleshooting
Robert Freeman
Hot Off the Press
OpenWorld 2009
Confio
Article Writing Contest
TruTek Training Schedule
QUICK LINKS
What We Do
TruTekTruTek is a national leader in technical and functional Oracle training and consulting. 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.
 
E-Business Suite Users: Are You Ready for Release 12?

one armed pushupIf 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/R12 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.0.6. Mike Swing does his best to make it look easy, but in reality, a good upgrade takes a lot of planning and preparation.

 
the little r12 upgrade guideHow 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 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.
 
Mike's upcoming training class, Oracle E-Business Suite R11i/R12 Technical Upgrade, is in Fullerton, CA, September 14-18, Seattle, WA, September 28-October 2, Denver, CO, November 2-6th, Las Vegas, NV, Nov 30-Dec 4th and New Jersey, Dec 7-11.

Mike has just officially started working on his next book - the little r12.1 upgrade guide!

Patch 'til there's nothin' left to fix...
Steven Chan's Oracle E-Business Suite Technology blog reported an exciting collection of upgrades affecting the E-Business Suite, including ATG RUP 7, Autoconfig Rollup Patch T, 10gR2 10.2.0.4 certification, Database Vault 11.1.0.7 certification, Tablespace Encryption 11.1.0.7 for Release 12, and the July 2009 Critical Patch Update (CPU). With Oracle's ongoing emphasis on staying current, these new patches and certifications are very important and should be reviewed carefully by your technical team:

Give us the scoop - as you apply these patches to your environment, why not share the gory details with your colleagues? Drop us a line if you run into issues, or even if you don't, so we can share the news with other E-Business Suite users who are preparing to "patch current".
A Peek Into E-Business Suite Fusion Applications
Check out Floyd Teter's blog for a fascinating article about his trip to the land of Oracle, where he got to do validation testing for the Fusion Applications. Floyd works at JPL (Jet Propulsion Lab), so his company was very interested in seeing the Project Portfolio Management (PPM) module.

According to Floyd:
  • I've sat at a keyboard with Fusion Apps for a week. Cleared caches, executed test scripts, gone exploring off-script, even tried to break things a few times. Oracle Fusion Applications are real and work proceeds. So can we now please stop all this nonsense about vaporware, non-existent products, and off-track software development?
  • I was very impressed. In particular, the user experience is a "game changer". The team at Oracle really got this right with Fusion Apps, and I'd sure like to know how they did it...I'm really hoping to do a "day in the life" with the Oracle Usability folks to see if we can bottle the magic. Fusion Apps customers will see productivity gains as a direct result of the outstanding user experience for Fusion Apps.
  • Even though the social networking functionality was not working during my testing, I can see the potential. Oracle is getting very close to the sweet spot of Web 2.0 for the enterprise with Fusion Apps.
  • I saw people from disparate Oracle organizations functioning in well-integrated teams, with a common goal of building the best possible product. If the teams are integrating well, I have to think some of that cross-functional magic will rub off on the apps themselves.
  • I'm struck by the elegance of design in Fusion Apps: simple and intuitive navigation, straight-forward and easily executed business processes, exceptions and errors pushed to the user, seamless integration between the various applications in the PPM Suite.
Read More
What's New in PL/SQL in Oracle Database 10g? by Steven Feuerstein
Steven 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 on September 15-16 in Fullerton, CA. Don't miss it!

Since we know that not everyone is ready to make the leap to Oracle RDBMS 11g, this month's article from Steven is about Oracle Database 10g features:

As is the case with every new release, Oracle Database 10g introduces some new PL/SQL language features and some new supplied PL/SQL packages. These are listed briefly at the end of this page.

However, the big news for PL/SQL in this release is the dramatic increase in runtime performance from transparent changes. Oracle Database 10g brings a new PL/SQL compiler and a newly tuned PL/SQL execution environment. Additionally, the system for the native compilation of PL/SQL has been substantially improved. As a result, users can expect that
  • Computationally intensive PL/SQL programs compiled under Oracle Database 10g will run, on average, twice as fast as they did under Oracle9i Database Release 2
  • They will run three times as fast as they did under Oracle8 Database
These factors are so large that they might seem - literally - incredible. Lest you doubt them, we provide extensive corroborative collateral:

PL/SQL Just Got Faster explains the workings of the PL/SQL compiler and runtime system and shows how major improvements on this scale are indeed possible.

PL/SQL Performance Measurement Harness describes a performance experiment whose conclusion is the large factors quoted above. We've provided a downloadable kit to enable you to repeat the experiment yourself.

Freedom, Order, and PL/SQL Optimization, intended for professional PL/SQL programmers, explores the use and behavior of the new compiler.

PL/SQL Performance - Debunking the Myths, again intended for readers who work at the PL/SQL codeface, re-examines some old notions about PL/SQL performance.

Summary of New PL/SQL Language Features
Oracle Database 10g introduces support for these new language features:
  • the binary_float and binary_double datatypes (the IEEE datatypes).
  • the regexp_like, regexp_instr, regexp_substr and regexp_replace builtins to support regular expression manipulation with standard POSIX syntax.
  • multiset operations on nested table instances supporting operations like equals, union, intersect, except, member, and so on.
  • the user-defined quote character.
  • indices of and values of syntax for forall.
  • the distinction between binary_integer and pls_integer vanishes.
All these features except the user-defined quote character - a convenience feature for the programmer - are performance features and, of course, they all have efficient implementations. For example, the IEEE datatypes enjoy the benefit of machine arithmetic for mathematical real numbers. An appropriate algorithmic task that is expressed in PL/SQL using any of these new features will run very much faster than one that avoided them. The PL/SQL Just Got Faster whitepaper reports improvement factors ranging between four and thirteen for test programs which depend heavily on number arithmetic and which were reimplemented using the new binary_double datatype.

In the list of new language features, all but the forall enhancement and the change concerning PL/SQL integers are, formally speaking, new features in SQL. PL/SQL has an obligation to support all such SQL features in a PL/SQL context (for example, in PL/SQL assignment statements). This is a unique strength of PL/SQL and is closely related to the fact that it shares the same datatype system as SQL. The PL/SQL Development Team works to enable users to be able to use SQL and PL/SQL seamlessly together.

The new PL/SQL compiler also introduces support for compiler warnings. There are various categories of warning (severe, performance, and informational). Each category and each individual warning can be independently enabled, disabled, or treated as a compilation error.

Summary of New PL/SQL Supplied Packages
PL/SQL packages are used to extend the functionality of the Oracle Database when SQL cannot be extended for the purpose. As such, they implement a vast range of functionality. As is normal when discussing new PL/SQL features, we restrict ourselves in this section to just those packages which can be considered to augment the PL/SQL language itself.

  • Utl_Mail. This new package makes it possible for a PL/SQL programmer to send programmatically composed emails. It requires only the normal mental model of a user of a GUI email client rather than an understanding of the underlying protocol (SMTP) features. This distinguishes it from Utl_Smtp which was introduced in Oracle8i Database. Utl_Smtp requires that the programmer understands the details of the SMTP protocol. Utl_Mail is much simpler to use because it supports just a limited, but very common, subset of the functionality that Utl_Smtp provides. 
  • Utl_Compress. This new package delivers the familiar functionality of the zip and unzip utilities in a PL/SQL environment. It lets you compress and uncompress a raw or blob bytestream and guarantees return of original bytestream after a round trip.
  • Dbms_Warning. This allows the PL/SQL programmer fine grained control over which categories of warning and which individual warnings to disable, to enable, or to treat as errors. Its expected use is at the start and end of installation scripts so that each script may run in its intended regime without affecting the regime of subsequent scripts.
Oracle PL/SQL Programming, 5th EditionSteven's upcoming book - Oracle PL/SQL Programming is due in October at Oracle Open World, but you can pre-order it today! Steven tells us the new book includes the following key changes:
  • Coverage of new Oracle Database 11g Release 2 features, which I cannot (according to my lawyers) even describe to you yet, plus of course Release 1 features, including the function result cache, the CONTINUE statement, fine-grained dependency tracking, compound triggers, SecureFiles for large objects, supertype invocation from subtypes, and enhancements to native compilation, compiler optimization, and dynamic SQL.
  • A new chapter on PL/SQL performance optimization that collects together just about everything I could think of to help you make your code run faster, including a fantastic and very detailed section on pipelined table functions written by Adrian Billington.
  • For the very first time ever, all code examples and fragments are available in files, include DDL statements for all referenced tables. Readers have been asking for this for years and I finally buckled down and did it (finding lots of typos and bugs to fix along the way, of course!).

Other Papers by Steven Feuerstein:

Did You Know? We Do More Than Just Training!
At TruTek, we offer training classes, remote database and applications administration support, and on-site consulting. And in the next month, a few of our top consultants 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.

Brandon - Brandon's extensive background with various ERP systems, coupled with his degree in Human Resource Management, him an excellent functional lead for Human Resource applications, including the Oracle E-Business Suite, Lawson ERP and Viewpoint ERP.

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.

Samuel - Here's a Database Administrator with excellent credentials. Samuel is an Oracle Certified Professional, an Oracle 10g Certified Technician, and he has an Oracle DBA Masters. Couple that with years of experience as a senior database analyst, and you've got someone that can manage your database and work well with any development team.

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.
Identify the SQL Statement Causing Those WAIT #X Lines in a (top-truncated) SQL Tracefile by Tanel Poder
Tanel Poder, an Oracle ACE Director and Oracle Certified Master, is one of our most popular instructors.

Have you experienced this situation before?
  1. A performance issue happens in production - let say some batch job has ran way over time
  2. You enable SQL trace on the problem session (while the problem is already ongoing)
  3. In tracefile you see lots of waits (or execs or fetches) caused by cursor X
  4. You grep for "PARSING IN CURSOR #X" above the waits in the tracefile but don't find the corresponding parsing entry nor SQL text there (this is a "top-truncated" tracefile)
  5. You really want to know which SQL corresponds to all those WAIT #X/FETCH #X lines
An example output would be here:

WAIT #2: nam='db file scattered read' ela= 25190 file#=1 block#=863 blocks=2 obj#=113 tim=548703769817
WAIT #2: nam='db file sequential read' ela= 51397 file#=1 block#=864 blocks=1 obj#=113 tim=548719015123
WAIT #2: nam='db file scattered read' ela= 348553 file#=1 block#=5969 blocks=8 obj#=113 tim=548732315966
WAIT #2: nam='db file scattered read' ela= 32275 file#=1 block#=5972 blocks=5 obj#=113 tim=548771073619

In above case the cursor #2 was causing all these WAIT lines. The problem is, that if the cursor #2 was parsed before the SQL trace was enabled, we won't have the SQL statement dumped in the tracefile! Thus, by looking into the tracefile only, there's no way to know which exact SQL statement is causing those waits.

If this was a single long-running SQL statement, you could easily look into v$session.sql_hash_value and map this to SQL text using v$sql. However things aren't as simple when you have lots of PARSE,EXEC,FETCH calls of other statements happening in between (as the sql_hash_value would be constantly changing due each such call.

Also, other v$ (or x$) views don't show you anything about the WAIT #X mapping to SQL statement as this stuff is not stored in SGA.

As a workaround, you could take the obj# and map it back to object number the (io) wait happened on and make some guesses about SQL statement from there. Or you could dump the datablock using file# and block# numbers, look at the data and make some further guesses about SQL statement, but guesses are no good as they can be wrong and misleading - and you would be dependent on luck in your troubleshooting. But you want to be systematic, right? ;-)

So, in case of the top-truncated tracefile, if you want to be sure which WAIT# (or FETCH#,EXEC#) lines correspond to which SQL statement, we need to use some other way than v$views or trying to guess based on bits in the tracefile.

And guess what - its easy! Well, as long as the cursor of interest is still open... Time to talk about cursordump!

Since Oracle 10g there's a new dump event, called CURSORDUMP in Oracle. Depending on level, it can dump either shared cursors from library cache or opened/cached cursors of a session.

As CURSORDUMP is a little documented event and as it crashes on some early Oracle 10g versions, I don't recommend to use that.

But there are the widely known and Metalink-documented ERRORSTACK and PROCESSSTATE dumps which also dump the cursordump data!

When you dump ERRORSTACK at level 3 or PROCESSSTATE at level 10 with oradebug, you will have cursors from target process'es session open cursor array dumped to trace.

Among a lot of other info, you will see an overview section which mentions how many cursors are opened by that session and in which state they are (like parsing or fetch-ready state):

******************** Session Cursor Dump **********************
Current cursor: 2, pgadep: 0
Open cursors(pls, sys, hwm, max): 2(0, 0, 64, 300)
NULL 0 SYNTAX 0 PARSE 0 BOUND 0 FETCH 2 ROW 0
Cached frame pages(total, free):
4k(11, 2), 8k(0, 0), 16k(0, 0), 32k(0, 0)
pgactx: 257EED54 ctxcbk: 00000000 ctxqbc: 00000000 ctxrws: 257F5B8C

Read More

Other Papers by Tanel Poder:
Learn From the Master: Robert Freeman
Don't be intimidated by Robert's many credentials - in addition to being an author of many books about Oracle, and a very experienced DBA, Robert is also an Oracle ACE and a karate black belt. Don't miss Robert's upcoming classes: Oracle 10g DBA Boot Camp I, Backup and Recovery Using 10g RMAN, Oracle 10g DBA Boot Camp II, and Oracle Database 11g New Features.

Robert FreemanRobert's latest technical book, called 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.

Hot Off the Press... Oracle Data Guard 11g Handbook 
Oracle Data Guard 11g Handbook
Co-authored by Larry Carpenter, Joseph Meeks, Charles Kim, Bill Burke, Sonya Carothers, Joydip Kundu, Michael Smith and Nitin Venguerleker, this book describes how Data Guard provides superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Co-written by a team of Oracle experts, the Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download.


  • Develop a disaster recovery plan for your Oracle database to meet your organization's requirements
  • Configure and deploy Oracle Data Guard for your environment
  • Tune and troubleshoot your physical and logical standby databases
  • Implement the Oracle Data Guard Broker management framework
  • Integrate with Oracle Grid Control
  • Monitor your Oracle Data Guard environment
  • Enable read-only services and disaster recovery with Oracle Active Data Guard
  • Configure seamless database and application failover
  • Minimize planned downtime using Oracle Data Guard switchover
  • Handle backup and recovery with Oracle Recovery Manager
Don't Miss Our Favorite Gurus at OpenWorld!
These are the experts we turn to, not only for our training classes, but also for their deep knowledge about Oracle. Don't miss their presentations and Oracle OpenWorld 2009, which will be October 11-15 in San Francisco.

Steven Feuerstein
Why You Should Care About PL/SQL in Oracle Database 11g Now! - So Oracle has come out with another version. You probably won't be using it for years, so why should you bother learning about what's new in PL/SQL in Oracle Database 11g now? A very reasonable question, and the answer is: because once you understand what will be possible in Oracle Database 11g, it will change the way you write your code now. This session offers an overview of the most exciting new features for PL/SQL in Oracle Database 11g and proves to you beyond the shadow of a doubt that you should be designing your code at this moment to get ready for that version.

Automated Testing Options for Oracle PL/SQL -
We all know we should test our code more thoroughly, but who has the time and patience, and isn't our code "good enough" anyway? Did you know that it is widely accepted that if you have a program of 500 lines, you should expect to write 5,000 lines of test code? Ah, so that's why we don't test our code! If you are not satisfied with the number of bugs in your code or if you sometimes find yourself embarrassed when demonstrating your software to users, then attend this session to learn how you can automate the testing process, reduce bugs in your code, and increase confidence in your applications. The session reviews tools, from open source to commercial, that offer varying levels of testing automation.

Coding Therapy for Software Developers - We can't write software without our brains, and our brains come with a full load of "issues." The way our brain remembers the past and projects into the future has a big impact on how we write code. Moving beyond physiology, human psychology also plays its role, making it difficult for us to acknowledge ignorance and ask for help. This keynote address offers an intensive coding therapy session to help all attendees come to grips with their innate, unavoidable "issues," making it easier to write better code-and help others on their team write better code.

Mike Swing
Failover and Load Balancing of Parallel Concurrent Processing in Oracle E-Business Suite 11i/12 - This session introduces failover and load balancing concepts for Releases 11i and 12 and discusses new features. Failover mechanisms vary with each release and depend on an understanding of TCP concepts and SQL*Net. This makes the configuration critical. It examines the importance of dead connection detection, reviews the results of a case study, and explains generic service management relative to the starting and stopping of services for parallel concurrent processing. It also explains which features of Release 11i are now obsolete, discusses new features introduced in Release 12, and explores the effects of these new features.

Jonathan Lewis
How to Hint - Hints are badly understood and difficult to use safely. The optimizer group is working constantly to make the optimizer so robust that hints will become redundant, but until it achieves this aim, it is important to understand what hints are and how they work. In Oracle 9 Database, there were about 127 hints, of which about 60 were documented. In Oracle Database 11g, there are about 236, and even the hints that seem to be well known and easily understood may be more subtle than you think, which fools people into believing that Oracle can "decide" to ignore a hint. This session explains what a hint is and then offers you insight into why hints generally should be avoided but are sometimes needed and must be treated with extreme caution.

Tim Gorman
Scaling to Infinity: Partitioning Data Warehouses on Oracle Database - This presentation explains and conclusively justifies one of most important technical decisions that can be made during the physical build of a data warehouse based on Oracle Database, regardless of size: how best to implement partitioning. Partitioning permits the full power of numerous advanced Oracle Database features to be brought to bear on the data warehouse, regardless of how large it grows or how busy it becomes in the future, which the speaker characterizes as the "virtuous cycle." Not starting with partitioning, regardless of how humble the beginnings, can lead to a deadly embrace of unfortunate circumstances that can doom a project to eventual-almost inevitable-failure, which the speaker characterizes as a "death spiral."

Christian Antognini
Interpreting Execution Plans - An execution plan describes the operations carried out by the SQL engine to execute an SQL statement. Every time you have to analyze a performance problem related to an SQL statement or simply question the decisions taken by the query optimizer, you must know the execution plan. Whenever you deal with an execution plan, you carry out three basic actions: you obtain it, you interpret it, and you judge its efficiency. The aim of this session is to describe in detail how you should perform the second of these three actions-in other words, how to read execution plans.

Dan Hotka
Tools of the Trade: All the Free Tools from Oracle - This session's speaker has used a variety of SQL tuning tools over the years. The presentation includes a live demonstration of various tools available from Oracle. It is packed full of tips and techniques, including scripts that help find offending SQL statements.

The session covers these topics:
� Oracle SQL Developer
� SQL*Plus autotrace
� SQL*Plus explain plan scripts
� SQL*Plus undocumented explain plan features
� TKProf (Oracle trace facility)
� The new Oracle Database 10g trace analyzer
� PL/SQL profiler (with scripts)

Scott Spendolini
Welcome to the Oracle Application Express Sunday Symposium (ODTUG/IOUG) - In this session, Scott Spendolini of Sumner Technologies and Dimitri Gielis of APEX Evangelists welcome the group and provide an overview for the entire day.

Troubleshooting Oracle Application Express - Oracle Application Express is made up of several technologies: PL/SQL, HTML, CSS, JavaScript, and Ajax. When something goes wrong, it's often more difficult to figure out what went wrong than it is to fix it. This presentation takes a brief look at each technology that makes up Oracle Application Express and discusses and demonstrates how to effectively track down and solve the problem. As an added bonus, every tool outlined in this presentation is available for free.
 
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 August 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!
Upcoming TruTek Training Classes
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. 

Not finding the course or date or location that you're looking for? Let us know!

Date

Class

Location

 

Technical Classes

 

Aug 10-12

Oracle BI Publisher

SLC, UT

Aug 25-27

Intro to SQL

SLC, UT

Sep 14-18

Oracle R12 Applications  DBA Concepts and Administration

Fullerton, CA

Sep 14-18

Oracle E-Business Suite R11i-R12 Technical Upgrade

Fullerton, CA

Sep 15-17

Intro to SQL

Fullerton, CA

Sep 15-16

The Best of Oracle PL/SQL Seminar with Steve Feuerstein

Fullerton, CA

Sep 21-23

Oracle 11i Workflow Builder, Business Events and Administration

SLC, UT

Sep 21-25

Oracle 10g DBA Boot Camp I with Robert Freeman

SLC, UT

Sep 28- Oct 2

Oracle R12 Applications  DBA Concepts and Administration

Seattle, WA

Sep 28- Oct 2

Oracle E-Business Suite R11i-R12 Technical Upgrade

Seattle, WA

Sep 28-30

Intro to SQL

Seattle, WA

Oct 19-23

Oracle Release 11i Applications System Administration

SLC, UT

Oct 19-20

Intro to PL/SQL

SLC, UT

Oct 21-23

Advanced PL/SQL Tips and Techniques

SLC, UT

Oct 26-30

Oracle Database 11g New Features with Robert Freeman

SLC, UT

Nov 3-5

Intro to SQL

Denver, CO

Nov 2-6

Oracle E-Business Suite R11i-R12 Technical Upgrade

Denver, CO

Nov 2-6

Oracle 11i/R12 Applications  DBA Concepts and Administration

Denver, CO

Nov 10-13

Introduction to Oracle Business Intelligence EE (OBIEE)

SLC, UT

Nov 17-20

Scaling to Infinity: Partitioning in Data Warehouses on Oracle     with Tim Gorman

SLC, UT

Nov 30-Dec 4

Oracle E-Business Suite R11i-R12 Technical Upgrade

Las Vegas, NV

Nov 30-Dec 4

Oracle 11i/R12 Applications  DBA Concepts and Administration

Las Vegas, NV

Dec 7-11

Oracle E-Business Suite R11i-R12Technical Upgrade

New Jersey

Dec 7-11

Oracle 10g DBA Boot Camp I with Robert Freeman

New Jersey

Dec 7-11

Oracle 11i/R12 Applications  DBA Concepts and Administration

New Jersey

Dec 8-10

Intro to SQL

New Jersey

Dec 10-11

The Best of Oracle PL/SQL Seminar with Steve Feuerstein

New Jersey

Dec 14-18

Oracle 10g DBA Boot Camp II with Robert Freeman

SLC, UT

Dec 15-16

Discoverer for End Users Training

SLC, UT

Dec 17-18

Discoverer for Administrators

SLC, UT

Dec 15-17

Intro to SQL

Phoenix, AZ

Jan 18-22

Oracle 10g DBA Boot Camp II with Robert Freeman

Las Vegas, NV

Jan 19-21

Intro 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

May 17

Trouble Shooting and Tuning Oracle with Jonathan Lewis

Boston, MA

May 18

Writing Optimal SQL with Jonathan Lewis

Boston, MA

 

Functional Classes

 

Aug 10-12

Oracle Release 12 AME (Approvals Management Engine)

SLC, UT

Aug 17-20

R11i/R12 Financial Business Process Overview

San Diego, CA

Aug 24-25

Oracle Release 11i Fixed Assets

San Diego, CA

Aug 24-27

Oracle Release 12 New Features (Functional)

San Diego, CA

 

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

 

Sep 2

UTOUG SIG Fest

SLC, UT

Oct 11-15

Open World

San Francisco, CA


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