Scheduled Queries (171KB) Presented at: Article Presented by: Brad Brown Date: 09/07/2007 Abstract: For any database application environment, you may wish to run a query and return the results to a list of people on a scheduled basis. This document describes exactly how you can accomplish this goal through scheduled queries. This process is a universally applicable database application. Each example in this paper is driven by data (i.e. queries) in the database.

Integration: Using OracleAS Portal to 'Bring It All Together' (1.05MB) Presented at: Collaborate 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 at: Collaborate 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 at: Collaborate 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 PL/SQL Challenge: 20 Key Tips Everyone Must Know (4.62MB) Presented at: Collaborate 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.

The Best 11g New Features (5.70MB) Presented at: Collaborate 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

Time to Master the Other Side - Key Non Technical Traits for Success (4.36MB) Presented at: Collaborate 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 at: Collaborate 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 at: Collaborate 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).

Quick Web Development using JDeveloper 10g (2.26MB) Presented at: Collaborate 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.

Oracle XML Best Practices (Sponsored by Select Journal) (2.95MB) Presented at: Collaborate 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

How Oracle Came to Rule the Database World (5.71MB) Presented at: Twin Cities Oracle Users Group (TCOUG) Presented by: Rich Niemiec Date: 04/12/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

How IntelliReal uses Web Services to Enable Customers to Better Service their Clients (3.80MB) Presented at: Utah Oracle Users Group (UTOUG) Presented by: Brad Brown Date: 03/20/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).

How IntelliReal used Oracle Application Express to Rapidly Build their Production Environment (4.38MB) Presented at: Utah Oracle Users Group (UTOUG) Presented by: Brad Brown Date: 03/20/2007 Abstract: IntelliReal's user interface was developed using Oracle Application Express (APEX). With most any technical presentation that you've attended, you're likely always thinking about how to relate your environment to what the speaker is discussing and building a real world application using the tool. This presentation covers a specific business problem that was solved using APEX: delivering a rich user interface for "show." IntelliReal's primary customer base are businesses. Most of the customers actually access the IntelliReal systems using SOA. The APEX application uses the SOA components too. This presentation will discuss the functional requirements, how the application continues to be extended, the net results and cost savings. This presentation will include an online demo and discussion of the components.

APEX Advanced Topics (1.33MB) Presented at: Utah Oracle Users Group (UTOUG) Presented by: Larry Linnemeyer Date: 03/20/2007 Abstract: Now that you have figured out just how easily APEX can be used to quickly develop and deploy critical applications, this session will help you to take your APEX development work to the next level. In this session, we will explore advanced topics that utilize APEX APIs, JavaScript, XML and more. Some of the areas we will explore include: - Creating custom popup LOV windows that can perform advance searches, display more than just a single value and return any number of values to the calling page - Multiple master detail reports on a single page that highlight current rows in master reports - Utilizing JavaScript and XML to interact with the server without resubmitting the page. - Creating, populating and processing multiple dynamic checkboxes. - A package approach to doing manual tabular forms that handles display, validation, correction and processing using apex_item and apex_application. - Using dynamic SQL to render and process a form page that is totally dynamic as far as the number and types of fields that are on the page. The purpose of this session will be to introduce you to these advanced topics and provide you with actual code examples that will allow you to implement these techniques yourself.

Hands-on Oracle Application Express Full Day Session (3.56MB) Presented at: Utah Oracle Users Group (UTOUG) Presented by: Larry Linnemeyer Date: 03/20/2007 Abstract: In this full day hands on session, you'll learn to use Application Express from concept to delivery to support. We'll start with an existing database (i.e. an Excel spreadsheet) and build an application from the ground up. The exercises will build on each other and expose the student to the different components of the Application Express development environment. Application Express is a declarative web-based application development & deployment environment. It's a powerful and easy way to quickly develop a database-centric Web application. You can install Application Express on your own machines or run in a hosted environment on Oracle's site. All development (construction of pages) is done through the browser interface. You can use the SQL Workshop to run SQL and add data to your environment. This easy-to-use tool will impress you in no time at all! This presentation gives the participants a good introduction and great hands on experience with the Application Express development environment and a good idea of the power that it contains to create quick powerful Web application in a very short time.

How Oracle Came to Rule the Database World (6.33MB) Presented at: New York Oracle Users Group (NYOUG) Presented by: Rich Niemiec Date: 03/15/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Tuning the Oracle Grid (10.6MB) Presented at: Georgia Oracle Users Group (GOUSER) Presented by: Rich Niemiec Date: 03/05/2007 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. The main focus is to show many of the Grid Control screen shots so that the attendee can see the depth of the product.

How Oracle Came to Rule the Database World (5.71MB) Presented at: Georgia Oracle Users Group (GOUSER) Presented by: Rich Niemiec Date: 03/05/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Tuning Oracle9i/10g using Statspack & AWR (7.18MB) Presented at: Suncoast Oracle Users Group (SOUG) Presented by: Rich Niemiec Date: 02/15/2007 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. We will also look at block level dumps and the rare case that you would use them for tuning.

Tuning Oracle9i/10g using Statspack & AWR (11.4MB) Presented at: Dallas Oracle Users Group (DOUG) Presented by: Rich Niemiec Date: 02/15/2007 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.

Tuning the Oracle Grid (10.6MB) Presented at: Suncoast Oracle Users Group (SOUG) Presented by: Rich Niemiec Date: 02/15/2007 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. The main focus is to show many of the Grid Control screen shots so that the attendee can see the depth of the product.

Exceptional Leadership - Be the Uncommon Leader (3.39MB) Presented at: Suncoast Oracle Users Group (SOUG) Presented by: Rich Niemiec Date: 02/15/2007 Abstract: How do you really succeed in your profession and in life? This presentation focuses on some of traits that can help elevate you to the next level. Those leadership skills discussed include: integrity, moral courage, physical courage, self control, enthusiasm, knowledge, initiative, respect, tact, loyalty, unselfishness and humility. It also focuses on mentoring the next generation and leading the next historic wave.

Changing the World with Oracle Web Services and the Service Oriented Architecture (4.03MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 02/14/2007 Abstract: Web Services are the next logical step in application development. They provide a major step forward in the Internet computing model. There are so many components and continual research going on in this area. This presentation will focus on the things you really need to know and care about with Web Services. This presentation will focus on a practical example of a Web service application of the future.

Advanced APEX DB Tips and Techniques (1.84MB) Presented at: Rocky Mountain Oracle Users Group (RMOUG) Presented by: Brad Brown Date: 02/14/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.

Tuning Oracle9i/10g using Statspack & AWR (4.88MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Presented by: Rich Niemiec Date: 02/06/2007 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.

How Oracle Came to Rule the Database World (4.76MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Presented by: Rich Niemiec Date: 02/06/2007 Abstract: This is a break from the technical presentations, but not too much of a break. Sit back and listen to the history of the relational database go by. Find out the crucial moves that Oracle made at critical junctures of their history. See what drove the product from inception, over the rocky road and eventual to the top of the mountain. Learn what made Oracle the product a success, but also find out the attributes that made Oracle the company a font of technological wizardry. This talk will reveal several seldom heard facts and some unknown secrets of Oracle's success.

Tuning the Oracle Grid (10.0MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Presented by: Rich Niemiec Date: 02/06/2007 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. This presentation will show many screen shots of what the product encompasses.

Giving Winning Presentations (7.58MB) Presented at: Los Angeles Oracle Users Group (LAOUG) Presented by: Rich Niemiec Date: 02/06/2007 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: