Were you unable to attend the last TUSC monthly web briefing?  The briefings are now available on-demand:

• Watch the entire briefing, or choose individual sections to maximize your time.
• Come back as many times as necessary to get the expert information you need.
• Allow others in your organization to watch the briefings as it applies to, and benefits, their individual positions.

Please note:  All briefings require Internet Explorer 5.0 or later, Netscape Navigator 7.0 or later, or Internet Explorer 5.2.2 or later for Mac.

Subjects

Oracle E-Business Suite
Business Intelligence
Custom Development
Database Services
Managed Services
Personal Development
 

Upcoming Live and Recorded Presentations

The ABCs of Outside Processing with R12 - A Guide to Get Up and Running
As companies continue to strive to reduce costs and improve customer service, more and more companies are streamlining their manufacturing operations with outside processing. This presentation will focus on the essentials to utilizing outside processing within the Discrete Manufacturing module. Attendees will learn the required steps to set up and configure this functionality while highlighting each area and offering tips and tricks to introduce this powerful functionality.

My Adventures Tuning Oracle Applications on RAC with Grid Control
This presentation will focus on experiences of tuning Oracle Applications on RAC using Oracle Grid Control (Enterprise Manager Grid Conrol). Areas to be covered include:

1. Grid basics
2. How Oracle Applications changed the playing field
3. Quick tuning quick tips using AWR Report
4. Using Grid Control to monitor Oracle Applications
5. Using Grid Control to tune systems
6. Other Oracle Applications-specific issues
7. Summary

Understanding LDAP
While the LDAP standard has existed for quite some time, it is a relatively new concept for most administrators and developers who work with Oracle. This presentation will detail what LDAP is, how it works, what LDAP means to developers and administrators, and how Oracle has chosen to implement LDAP as part of the Oracle Application Server.

BPEL 101
Service-Oriented Architecture (SOA) has been identified by Oracle as a key technology for the future. Oracle's recent versions of the Application Server have all included SOA technologies, and its specifications for Oracle Application Server 11g indicate that Oracle is committed to SOA. As Oracle's development tools (JDeveloper, Application Express, Portal) focus more and more on Web-centric implementations, the Application Server will become a staple in most organizations committed to Oracle technologies. As such, understanding and being able to implement BPEL-based solutions will become a prerequisite for developers, administrators and system architects. This presentation will explain Oracle's BPEL implementation and how to use it effectively when architecting Web-based solutions.

10g Tuning - Tuning Oracle has Radically Changed
This presentation focuses on tuning Oracle10g. We will briefly review how Oracle has changed over the years and demonstrate the company's current direction with 10g. We'll look at RAC and how it can prepare you for moving to grid computing, how Enterprise Manager lets you manage the entire environment and some other tuning features. We will also cover statspack tuning in detail, demonstrating how to use statspack to evaluate and fix issues related to the top five wait events, load profile, instance efficiency ratios, latch waits, top SQL, instance activity, and file i/o issues. Finally, we'll look at some helpful V$ views and X$ tables when you need to dig deeper that can help as well. The presentation outline follows below.

I. Oracle...Always in the fast lane
     a. Why Oracle?
     b. Oracle Innovation
II. Consolidation
     a. Moving to centralized computing
     b. Cost savings c. Where grid fits in
III. Grid Computing and 10g new features
     a. Data Pump
     b. Rename Tablespace
     c. DBMS_ADVANCED_REWRITE
     d. Flush

Manager's Guide to 11g New Features
This presentation will look at which 11g new features should be investigated for use by managers. The presenter will discuss when and why to use the following new features:

Memory Target; Partition Advisor; Security Enhancements; Read-only Tables; DDL Lock Timeout; The Invisible Index; The Virtual Column; Automatic Diagnostics Repository; SQL Plan Baselines; The Result Cache; Workload Capture and Replay; SQL Repair Advisor; ADDM Enhancements; Interval Partitioning; Partition Compression

Take the Plunge: Top New 11g PL/SQL Features
This presentation will cover the new key PL/SQL-related features specific to Oracle 11g. The new features covered include: new conditional compilation, new PL/SQL commands, new and enhanced Oracle supplied packages, new functions, new enhanced SQL commands, etc. Each of the features covered will include example code to enforce the new feature's capabilities and usefulness.

A look behind the scenes - Managed Services
A look at what you can expect and the value you receive from Remote DBA, Database, OS Support, and Oracle E-Business Support.

