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. 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 eventually 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.
on a presenter name to view summaries and click on the speaker presentation link to download the available presentations.
This presentation will introduce the attendee to LDAP and Active Directory. It will also give an overview of how to access an LDAP directory (Active Directory) for user authentication and authorization from an Oracle Database. Code examples using dbms_ldap will be explained and examined.
This presentation will cover the new tools in Oracle11g that allow the database administrator to tune virtually every aspect of their database environment. SQL, access, backup, and replay utilities make the DBA more able to tune and control his or her database than ever before. This presentation will feature demonstrations of several of the tools from a manual viewpoint.
Public speaking is not something to be feared. Speaking and presentation skills are important assets that professionals need to get and hold their jobs. The ability to develop and deliver a polished presentation is an important skill to have when it becomes necessary to sell ideas or to get a point across. Technical professionals with superior presentation skills can advance their careers by earning recognition among superiors, subordinates, and peers. Developing a polished presentation is difficult, but with time, effort, a few basic techniques, and the proper tools, it can be done. This presentation will provide tips on overcoming the fear of public speaking, preparing a speech, then delivering it to a technical or non-technical audience.
The presentation will cover the use of alternative open source reporting solutions for Business Intelligence. This presentation will show the current state of several open source solutions as well as an in-depth overview/setup of the Pentaho tool suite using Oracle. Attendees will see how a full Business Intelligence solution can be developed and deployed integrated with the Oracle platform; including ad hoc and standard (or fixed) reporting, multi-dimensional analysis, and ETL.
and External Application Integration — Oracle
Fusion Web Services
is intended to educate users, developers, and managers using Oracle
E-Business Suite to learn how to utilize native Oracle functionality
(workflow, forms, and database technology) to automate e-mail and fax
delivery of any document and volume of documents with XML Publisher
integration. This session provides valuable insight into document delivery,
acknowledgment, and management using robust software backed by twenty-one
years of established experience. Learn how Canada’s largest communications
company, an electric utility cooperative, and a major tire distributor
realized immediate savings, streamlined back-office processes, increased
employee productivity, and shortened procure-to-pay and order-to-cash
cycles for their products and services
In today's Oracle database management systems, physical disk I/O remains
one of the foremost bottlenecks. Even at relatively fast speeds of 10
milliseconds, many data intensive Oracle applications can still choke
on I/O by having disk enqueues or Oracle block read tasks waiting to
pull information from the spinning platters. Data compression is certainly
useful for reducing the amount of physical disk I/O but there are some
caveats that need to be followed by the Oracle database administrator.
Oracle SQL tuning is now more complex than ever before. This presentation will focus on real-world techniques for improving the speed of SQL queries with a focus on the new Oracle10g SQL tuning features. The topics will include the new Oracle parameters that affect SQL performance, the use of hints to change SQL execution plans, re-writing SQL queries in more efficient forms, and the use of advanced techniques such as materialized views, replacing SQL with PL/SQL, the new automated CBO statistics collection, and using the new Oracle10g CPU costing approach. Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution.
If your company is beginning to create (or already has) custom systems that use PL/SQL somewhere in the application stack, you probably need a PL/SQL application framework. This presentation will briefly cover what an application framework/library is, how one determines what to put in it, and how to build and deploy it to avoid common pitfalls. We will also examine some of the present libraries and frameworks available commercially and through open source. References will be made to the presenter's freeware framework which has been used successfully by a number of past clients and employers. Attendees are encouraged to download, peruse, use, and improve the framework.
This presentation, useful for Oracle developers and database administrators, explores the various V$SQL views that comprise the visible aspects of the Oracle library cache. Special emphasis is given to identifying, testing, and profiling troublesome SQL statements. Methods for tracking and comparing baselines and variations are explained, along with take-away SQL scripts for this purpose. In addition, new Oracle Database 11g features pursuant to the library cache are revealed.
IT Governance, risk, and compliance management is a topic of much current debate. The global economy's dependence on high-quality data, continuous service availability, and system performance means that the oversight of core IT infrastructure is a key component of enterprise risk management and compliance. The successful application of IT Governance principles can provide a mechanism to increase the effectiveness of IT, and in turn, meet the increasingly stringent demands placed on IT by regulators and by the business. In the past Twelve months, Oracle has made significant investments to help customers simplify and integrate IT Governance for improved business performance. Join this session to find out the latest in Oracle GRC, including the recent acquisition of LogicalApps.
Accounting Intelligence - Beyond BI
Since its inception, ERP systems have struggled to provide accounting and finance departments with easy to use reporting tools. Most report writers are difficult to use, require development skills, are slow to run, and can't drill down for further analysis. What's more, by the time you have designed, created, and run the data it is out of date. Business Intelligence (BI) was invented to fill this void. However, the nature of most BI systems, latent data, staged data, and transformed data, seems to fly in the face of the fundamental accounting principles. The major flaw is data must be duplicated to a data warehouse. The data transfer is normally run overnight, and it can take as long as 24 hours for the data to show up on a report, often rendering the financial information obsolete before it is even reviewed. To overcome the off-line limitations of BI, companies have started using home-grown Excel spreadsheets or Excel plug-in applications to pull data directly from the ERP system, a practice known as Shadowing Data (SD). This presentation will show you how Accounting Intelligence tools combine the best aspects of BI and SD tools, offering the speed and simplicity of implementation and use, with the security and power of a full scale Business Intelligence solution.
As demand for availability increases, all self-respecting vendors tumble over one another to provide "solutions" for better availability. From an Oracle database perspective, we see the use of RAC, DataGuard, ASM, Direct NFS, and various Oracle and non-Oracle tools that spring up around those. Can many databases share a single system (m:1)? Should a single database be shared over many systems (1:m, grid)? Is 1:1 an option? Various options for virtualization offer even more flexibility. How do you stay ahead of this inevitable evolution? And what sensible and practical choices can you make? How do you make sure your systems stay robust, manageable, and of an assured high availability? What is the role of the business, of the ASP and of the IT department ? How can they impact the decisions?
The nightmare of each ETL developer is to reliably and accurately match data elements from disparate systems. Whether you are looking at a master data management solution or a data warehouse, you will need to automate your match/merge process. We will show you how you can deal with this nightmare using Oracle Warehouse Builder. This session will go in-depth into how to set up a system that does the heavy lifting using match and merge rules fully based on algorithms and science rather than on gut-feel and lots of hard-to-maintain custom code.
2008 will see the next big update of Oracle Warehouse Builder. We will bring the latest software to Denver and show you (among other things): loading heterogeneous targets based on Oracle Data Integrator technology; Web services and BPEL support from within Warehouse Builder for any heterogeneous process; integration with Oracle BI Enterprise Edition and end-to-end lineage and impact analysis; and the new IDE for Warehouse Builder and many new goodies such as spotlighting, auto-mapping, and advanced search.
For organizations adopting Oracle's Fusion Middleware as their development
technology stack, there are many decisions to be made regarding which
portions of this stack to use and how to integrate these technologies
into an effective development environment. Should you use JSP/Struts
or Faces? How does BPEL fit into the process? Should applications be
built to be database-independent or heavily rely on the database? This
presentation will describe the experiences of two development teams trying
to answer these questions and what development environments were ultimately
Most large software project failures could have been prevented if someone had bothered to take an objective look at the progress of the system at key points along the way. Even if an audit doesn't prevent the project from failing, discovering serious problems earlier in the project life cycle can save both time and money. Software system audits are, in and of themselves, significant projects. They cannot be accomplished by a single individual interviewing a few members of the development team over a few days. An effective audit requires a skilled team of individuals examining the functional adequacy of the system, the quality of the database design, system security, flexibility, and scalability over time. This presentation will outline the key points in a project when these audits should be performed, how to select the audit team, and the information that can be gained from the results of the audit. A case study chronicling the audit of a large financial system built in a developing nation will be included.
Oracle Data Guard comes with two very nice new feautures (among others):
compressed redo transport and the real time query capability of physical
standby. The latter is a priced option, making a Data Guard configuration
even more expensive. However, now the resources of the standby server
can be used to provide reports, support Data Warehouse feeds etc., instead
of having a server 'sitting idle', just in case. Can compressed redo
transport help this scenario become true, by allowing synchronous redo
transport at lower bandwidth usage? This presentation will give you the
information you need to answer this question.
Data Guard is a high availability solution that protects you from more than just hardware errors. It can also save you from logical errors, statistically known as the major cause of unavailability of an RDBMS. If you have ever been (part of) the root cause of a disaster striking a production system — who hasn't? — this might be a nice session to help you recover from future disasters. This presentation will explain how the architecture of Data Guard can provide you with a safety net. Recovery actions after a disaster will be demonstrated.
are not well understood and the trace file generated by Oracle when
a deadlock occurs suggests that a deadlock is a problem "due
to user error in the design of an application or from issuing incorrect
ad-hoc SQL." In fact, sessions can deadlock even if they are not
contending for the same data and a session can even deadlock with itself!
We discuss this and other misconceptions about deadlock and demonstrate
multiple ways in which deadlock can occur. The trace file created by
Oracle when a deadlock occurs does not contain enough information to
diagnose the problem and we suggest a better way. We end with an amusing
demonstration of the phenomenon of "livelock."
The query optimizer assumes that the columns of a table are independent. For example, the optimizer cannot predict that the query SELECT * FROM CARS WHERE MAKE = 'TOYOTA' AND MODEL = 'ACCORD' will not produce any rows of data. Also, the optimizer does not know how many rows will be created when two tables are joined. The search for the best execution strategy is heavily influenced by the estimates of the cardinalities of SQL operations, such as Selection and Join and is therefore prone to error. The query optimizer also has to contend with SQL redundancy, computational complexity, and bind variables. We analyze these four problems and discuss the available workarounds. We conclude with a discussion of improvements in Oracle 11g including the “learning optimizer,” multi-column statistics, and statistics on expressions.
Introduced in Oracle8, Statspack has become a valuable resource for
diagnosing systemic performance problems. However, statspack data structures
and snapshot logic are designed to support the supplied reports. Going
beyond the basic report requires additional understanding and techniques.
This presentation begins with an overview of statspack processing and
data, focusing on the traps that can cause even the standard report to
miss key information. Next, analytical functions are introduced and key
concepts relating to reporting performance information are examined.
The final topic is the integration of statspack data and analytical functions
using examples from actual system monitoring activities.
Regular expressions have long been used in the Unix world. With Oracle 10g, they have now entered the SQL toolbox. For those unfamiliar with them, regular expressions can be both complex and confusing, but do bring substantial flexibility to the developer. This paper attempts to introduce them to the competent SQL user who has no experience with regular expressions, either in 10g, or in the Unix world. Rather than simply list their parameters, this paper will demonstrate, using simple worked examples, how the four types of regular expressions can be used in everyday coding situations. It will show how these expressions are built on the existing and familiar SQL character functions, and will explain in detail each of the various parameters associated with the four regular expressions.
At Graebel Companies, Inc. and as a volunteer at RMOUG, there are opportunities for me to implement applications and modules using the ADF tool. Both opportunities provide ample examples of practices which do well and practices which do not. In this case study presentation we will look at these pluses and minuses in a more detailed way, and the presenter will generalize about an organization's first applications using the ADF tool. Issues regarding menu systems, security concerns, user-interface components, business components, and custom class adaptations utilized will be covered. This presentation will target a beginning to intermediate ADF/JDeveloper audience.
County School District knows we are not unique in our struggle to get
useful information from the Oracle E-Business Suite and other systems.
(We keep acquiring other Oracle and SQLServer based systems.) Over
the years we have spent large amounts of time writing custom reports,
Discoverer workbooks, and ad hoc queries, with little to show for it.
Until recently, a user request for information was likely to result in
yet another ‘from scratch’ effort. We weren’t building
on what we had already done, mostly because we were overwhelmed with
new requests. This talk will focus on some successes in the past year
to reduce the time effort, yet improve quality and availability of information.
There have been some custom efforts in pulling data together into a useful
format – data about reports and about employees. The presenter
will share code and will talk about efforts to introduce new reporting
tools: Discoverer 10g, MicroSoft Reporting Services and XML
Publisher (aka BI Publisher) and how DCSD has worked to overcome a passive
user mindset – why learn a new tool when you can just create a
ticket and have IT do all the work?
Being Regular with Regular Expressions
The DataGuard Logical Standby and Oracle Streams both use SQL Apply to move data from one database to another. Although one is built for protection and the other for replication, many times an organization will implement the wrong technology because they do not understand the capabilities and limitations of each product. This presentation will discuss the capabilities of these similar technologies focusing on the advantages and disadvantages of each implementation. This includes setup requirements; switchover/failover, implementing RULEs and custom apply processes to control data flow and format. A detail discussion of the impact and maintenance requirements will also be covered.
Oracle’s Flashback technology is the quickest method to recover from most logical errors with the least amount of impact. In this session, Gary Garrison covers Flashback Query introduced in 9i and Flashback Database, Flashback Table, and Flashback Drop, all introduced in Oracle 10g. In addition, new features from Oracle 11g such as Flashback Archive are covered. The presentation will use examples of all of the features to demonstrate the utility of using Oracle Flashback technology to fix almost any logical error.
Writing can be a huge boost to your career. Writing is a way to join in the fray, communicate with fellow professionals, influence your industry, establish your competency, help others learn, and push yourself to learn. Computing professionals are in a very favorable position—compared to aspiring authors in general—to become published. This presentation explains how the publishing industry works, tells what publishers look for in book proposals, warns of what you are getting into when you dare to write a book, and shares some tips on working smoothly with your editor. You’ll learn the benefits from publishing and some of the pitfalls to avoid. Should you aspire to someday write a book, you’ll leave this presentation with (hopefully!) a good idea as to how to make that aspiration become a reality.
Oracle Business Intelligence Suite Enterprise Edition is a robust, flexible, next-generation business intelligence platform that enables organizations to tap into any data source and deliver actionable insight to all users across an organization. This session provides a technical overview of the platform, reviews how it fits into a typical IT environment, and outlines the significant benefits of its architecture.
This presentation is based on a project demonstrating the benefits of one particular hardware virtualization platform running Oracle RAC database — real time infrastructure. Interconnect-centric architecture is something different from VMware-style platforms, as you will learn. This presentation highlights many cornerstone issues of Oracle RAC implementations including connection management and load balancing, application design, monitoring and troubleshooting, hardware capacity, interconnect performance and stability, and storage infrastructure. Many interesting administration tasks and unusual situations were encountered and resolved and the presenter will share his experience. He will also cover the tools and techniques used to simulate application and taking measurements.
This presentation covers connection management in a RAC environment. What happens during connection, failover, how run-time workload balancing is working, and what needs to be done in client applications including JDBC, OCI, and .NET environments to handle those situations. Are technologies like Oracle TAF, FAN, and FCF really working? The major part is valid for non-RAC environments as well, such as Data Guard and cold failover.
Partitioning is crucial to data warehouses, but how do you use this complex functionality effectively? What other major features of Oracle does partitioning enable, and how and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements. It will provide straight answers and solid guidelines to best utilize Oracle DW features to ensure success. Data warehouses that utilize partitioning effectively often succeed, while data warehouses that are not designed to use partitioning effectively often die painfully.
Automatically starting and stopping applications in a clustered environment can be a complex task, quite unlike the same task in a non-clustered environment. Oracle's "Cluster Ready Services" (CRS), a component of Oracle RAC, provides the ability to do this in a supported and reliable manner. This quick tip outlines the criteria for choosing to use this feature, and steps through a sample implementation.
Oracle's "Recovery Manager" (RMAN) provides some limited reporting with the LIST and REPORT commands, but how about answers to some of the really *REALLY* important questions, such as: Will I be able to recover to a specific point in time? How long should it take me to restore and recover? How much space are my backups taking? This presentation will describe the repositories used by RMAN, in the control file (i.e. NOCATALOG) as well as the "recovery catalog database", and how to report from them.
Many companies have struggled to produce actionable and relevant information that supports business decisions and day-to-day management. Some efforts have required significant resources to execute and support, while others have become bogged down in complicated and time-consuming data management efforts. In either case, information still remains beyond the reach of those who can put it to profitable use. Hitachi Consulting will discuss how enterprises are tackling these issues using the Oracle BI platform, focusing particularly on what it takes to make business intelligence relevant and how to balance the desire for rapid deployment with the flexibility to react to changes in our business.
In 10g Oracle has introduced a couple of new features to reduce the overhead for small transactions in the form of In-Memory Undo and Zero-Copy Redo. This presentation will first explain the basic pre-10g algorithm showing the associated overheads through test results. The two new features will then be explained with comparative test results. Throughout the presentation available views,tables, and structures for seeing these features work in your environment will be shown.
The latest release of Oracle SQL Developer includes significant updates to the SQL and PL SQL Code Editors, by including enhanced formatting and code templates. With SQL Developer, database developers have a convenient way of performing basic database tasks and managing database objects. Users can browse, create, and edit database objects; create and execute SQL statements and PL/SQL code; export and import data; export database objects; and work with reports. This session includes demonstrations of the latest features including the Migration Workbench, which gives users the ability to browse, manipulate, and then migrate objects from third party databases. In closing, we’ll discuss the plans for our future releases.
Oracle SQL Developer provides database developers with a convenient way to perform various database tasks and to manage database objects. This session focuses on three aspects of the tool that users often overlook, PL/SQL debugging, reporting, and building extensions. We start with editing and debugging PL/SQL, with particular reference to remote debugging. SQL Developer provides advanced reporting capabilities by allowing users to introduce graphical displays and master-detail reports. We will demonstrate building more complex master-detail reports, passing parameters, and drill down capabilities. We conclude with SQL Developer's extensibility and demonstrate adding new features to the core product.
XML was designed as a way to organize data for the purpose of transmitting them from one place to another. A relational database is intended to be a way of organizing data for the purposes of storing and managing them. An entity/relationship model is a way of displaying the semantics of an underlying database design. While all of these technologies are concerned with data structure, their purposes are clearly different, and confusing them (which is often done) is done at a company’s (or a government agency’s) peril. This presentation will present an example of the same domain presented as a data model (a surrogate for database design) and as an XML schema, showing the information lost in XML version. It also shows the kinds of semantic information that are lost in XML and how they can be found again through careful analysis of an entity/relationship diagram. The presentation ends with a description of how to extract one or more XML files from an E/R diagram.
Explore PHP as a powerful tool for quickly writing Web applications with an Oracle database. Fraser will share his experience writing a Web application in PHP using an Oracle database. This presentation will cover why PHP and Oracle were chosen over competitive offerings, design decisions, and tolls such as Oracle SQL Developer.
The Oracle Business Process Analysis Suite is a mature, repository-based tool for analyzing and modeling business processes. It is a key component of Oracle's complete Business Process Management (BPM) solution. It supports UML, BPMN, process simulation, and round-trip engineering to BPEL models. This suite is being leveraged to deliver Fusion Application Reference Models. This presentation will present the capabilities of the BPA Suite, teach you to use this tool, and explain why you will want to use it.
Dan Hotka will demonstrate Discoverer 10g features in a live-demo format. This presentation is packed full of tips and techniques, including scripts. Dan will cover these topics using the Discoverer10g Web version including: review of the new “Drake” interface; stop light exceptions; advanced conditions; adding columns and formatting data with calculations; graph review; scheduling features and a useful Oracle script; key differences between the Oracle 10g Desktop and Web versions; and time permitting, Discoverer10g Administrator topics. Dan will conclude with an in-depth comparison of the Web-version versus the Desktop versions of the Oracle10g Discoverer product. This presentation is good for people who are considering implementing Discoverer, those new to Oracle Discoverer, as well as experienced Discoverer users.
Utilizing Oracle Warehouse Management (WMS) and Mobile Supply Chain Architecture (MSCA), Oracle has provided the ability to perform many traditional material handling processes more quickly and efficiently. Oracle WMS has the ability to manage and improve the process of material picking, receiving, and replenishment by incorporating barcode and RFID scanners. This presentation focuses on setup steps and guidelines required for material handling including: receiving, material adjustments, replenishment, movement, shipping transactions, and label generation. Participants will be able to understand the setups necessary to get started with Oracle Warehouse Management in Release 11i.
Over the last several years, many manufacturing companies have begun to implement Lean Manufacturing solutions to improve efficiencies, operations, and customer services, all of which to help improve their financial performance. A significant directive of Lean Manufacturing is the reduction of non-conformances and achieving a seamless manufacturing process. A component of Oracle Manufacturing, “Kanban Replenishment” can be implemented to accomplish this task. Utilizing Oracle Inventory and Purchasing, the Kanban replenishment functionality and procedures can help to improve manufacturing operations by providing a seamless supply chain of manufacturing components to your shop floor on a timely and scheduled basis.
Identity management, access control, and security are among the most important concerns of today’s enterprises. A decade of rapid application development and system deployments have left companies with disjointed user and password stores, many proprietary and some based on LDAP or Active Directory. It takes an army of people to provision and control access to the many applications, users cannot remember their user logins and passwords, and it takes weeks before new employees have the right access to all necessary applications. This presentation will give an overview of how the Oracle Identity Management solution addresses the above problems. Oracle Virtual Directory, Oracle Access Manager, and Oracle Enterprise Single Sign-On will be discussed. However, the emphasis will be on how Oracle Identity Manager solves real-life provisioning problems, how it integrates with ERP solutions such as Oracle E-Business Suite, SAP, Microsoft, etc., and how it integrates with custom applications using custom Java or PL/SQL code. A demonstration of Oracle Identity Manager will be given and lessons learned from implementations will be shared.
This presentation will cover the fundamentals of concurrency and then examine and compare the various tools and techniques used to address the problem in three different arenas: database, software, and enterprise applications. By the end of the presentation, attendees will have a clear grasp of why concurrency should be considered throughout all phases of development, how different mediums implement the solutions, and how to incorporate the tools into all aspects of an application.
Using SQL to generate SQl commands. This technique has been used by DBAs for many years. With the advent of Enterprise manager, you may not have learned this skill yet. However, using SQL to generate SQL commands will save you time, help prevent mistakes, and amaze your peers. In this presentation, Stephen Jackson will cover the basics, plus some more advanced techniques to make your job easier.
This presentation discusses Oracle solutions for several information security challenges such as secure and centralized auditing, stronger controls on the all powerful users, network encryption, and the segregation and protection of sensitive information stored in the database. We talk about the Advanced Security Option (ASO), Database Vault, and the Audit Vault 10g solutions and 11g enhancements that address these challenges. We will also do a live demonstration of some of these features.
The goal of this presentation is to provide an overview of an enterprise RAC installation to the novice DBA. While detailed installation documentation can be found in Oracle as well as in textbooks, a significant learning curve and fear of the unknown prevent a lot of DBAs and corporations from moving to the RAC route. This presentation aims to lower that threshold by relating concepts to real implementation details in a complete picture of the RAC installation process. We start with a brief discussion of the end state as it exists in an Enterprise setting — a multiple-node RAC cluster running on ASM and replicating via DataGuard to a DR site, with Grid Control used to manage and monitor the set up. We then take the picture apart and show the DBA how to put the blocks together. These building blocks include prerequisite checking, Oracle clusterware, Oracle databases for 10g RAC, ASM, post-installation setup, RAC administration, backup and recovery, DataGuard configuration, and grid control. Lastly, we talk about some experiences like lessons learned and the migration of existing databases to RAC.
This presentation will explore the best practices for developing Oracle Application Express (APEX) applications that work well on hand-held terminals such as those used in warehouses and other mobile environments. Featured will be examples from the presenter’s personal experience developing a custom Warehouse Management System (WMS) and other applications that work on mobile Web browsers including cell phones. This presentation is for developers with any level of Application Express experience (including beginners) or non-developers who have an interest in this topic.
Oracle’s analytic functions can facilitate many database administration tasks. Instead of grouping a result set and applying an aggregate function to the entire group or result set, analytic functions allow result sets to be partitioned along logical boundaries. Analytic functions can then be applied in order to rank, aggregate, compare, compute moving averages, or otherwise operate on data within individual partitions. Published examples of using analytic functions typically apply to business situations. However, analytic functions can also help database administrators in their day-to-day tasks. Analytic functions extend the SQL language and can help queries more efficiently. They can help simplify some complex queries and allow data to be examined and displayed in new and interesting ways. This presentation will help you with tasks such as: (1) More efficiently determining which object owns a given file and block, (2) Allocating segments to the most appropriate tablespace and keeping a running total of space usage, (3) Analyzing database performance through time and, by computing a moving average, enhancing the graphical display of the results.
Oracle Database version 8i included database packages to generate HTML tagging and a "mod_plsql" for the Oracle HTTP Server (OHS) to connect HTTP requests to database objects and vice versa. The result is an efficient and easy to program (for PL/SQL programmers, anyway) Web-based application development environment, which takes maximum advantage of the database. This session will cover an overview of the HTML Web-based application development technology and specific nuances included in the Oracle PL/SQL Web Toolkit. We will then examine the technology, backend, and user interface of a "typical" application. Coding suggestions, tips, and examples of "what not to do" will also be included.
Get familiar with the tables, packages, and structure of Oracle 10g ADDM. Steve Jun will provide some useful queries against DBA_HIST tables and some sample recommendations from the ADDM.
Online fraud and regulatory issues are driving organizations to choose stronger authentication and fraud prevention technologies as critical elements of their security infrastructure. This session introduces Oracle's adaptive access management solutions, which provide proactive, real-time fraud prevention, mutual site authentication, stronger authentication, risk monitoring, and online/offline analysis of transactions and audit data.
You have your warehouse populated with fresh data. Now what? How do you produce, organize and deliver your reports? Oracle Business Intelligence Suite (OBI) comes to the rescue. This presentation is geared towards the technical, those looking for a robust Business Intelligence development and deployment platform as well as managers looking for a comprehensive, enterprise-level, long-term Business Intelligence solution. This presentation will cover OBI main modules such as Oracle Answers, Interactive Dashboards, and BI Publisher, as well as OBI security model and Server Repository. A live demo will cover various techniques such as slice and dice, drill downs, and data visualization.
New features of the Oracle 11g and 10g databases geared to developers will be discussed and demonstrated. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include new SQL functions, regular expressions, virtual columns, new XMLType options, XML indexing improvements, SQL pivot statements, JDBC improvements, PL/SQL syntax enhancements, PL/SQL compiler, trigger improvements, PL/SQL result cache, case/accent-insensitive query, new data types, new statistical functions, Model clause, and the recycle bin. Attendees will be better equipped to create new applications or modify existing applications to take full advantage of Oracle11g/10g.
What's the Fuss about Fusion? Oracle and SOA
Oracle has been at the forefront of incorporating XML data into its database products; both Oracle 11g and Oracle 10g break additional new ground. XML data may be stored in the Oracle 10g database in two ways: Structured ("shredded" into tables and columns) and Unstructured (XML document). In this session attendees will learn how to store/maintain/retrieve XML data in the Oracle database in both Structured and Unstructured forms. Oracle 11g introduces a new binary capability attendees will learn about. Oracle’s incorporation of XQuery to access data inside the database is an important feature that will demonstrated. Use of the XML DB WebDAV interface will be explored to show how Oracle data may easily be shared with non-Oracle applications. New Oracle 11g XML features will be examined as part of the session.
Users will more easily understand your application and will therefore be more productive if all pages of your Web application are designed to look and act the same. The requirement for a common look and feel has traditionally been been met by the use of templates. However, the methods for implementing template systems change with each new technology. This presentation discusses how to work with templates and other common look-and-feel options in JDeveloper 10.1.3. It explains and provides code examples for template systems using ADF Faces and JSP tags as well as additional Java frameworks. It also describes the Oracle Browser Look and Feel (BLAF), which is used for the E-Business Suite. The presentation also describes the ADF Faces skinning feature as well as how the JHeadstart plug-in to JDeveloper uses templates.
Deploying a J2EE Web application consists of wrapping all application files into a single Java archive file (the EAR, enterprise application archive) and then copying this file to the application server. Although the Oracle Containers for J2EE (OC4J) service of the Oracle Application Server is a standard J2EE runtime process, it has its own deployment utilities and procedures. This presentation explores the process deploying to an Oracle Application Server OC4J container. It outlines JDeveloper utilities and profiles that help you create an EAR file with all required libraries. The presentation explains how to deploy the application using JDeveloper. It also discusses the benefits of and techniques for testing deployment on a local standalone OC4J server. In addition, the presentation describes the deployment services of the Application Server's Enterprise Manager Console (EM). The presentation also discusses deployment plans and common deployment process and runtime errors.
Configuring storage need not be difficult if proper planning is done. Using Oracle’s ORION Workload tool we can effectively benchmark storage for expected application mix. Only after benchmarking potential storage can we gain an understanding for the performance capabilities of our storage and become confident in its ultimate deployment. This presentation will introduce storage concepts, Oracle’s ORION workload tool, and provide scripts that show disk access trends in Oracle. Results from various workloads using RAID 0, 1, 10, and 5 on a 30TB storage system will be compared. Come see how your favorite RAID level performed.
This session will focus on eleven new, high-impact features of Oracle Database 11g and what they mean to you, the developer or DBA. Continuing the format of the last four Oracle OpenWorlds – Oracle’s AskTom will present these as a “top eleven” list – the eleven new features he believes will be the reason to look at Oracle Database 11g in the near future.
This session will talk about the importance of heavily instrumenting your code and exploring the possible methods of instrumenting your code in an Oracle environment — concentrating on developed code both in the database (stored procedures) as well as outside the database (Java, C, VB and the like).
What is an Enterprise Portal? Oracle, IBM, and BEA all offer products in this area, but what do they accomplish? How do you know when you need a portal? This presentation will cover the enterprise portal space and the problems that portals solve. We will discuss application integration, security consolidation, content aggregation, profile aggregation, and collaboration. This talk is aimed at CIOs, IT architects, and IT management.
Google Gadgets have become a popular widget technology and were the fastest growing product at Google in 2006. A gadget is a small Web page that encapsulates a feature like a stock ticker or flight status lookup. Gadgets are normally surfaced on your iGoogle portal page, but they can also be placed on any Web page. This session will show you how you can surface your enteprise applications in a Google gadget and allow you to capture more eye balls.
Possibly an executive or even a co-worker in your company considers Oracle still just a database company. And if it is someone within your management chain, it might be impacting your role without your knowledge. Oracle technology continues to change as well as its use and management. Database growth, business, and Services Oriented Architecture continue to alter the role of the Oracle administration. Attend this presentation and learn how Fusion Middleware is changing the role of the database administrator as well as other technology professionals. New technology presents new opportunities if you are prepared to take advantage of it.
Once you start to write more complex statements, it's fairly common to see the optimizer making mistakes. In such cases, you need to review the data, understand what should happen, and force the relevant access path. But unless you know what can be done, and why it needs to be done, it's not an easy task. In this presentation, we examine a single SQL statement and show that the optimum execution path depends entirely on a good understanding of the data volumes, the data relationships, and the available indexes. In the course of the presentation, we will see several different execution paths for that one statement. One is a path the optimizer will never find, one is a path a human being would (probably) never think of; but each of the paths would be the correct path for a specific set of circumstances. After seeing this presentation, you will be better equipped to deal with the problems of analyzing and optimizing complex SQL.
When you are trouble-shooting it's often easy to spot a problem. Something is doing too much work, or possibly wasting too much time waiting. Once you've spotted the obvious problem, it's often easy to spot the equally “obvious” fix. But local fixes may have global side effects. In this presentation, we examine a few of the easy fixes, highlighting possible side effects and suggesting strategies to minimize the risk. After seeing this presentation, you will have a better idea of when an "easy" fix is likely to be a safe fix, and when it might have some very unsafe side-effects.
Oracle makes access path decisions based on optimizer statistics stored in the data dictionary. DBAs have the option to estimate these statistics based on samples of table data. But unexpected variation in these statistics can occur when using insufficient sample sizes. Under the right circumstances, this can cause a query's execution plan to change, even when the actual data remains constant. This presentation demonstrates one set of conditions where this phenomenon occurs and explores the underlying reasons for this behavior.
2007 marks thirty years of Oracle helping businesses and governments manage their most valuable asset—information. Daniel Liu will introduce the new features in Oracle Database 11g. Those topics include: automatic memory management, automatic diagnostic repository, invisible index, SQL query result cache, flashback data archive, real application testing, new compression algorithms, new partitioning methods, and more. The topics covered in this seminar are primarily for database administrators.
This presentation will provide an overview of XQuery along with its use in the Oracle database and in the Oracle application server. The presentation will explain terms and concepts related to XQuery such as XQJ (XML Query for Java API), XQS (XML Query Services), XPath, and XSLT. After providing a high-level overview of XQuery, its wide variety of uses, and its uses specific to Oracle products, the presentation will show some actual examples of XQuery used in practice. XQuery is rapidly becoming a commonly used specification in many software applications that use XML, sometimes even without the users and developers realizing it. This introductory-level presentation is aimed at developers, architects, and managers who do not know much about XQuery, but would like to learn more about it and how it is likely to play a major role in future application development.
Apache POI is an open source, Java-based library for reading and writing documents that can be opened in Microsoft Excel. Apache POI can be included in Java-based applications (including both SE and EE applications) to produce Excel documents. Many stakeholders have interest in the data stored in Oracle databases and Apache POI allows developers to easily report this data in Excel documents. This presentation will provide an overview of how and why developers should use Apache POI to produce Excel documents from their Oracle database-driven Java applications. The presentation will include some brief code examples and demonstrations of writing Excel documents based on data from an Oracle database instance using Java and Apache POI.
In this session, we present an ROI analysis and overview of an actual implementation demonstrating how the Oracle Identity Management Suite can provide enterprise-wide single sign-on and provisioning, reduce operational costs, and improve security by implementing automated user lifecycle management.
Ready or not, Fusion is peeking over the horizon. Now is the time for all Oracle developers to understand what it will mean to become a Fusion developer, be it for custom applications or integration with Oracle's own Fusion Applications. In this session, Duncan Mills will cover the key strategies, architectures, and technologies that define the Fusion development method and demonstrate the kind of applications that this technology can enable. This is the opportunity to push ahead of the crowd, get a sneak peak at Release 11 of JDeveloper and ADF, and learn what Fusion is really all about.
This presentation provides an overview of Oracle JDeveloper with a focus on the new features being introduced in the new 11g release. Oracle JDeveloper provides an integrated development environment for the Oracle Fusion Applications and the Oracle Fusion Middleware components. This presentation will review the features offered for Java, SOA, WebCenter, and Database development as well as the full development life-cycle supported by JDeveloper.
Reflecting across nearly twenty years of solving Oracle performance problems, Cary Millsap can recognize a single pattern of behavior that is the dominant reason for failure in all the projects he has witnessed. In almost every case seen, failures in diagnosing and repairing performance problems have been caused by unrecognized SKEW in diagnostic data. This presentation shows several examples that illustrate why skew is such a pervasive problem for performance analysts.
In today’s business environment, it is more important than ever that systems and databases remain available. The potential for businesses to lose money is enough incentive to put an HA solution in place. Oracle provides a proven solution for High Availability through it’s Real Application Cluster technology. Since more businesses are going to Oracle RAC, the need for knowledgeable RAC professionals becomes even more necessary. The next question becomes important to the Oracle professional who wishes to learn Oracle RAC. How do I learn more about RAC? In a perfect world, all the hardware is in place and the learning can start. However, the cost is usually out of line for most people desiring to learn RAC in a real-world environment. For learning and prototyping, there is an alternative and it can be done using a single laptop. This session will go over how to create a fully functional two node RAC environment on a laptop using vmware, Red Hat Linux, Cluster Ready Services, ASM, and Oracle 10g. In the process, a correlation will be mapped out between the virtual and real-world environments.
Even as the volume of data continues to grow out of control, companies are keeping large amounts of data readily accessible in Oracle databases. But very few business policies dictate the need to have that much data on line. As a result, performance is degraded, more disk drives are needed and administration tasks (backup, recovery, reorgs) take longer and longer. This, coupled with the new legal requirements for data retention and e-discovery are creating new challenges for archiving data. Join Oracle Ace David Moore to discover the best ways to archive Oracle data and what you need to do after the archive in order to get your database performing again.
Oracle 11g offers a variety of great new capabilities that extend the value of your investment in the Oracle database. This presentation, live in SQL*Plus and presented in a PowerPoint Free Zone, will feature demonstrations of virtual columns, invisible indexes, flashback archive, native compilation, the new table trigger follows clause, and the new 11g result cache, and more.
This session explains how Oracle Fusion Development Tools (JDeveloper, Application Development Framework (ADF), WebCenter, and BPEL Designer) deliver the rapid and declarative development experience you need to build robust applications. Through demonstrations, this session shows you how to leverage these tools today to build applications that integrate with Fusion Applications in the future.
This presentation will change your life. It is a non-technical refreshing break to relax your mind from the technical sessions. The IT leader is now the pivotal position in an organization's business plan. This talk will focus on the attributes that the leader must have from a character perspective to combine with a technical prowess. To be a leader that builds a truly great organization, you must build into the team: integrity, moral courage, physical courage, tact, loyalty, unselfishness, initiative, enthusiasm, knowledge, respect, self control, and humility. The result will be the fortitude of an organization to handle any and all challenges. This presentation will teach you how to refine attributes of character and become an uncommon leader.
It seems that every day we read a report of another data breach. The threat of mass data breaches continues to increase as attackers become more sophisticated in their approaches to penetrate corporate internal networks and acquire valuable data. Companies must also deal with the "threat from within" -- privileged users with valid corporate credentials and access to your most sensitive data. Combine these challenges with the pressures to meet the data auditing requirements of industry compliance regulations like Sarbanes Oxley (SOX) and Payment Card Industry (PCI), and it's easy to understand why companies are making data auditing a priority in their protection architecture.
It seems that every day we read a report of another data breach. The threat of mass data breaches continues to increase as attackers become more sophisticated in their approaches to penetrate corporate internal networks and acquire valuable data. Companies must also deal with the "threat from within" -- privileged users with valid corporate credentials and access to your most sensitive data. This presentation will provide the audience with insight into:
In administering both Oracle Applications 11i and R12 the cloning process helps organizations create multiple environments based on production to test and develop changes that will and need to occur as the organization grows. This process also takes a tremendous amount of time in a DBA's daily routine. Using Enterprise Manager 10gR2 Grid Control for Cloning Oracle Applications allows a DBA to simplify the process of cloning environments. Ultimately, this tool allows the cloning process to be automated and reduces the amount of time that DBAs spend on cloning. This presentation will review the functional cloning flow and include a technical discussion on installation process for the Application Plug-in EM. The final main topic will discuss troubleshooting and tips in resolving issues that may come up in the cloning process, making this an effective tool in an Application environment.
The presentation will explain the three worst practices to date: Counters (don't) count, Guess & Grimacing, and Groundhog Day Tuning. The Grand Unifying Solution (GUS) will be presented. The problems with GUS will be discussed briefly.
The Oracle Application Server is an extremely complex piece of software. Getting a grip on all of the components, how they fit together, and how they can benefit your organization can be a daunting task. This presentation will examine all of the Oracle Application Server components and show how you can use them effectively in your organization.
While the LDAP standard has existed for quite some time, it is a relatively new concept for most administrators and developers who work with Oracle. This presentation will detail what LDAP is, how it works, what LDAP means to developers and administrators, and how Oracle has chosen to implement LDAP as part of the Oracle Application Server.
Rapid and erratic change in requirements, demands for decreased time to market, and the use of leading or bleeding edge technologies drive software development organizations to implement new methodologies. Agile methods are emerging as the choice of many organizations to address current demands on software development groups. Migrating to these methods introduces many challenges to a traditional plan-driven organization. Nerur, Mahapatra, and Mangalara (Communications of the ACM, May 2005) discussed many challenges in such a migration. These identified challenges are the framework for this discussion. This presentation will discuss the challenges of migrating to Agile methods from traditional, plan-driven methods and provide an approach to meeting those challenges through example and case studies as documented at Gold Systems, Inc.
Increasingly we live in a real-time world in which banks, airlines, telecom operators, and network service providers require their applications respond to events in sub-millisecond time. A standard method to solve this problem is to locate data closer to the application, avoiding network roundtrips. Rather than coding a special purpose mid-tier cache, consider placing the TimesTen fully relational database in the midtier for high-speed access. In this session, we'll discuss the hows and whys of using TimesTen at a high level. We’ll also touch on using TimesTen in conjunction with an Oracle database and replicating between TimesTen databases. No deep DBA or application development knowledge is required, but a basic understanding of IT architectures would be helpful.
Oracle Collaboration Suite is filled with lots of goodies. This presentation will introduce you to the various components available and then focus on Real Time Collaboration with the emphasis on the Web conferencing capabilities of OCS including the old and the new!
When tuning is needed, the most common phrase heard is "Add an index!" Are your performance problems because you don't have enough indexes? Maybe, or you might just have too many indexes. Or the wrong indexes. This presentation will introduce the basic strategies of indexing, the different types of indexes available in Oracle, and why they don't always seem to work the way you thought they would. Participants will learn when to index, why to index, and how to index an Oracle database.
This presentation discusses when, why, and how to use autonomous transactions in conjunction with other features, such as object collections, dynamic SQL, INSTEAD OF triggers, etc. Additional focus will be placed on critical issues such as resolving self-mutating tables, preventing deadlocks, understanding read/write-consistency and its corresponding side-effects. Real-life examples will be included to help attendees avoid hidden traps on the way to building systems better, faster, and cheaper.
This presentation discusses the differences between creating a “statefull” or “stateless” system front-end. The decision about whether to keep persistent sessions (client/server) or not (most Web applications) has a direct impact in many areas such as locking, transaction control, error handling, resource utilization, performance tuning, etc. Real-life examples will be included to help attendees avoid hidden traps on the way to building systems better, faster, and cheaper.
We have tended to write SQL exactly the same way for the past decades. This presentation will show how SQL can be written more effectively and will demonstrate that performance improvement is excellent with rewritten SQL. The following SQL features are used to rewrite SQL: 1. Model clause 2. Analytic functions (first_value , last_value, lead, lag, etc.).
This presentation will list various myths about redo,undo, commit, rollback, etc. and will disprove them with test cases. Some of the myths covered: rollback does not generate redo; nologging works for all table structures and does not generate any redo; effects of foreign key constraints and row level triggers over nologging redo; DBW does not write uncommitted buffers; and commit forces dirty buffers to be written.
Have you ever wished your users would just write the code for you? Let Margaret Steber show you how. Learn how to use PL/SQL to generate simple functions based in data entered into a form by a user. This presentation will include table structure, user interface, and PL/SQL code snippets to: 1) Create a SQL select statement from user input; 2) Execute that select statement and; 3) Use the data returned from the select statement in a procedure to generate data.
Oracle Application Express (formerly Oracle HTML DB) enables anyone—even those with limited programming experience—using just a Web browser to quickly create secure, scalable, database-centric Web applications. In this session, you’ll learn why Oracle Application Express is one of Oracle’s most popular technologies, and you will learn about exciting new features in Application Express 3.x. Details relating to Version 4.0 (due first half of 2008) will also be covered.
Recovery Manager (RMAN) is an Oracle utility that can simplify the process of database backup and recovery, especially for hot backups and restores. RMAN is most functional when a recovery catalog is used and the loss of the catalog can impede its usage. RMAN availability can be enhanced through the use of two synchronized recovery catalogs so that in the event that one catalog is lost, RMAN can still continue to run normally. This presentation illustrates in detail how to implement RMAN with dual recovery catalogs and enhance its availability. The implementation is covered from the creation of the RMAN owner and the recovery catalog, through the execution of the shell script that maintains and synchronizes the dual catalogs. As there are quite a few details involved, a project plan that details the steps involved is also presented, as well as some “desired” features for future versions of RMAN.
This is a fast paced presentation focused on showing Oracle DBAs and developers key features and benefits of using MySQL and the LAMP stack for projects. Topics will focus on: best practices for configuring a MySQL database server, understanding key differences between Oracle and MySQL, and OFA versus MOCA. Attendees will also be introduced to MySQL replication and Cluster configurations. This is an excellent bootstrap presentation for developers and DBAs that may be looking at using MySQL and the LAMP stack for future projects.
Data Pump is the best tool to use when you need to move data and metadata very quickly from one database to another. Oracle has pumped up Data Pump in Oracle 11g, providing encryption and data compression. In this session, we will give an overview of the new Oracle 11g Data Pump utility, giving emphasis to the 11g enhancements. Details on the Data Pump structure, components, and dictionary views will be covered, including DBMS_DATAPUMP, DBMS_METADATA packages, and the ORACLE_DATAPUMP access drivers. We complete the session with a live demonstration, showing how to use Oracle Data Pump effectively and efficiently.
With each new release, Oracle provides more and more functionality in the Oracle Application Server, from Web-based application support, to Single-Server Sign on. But what about a centralized repository for all database connection descriptor? Yes, App Server can provide LDAP functionality to resolve all database descriptors and provide a centrally managed "tnsnames server". This session will introduce Oracle Internet Directory and demonstrate how to configure it with Oracle Application Server. Existing connection information (from tnsnames.ora) will be loaded and used to connect to the database. The session will end showing how to use LDAP to retrieve connection information to be used with Oracle 10g Instant Client.
Diagnose system issues before they become critical. Increase system performance and availability. Get faster problem resolution and reduce IT risks and costs. Software Configuration Manager, a proactive automated support capability included in Oracle Premier Support, offers you a simpler way to track, manage, and support your Oracle configurations while reducing the risk of unplanned system downtime. Expect more with Software Configuration Manager.
Quality is the enemy of innovation, innovation is the enemy of quality, and people get in the way of both. A great organization needs to focus on all three, all the time, and a great manager must see from all three perspectives. Three-Filters technology offers a way for dealing with these conflicting needs.
There are a lot of books and papers on building a data warehouse, but most of these sources do not cover key concepts that are required in almost every project because these topics are nasty and difficult. Attendees are presented five advanced data warehouse concepts: physical party model, auditing and managing multi-source rows, meta data structures in the source, standardizing code values, and managing history. The dirty secret is that these concepts can be a sure project death if they are not dealt with efficiently. This presentation will cover these five topics and provide attendees real-world solutions and approaches for handling each.
Have you heard about data warehousing, but have never had a down to earth presentation on questions such as—Why build a data warehouse? How do I get started? What are the core components of a data warehouse? This presentation will strip data warehousing down to the core concepts and remove the hype, vendor promises, and buzzwords (well, most). This session will cover the following topics: basic data warehouse architecture, business intelligence basics, data warehouse data structures, dimensional modeling basics, and data transformation Oracle specifics. This presentation will also cover key project deliverables and templates required for a successful data warehouse project.
Oracle 10g saw the introduction of the concept of Database Time as the latest evolutionary advance in Oracle performance tuning. In this presentation, Graham Wood will describe how DB Time can be used not only at the instance and database level, as in ADDM, but also to tune at lower levels, such as session and individual SQL statements. This presentation will demonstrate how the use of DB Time has been extended in Oracle 11g.
This presentation will uncover the little known and understood relationships between EDM and SOA, and how strategies for either will ultimately fail if key aspects for both are not taken into account in a coordinated fashion. Further, by coordinating your EDM and SOA strategies, you will tap into additional opportunities to maximize the value of your enterprise data as well as to gain economies of scale in key governance and IT portfolio management roles and processes. This session lays out the need for a framework that facilitates this coordination and the resulting benefits, and it shows how to use and adapt such a Coordinated Service-Oriented and Data Architecture (C-SODA) framework for your organizational needs. In addition, this presentation lays out the appropriate and effective usage and best practices of common Oracle tools and products that help facilitate a C-SODA for your organization.
Being a loyal Oracle BI customer, you followed Oracle’s footstep in adopting Discoverer, Reports, BIS, OFA, DBI, BSC, EPB, Fusion Intelligence. Then the acquisition of Siebel and Hyperion came along. All of a sudden, the landscape of Oracle BI has been changed. OBIEE, OBISE, OBIEE Plus, OBISE One—what are we getting into? Stay the course or start the migration, which way should we go? This presentation provides a non-biased perspective and insight into Oracle’s BI product offering and guides you through the key considerations and general guidelines for migrating within Oracle’s new BI product landscape.