Federating with Google Apps This presentation will outline the steps to install Oracle Identity Federation. After installation, the presentation will look at the configuration necessary to use SAML for SSO with Google Apps.
Mike Ault, Texas Memory Systems
DBA
Rapid AWR/Staspack Analysis
Tired of looking at a statspack or AWR and being overwhelmed by the numbers? Attend this presentation and learn what is important and what isn't when analyzing statspack and AWR reports. Find out important wait events, enqueues, latches, and parameters that need attention first. Learn how to quickly evaluate SQL statement listings. This presentation covers a rapid analysis technique that gets you to the answers fast.
Golden Gate - Simplified - Explore the Possibilities
Oracle has recently completed a purchase of Golden Gate. Golden Gate is the industry leader in simple, robust, and fast data replication. This session will walk the listener through the base fundamentals required to utilize Golden Gate. This includes base replication, data transformations, operational procedures, active-active configurations, and warm standby databases. This presentation utilizes E-Business Suite as a sample application to demonstrate the ease of implementation for complex database environments. Also, this session includes common operational procedures from monitoring to Veridata (another Golden Gate tool used to validate data). Finally, this session will detail the differences between Golden Gate and other Oracle products (i.e. Logical Standby). Following this presentation, the listener will poses the required tools to setup and use Oracle Golden Gate.
SOAToday: How to Use an Agile Methodology on SOA Projects to Achieve Rapid Results
The session will also cover fundamental principles of Service Oriented Architecture implementation approaches by explaining definitions, concepts, and practices and their applicability to an Agile methodology. This will help participants gain a common understanding of what SOA is, what constitutes SOA, and why it is so important to businesses to produce rapid implementation results. It will cover similarities of SOA and Agile, as well as principles of Agile that are not applicable to SOA.
Introduction to Mobile Application Development
This session will cover introduction, approach, and leading practices for building applications in a mobile platform. It will also provide an introduction to Mobile Application Development, an example of the iPhone user interface, architecture considerations for development (features, constraints, usability), and applying design patterns such as model-view-controller.
How to Effectively Run an Outsourced Development Team
This session will cover best practice approaches to organizing an outsourcing team such as: defining policy, organizing the team, processes to lower risk, baseline reference, and model governance formalization.
Database Lite & SQLite Concepts + Synchronization <=> This presentation will be a concept overview of Oracle Database Lite and open source SQLite for Oracle DBAs plus a demonstration of Oracle Database Lite and SQLite bi-directional synchronization.
Deploying a Dimensional Model on the Oracle Database
Understanding the logical model for a data warehouse environment may seem confusing to Oracle DBAs with little or no experience in dimensional modeling. This session will investigate the core physical objects in a dimensional model, and explore the differences between these objects, such as dimension tables, fact tables, and aggregate tables. The presentation will consider the effect different physical properties will have on these objects, such as partitioning, compression, and constraint and indexing properties. Attendees will also see how the physical implementation of these objects can affect advanced database features such as summary management and star transformation.
Resuming, Restarting, Restoring: Three R's of Data Warehouse Fault Tolerance
In this presentation, we will examine the three key aspects of recovering from errors and failures in a BI/DW environment running Oracle Database 11g, including failures in the ETL processing. We will investigate how to design ETL processes to be both resumable and restartable, using best practices in ETL design combined with Oracle Database 11g features. Learn best practices for backing up a data warehouse using RMAN, including the evaluation of specific RMAN configuration parameters and techniques, and discover the answer to the age-old question of whether to ARCHIVELOG or not.
Real-time Data Warehousing with Oracle Business Intelligence and the Oracle Database A successful real-time data warehouse implementation involves integrating the logical and physical model, source and target databases, ETL subsystems, and front-end dashboards and reports. This session will explore how these different pieces fit together; this will be demonstrated using the Oracle Database and Oracle Business Intelligence Enterprise Edition. The session will investigate alternative modeling approaches for delivering up-to-the-second reporting, including the use of a real-time logical fact partition, as well as integrating the OLTP source system as a data source. The session will also investigate ETL approaches for delivering the data model, including combinations of batch loads, micro-batch loads, and trickle-feed processing.
APEX: Tight Tabular Forms
Tabular forms are a popular APEX construct, but adding validations to those forms to enforce real-life business rules is not always as simple as it should be. This presentation covers how to tighten down your APEX tabular forms with item, row, and form-level validations that are not disruptive to a user's data entry flow. The session will cover the new tabular form features in APEX 4.0, how they help, where they fall short, and demonstrate how to supplement what APEX 4.0 provides when necessary. You'll learn how to produce tight tabular forms that enforce your business rules by leveraging APEX 4.0 tabular form features first and supplementing with custom code as needed.
APEX 4.0: Meaningful Maps, Gantts and Charts
APEX 4.0 introduces improved declarative Maps and Charting, including time and resource Gantt charts. Great, but how can I make meaningful use of these new features in my applications? This session is a deep dive into practical adoption of these important new features in your current and future applications, touching on additional APEX 4.0 new features along the way.
Oracle Optimizer - Top Tips to get Optimal SQL Execution all the Time
This session shows the process of identifying and resolving the most common SQL execution performance problems including, poor cardinality estimations, wrong access method being used, and much more. With clear how-to examples, you will learn how the Optimizer determines an execution plan, from the types of statistics it looks at, to the formulas it uses to calculate the cardinality estimates for each operation in the plan. By understanding how the Optimizer thinks, you will be able to determine if the execution plan you are looking at is the best plan you could get and, if not, why the Optimizer got it wrong. By applying some of the simple procedures explained in this session, you will be able to quickly resolve these issues without the necessity of Optimizer hints or messing with initialization parameters.
Best Practices for Implementing a Data Warehouse with Oracle
Attend this session to learn best practices for deploying a data warehouse on Oracle Database 11g. Using detailed examples and live demonstrations, this session will cover the best practices for schema design, hardware configuration, data loading, partitioning strategies, parallel query, and workload management. You will also learn how to monitor, diagnose, and correct common performance issues using both the old reliable tools such as explain plan and AWR as well as an introduction to the latest and greatest SQL monitor tool. By applying what you learn in this session you will be able to deploy a data warehouse that can seamlessly scale without constant tuning or tweaking.
Consistent Plan Performance through Database Upgrade with SQL Plan Management
After an upgrade, the Optimizer is supposed to generate the same or better performing execution plans for your SQL statements. Still it is possible that the Optimizer may generate a suboptimal plan for some SQL statements in the new release. This session will provide step by step instructions on how to use SQL Plan Management to capture your existing execution plans before the upgrade and ensure they will be the execution plans used by the Optimizer after the upgrade. The session will also cover how to test and verify any new plans found by the Optimizer before using them, as well as explaining in detail how SQL Plan Management can help tackle any plan regression you might encounter without having to change the SQL statement.
Oracle (Streams) Advanced Queuing: Lessons from the Trenches
Whether you are new to AQ, or somewhat experienced, there should be something new to learn in this tale of problems and solutions as the author trail-blazed the use of single-consumer queues in his organization within three new applications, all while the databases were undergoing upgrades from 9i to 10g. The session will briefly cover asynchronous processing and Oracle's queuing features for the uninitiated; create some single consumer queues and queue tables, then enqueue and dequeue some messages; create some problems, mimicking some the presenter encountered; and show some working solutions that you may be able to replicate for your own needs to manage, monitor, and troubleshoot queues.
System Statistics: The Full Story
Tucked away inside the Oracle data dictionary is a single table of system statistics that have a profound influence on the quality and performance of SQL execution plans generated by the cost-based optimizer. Usually accepted with just their default values, these system statistics can profoundly affect SQL performance. Participants in this session will learn the best practices for gathering, maintaining, and leveraging system statistics in order to deliver optimum performance to their organizations. Learn exactly which statistics are maintained, how they are instrumented, where they are stored, and how to manage them to best benefit. Observe the impact of various system statistic scenarios on the resulting SQL explain plans and what difference these plan changes have on performance. Leave with best practices governing the collection, maintenance, and options available surrounding the administration of system statistics.
The Nitty-Griddy on OEM Grid Control
Learn the essentials for installing and deploying a successful implementation of the Oracle Enterprise Manager Grid Control software. Available for a number of years, the current release of Oracle Enterprise Manager has finally "come of age" and is able to provide significant benefits to organizations that use it properly. Both 10gR5 and 11gR1 will be discussed, and special emphasis will be given to the installation, administration, and demonstration of 11gR1, which is now based on Fusion Middleware and uses WebLogic as the mid-tier engine. Also hear about some of the common missteps and problems surrounding implementations of OEM Grid Control and avoid repeating them in your own installation.
Top Down Monitoring with OEM
The motto in most businesses today seems to be, "Do more with less." DBAs are being asked to manage larger environments while maintaining (or increasing) service level agreements. Oracle Enterprise Manager can help meet these two opposing goals by allowing DBAs to quickly discover, find root cause, and correct various problems within the enterprise.
When You Don't Know What You Don't Know
This session will be a case study presentation investigating an Oracle EBS implementation with highlights and life experiences of the challenges and successes of the processes.
Managing Concurrent Parallel Execution Without Tuning
In today’s world, you as a DBA will need to understand how to run your statements in parallel to achieve acceptable performance for all users. On top of that, you will deal with more and more users wanting faster execution times on larger data sets. This session will address these hot topics by discussing how you manage an Oracle system to achieve optimal parallelism, good workload management, and drive excellent query performance of your systems, without excessive tuning. It will cover some of the latest features in Oracle Database 11g Release 2, like Automatic Degree of Parallelism, resource manager statement queuing, and in-memory parallel execution and how to use them.
Oracle Forms Modernization Challenges – Determine the Future Direction for Your Oracle Forms and Reports Applications
Have you determined the future direction for your Oracle Forms and Reports Applications yet? Many organizations are unsure whether to upgrade, migrate, or replace their legacy Oracle Forms and Reports applications and assume considerable risk with unsupported deployments of Oracle Forms solutions. Besides upgrading to the most recent version of Oracle Forms and Reports 11g, you may consider migrating to ADF, APEX, Java, or integrate your application in a SOA-enabled IT environment. Learn about the risks and challenges you should consider prior to modernizing your Forms and Reports applications. Back to the top
Paul Dorsey, Dulcian
Applications
Achieving Great Web Application Performance Using ONLY SQL and PL/SQL
Well-designed Web applications can provide performance that is just as fast as their older client/server counterparts, but this requires a rethinking of application tuning strategies. Poorly performing Web applications are rarely or only marginally improved by tweaking the database and tuning the SQL statements. This presentation will discuss techniques that can be used to identify and resolve many common performance issues that arise when developing Web applications.
Cisco Unified Computing System: Cost Effective Grid Computing
Cisco’s Unified Computing System (UCS) provides a hardware/software platform that enables businesses to implement an Oracle Grid architecture that brings to fruition the promise of the on-demand, cloud computing paradigm. Session I will define and discuss the technical innovations that enables UCS to offer Oracle RAC cloud computing today. These innovations are: Extended Memory, Integrated System Architecture, Unified Fabric, Embedded Management, and Service Profiles.
Colorado Department of Education (CDE) Identity Management - A Delegated Administration Model (DAM) - A DAM Good Idea!
Since November 2008, CDE has been working on a new Identity Management process using Oracle Identity Manager (OIM) that will simplify and streamline the user login process for CDE data systems and enhance security for access to student-level data. The first phase of the project has involved completing the analysis to support a Single Sign-on / Delegated Administration Model (DAM). This includes drastically reducing the manual effort currently required by districts and CDE resources to assign user ids and passwords by automating the user registration, approval, and password reset processes, and providing school districts the ability to maintain users via DAM. CDE works regularly with approximately 180 school districts to assist with data collection and data analysis systems. For DAM to work, we implemented a User Manager (UM) concept with user approval and user creation through a self registration request. Once approved and created, the UM creates a Local Access Manager (LAM), who creates and manages the application users based on their role/responsibility for the data collection and/or data analysis systems maintained by CDE. User access to the individual applications is controlled through group membership in OIM and OID down to the corresponding roles. This presentation will provide an overview of the business needs for DAM, and then describe in detail how OIM uses the combination of OIM groups, the OID resource, and OID groups to control user access to the various CDE applications.
Managing Transactions with Disappearing Indexes
If a system receives information that drives transaction processing, it is sometimes necessary to follow the transaction detail through several stages of processing or through processing steps that may vary depending upon the source data. When processing of a given row is “complete,” there are more efficient means than deletion to remove it from consideration in continuing passes of transaction processing. One method, using a “disappearing index,” is particularly useful and efficient. This method takes advantage of the fact that index column sets that become completely null are eliminated from the index, so that at a steady state a fast full scan of the index to find candidate rows for further processing remains fast and efficient even for a very large partition or table.
Physical Ordering of Data: Is It Ever Useful?
Certain operations, some small like lookup lists and some large like batch jobs and reports, can perform better if the physical order of the data matches the predominant order of use. When is it worthwhile to attempt this ordering? How does ASSM affect the ability to physically order data? An expensive mission to periodically physically order all the data you have in the best possible order for the queries you expect to run on the data is silly. But if you verify that a one time complete or periodic partial physical ordering of some of your data will have a reasonable cost that is nearly certain to be exceeded many times over by the reduction in cost of future projected queries against a constrained resource, then it is not silly.
360 Degrees: Migrate Your Online Oracle Database to RAC Using Streams & Data Pump
The presenter/author will talk about his experience, lessons learned, Streams & Data Pump Performance Tuning, tips/tricks, recommendations, best practices, and a whole lot more about a series of documents/guides that he has authored to migrate an online/HOT Oracle Single-Server Single-Instance database to Real Application Clusters on Automatic Storage Management (ASM) on new/separate hardware using Oracle Streams and Data Pump.
360 Degrees: Build a Private Oracle E-Business Suite Cloud using OracleVM
The presenter/author will talk about his Experience, Lessons learned, Tips/Tricks, Recommendations, Best-Practices and a whole lot more about a series of guides that that he has authored to build a Private Oracle E-Business Suite R12 "Platform/Infrastructure as a Service" Cloud using Oracle VM Templates.
Automatic SQL Tuning in Oracle Database 10g and 11g
To have a well-run database, DBAs should look for resource-intensive SQL statements and proactively tune them. Oracle Database 10g introduced the SQL Tuning Advisor to help tune SQL statements. Oracle 11g enhances the SQL tuning capability by automating it. This presentation begins with an overview of the 11g Automatic SQL Tuning feature. It is followed by an explanation of what SQL Profile is and what benefit it provides. The Automatic SQL Tuning Advisor provided by 11g is a step towards proactive tuning. Proactive tuning can also be achieved by using Oracle's DBMS_SQLTUNE package in 10gR2. Additionally, this presentation provides a detailed look at the subprograms of the DBMS_SQLTUNE package and steps through a package written by the author to automate SQL tuning using DBMS_SQLTUNE. Finally, it gives examples of creative uses of DBMS_SQLTUNE, such as 1) creating a repository of SQL and execution plans; 2) aiding upgrade performance testing; and 3) capturing system workload.
DBA 101: 52 Weeks in the Life of a Database
The most important tool in performance tuning is charts. As the old saying goes, one picture is worth ten thousand words. Oracle Database is richly instrumented but charts are surprisingly hard to come by. With the help of 52 charts covering 52 weeks in the life of a database, the session will demonstrate how to plot performance data in effective ways that allow you to visualize database performance. No special tools or licenses are necessary; the data can be obtained from Statspack while Microsoft Excel can be used to produce stunning charts of database performance. Attendees will receive an Excel utility for the purpose.
Performance Diagnosis for Oracle DBAs
Oracle is rich in diagnostic tools and data. The key to effective and efficient use is to know which ones to use and what data to query when issues are reported, a feat that is often difficult when a system is unusable and users are demanding fixes NOW! This session will cover the diagnostic process, the tools and data available in the Oracle database, and the techniques to apply the knowledge to diagnose actual performance issues. The first part of the session will cover the diagnostic process, laying the foundation with overviews of how to diagnose issues, developing your own process, and identifying common performance threats. The second section covers the data and tools that are available in the Oracle Database to assist in diagnosing current or future issues. The final section applies the processes, knowledge, and skills as part of an interactive exercise to diagnose common issues in an Oracle Database system, including proactive query diagnosis and a complete database hang.
UUsing Virtualization to Setup QA/Dev Database Environments Solaris ZFS and Zones allow an easy and quick way to setup a QA and test environments. Without Solaris Virtualization, the restoration of a QA and test environments in a multi-datacenter environment would take six to eight hours. Using Solaris Zones and ZFS, they have been able to restore a QA and test database in less than two hours. This presentation will demonstrate how to set up the environments and use ZFS commands and Solaris Zones.
Replication Options – You Have More than You Think
Many shops are implementing replication of all or part of their data for a variety of reasons, from regulatory requirements, off site recovery, to distributed access. In the days of 9i and before, you had only a few options; remote mview, updatable mview, and advanced replication. In the world of 11gR2, you have so many options it is hard to determine which one is right for you. This presentation will cover the available options, how they differ, and how they are the alike. The goal is to help you determine which one is right for you. The presentation will cover options from active dataguard, logical standby, Streams, Golden Gate, and some non-Oracle solutions. The focus will be on each option’s capabilities, manageability, and of course, cost.
Because Daddy Did Not Buy You an Exadata for Christmas: Data Warehouse Performance on a Budget
The data warehouse professional is caught between two powerful forces. End users and management represent an irresistible force that constantly desires to access information held in a data warehouse for both tactical and strategic uses. The other difficulty is the immovable object. The amount of data held in some data warehouses has become so voluminous that poor performance makes reasonable data retrieval impossible or makes it extremely frustrating for the end user. This presentation will cover the use of aggregation and Oracle’s Query Rewrite functionality to achieve excellent data warehouse performance.
Analysis of Oracle ASM Failability
Oracle Automatic Storage Management (ASM) has introduced the new concept of mirroring that is implemented differently than in any known RAID levels. So what happens when not one but two or more disks fail? Is such a situation hypothetical and highly unlikely? Apparently not. This session will help you evaluate the data loss risks better and make you re-think your ASM deployment strategy.
Is Oracle Exadata for You?
Oracle Exadata has become the fastest growing Oracle product in history, and many IT managers are curious as to how it can help their business. This session will look at Exadata suitability for various environments and what problems it solves for IT and business. Based on Pythian Exadata experience, the session will go through the benefits of Exadata in different deployment scenarios to help you justify the technology for the right projects - data warehousing, OLTP, database consolidation, as well as hybrid environments.
Troubleshooting RDBMS Problems: Using ASH, AWR, and Everything Available
Arthur C. Clarke wrote that "any sufficiently advanced technology is indistinguishable from magic." This has been proven true, and it makes troubleshooting of that technology seem like art. But it is not art, it is process, and the intent of this presentation is to use a case study (i.e. resolving ORA-03136 "connection lost" error) to demonstrate that process, and also to show how components such as AWR and ASH, typically thought of as "performance tuning" tools, are also useful diagnostic tools. Attendees to this presentation will learn a forensic, empirical approach to trouble-shooting and also see a demonstration of a complex troubleshooting task following a non-intuitive but empirically sound resolution.
Manage Customizations Using Application Change Management Pack for Oracle E-Business Suite
Oracle Application Change Management Pack for Oracle E-Business Suite provides a centralized view to monitor and orchestrate changes (both functional and technical) across multiple Oracle E-Business Suite systems. Oracle Application Change Management Pack for Oracle E-Business Suite offers the capabilities to manage changes introduced by customizations, patches, and functional setups during implementation or maintenance activities. This presentation will show in detail real life examples on how this tool can be used to successfully manage and deploy any customization into your Oracle E-Business Suite system the same way Oracle deploys code changes for core (standard) components.
Oracle E-Business Suite Advance Networking
Due to the high demand and low cost of low end servers companies are relying more and more in a linear architecture that requires multiple nodes in both database tier and middle tiers. This presentation will show easy methods to quickly deploy multiple application tiers in your Oracle E-Business System.
Optimize Your Oracle Licensing
Oracle licensing and maintenance can sometimes be hard to understand. As Oracle has grown and acquired new products, more and more organizations are using a range of Oracle products. Understanding the various products, product versions, virtualization, hardware implications, and maintenance costs associated with these products is very important to many organizations. This presentation explores how to optimize your licensing when buying Oracle products by explaining the different product versions, license types, options, and terms and developing an understanding of Oracle licensing and maintenance policies.
Database Performance Made Easy Through Graphics
Average Active Sessions (AAS) Formulas, Interpreting Load Charts, and Visual SQL Tuning (VST)—Kyle begins his presentation with a discussion of the use of sample data to create Active Sessions History (ASH). But ASH is dense, multidimensional data, which makes it difficult to analyze. Fortunately, ASH can be simplified using a metric called Average Active Sessions (AAS). AAS shows the load on the database and allows you to drill down with precision and clarity into the cause of each bottleneck. Most often, bottlenecks are caused by poor-performing SQL statements. For analyzing suboptimal SQL statements, Kyle will show you how to lay out the query graphically in a Visual SQL Tuning (VST) diagram. Through the VST, you’ll learn how to quickly visualize any coding errors in the query, discover flaws in the underlying database schema, and most importantly, find the best execution path through the query.
E-Business Suite R12 Upgrade Best Practices
Thinking about an R12 upgrade or new installation? Already involved in an R12 upgrade or new installation? This session will review the many resources and best practices available to assist you as you plan and drive a successful R12 upgrade or implementation project. During this session you will review: the R12 Upgrade Guide, which provides a consolidated list of information that helps in the evaluation and planning of your upgrade project; the E-Business Suite R12 Information Center, which offers links to the latest published information; best practices for adopting Oracle E-Business Suite; valuable tools like the Maintenance Wizard and E-Business Suite Diagnostics Support Pack; and their new R12 Upgrade Advisors, specially crafted dynamic documents that are intended to guide you through an upgrade lifecycle using step-by-step instructions. These are created by incorporating information from various sources, as well as best practices they have collected over numerous upgrades.
Small and Mid-size Companies Can Do Oracle Too: The GL/AP Fix
Small and mid-size companies used to think that enterprise ERP was simply out of reach for organizations their size. However, many are beginning to understand that applied on a scale to suit their size, some enterprise applications make a great deal of sense and actually fit the small to mid-size budget. Organizations are beginning to make the transition to enterprise Financials applications in order to control costs, manage risk, position themselves for faster growth, modernize outdated or non-integrated legacy systems, and to gain efficiencies that out of the box applications simply don’t provide. This presentation highlights how to get up and running on R12 GL and AP in less than six weeks for a small-mid-size organization. The presentation also includes points on building the business case for a GL/AP implementation and detailed specifics on completing the R12 GL/AP implementation successfully.
Tools of the Trade: All the Free Tools from Oracle Corp
This is a live-demo presentation of various tools and features of the Oracle9, 10, and 11 databases. Dan is an experienced trainer and will demonstrate a variety of these features using tools like TOAD and SQL*Plus. The attendees will gain valuable insights as to the many features of Oracle.
BPEL for Workflow Developers
Business Process Execution Language (BPEL) is one of the cornerstones of Service Oriented Architecture. It is the language used to orchestrate processes within Oracle's Service Oriented Architecture Suite. This presentation will provide an overview of various components of BPEL and show, through a live demonstration, how to build a BPEL process. For those who are familiar with Oracle Workflow, a comparison will be made between a workflow and a BPEL representation of the same functionality. The attendees will get a great introduction to this technology that is becoming such an important part of current and future Oracle development.
The Reason for Dynamic Costing
Dynamic costing is the adjustment of costs of individual operations for the cost-based query planner. These costs can change based on hardware capabilities, as well as machine load. This session will discuss why to bother gathering this information, how it is used, and what other possibilities it opens up for database tuning and maintenance in the future. Because this is a session on the theory and reasons, rather than specific implementation, this will be presented in a database platform neutral manner.
SORT of Interesting
What exactly happens when Oracle sorts data? What are the differences between the various types of Oracle sorts? How can you affect the outcome? This presentation will provide you with an overview of how Oracle performs sorts and give you the tools you need to understand and tune sorts in your environment. The presentation will review Oracle sort mechanics, cover the specific Oracle events you can use to understand and tune those sorts, and lastly, talk about how manual and automatic work area policies affect the memory available for sorts. You can expect real world examples and sample trace data that will allow you to truly understand this topic. Or at least SORT of understand it.
Flashback Database in 10g and 11g
In 10g, Oracle introduced Flashback Database. This presentation will provide a quick overview of the what, how, and why of Flashback Database.
Oracle 11g Intelligible Business Intelligence
Plenty of organizations around the world claim to have a “data warehouse” and “business intelligence,” but very few are able to fully understand and correlate their data and subsequently turn data into actionable information. This presentation is geared towards the technical, those looking for a truly valuable business intelligence development and deployment platform as well as managers looking for a comprehensive, enterprise-level, long-term business intelligence solution that will deliver real value to the business. This presentation will cover OBI 11g main modules such as Oracle Answers, Interactive Dashboards, and BI Publisher, as well as OBI security model and Server Repository. Lessons learned, as well as Arisant’s methodology used during a large-scale implementation for a Fortune 100 corporation, will be shared. A live demo will cover various techniques such as slice and dice, drill downs, and data visualizations using reports, scorecards, dashboards, ad hoc analysis, and OLAP analysis.
Exploring Edition-Based Redefinition
Edition-Based Redefinition (EBR) is often described as the “killer feature” of Oracle 11g R2. This session will explore the concepts of EBR and planning for EBR implementation. Specific topics include EBR “admin” user, Edition objects, Editioning Views, and Cross-Edition triggers. A brief demonstration will highlight the basics of EBR.
Oracle ADF & JDeveloper; Coming of Age
Oracle has “bet the farm” on the rewrite of its Application stack with ADF and JDeveloper. JDeveloper has come a long way from the tool that crashed during every Oracle demo and has become a robust development tool. ADF likewise has become a useful development tool reminiscent of the simplicity of 4GL tools. This session illustrates the ease with which JDeveloper and ADF can be used to create Java applications.
Oracle EPM Migration and Upgrade - A Complete Solution
A technical discussion on the approach and challenges of migrating from Hyperion 9.x to Oracle EPM 11.x. Products include Essbase, Planning, Financial Management, Financial Data Quality Management, Reporting, and Security.
Hello Worldwide Web: Your First JSF in JDeveloper
JavaServer Faces (JSF) is a Java-based user interface technology used primarily to develop Web applications. It is currently the most popular UI technology in the Java world and it is a key technology in the Oracle Application Development Framework (ADF). Oracle's Fusion Applications (formerly E-Business Suite) use JSF as the main user interface technology. This presentation provides an in-depth overview of JSF technology as it is used with ADF to build applications in JDeveloper. It discusses the basic communication paths used when running a JSF application. The presentation also explores development details for creating and testing JSF files. It describes the contents of runtime files such as backing beans and managed beans, message bundles, faces-config.xml, and web.xml. The presentation also briefly explores how to link data from the database into the JSF page so it can be saved or retrieved from the database. Throughout this presentation, sample code and demonstrations show how these concepts manifest in a sample application.
Introduction to Java-PL/SQL Developers Take Heart
Oracle's current focus on implementing database and development features based on the Java language may have you thinking that you need to learn Java. However, if you are familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. Also, you may be wondering about where Java fits in the industry and how much Java you really need to know to create Web applications. This presentation explains, to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures—classes and methods—as well as control statements, exception handling, datatypes, and variables. This explanation will act as a springboard for further study.
The Diagnostic World Has Changed; Using Oracle’s Automatic Diagnostic Repository Command Interface to Effectively View and Manage Diagnostic Information
Oracle has revamped and improved its infrastructure to diagnose, collect, report, and manage diagnostic information. This presentation will relate pre-11g diagnostic information to current 11g Automatic Diagnostic Repository concepts (ADR) and then dive deeper into the use of basic and extended ADR command interface commands; giving DBAs a quick-start to managing 11g diagnostic information.
Oracle SQL Developer 3.0: Product Overview and New Features
SQL Developer provides database developers with a powerful tool for database tasks. This session reviews the latest features, including the new visual query builder, support for DBMS Scheduler, and the SQL Code Advisor. The presentation will review the new DBA-related functionality, such as DB Controls and support for roles and tablespaces. The session also reviews popular features in SQL Developer 2.1.
APEX-O-MATIC - In a Blender with APEX and Web Services
Using a working APEX environment which includes the latest version of APEX, the APEX Listener, Tomcat, an Oracle XE database instance, the session attendee will discover how to integrate Web services into an APEX application. In this session, Apache Axis will be used to create the Web services from the default EMP and DEPT tables and run under the existing Tomcat server. Looking at the generated files using tools such as Firebug and soapUI will be included to show what is being used and is needed to incorporate this technology into your APEX applications.
Starting an Agile Oracle BI Project on a Budget
Many organizations that could benefit from a BI project are searching for an on ramp to demonstrating business value. The primary components of the effort are software selection and cost, delivery scope, and modeling approach. The session will survey the low/no cost versions of the Oracle tools. The session will look at cases and develop general rules of thumb. It will allow you to develop a feel for the range of tool options available on a tight budget; to understand the choices for BI data models and their impact on the business user experience; and to establish a business meaningful scope that can be delivered quickly.
Fusion Applications - The Window on Oracle Technology
For the last two years, Debra has had the privilege to present at RMOUG on "Thinking of Supporting or Extending Fusion Applications." Now that they have been launched at Oracle OpenWorld 2010, you can all see much more. Does general availability mean everyone will rush out and move to Fusion Applications? Debra very much doubts it, and Oracle themselves are suggesting co-existence, keeping your existing applications and just picking the Fusion Application modules that add value to your business now. How do you go about that? Well, it is all about the technology. Fusion Applications are a shop window for Oracle Fusion Middleware, and you will see a big jump in the number of projects and not just to do the same old thing with new technology. You are only limited by your imagination.
Ergonomics 201 - Beyond Muscles: How Fascia Affects Your Posture
Last year's presentation, Ergonomics 101, explored posture in the workplace and movements that would help to relieve tension and chronic pain. This year, attendees will explore beyond muscles and learn about fascia. What is fascia anyway? Why does fascia impact our posture? Why does poor posture lead to injury? Learn how to set up your workstation. Learn movements that can help you sit, stand, and walk with better posture.
Data Architecture for Loonies
Tired of developers dropping off their table design for you to implement? Tired of performance problems you recognized months ago finally impacting production. Want to spend more time with people, and less time with the pager? So you think you want to be a Data Architect, eh? It's not just designing a couple of tables, and otherwise doing DBA stuff with your head down in a cubicle. It's planning a data strategy, developing and enforcing standards, socializing your ideas, building relationships and fostering a spirit of team work. This class will present the characteristics of a good Data Architect, how this role differs from existing roles in a company (DBA and an Application Architect specifically), and how to maintain a good relationship with those roles. The session will also go over difficulties in different development methodologies (Scrum, Waterfall, etc) and how to overcome them.
What's New in BI Publisher Enterprise 11g - EVERYTHING! The latest version of BI Publisher (11g) was released in August 2010 as part of Oracle Business Intelligence 11g. Using a demonstration, the presentation will discuss key BI Publisher concepts and walk through the user interface to build, burst, and deliver a report. This session is geared for all users, administrators, and developers interested in learning about BI Publisher features in general as well as those who are already using previous versions, planning to upgrade, or just want to see what’s new. Oracle’s Business Intelligence Publisher Enterprise is a stand-alone reporting and document output management solution that allows companies to lower the cost of ownership for reporting solutions. Leveraging open standards, BI Publisher Enterprise can run on any J2EE application server, access data from any database, and deliver finished documents via a number of standard protocols.
The Attack of the Deadly Janitor
Know your enemy. The presenter will play the part of a malicious insider and demonstrate likely techniques that someone targeting your sensitive data might use to break in. The reality is that with some basic system knowledge, a little ingenuity, and a company ID, a hacker you’ve hired as a contractor (or even as a janitor!) could easily overcome a lack of privileged credentials and gain access to your databases. Watch through the eyes of a hacker, as they identify vulnerable points on the network and leverage physical access to a database server to circumvent or breach common defenses. The live demo during the presentation will demonstrate various attacks, as well as methods of evasion for common protective measures, and along the way, the session will provide advice and recommendations on potential solutions to avoid a costly breach.
Groovier Java Scripting
Groovy is a dynamic language that runs in the Java Virtual Machine and has full access to the Java SDK as well as third-party Java libraries and frameworks. Groovy supports most Java syntax as-is, but provides an even more concise syntax that makes it more suitable for scripting. Groovy can be run directly without explicit compilation and enjoys many other script-friendly benefits. This presentation expands on topics discussed at RMOUG Training Days 2010 in the presentation "Applied Groovy: Scripting for Java Development." The presentation briefly summarizes select basic features and syntax of Groovy, advantages of using Groovy as a scripting language, and demonstrates how to use Groovy to improve building, developing, and testing Java-based applications. The presentation will emphasize how easy it is to write and parse XML with Groovy and how easy it is to manipulate database content with Groovy. Although the basics of Groovy will be covered initially in the presentation, for those who have not used Groovy previously, most of the syntax and other features covered in this presentation will be presented in conjunction with the use of Groovy in building, maintaining, and testing applications for the Java platform.
A First Look at HTML5
HTML5 is the forthcoming standard in hypertext markup for the modern Web. Although work on HTML5 has been ongoing for several years, interest and support for HTML5 has increased rapidly in recent months. An example of this is the JavaOne 2010 announcement that JavaFX 2.0 will provide HTML5 support. This short presentation will describe some of the most exciting features of HTML5. The presentation also covers the reasons that HTML5 is important and describes some of its limitations and obstacles to adoption. Finally, HTML5 features already supported in four popular modern Web browsers (Microsoft Internet Explorer, Firefox, Google Chrome, and Safari) will be demonstrated.
Oracle Database 11g: Partitioning and Compression, More Savings, Better Performance, and Management
Using new features of Oracle Database 11g in partitioning and advanced compression, maximizes cost savings and performance without sacrificing ease of management. New partitioning features can help us improve performance, in combination with Oracle Advanced Compression, to reduce disk storage costs and eke out some further performance improvements. This session shows examples and demonstrates cost savings, performance gains, and management ease.
Oracle RMAN 11g R1 and R2 New Features
This session covers new Oracle Recovery Manager (RMAN) features and their use for 11g Release 1 and Release 2. The features include archive log management improvements, network-aware DUPLICATE, fast incremental backups on physical standby, improved backup compression performance, improved integration with Oracle Data Guard, optimized undo backup, read-only transported tablespaces backup 11g Release 2 duplicate without connection to the target database, Oracle RMAN backup capabilities to Web storage services, automatic block repair, new duplicate options, enhanced tablespace point-in-time recovery (recovery of a dropped tablespace), and new SET NEWNAME clauses and format option.
Real Application Testing, Never Get Caught by Change Again
Real Application Testing (RAT) with Database Replay and SQL Performance Analyzer has given us the ability to be more proactive in ensuring that application, database, operating system, hardware, etc. changes and upgrades never negatively impact our database and system operations again. This presentation will review the features and use of real application testing with examples.
Cary Millsap describes Oracle extended SQL trace data so that developers and performance analysts can learn how to use this rich source of performance data to build faster, more scalable, more easily maintainable applications.
ASM – The Next Generation
Oracle 11g R2 has revolutionized the way we think about database storage technology. Automatic Storage Management is no longer just an alternative for Real Application Clusters, but is now used for general database implementations. The next generation of ASM now gives system and database administrators alternatives to storage solutions that were unavailable until now. The newly introduced ASM cluster file system and a rich set of available tools make ASM an exciting alternative for database storage. This session will go over the new grid architecture and take the participant through several examples of how to set up and use ASM. The targeted audience is for any IT professional wanting more information about the next generation of ASM.
The Easy Way to Recover a Database using RMAN
As an Oracle DBA, the focus tends to be on database backups. The questions are usually centered around “How long did it take?,” “Are there any errors in the log files?,” “What is our retention policy?”. These are good questions to ask relating to the backup process. What about the recoveries? This session will be devoted to tackling the issues relating directly to database recoveries. Assumptions are made from the backup process when actually recovering a database is an entirely different issue. This session will start by going over simple recoveries and progressively go though more complex situations. This subject matter will benefit any DBA or IT professional needing a refresher on RMAN recoveries.
Edition-Based Redefinition: Live in SQL*Plus
Edition-Based Redefinition is a new and critical component adding abilities that greatly enhance high availability in Oracle Database 11g Release 2. These are revolutionary new capabilities that allow online application upgrade with uninterrupted availability using three new database objects: the Edition, the Editioning View, and Crossedition Triggers. This session, with live a demonstration, "Live in SQL*Plus," will show each of the key components of editioning work and explain how they can be leveraged with single-instance stand-alone databases and with Real Application Clusters. New editioning enhancements in version 11.2.0.2 will also be shown.
Put Your Good Taste into Action: How to Skin ADF Faces Rich ClientApplications Using the New Skin Editor in Oracle JDeveloper 11g
The skinning feature of the ADF Faces JSF component set supports developers in building their own custom look and feel for Fusion Web applications. Using external CSS definitions for component colors, sizing, behavior, and fonts, skinning presents a flexible and powerful alternative to the traditional way of embedding CSS artifacts in the page source, which usually is hard to maintain and change. Also, a new skin editor in Oracle JDeveloper 11g further simplifies the discovery and styling of ADF Faces component selectors, reducing the development time for new application looks. This session will give you a 360 degree overview of skinning in ADF Faces, as well as an introduction to the brand new skin editor. Join us and learn how to put your good taste for visually attractive applications into action.
The Fusion Development Platform This session explains how Oracle Fusion Development Tools (Oracle JDeveloper, Oracle Application Development Framework (Oracle ADF), Oracle WebCenter, and the SOA Suite) deliver the rapid and declarative development experience you need for building robust applications. Through demonstrations, this session shows how to leverage these tools today to build applications that will integrate with Oracle Fusion Applications in the future, as well as giving you a sneak peek into the development environment used for the Fusion generation of applications.
Competing on Appliances
In this session, the speaker will de-mystify the Database Appliances like Oracle Database Machine / Exadata Server, Exalogic and compare/contrast with similar products from vendors like Teradata, Netezza, and IBM (Purescale). Attendees will learn about the industry landscape of the DB appliances and understand when and how to use them. The attendees will be able to understand when or why they would need DB appliances like the Oracle offering and how to plan for it in their organization. The speaker will discuss the future of Oracle RAC vis-a-vis the Oracle Database Machine. A few case studies of customers using or in the process of migrating to DB appliances will be used to illustrate the concepts.
Panel - BI and EPM Critical Success Factors
This will be a Panel discussion to discuss critical success factors of BI/EPM projects with a panel of experts. The Panelists will include customers, industry experts, and Oracle representatives to share their own experiences. This session will be highly interactive and the audience will have inputs and questions to the discussion. Attendees will get valuable tips to plan their own BI/EPM projects after participating in this session.
Drinking the Kool-Aid – My Journey to Becoming an ADF Believer
This presentation will cover the ADF framework and how it is a benefit for the right organization or the right developer willing to work with and take advantage of all it has to offer. The presentation will cover the good and the bad of ADF. If you are willing to take both, you might find that ADF is the framework for you. This presentation is technical and will provide detailed insight into using ADF v11 in a practical, thoughtful manner. This is an ideal presentation for organizations who are new to ADF, or considering it as an application architecture in the future.
Automate Your Processes with Oracle Business Process Management Suite
Business processes surround us. We participate in hundreds of processes every day at work, and every company we interact with is driven by business processes to ensure smooth operations. Operational activities, order processing, workflow, document management, change management, and HR processes are all examples of business processes that can be managed and automated. However, these real world business processes span organizations, systems, and applications and often suffer from lack of visibility and difficulty in adapting to changing business conditions. Business Process Management (BPM) aims to solve these problems. It is a defined approach for treating business processes as essential to an organization, managing changes in processes over time, and striving for constant improvement and optimization. Oracle Business Process Management Suite 11g offers new capabilities to model, manage, automate, and integrate processes in ways that were previously impractical or impossible. It is built on and integrates seamlessly with Oracle SOA Suite 11g, enabling human-centric processes and back-office automated processes to work together and share common business rules in an integrated fashion. This introductory session will: • Introduce BPM, an approach for improving, automating, and optimizing business processes • Explain the interaction between business process and business rules, using Oracle BPM Business Rules. • Describe Business Process Modeling Notation (BPMN), the executable, graphical, standard for modeling business process. • Introduce Oracle BPM Suite 11g • Demonstrate how to build a sample business process, simulate it, and deploy it using Oracle BPM Suite.
Scala: A Concise Introduction through Code, Concepts, and Demonstrations
This introduction to the Scala language will explain key concepts and illustrate their use. Everything in Scala is an object, including functions. It has no primitive types. With concise syntax and support for closures and mixins, it bears a strong resemblance to Ruby. Yet it performs type checking to help identify problems at compile time. The principle runtime platform is the JVM, while a moribund .Net CLR project does exist. Scala simplifies the development of concurrent code using the Actor model (as does Erlang) that is based on messaging passing techniques. Java libraries and third-party JAR files are easily integrated with Scala. Come learn more about this practical language through demonstrations and code walk throughs.
Crystal Reports Peak Performance with Oracle
After all these years, Crystal Reports is still the market leader when it comes to business reporting. And, there are still seemingly innocent mistakes you can make when designing reports with Oracle that cause severe performance problems. In this interactive live presentation, you’ll see what these mistakes are. And, better yet, you’ll learn how to work around them. You’ll see the latest version of Crystal Reports, too – Crystal Reports 2011/BusinessObjects 4.
Oracle Application Express 101
You keep hearing about Application Express as the popularity of this tool continues to grow. Learn for yourself just why Oracle Application Express is such a powerful, easy to use development tool. This session is designed to give you an overview of the tool complete with demonstrations on how you can maximize your Oracle Database investment. This session is based on APEX 4.0 and all of the brilliant new features that make development even easier and more productive.
Oracle Application Express Interactive Reports & Websheets
Interactive Reports has been one of THE best features within Application Express since it was released in APEX 3.1. Come and learn what we have added into Interactive Reports for APEX 4.0 to make them even more compelling for online reporting. Even though APEX is very easy for developers to create applications, it remains intimidating for many business users. These users are often not comfortable defining tables and other database components, so we developed Websheets. Websheets are one of the premier new features within APEX 4.0 and include the ability for end-users to create pages of static information together with data grids which are effectively updateable interactive reports without the need for any tables.
Warp Speed with Temp Tablespace Groups
Temp tablespace groups have received little press and less discussion since their introduction in Oracle 10g numerous years ago. Introducing this newer feature to an environment that suffers from waits on temp read and writes that have struck a roadblock on logical tuning is an excellent physical tuning answer to the challenge. As no sort or hash on large data sets can easily accommodate the PGA and must “swap” to the temp tablespace, monitoring temp usage has become a common DBA task for many. By utilizing temp tablespace groups, a DBA or developer can find extensive performance increases by spreading the I/O of the task across multiple files vs. one tempfile. How is this done? What steps have to be taken to implement this feature in a way to ensure Oracle will “stripe” across the temp tablespaces and what drawbacks are there to the configuration? This presentation covers requirements, setup, monitoring, optimal design, and hardware, along with tuning recommendations for getting the most out of temp tablespace groups.
Get to the Heart of the Matter - Performance Assessment That Works
Have you ever implemented a plan to discover that the approach didn’t quite hit the mark? Assessment is a key step that gets skimmed over, often because it seems too complicated and time consuming when problems need to be solved right away. In this session, discover a comprehensive, yet logical, performance assessment tool and process that works. Learn about the process, when to apply it, how to use the tool, and see it in action through successful case studies. Also learn how to remove barriers and overcome resistance while building critical relationships. Apply this process to help your teams discover the root of performance gaps and prioritize the right approach to impact change and get results.
SQL Fundamentals 11g
This presentation will be an overview of SQL (SQLPPlus) that would be of interest to new developers or DBAs covering the basics that may be found on a certification exam. Topics will include DDL and schema objects, DML and concurrency, DCL, and security. It will also cover retrieving, restricting, and sorting data using SQL, single-row and conversion functions, group functions, SQL joins, subqueries, and set operators.
Getting to Go-Live: Facts vs. Feelings
This presentation will provide participants with an overview of how to measure project progress toward specific and measurable acceptance criteria. Often the "Go-Live" decision is left to individuals or teams to decide whether the system is ready for "Go-Live" or not. Participants will learn how to help business owners define meaningful acceptance criteria and how to manage a project to a successful "Go-Live" based on facts as opposed to feelings. Project management tools will be demonstrated that can be used to help teams visualize their project progress.
Tales from the Bozosphere: Learning from Other’s Mistakes
It’s said that we only learn from mistakes. This session will take a look at some mistakes others have made in creating and maintaining large data-centric environments, see their consequences, and determine what could and should have been done to prevent downtime and loss of data. Each of the short case studies come from a real situation in which IT staff made errors because they were misinformed, misled, lazy, procrastinating, constrained by “company policy,” short of time, or afraid to ask for help in time of crisis. This session is not meant to embarrass others, but to learn some lessons on better system architecture and practice so that costly outages can be avoided.
The Oracle Exadata Database Machine: Technical Overview and Use Cases
Oracle’s first hardware product, the Sun Oracle Database Machine, is an integrated system that can run scan-intensive data warehouse applications to highly concurrent OLTP applications. With its combination of Oracle Exadata Storage Server software, Oracle Database software, and the latest industry standard hardware components from Sun, the Database Machine delivers extreme performance in a highly-available, highly-secure environment. With Oracle's RAC clustering and workload management capabilities, the Database Machine is also well-suited for consolidating multiple databases onto a single grid. Delivered as a complete pre-optimized and pre-configured package of software, servers, and storage, the Sun Oracle Database Machine is simple and fast to implement. This talk will provide a technical overview and some use cases from production environments.
Enterprise Information Management Maturity
Enterprise Information Management (EIM) is a governing policy put in place to structure, guide, and manage assets across business and technological organizations to improve quality, time to market, transparency, and ensure compliance. This presentation reviews an independent study to measure EIM maturity and readiness conducted by NEOS of financial services and insurance respondents. It was conducted with focus on five key dimensions: management, execution, process, perception, and technology. The five dimension maturity model will be presented, and then survey responses will be analyzed for trends in the market place from an EIM perspective.
Rationalization - Simplifying Your Oracle Architecture
"I've got 1400 production databases;" how many times have you heard that before? Maybe not every day, but companies who have been in business the past twenty years, or who have aggressively acquired businesses, have IT portfolios that are big, slow, and very expensive. Their issues compound year after year as business partners decide to do things "faster" because the current landscape is too slow. The intent of this session is to review the process of rationalizing a portfolio of databases and applications with the aim of coming to a modern, more simplified, landscape. The focus is to look at this exercise from a pure business perspective. This is not a technical session (i.e. we'll not be talking about how to consolidate databases and leverage Exadata), but more of a strategy session; a way for you to think about your portfolio and methods of making in-roads with your business counter parts. A case study of data from a major insurance company will be provided and discussed, as we review taking a "business product" view of system simplification.
On the Importance of a Good Data Model
With all the emphasis on features, business process models, and work flows, have data models become irrelevant? Does the object model replace the ERD diagram, or are we skipping a critical design process in our rush to be 'agile'? This presentation will discuss data model requirements and why understanding the data is necessary for scalability, performance, and agility.
Using Instrumentation to Ensure Performance
Oracle continues to provide new and better tools to measure database performance, yet as the amount of performance data increases, fewer software professional have the time to research complex performance problems. This presentation will discuss using instrumentation in conjunction with the wait interface, ASH, and DB Time to help you identify and solve the right problems.
Oracle APEX 4.0 – User Interface Design & Themes
Developing functional, easy-to-use, secure, and fast Web applications requires many different skills. Starting with a good database design to building a modern and well designed user interface, in most projects, these steps are typically done by different developers. Often though, the developer in charge for building the user interface, is also expected to come up with a nice looking UI. Chances are, this developer may be well versed in the latest Web 2.0 techniques, Ajax, and JavaScript, but using Photoshop or CSS might not be his area of expertise. For this reason, Oracle Application Express provides a user interface theme framework and ships with twenty built-in themes, so that developers can focus on what they do best, and have graphic artists provide the user interface design. In this session, you will learn about the basic architecture behind themes and the composition of a template. Using the APEX-based Oracle Online Store as an example, this session will discuss the different approaches to building a custom theme using simple, easy to follow Photoshop-techniques and show how Oracle overhauled many of the in-built themes in APEX 4.0, transitioning from a traditional table-based page structure, to a more modern DIV and CSS-based structure. You will see how you can go about testing your theme, to ensure that you have covered all the bases, and how to package and deploy your application with all images and CSS files included.
RAC or Not, Here I Come?
Many clients are simply jumping on the RAC wagon without sufficient scientific analysis. This presentation will explore the thought process for choosing RAC, and critical design elements for successful implementation of RAC. Choosing RAC should not be a simple relink of executables, rather numerous factors must be considered such as application usage, effective node affinity, considerations for RAC background processes, data access patterns, skill availability, etc. Power of a software product emanates from the effective configuration of the software. In the case of RAC, not only software configuration must be setup properly; hardware setup must match with the software configuration. Numerous critical success factors must be met before the application can be implemented to use RAC. This session will explore the thought process for implementing RAC, advantages of RAC, and show how few new features are useful to avoid the drawbacks of RAC. The session will explore various factors such as proper parameter setup, dynamic remastering issues, ASM setup, protocol setup, jumbo packets, etc. The session will also introduce a few scripts to measure RAC performance in an efficient manner.
Real-world Performance Issues: RAC Focused
This presentation will explore various real world performance issues encountered in RAC. The session will explore various concepts behind RAC while discussing real-world performance issues. This will be a tour of performance issues and how to resolve them. Few, not a complete list, of performance issues discussed are: 1. Extreme GC Buffer Busy waits 2. LMS: A friend or foe? 3. Foul: LGWR and LMS interference 4. How can a single process cause cluster wide turbulence?
From SQL to Rich Web Data Visualization - The Fast Route
This session will show you how to build visually-appealing dynamic Web dashboards that present data from your database. See how you can build interactive graphs, geographic maps, pivot tables, gauges, and more in a visual and declarative way. The session will start from simple SQL queries and show how easy it is to build interactive dashboards using Oracle ADF Faces Data Visualization Components, the same components used in Oracle's Fusion Application.
Adding Mobile and Web 2.0 UIs to Existing Applications - The Fusion Way You already have an application in place, but now you are getting demand for better UI and mobile access to the data. How can you achieve these in an easy way? Learn how Oracle ADF allows you to build rich Web user interfaces including carousels, maps, graphs, and more in an easy way. Then learn how the same skills extend to mobile application development. Also understand how you can use Oracle ADF on top of your existing custom or off the shelf applications.
Self Service Information: A New Wave of Technology
Traditionally, the way enterprises provide information to vendors, employees, clients, or anyone else who needed information is for a request to be submitted to IT. IT would then have to do something to get the data out of the system, into human readable format, and then provide that information to the requesting party. Outside of the enterprise, in today's world, people have information at their fingertips via the Web almost instantaneously and in whatever format they want. This presentation will discuss new technologies available and possible ways to utilize them for the enterprise to provide information to employees more quickly.
Tomorrow's Forecast: Looks like a Cloudy Day
Many companies are really starting to learn about and consider "Cloud." What is "Cloud'? What does it really mean for IT departments? What will happen to the current technologies in the "Cloud"? This presentation will address these questions and many more as it takes a closer, more practical and technical look at "Cloud" and what it means for the future of Information Technology through scenarios and examples of use of the "Cloud."
Disaster Recovery (ITSCM) - Holistic Approach
The perception of DR strategy is that it has historically been concerned solely with protecting critical applications, but the truth is that it relies on the entire environment. This presentation focuses on developing a successful DR strategy from a holistic standpoint that fits within an organization’s strategic direction and IT strategy and infrastructure.
Case Study: Performance Tuning New ADF Applications Using Oracle Application Testing Suite (ATS)
Web-based applications are notoriously hard to test, and a significant percentage of applications are not being tested before being deployed in production because of a lack of resources, time, and proper testing tools. This seriously affects application service levels and negatively impacts end users. To avoid downtime and performance problems in a new Web-based health care application, ECS used Oracle Application Testing Suite (ATS) to prove the application was ready before implementing it in production. This session will introduce the business need behind the El Perico application and demonstrate how ATS was used to answer key questions such as:
· How many users can we have on the system at one time?
· How many licenses does that translate into?
· Where can we make quick, significant gains?
Because of the visibility into the application's capabilities that ATS gives, they were able to drastically improve the capacity of the application before deploying it and without consuming valuable IT and end-user resources. Come see how ATS provides a perfect fit for achieving higher quality and performance for your Web-based and ADF applications. More than just an overview, the session will demonstrate specifically how to use ATS with a real-world business application developed with ADF.
E-Business Suite Release 12 Apps DBA 101
This presentation describes the new features, functionality and utilities available to Applications DBAs with Release 12 of Oracle's E-Business Suite of Applications. We will start by comparing the Release 11i and Release 12 architectures to lay the foundation for understanding the assortment of tools available to manage and maintain the Release 12 environment. Tools including Oracle Enterprise Manager (OEM), Oracle Applications Manager (OAM), Applications Management Pack (AMP), Applications Change Management Pack (ACP), Rapid Install Wizard, Rapid Clone, AutoConfig, Patch Wizard, OPatch and napply CPU, Oracle E-Business Suite Diagnostics, the Oracle Integration Repository (iRep), and the java console tools will be covered. This paper also discusses considerations for whether and when you should consider upgrading to Release 12. Back to the top
John Stouffer, Just a DBA
Applications
Managing R12 E-Business Suite Using OEM with the Application Management and Application Change Management Packs
Learn about these standard Oracle Application tools to help lower your maintenance and administration of the highly complex Oracle E-Business Applications environment. This session will cover the features and functionalities available in the most recent versions of the two Application Management Packs—Application Management Pack (AMP) and Application Change Management Pack (ACP) which are enabled from the standard Oracle Enterprise Manager (OEM).
Oracle E-Business Suite Patch Wizard Path to Less Errors
The variety and scope of patches available for E-Business Suite customers has become overwhelming. There are Critical Patch Updates/Patch Set Updates (CPUs/PSUs), Release Update Packs (RUPs), Family Packs, Mini-Packs, and one off patches, among others. Oracle provides patchset.sh to show customers their high-level patch situation, including patchsets and mini-packs. But there are still more patches available that customers may not see if they don't dig deep enough. The Patch Wizard, which is part of the E-Business Suite, helps customers decide which patches to apply and what data the patch will change. It compares the list of patches that it knows have been applied to what is available (by downloading the Patch Information Bundle) and makes recommendations. This presentation will describe how to take all this information and plan out which patches to test and apply next. For those Release 11i customers who haven't applied the mandatory patches required by Oracle to receive Extended Support (My Oracle Support Doc. ID: 883202.1), this session will walk through an example of how to determine what patches are missing using Patch Wizard.
Six Easy Pieces: Essentials of Database Tuning for Packaged Applications
Packaged applications such as E-Business Suite and Demantra may require significant hardware and performance tuning resources. Large investments in hardware will benefit from period tuning of the application and underlying database. Tuning the database for these packaged applications is quite similar; however, the hardware resources required may be vastly different. We are faced with the constraint that we can’t tune the SQL in these packaged applications, but we can create/drop indexes and gather statistics that generate the best execution plans. In addition to these generally used techniques, there are six more tuning techniques. Use these six techniques to help improve the performance of your packaged application: more hardware resources, partitioning, parallel query, materialized views, maintenance, and proper initialization parameters.
The Big Picture - The EBS Release 12.1.3 Upgrade
The Big Picture shows, at a high level, the tasks and challenges of the R12.1.3 upgrade. The Big Picture describes how to get started, how to motivate business users to upgrade, and whether to re-implement or upgrade. It covers the upgrade steps, both functional and technical, and understanding these steps helps all team members work toward a better upgrade.
Introduction to Ruby on Rails with Oracle - Open Source and Commercial Software Can Co-Exist
If you are looking to develop an information system, and want it to be WEB-based, Ruby on Rails may be for you. It was for the presenter. This presentation will cover what exactly is Ruby on Rails and how it can and will compliment your Oracle database. This presentation will cover the Model-View-Controller frame work that Rails is based on, as well as specific examples of how this open source collection of tools work together and the results they can produce. Design and development considerations will also be touched on.
Just Give Me an Example - Seven Ruby on Rails Tricks for Novices
One of the challenges of open source software is the limited documentation and support. This presentation will show you seven tricks that you won’t have to learn on your own. This will show you exact syntax and will describe exactly what is going on. If you are just making the decision to use Ruby on Rails to access you’re Oracle Database, this presentation will save you time and much frustration. The presentation will demonstrate the following: • Installation tricks on an Oracle database • How to set up a parent child relationship in ActiveRecord • How to access child and parent data in ActiveRecord • How to create a database table driven pull down list • How to present ordered data • How parameters are passed • How to communicate with the operating system and kick off a shell script.
OTN Hands-on Workshop
This session is a new concept that Todd is working up for RMOUG. It is a cross between an installfest and a hands-on lab, with some guest gurus thrown into the mix. It will be heavy on demos, resources, and Q&A and light on ppt. Topic areas covered will be Oracle Linux and the Unbreakable Enterprise Kernel, Oracle Solaris, Desktop to Data-Center Virtualization, and Database App Development. The session will highlight what's new and cool; why you might care about it, and when would you use it; and how do you get started with it. Attendees can come watch the demos and ask their questions, or follow along on their own laptops. (If you plan on doing the latter you should have 2GB RAM and 20GB of free disk space). Each attendee will receive an OTN Installfest media kit - all the resources you need to set up your own test environment. Todd Trichler and Rick Ramsey from Oracle Technology Network, will probably have some cool t-shirts too.
Introduction to the Semantic Web and Linked Data
The Semantic Web is a term used to describe a W3C model and collection of technologies including the Resource Description Framework (RDF), data interchange formats (e.g. RDF/XML, N3, Turtle, N-Triples), and notations such as RDF Schema (RDFS) and the Web Ontology Language (OWL). A goal of the Semantic Web is to enable machines to grasp the meaning ("semantics") of information distributed across the Web. Linked data describes a method for exposing, sharing, and connecting data on the Web. This presentation will provide an overview of Semantic Web technologies available from Oracle and the open source community, as well as a Semantic Web case study.
Getting Started with Standby Databases From a high-level overview to technical detail of what a standby database is, what it is used for, and how it should be managed, this presentation focuses more on the standby database with Oracle Standard Edition and Standard Edition One rather than Enterprise Edition and Data Guard. This session is suitable for DBAs that would like to get started or increase their knowledge of standby databases.
Perl - A DBA and Developer's Best (forgotten) Friend
This presentation re-introduces Perl as a language of choice for many solutions for DBAs and developers. Discover what makes Perl so successful and why it is so versatile. Perl can automate all those manual daily tasks and is truly platform independent so that your scripts can now run on Linux, Unix, and Windows. Perl may not be in the limelight as other languages, but it truly is a remarkable language for development and is still very current with ongoing development. Companies such as Oracle and VMware use it as part of their latest software releases.
BI Tools
Oracle offers many different BI tools (OBIEE, OBISE, OBISE1, BI Apps). It can be overwhelming to wade through all of the BI information to determine the right solution. This presentation covers the features and some of the differences between Oracle Business Intelligence Enterprise Edition, Oracle Business Intelligence Standard Edition and Standard Edition 1, and BI Applications. The goal of this presentation is to help you get it right—to help you find the right Oracle EBS BI solution for your circumstances.
Oracle SQL Developer Data Modeler 3.0: Introducing Version Support and other New Features
Oracle SQL Developer Data Modeler is a feature-rich product supporting logical, relational, physical, multi-dimensional, data type, and data flow models. The latest release is tightly integrated with Subversion, allowing users to track changes to models and objects. The session will demonstrate this and other new features, such as the ability to add design rules, and to open multiple designs.
New Normal - Information Technology Re-invention
Things have changed and they are not going back. The economic crash drove productivity up because corporate survival required efficiency. Technology accelerated the change and made it permanent. You need to adjust to the new reality. Numerous jobs are gone, replaced by better and faster technology. Maybe your old job is gone, too. As technology workers, you must reinvent your careers, investing time in future technology, if you want to avoid being in the next wave of layoffs. Current trends are toward open source, along with the proprietary Microsoft tools, along with pie in the sky technologies like cloud computing. How about Android, Google Office, and Open Office? Will this continue? How do you find the new normal and prepare for the future? No one can predict the future, but you can see patterns. If you look at the present situation from several perspectives, you can get a clearer picture and make better decisions. This presentation will use a model that traces a technology from its inception, through market acceptance, to old commodity, on its way to obsolete and forgotten. This model applies to your products, your technology, and your career.
Establishing the Enterprise Business Architecture
Enterprise Business Architecture defines the data environment from four perspectives: Business, Applications, Information, and Technology. These perspectives are used to assure that the effort is focused on core business needs. The process framework will define the affect to business operations. The data domains set a foundation of the business information components that are critical for success. Finally, the systems view will provide a technical framework and flow of applications used to support the business processes. This presentation will define the components of the Data Foundation plan and provide actual examples for creating and establishing.
MySQL for the Oracle DBA
MySQL is widely deployed by Oracle 11g customers. MySQL is sometimes run in small, embedded applications, often without technical staff knowing about the underlying database. MySQL is also frequently responsible for massive scale, mission critical applications, often working in conjunction with 11g.
Learn how organizations like TicketMaster and eBay use MySQL and Oracle together to address modern deployment requirements. Find out what makes MySQL different and how you can get started using the world's most popular open source database.
Oracle 'Hidden' Features: Features You Probably Didn't Know About and Are (mostly) FREE
Oracle presentations mainly focus on the major features of new releases and new options. This presentation will highlight some less advertised features added in new releases that are not part of add-on options, but part of the base product and a few that are included in options that you may already have.
Mike Ault, Texas Memory Systems 
Jordan Braunstein, Rolta TUSC
Alex Gorbachev, The Pythian Group