Uncommon Leaders of IT
The IT leader is now a pivotal position in an organization's business plan. This presentation will focus on the attributes that a leader must have from a character perspective to complement technical prowess. As the IT leader, you must build qualities into your team including: integrity, moral courage, physical courage, tact, loyalty, unselfishness, initiative, enthusiasm, knowledge, respect, self control, and humility. This presentation will teach you how to refine these attributes and allow the uncommon leader within you to emerge.

Your Success Extends Beyond Technical Excellence - The Non-Technical Side
This presentation focuses on the keys to being successful at your job by applying non-technical skills. Far too often, employees become technically proficient through education, but they are never educated on the other half of the equation - namely, the non-technical skills. These critical skills should not be overlooked. This presentation reviews a variety of skills that can be applied to your work environment to make you and your company more effective. The presentation covers the following areas: customer service, change, effective meetings, listening, responding to situations, building a winning team and effective communication. These areas are each covered with examples.

Oracle E-Business Suite

Coming Soon

The ABCs of Outside Processing with R12 - A Guide to Get Up and Running
As companies continue to strive to reduce costs and improve customer service, more and more companies are streamlining their manufacturing operations with outside processing. This presentation will focus on the essentials to utilizing outside processing within the Discrete Manufacturing module. Attendees will learn the required steps to set up and configure this functionality while highlighting each area and offering tips and tricks to introduce this powerful functionality.

My Adventures Tuning Oracle Applications on RAC with Grid Control
This presentation will focus on experiences of tuning Oracle Applications on RAC using Oracle Grid Control (Enterprise Manager Grid Conrol). Areas to be covered include:

1. Grid basics
2. How Oracle Applications changed the playing field
3. Quick tuning quick tips using AWR Report
4. Using Grid Control to monitor Oracle Applications
5. Using Grid Control to tune systems
6. Other Oracle Applications-specific issues
7. Summary

Now Available

Project Management Strategies to Ensure a Successful Global Implementation (Live Broadcast 9/27/07)
This presentation will focus on several vital areas of Project Management that are often difficult to manage during a Global project - key areas to keep a global team a team, from preparing the user community, the CRP process, communication and sharing the success!

Business Intelligence

Now Available

Business Intelligence Center of Excellence (Live Broadcast 10/17/06)
What BI-COE is, what is working and what's not.  The seminar includes discussion on objectives, architecture roles and responsibilities, services, integration of the COE and project implementation teams, as well as what is working well, and not so well, at case study locations.

The CIO's Guide to Taking Data Asset Metrics to the Boardroom: A Case Study  (Live Broadcast 7/25/06)
This briefing represents a case study recently completed, discussing and resolving issues such as how to value or manage data, and what metrics are reported to the leadership team.

Virtual Data Warehousing (Live Broadcast 5/23/06)
A non-obtrusive, real-time, virtual integration solution. This presentation demonstrates how to create a virtual data warehouse.

Custom Development

Coming Soon

Understanding LDAP
While the LDAP standard has existed for quite some time, it is a relatively new concept for most administrators and developers who work with Oracle. This presentation will detail what LDAP is, how it works, what LDAP means to developers and administrators, and how Oracle has chosen to implement LDAP as part of the Oracle Application Server.

BPEL 101
Service-Oriented Architecture (SOA) has been identified by Oracle as a key technology for the future. Oracle's recent versions of the Application Server have all included SOA technologies, and its specifications for Oracle Application Server 11g indicate that Oracle is committed to SOA. As Oracle's development tools (JDeveloper, Application Express, Portal) focus more and more on Web-centric implementations, the Application Server will become a staple in most organizations committed to Oracle technologies. As such, understanding and being able to implement BPEL-based solutions will become a prerequisite for developers, administrators and system architects. This presentation will explain Oracle's BPEL implementation and how to use it effectively when architecting Web-based solutions.

Now Available

The Path to an Instant SOA (Live Broadcast 4/8/08)
Click Here to register for an extra live presentation on this Web Briefing on May 6, 2008.
TUSC has some exciting news that we would like to share with you. The benefits of having a service oriented architecture are many, as you can see below. However, the cost of effort to "get there" are also great... until now. With TUSC's new, revolutionary technology "Instant SOA", you'll be able to instantly move your existing architecture into a service oriented architecture...and we do mean instantly - without effort, and without re-writing anything.

Internal and External Application Integration through Web Services (Live Broadcast 7/24/07)
Having ventured down the path of a full bore implementation of internal and external application integration in what I perceived as the most efficient and cost effective manner, you'll get the benefit of my hind sight introspections today. Specifically, I implemented a light weight Service Oriented Architecture (i.e. Web Services) wherever it made sense. This presentation will discuss the good, bad and ugly about this approach that was taken. Knowing what I know today, I would in fact take this approach again. In fact, I highly recommend my self-named light-weight SOA.
Additional Downloads:
       Internal and External Application Integration through Web Services - White Paper
       Internal and External Application Integration through Web Services - Presentation Slide Deck
