|
|
| 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 |
|
|
|
| What We Do |
 TruTek 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?
|
 If your company is starting to think about upgrading to Release 12, one of the most important first steps is to try out the upgrade. TruTek's Oracle E-Business Suite R11i/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.
 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 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 FeaturesOracle 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.
 Steven'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?
- A performance issue happens in production - let say some batch job has ran way over time
- You enable SQL trace on the problem session (while the problem is already ongoing)
- In tracefile you see lots of waits (or execs or fetches) caused by cursor X
- 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)
- You really want to know which SQL corresponds to all those WAIT #X/FETCH #X lines
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'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.
   Other Papers by Robert Freeman: |
| Hot Off the Press... 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.
|
| Your Claim to Fame... |
 You 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 editor@trutek.com 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:
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
|
|
|
|
