The PL/SQL Challenge: 15 Key Tips Everyone Must Know (4.47MB) Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover 15 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 15 of the top features and tips and educates the attendees on the usefulness and power of these top 15. They are all covered with examples throughout the presentation.

Catapult to the New PL/SQL: 10gR1 and 10gR2 Key Features (3.24MB) Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover the new key PL/SQL related features specific to Oracle10g 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, new enhanced SQL commands (flashback table, etc.), etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Take the Plunge: Top New 11g PL/SQL Features (3.87MB) Presented by: Joe Trezzo Date: 04/13/2008 Abstract: This presentation will cover the new key PL/SQL related features specific to Oracle 11g. The new features covered include the following: 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 features capabilities and usefulness.

Time to Master the Other Side - Key Non Technical Traits for Success (4.49MB) Presented by: Joe Trezzo Date: 04/13/2008 Abstract: 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 should not be overlooked. The 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.

Integration: Using OracleAS Portal to 'Bring It All Together' (1.05MB) Presented by: Chris Ostrowski Date: 04/18/2007 Abstract: As systems become more and more complex, end-users are faced with increasingly complicated and varying user interfaces. There is an urgent need for IS depatments to integrate systems and provide consistency between these applications. OracleAS Portal provides the means to integrate Oracle and non-Oracle-based systems into a visually consistent environment that end-users can access easily and administrators can maintain securely.

Three Major Trends in the Database World (5.22MB) Presented by: Rich Niemiec Date: 04/17/2007 Abstract: I've worked on Oracle, for almost two decades. Over the past five years, I've seen three major trends that seem to be molding the future of Oracle architecture and administration. The first is the adoption of clustering and an accelerating trend toward grid computing. The second is a movement toward Linux for smaller and mid-sized systems. The third is the pendulum swing first toward off-shoring database work and then a shift away from off-shoring and toward a new mixed model. All three movements are being driven by the usual corporate business goals of increasing efficiency and lowering costs. This presentation will show how these trends will affect every organization interested in consolidation and increasing operating margin dramatically.

What if Kramer was your DBA and Seinfeld Tuned your Database (9.25MB) Presented by: Rich Niemiec Date: 04/17/2007 Abstract: This light hearted presentation will show what would happen if you had the characters from Seinfeld tune your database. Topics include: Jerry, I can't find my backup I know I had it here somewhere I think the UPS guys stole it I may have taped over it with Brittany Spears George, the database doesn't tune itself Elaine, the DBA can't stop working at 5 PM Jerry, uses Grid Control, Statspack and AWR Report...his system works spectacularly.

The Best 11g New Features (5.70MB) Presented by: Rich Niemiec Date: 04/17/2007 Abstract: This presentation will look at which 11g new features 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. The features covered include: Start Me Up – Using Memory Target The Result Cache Invisible Indexes & Online Index Rebuilds Virtual Columns and other Nice Developer Tools ADDM Enhancements SQL Plan Management and SQL Plan Baselines SQL Access Advisor & Partition Advisor SQL Query Repair Advisor SQL Replay Advisor and DB Workload Capture & Replay Interval Partitioning & Partition Compression DBA Tools, ADR and DBMS_STATS Enhancements Grid Control & EM Security Enhancements & the Future Sizes Summary

The PL/SQL Challenge: 20 Key Tips Everyone Must Know (4.62MB) Presented by: Joe Trezzo Date: 04/17/2007 Abstract: This presentation will cover 20 top Oracle PL/SQL tips and features. There are many features and tips that have been 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.

Time to Master the Other Side - Key Non Technical Traits for Success (4.36MB) Presented by: Joe Trezzo Date: 04/16/2007 Abstract: 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 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. This 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.