Additional PL/SQL help for Web Services:
      http://forums.oracle.com/forums/thread.jspa?threadID=515316&tstart=60
      http://forums.oracle.com/forums/thread.jspa?threadID=428059&tstart=-1
      http://download-uk.oracle.com/docs/cd/B32110_01/web.1013/b28974/devdbase.htm#BDCGJJHD

The Face of SOA (2007 Collaborate Presentation - Live 4/17/07)
Service-Oriented Architecture is the hot, new buzzword in the IT industry today. This presentation will define SOA, discuss Business Process Execution Language (BPEL), a major component of SOA, show how SOA can benefit your organization and how Oracle supports SOA through its many development and application server component offerings.

How IntelliReal uses Web Services to Enable Customers to Better Service their Clients (2007 Collaborate Presentation - Live 4/16/07)
This presentation includes a demonstration of the SOA application in action. IntelliReal uses Oracle Application Express as the sales tool, but typically delivers its solution from business-to-business using the SOA solutions. The presentation also covers SOA and how it can change how you deliver applications to your customers (and other internal groups).

SOA, BPEL and Web Services (Live Broadcast 6/27/06)
This presentation will help you understand each of these terms and how they will impact your business - now and in the future.

Advanced Oracle Application Express (APEX) Tips and Techniques (2007 Collaborate Presentation - Live Broadcast 6/26/07)
Oracle Application Express (Apex) is a powerful and comprehensive tool. Numerous advanced tips and techniques will be covered in this presentation. These topics include: pop-up windows, complex searches, document management, indexing and searching, "tool tip" or hints, email links, page 0, help text, background jobs, "add to my calendar" feature, saving contacts (VCF), sending mass emails, and more.
Demos to Download for the Presentation:
       http://www.tusc.com/oracle/technology/downloads/demo_app.dmp
       http://www.tusc.com/oracle/technology/downloads/demo_app_apex.sql

Oracle AS Portal - Past, Present & Future - Efficiency for Customer Enablement (Live Broadcast 4/24/07)
Please join TUSC for this live one-hour presentation and demo and discover how Oracle Portal can help you reduce cost, increase service, and provide a single point for customer-based interactions. Oracle Portal, a member of the Oracle Fusion Middleware family of products, offers a complete and integrated framework for building, deploying, and managing enterprise portals. Only Oracle Portal delivers a unified and secure point of access to all enterprise information and services to improve business visibility and collaboration, reduce integration costs, and ensure investment protection.

Database Services

Coming Soon

10g Tuning - Tuning Oracle has Radically Changed
This presentation focuses on tuning Oracle10g. We will briefly review how Oracle has changed over the years and demonstrate the company's current direction with 10g. We'll look at RAC and how it can prepare you for moving to grid computing, how Enterprise Manager lets you manage the entire environment and some other tuning features. We will also cover statspack tuning in detail, demonstrating how to use statspack to evaluate and fix issues related to the top five wait events, load profile, instance efficiency ratios, latch waits, top SQL, instance activity, and file i/o issues. Finally, we'll look at some helpful V$ views and X$ tables when you need to dig deeper that can help as well. The presentation outline follows below.

I. Oracle...Always in the fast lane
     a. Why Oracle?
     b. Oracle Innovation
II. Consolidation
     a. Moving to centralized computing
     b. Cost savings c. Where grid fits in
III. Grid Computing and 10g new features
     a. Data Pump
     b. Rename Tablespace
     c. DBMS_ADVANCED_REWRITE
     d. Flush

Manager's Guide to 11g New Features
This presentation will look at which 11g new features should be investigated for use by managers. The presenter will discuss when and why to use the following new features:

Memory Target; Partition Advisor; Security Enhancements; Read-only Tables; DDL Lock Timeout; The Invisible Index; The Virtual Column; Automatic Diagnostics Repository; SQL Plan Baselines; The Result Cache; Workload Capture and Replay; SQL Repair Advisor; ADDM Enhancements; Interval Partitioning; Partition Compression

Take the Plunge: Top New 11g PL/SQL Features
This presentation will cover the new key PL/SQL-related features specific to Oracle 11g. The new features covered include: new conditional compilation, new PL/SQL commands, new and enhanced Oracle supplied packages, new functions, new enhanced SQL commands, etc. Each of the features covered will include example code to enforce the new feature's capabilities and usefulness.

Now Available