Advanced APEX DB Tips and Techniques (1.84MB) Presented by: Brad Brown Date: 04/15/2007 Abstract: HTML DB (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.

Case Study - Using Web Services to seamlessly integrate companies (5.67MB) Presented by: Brad Brown Date: 04/15/2007 Abstract: IntelliReal (www.intellireal.com) is a real property market intelligence company. IntelliReal utilizes advanced technology and data aggregation to provide significantly enhanced data mining, accuracy, speed and reduced cost delivering valuation solutions. The Service Oriented Architecture (SOA) provides the foundation for IntelliReal's business-to-business delivery. IntelliReal's customers are able to seemly access the IntelliReal core technology as if that technology is running in their own IT environment. This presentation will include a demonstration of the SOA application in action. IntelliReal uses Oracle Application Express (APEX) as the "sales" tool, but typically delivers their solution from business-to-business using the SOA solutions. This presentation will cover the SOA and how it can change how you work to deliver applications to your customers (and other internal groups).

Oracle XML Best Practices (Sponsored by Select Journal) (2.95MB) Presented by: Brad Brown Date: 04/15/2007 Abstract: Are you facing the increasing demands for building SOA infrastructure, adoption industry XML standards, publishing reports over the Internet or handling unstructured data? If so, the XML expert round table session will be your excellent starting point to learn about the existing XML technologies. This panel of experts from the Oracle Product team, IOUG XML experts and customers will focus on best practices for XML, keys for successfully implementing XML and lessons learn. Topics: *XML best practices for data storage *XML best practices for data transformation *XML query best practices *XML validation best practices *XML publishing *Searching XML *XML Database Management (replications, streams, administration) *XML for integration (AQ, DB WS) *Optimizing large scale XML operations

Quick Web Development using JDeveloper 10g (2.26MB) Presented by: Brad Brown Date: 04/15/2007 Abstract: JDeveloper 10g is an amazing development environment. Each new version gets closer to rivaling Oracle Forms. Now with the Oracle Application Developer Framework (ADF), which includes TopLink and Struts, you can quickly and easily develop a GUI/HTML-based Web application using this point-and-click, drag-and-drop development tool.

New 10g and 9i Features for Developers (369KB) Presented by: Tony Catalano Date: 04/26/2006 Abstract: As the new database versions roll out, so do some exciting new features. This presentation discusses the new Oracle 10g, Oracle9i and Oracle8i features that enhance the developer's ability to develop mission critical Web-based applications. Using the new features demonstrated in this presentation add reliability, stability, speed and flexibility to any application. Just a few of the topics featured in the presentation are: PL/SQL compilation, Merge, multi-table 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.

Content Management with OracleAS Portal 10g R2 (1.04MB) Presented by: Chris Ostrowski Date: 04/26/2006 Abstract: Many people think of content management as icons on a web page that users can click to download an Excel file. The features Oracle provides in OracleAS 10gR2 to manage content give administrators incredible amounts of flexibility and security. This presentation will show the advanced features of Oracle's Content Management and show that, with the right planning, Content Administrators can deploy a dynamic content management system with virtually no written code whatsoever.

Using JDeveloper to Create and Deploy Portlets (592KB) Presented by: Chris Ostrowski Date: 04/25/2006 Abstract: The OracleAS Portal wizards are extremely powerful, but there many reasons for needing greater control of your portlets than the OracleAS Portal wizards can give you. Oracle JDeveloper gives you total control over your Portlet development. Previous versions of JDeveloper used an arduous process for developing and deploying portlets. This presentation will focus on the ease with which developers can develop and deploy portlets in the latest versions of JDeveloper and the Oracle Application Server.

The PL/SQL Grid: Time to Expand to 10g R1 and 10g R2 (899KB) Presented by: Joe Trezzo Date: 04/24/2006 Abstract: This presentation will cover the new PL/SQL related features specific to Oracle10g 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, new enhanced SQL commands (flashback table, etc.), etc. Each of the features covered will include example code to enforce the new features capabilities and usefulness.

Controlled Flights Into Terrain: Learning from Catastrophic Database Design Failures (643KB) Presented by: Kevin Loney Date: 04/24/2006 Abstract: Many database application failures result from design errors. These errors limit the performance and functionality of the application, ultimately limiting the business process the application is supposed to service. This presentation will provide a review of database application failures and a list of design principles that would have avoided the failures. From a performance perspective, every system is designed to fail at some point - and the system design is the key to extending the viability and usefulness.

Tuning Oracle at the Block Level; Beginners, Go Away! (1.54MB) Presented by: Rich Niemiec Date: 04/24/2006 Abstract: If this talk doesn't kill me nothing will. This is a look at Oracle moving at the block level. We'll look at how blocks move from disk to memory, how they become Current blocks, how they become Consistent Read (CR) versions and other interesting tidbits of information that only keep you from achieving the business goals of the company. Ok, it's because you want to know why. We'll also look at some of the cool x$ tables out there that you should stay away from including many that begin with x$ksm (like x$ksmsp - kernel storage memory SGA heap) what they'll reveal to you. We'll look at why the move toward 64-bit technology, memory resident databases and RAC/Grid makes this even more important to understand. Why you should understand some block level concepts Move toward memory resident databases Move toward RAC/Grid computing This is where the problems are hiding Block level concepts Current, CR and other blocks Versions of blocks Over the years Delayed block cleanout Blocks and the Grid Useful Scripts Summary

Beginner Tuning Tips for Developers (3.19MB) Presented by: Rich Niemiec Date: 04/24/2006 Abstract: This is a beginner level presentation on developer tuning. This presentation is focused on developers who are relatively new to Oracle. It will focus on some basic tuning tips and techniques that you can use to tune your code. After a brief look at how Oracle works and where a query fits into the process. We will look at how to find the problem queries in your system. We will also look at various indexes that can be built and things to watch out for with certain indexes. We'll review how to use explain plan and Autotrace. Lastly, we'll look at using hints to tune queries and joining tables. Overview of how Oracle works and where queries fit into the process Finding the problem queries Your indexing arsenal Using Explain Plan and Autotrace Hints that can help Joins and the Driving Table Partitioning Basics

Tuning Oracle9i/10g using Statspack & AWR (5.07MB) Presented by: Rich Niemiec Date: 04/24/2006 Abstract: What is a quick way to monitor, find and solve performance problems? Statspack & the 10g AWR Report are quick ways to solve many of your performance issues that plague your system. This presentation will show how to use statspack to evaluate and fix issues related to the top 5 wait events, load profile, instance efficiency ratios, wait events and wait histograms, latch waits, top SQL, instance activity, file i/o issues. We will also see how statspack compares to AWR Report and some of the additions that AWR Report gives you over statspack even though 80% is the same information as statspack. Come to this session to understand how to quickly solve performance issues without doing a system evaluation that is more costly the system itself. This includes both proactive tuning based on findings and reactive tuning based on wait events. Overview of statspack Top 5 wait events Load Profile Instance Efficiency Hit Ratios Wait Events Latch Waits Top SQL Instance Activity File I/O Memory Allocation Undo Oracle Recommendations Using Enterprise Manager Using other OEM screens to monitor and tune Helpful V$/X$ Scripts Summary

Giving Winning Presentations (4.45MB) Presented by: Rich Niemiec Date: 04/24/2006 Abstract: Every leader, manager, team leader and technology leader needs to effectively communicate information. How well you convey information to others can determine the success of a project, the relationship that you have with those around you and it can even determine your salary and how high you rise in the company. This presentation will focus on how to build and give winning presentations. This will show the keys to successful presentations along with my top tips for giving presentations. The topics that we'll cover include: Why you're giving the presentation Why your audience came to listen The opening Your speaking style and tone The abstract and material to cover Practicing Keeping it exciting The handouts Taking questions The summary and ending

Tuning the Oracle Grid (16.7MB) Presented by: Rich Niemiec Date: 04/24/2006 Abstract: This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. Getting good information RAC SIG OTN Oracle Technical Guides Grid Basics The interconnect and block coordination Tuning quick tips Tuning using statspack Tuning using grid tools High inserts Load balancing and FAN Future trends Installation Tips Where does ASM fit in? Enterprise Manager and Grid Control

Oracle Application Server 10g R2 New Features (198KB) Presented by: Chris Ostrowski Date: 04/24/2006 Abstract: Oracle Application Server embraces almost all of the major development frameworks available today. Oracle continues to add enhancements to its Application Server and keeping up with these new changes can be a challenge. The presentation will delineate the additional functionality Oracle has incorporated into the Application Server and will discuss Oracle's focus on SOA.

Spatially Enabling Your BI Applications with Oracle Spatial and Mapviewer (3.02MB) Presented by: Matt Topper Date: 04/24/2006 Abstract: Almost every data warehouse is litered with spatial information. Customer addresses, store locations, competitor locations, etc. All of this data has great potential to add value to your Business Intelligence products. This presentation will cover how to spatially enable your data and include it in your BI dashboards. I will show the Oracle Locator and Geocoder and how to transform address information to latitude and longitude numbers. Using the database data I we will show how to create store territories based on real customer data. Now that the territories have been made we can display the information utilizing Oracle Mapviewer to visualize the data. Lastly, we will turn the map created in Oracle Mapviewer and add it to a Portal BI Dashboard.

How to use Regular Expression Functions in 10g (339KB) Presented by: Kevin Loney Date: 04/24/2006 Abstract: As of Oracle Database 10g, you can use the regular expression functions to perform very complex searches. This presentation will show the formats for the functions along with examples of searches. Examples include case-insensitive searches and searches for classes of characters (such as all numbers, or all uppercase letters). As a bonus, case-insensitive search options that do not use the regular expressions will also be shown.