PL / SQL Challenge: 20 Key Tips Everyone Must Know  (2007 Collaborate Presentation - Live Broadcast 5/29/07)
This presentation will cover 20 top Oracle PL/SQL tips and features. There are many features and tips that have presented in various presentations throughout the years. There are many features that have been incorporated into Oracle PL/SQL over the past 15 years. This presentation takes 20 of the top features and tips and educates the attendees on the usefulness and power of these top 20. They are all covered with examples throughout the presentation.

The Best 11g New Features (2007 Collaborate Presentation - Live 4/17/07)
By special permission of Oracle, TUSC will be bringing you an exclusive look at the best new features of 11g, and exploring those that should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm. There will be simple examples to show the basic functionality of all features.

New Oracle Database 10g and Oracle 9i features for developers (2007 Collaborate Presentation - Live 4/17/07)
As new database versions roll out, so do some exciting new features. This presentation discusses the new Oracle Database 10g, Oracle9i, and Oracle8i features that enhance a developer's ability to develop mission-critical Web-based applications. The new features demonstrated in the presentation allow a developer to add reliability, stability, speed, and flexibility to any application. Among the topics featured in the presentation are PL/SQL compilation, merge, multitable inserts, bulk binds, triggers on system events, and native dynamic SQL. Attendees gain an understanding of the features, learn when to use them, and learn the design considerations associated with each.

Tuning Oracle 9i and Oracle Database 10g Using Statspack & AWR Report (2006 OOW Presentation - Live Broadcast 1/30/07)
What is a quick way to monitor, find, and solve performance problems? Statspack is a quick way to solve many of the performance issues that plague your system. This presentation shows you how to use Statspack and Oracle Automatic Workload Repository Report to evaluate and fix issues related to the top five wait events, load profile, instance efficiency ratios, wait histograms, latch waits, top SQL, instance activity, and file I/O issues. Come to the session to understand how to quickly solve performance issues without doing a system evaluation that is more costly than the system itself. The session also looks at how to run the report from Oracle Grid Control.

The PL/SQL Grid: Time to Expand to Oracle Database 10g Release 1 and Release 2 (2006 OOW Presentation - Live Broadcast 1/16/07)
This presentation covers the new PL/SQL-related features specific to Oracle Database 10g Release 1 and Release 2. The new features covered include the following: new conditional compilation, new PL/SQL commands (regular expressions), new and enhanced Oracle supplied packages (dbms_output, dbms_ddl wrap procedure, dbms_warning, dbms_stats), new functions, and new and enhanced SQL commands. Each of the features covered includes example code to enforce the capabilities and usefulness of the new features.

Tuning the Oracle Grid (2006 OOW Presentation - Live Broadcast 1/9/07)
This session shares the top tips when tuning your architecture for grid computing using Oracle Enterprise Manager 10g Grid Control. Oracle has come a long way from when it first introduced clustering. The tools for managing the grid continue to improve, and the session shows you many screenshots of some of the key features within the Oracle Enterprise Manager Grid Control 10g.

Managed Services

Coming Soon

A look behind the scenes - Managed Services
A look at what you can expect and the value you receive from Remote DBA, Database, OS Support, and Oracle E-Business Support.

Personal Development

Coming Soon

Uncommon Leaders of IT
The IT leader is now a pivotal position in an organization's business plan. This presentation will focus on the attributes that a leader must have from a character perspective to complement technical prowess. As the IT leader, you must build qualities into your team including: integrity, moral courage, physical courage, tact, loyalty, unselfishness, initiative, enthusiasm, knowledge, respect, self control, and humility. This presentation will teach you how to refine these attributes and allow the uncommon leader within you to emerge.

Your Success Extends Beyond Technical Excellence - The Non-Technical Side
This presentation focuses on the keys to being successful at your job by applying non-technical skills. Far too often, employees become technically proficient through education, but they are never educated on the other half of the equation - namely, the non-technical skills. These critical skills should not be overlooked. This presentation reviews a variety of skills that can be applied to your work environment to make you and your company more effective. The presentation covers the following areas: customer service, change, effective meetings, listening, responding to situations, building a winning team and effective communication. These areas are each covered with examples.

Now Available

How Oracle Came to Rule the Database World (2006 OOW Presentation - Live Broadcast 12/12/06)
In this session, sit back and listen to the history of the relational database go by. Learn what made Oracle the product a success, and the attributes that made Oracle the company a font of technological and business wizardry. The session reveals several seldom heard facts, and some of the secrets of Oracle's success.

Three Trends in the Oracle World  (2007 Collaborate Presentation - Live 4/17/07)
This presentation will discuss the current and future trends in Oracle, based on up to date information and announcements made at this year's Oracle Open World.