Directories, Directories Everywhere. Should I use Active Directory, OID, or OVD?
This presentation will give an introduction to using LDAP directories. The strengths and weaknesses of Active Directory, Oracle Internet Directory, and Oracle Virtual Directory will be discussed along with use cases for choosing the best directory for the application. In addition there will be examples of how applications can use the directory for username and password maintenance.
New CPUs and storage arrays are getting faster, but these resources are finite and come at a cost. Hence, capacity planning plays a very important role to ensure proper resources are available and to handle expected and unexpected workloads. Another critical matter for the DBAs and IT managers is justifying the expense of adding resources on the system. With guesswork, you'll end up getting the most expensive hardware. With proper measurement, proper planning, and management of growth, you'll be able to get just the right hardware for your workload with allowance for a particular growth period. This will result in huge savings for the company and a happier IT shop. AWR is a built-in data store that started in 10gR1 and is very much like a "Statspack on steroids." It has improved significantly in 11gR2, enabling you to have a far better workload information when going through all the AWR snapshots. From the AWR data samples, we could build amazing reports that will let us notice trends and makes it possible to visualize data and use statistical methods for analysis. Even more surprising about the AWR data samples is we are able to define the database server's Capacity, Requirements, and Utilization in terms of CPU, IO, memory, and network, which are very important key metrics for Capacity Planning.
Putting on the Flash! Using Oracle Smart Flash Cache
Oracle11g smart flash cache is a performance enhancing feature that can speed application data access by several fold. This presentation will show the steps to optimize memory settings and utilize flash cache to its fullest advantage. The session will cover the various optimization parameters to configure memory optimally and the settings needed for use with smart flash cache. The session will also discuss the differences between Exadata flash cache and smart flash cache.
With the constant increase in cyber attacks and notable breaches of data from large organizations including Sony, is your MySQL data safe? What are the best practices for securing and administering your MySQL environment, especially a public facing Web presence? This presentation will cover the essential steps for better MySQL security including necessary and critical installation improvements in user, file, and data management. Also detailed are the administration tasks and auditing options necessary to ensure your data is managed and protected from both external and internal threats.
How Cloud Computing will Change your Career, Life, and Bedtime Routine
Sorry Larry, Cloud isn't going away! Just because your virtualizing, doesn't mean you have Cloud, but it is a good step forward. This session will ensure you understand the fundamental concepts are more than just hosting and virtualization. What are the benefits of Public Cloud that make it 10x more compelling than Private Cloud? Ah, but this stuff is not so easy that any caveman can do it. There are risks, challenges, myths, and obstacles (and how to overcome them) that this session will cover. How is Oracle doing with Cloud? The session will cover the good, the bad, the ugly. The session will also cover practical approaches to implementing a Cloud project, both as a Cloud provider or a Cloud consumer—in other words a methodology for “entering the Cloud.”
How to Avoid a Spaghetti Architecture with Oracle SOA
Ninety percent of Oracle SOA projects result in spaghetti architectures that are difficult to change, have little agility, and are risky for the enterprise. This session will cover specific frameworks to avoid such enterprise pasta and mitigate risk of non-agile or non-flexibile services. Specific agenda includes: -- How to leverage SOA Frameworks that include mediation, separation of concerns, and object modeling so that your Oracle SOA environment achieves true loose coupling. -- How to use Service Contracts, Taxonomies, and Service Repositories for better agility, flexibility, and service re-use across the enterprise. -- How to build services so that they can change rapidly without changing a lot of source code.
This presentation will attempt, in sixty minutes or less, to outline the approach the Department of Defense uses to secure and evaluate its systems, focusing of Oracle database systems. It will attempt to do this without reducing the audience to a drooling mass of bored over acronymated and security lobotomized morons. It will give them some reasons as to why they might care whether their databases are secure, or at least why the government seems to care. It will review emerging trends in how the government approaches security. Finally, it will review the script tools that they can use to evaluate their Oracle security lockdowns and where they can get these tools.
Oracle ADF Mobile Application Development with Demo
Oracle JDeveloper has mobile extensions for rapid application development for on-device mobile client or mobile browser. Learn about ADF Mobile extensions plus see a mobile banking sample demonstration. In October 2011, Oracle previewed next generation ADF Mobile at OpenWorld.
In past versions of Hyperion, moving and upgrading applications was a monumental task requiring specialized consulting skills. With the maturity of Life Cycle Management, Hyperion administrators can now perform once complex migration tasks with only a few clicks. The Life Cycle Management tool has completely rewritten the book on how to perform migrations and upgrades. However, there is still a learning curve preventing most administrators from fully utilizing the tool. This presentation will demonstrate LCM best practices for migrating Hyperion Planning, Essbase, Financial Management, and Reporting and Analysis while maintaining security and provisioning. It will also discuss using the command line LCM tool to aid in Disaster Recovery.
In Agile project management methodologies, user stories describe desired content and functionality delivered and verified in a short amount of time. But traditional data warehouse projects struggle to deliver completed user stories due to the complexity of the intermingled moving parts: data modeling, ETL, front-end development, and a QA process that needs to validate the data from source to target. Combining the logical modeling capabilities of OBIEE 11g, the brute force of the Oracle Exadata Database Machine, and the “Smart”-ness of Oracle Exadata Storage provides the power and flexibility to drive the completion of user stories within the standard timeframes demanded by Agile projects.
Loading data is a common APEX Web application task, and there are many ways to do it, most of which involve user cut/paste and/or custom coding. This presentation reviews several ways to load data in APEX; the common, the not-so-common, the new Data Load wizard, and the APEX Listener XLS upload feature. What are the APEX data load options? What are the costs involved in each? What's the best way to load data via APEX? What makes most sense for your users, for your environment, for your budget? This session will review and demonstrate each data load option and list the pros and cons of each. You will leave with enough information to make an intelligent choice for your data load needs.
Planning Your Oracle E-Business Suite Upgrade from Release 11i to 12.1 and Beyond
Are you still on Release 11i deciding what to do next? Are you looking for the key planning considerations around an upgrade to Release 12.1 and beyond? Attend this session to learn about the latest upgrade planning tips gathered from customers who have already done the project, as well as from Oracle's support, consulting, development and IT organizations. You'll get specific, cross-product advice to help you establish the target release, identify factors that affect time and resources, decide between an upgrade and a reimplementation, manage custom code, minimize upgrade downtime, and more. In a nutshell, this session tells you things you need to know before embarking upon your E-Business Suite upgrade project.
During the optimization of a SQL statement, the Optimizer relies heavily on statistics to estimate the number of rows produced by each of the SQL operators. The quality of the statistics for the objects referenced in the statement greatly affects the quality of the plan. Statistics maintenance is a challenge all DBAs must face in order to prevent execution plan from becoming suboptimal. This presentation provides a detailed description of Optimizer statistics and the features introduced in 11g to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling, and when and how to manually set statistics directly versus collecting them.
Since its introduction in Oracle 7, people have been fascinated and intimidated by the cost-based Optimizer and the statistics it relies on. It has long been felt that the internals of the Optimizer were shrouded in mystery and that a degree in wizardry is required to be able to make it do the right thing. This presentation will explain the fundamentals of the cost-based Optimizer and how it has been extended in Oracle Database 11g to address its known limitations. For each of the new features discussed, a detailed explanation will be given on what limitation it will address and how you should take advantage of it in your Oracle Database environment. The session will also include a demonstration of some of the new features.
You have gathered the perfect set of statistics, but you still get a suboptimal execution plan. Why? This presentation will discuss the other factors that influence the Optimizer’s decisions and can prevent you from getting an optimal execution plan. This session will answer questions like, why an index wasn’t used or was used the wrong way, why partition eliminations did not occur, why statistics were ignored, and many more. With clear how-to examples, you will learn to identify and quickly resolve these issues without the necessity of Optimizer hints or initialization parameters.
Dynamic Debugging and Instrumentation of Production PL/SQL
Good software engineering practices apply to all languages, including PL/SQL. Instrumenting your code appropriately is one of these best practices, and yet very few do it. If things go badly in production, you should be able to flip a switch and find the problem within seconds to a few minutes. Attendees will learn how to do this for new and legacy PL/SQL source code using easy-to-learn habits and free logging, debugging, and messaging libraries.
Exadata Customer Case Studies: Key Considerations when Planning and Executing a Complex Database Consolidation
Some database consolidations targeted for an Exadata machine can be quite complex and need careful planning to mitigate perceived (and real) project risk in order to achieve the client’s expectations and Exadata’s promise.This presentation will examine several important deployment considerations through the lens of real world customer experiences.
Complex Database Consolidations and Exadata Sizing– Each database has its own workload profile and resource consumption pattern. When several or many databases are combined and consolidated onto a single platform, the complex interactions and resource utilizations must be accounted for when sizing an Exadata environment.
Although it has been a part of the Oracle Database since its introduction in Oracle 8i, the Database Resource Manager is often overlooked as a means for achieving optimum performance from databases that experience peak loads, workload resource contention, and similar issues resulting from multiple, possibly conflicting tasks. This presentation introduces the Database Resource Manager and focuses particularly on when and how to implement it on an Oracle Database. Topics covered include planning for a Resource Manager implementation, defining and installing resource plans, defining resource consumer groups, and monitoring the Resource Manager as well as its effect on the operating environment. Explanation of what resources can be managed, along with real-life examples, is provided. Instance caging is explained. Actual case studies and benchmarks are provided, to demonstrate the level of performance benefit that can be expected when using the Resource Manager on systems ranging from small, Windows-based systems all the way up to Exadata clusters. Brief explanation of the interaction of Database Resource Manager with other components is planned, including the Database Scheduler, operating system resource controls, and the Exadata I/O Resource Manager. Learn about Resource Manager and how it can help you automate workload management and improve service levels.
This presentation provides case studies demonstrating problems that occurred because a system had too much memory, too many CPUs and too much storage for the workload at hand. The solutions to these problems -- none of which involved removing the ample resources -- are also presented.
Find out more about some of the new cloning technologies available in Oracle 11g. The presentation will demonstrate using snapshot standby, Active Data Guard, Clonedb, and Edition Based Redefinition to clone databases. Utilizing these features will allow IT departments leverage cloning methods that previous to 11g required 3rd party software of expensive storage technology.
Making Business Process Mapping a Cost Reduction Center
This presentation discusses essential components of business process evaluation, mapping, and documentation and follows case studies from both the financial and medical industries.
Implementing MapReduce Algorithms in SQL and PL/SQL
Many new large-scale data analysis tasks are being described using MapReduce as an implementation language. These descriptions imply that you need Hadoop and HDFS in order to fully exploit the power of MapReduce. However, since MapReduce simply describes implementation primitives, it is actually possible to implement those concepts using SQL and PL/SQL. Doing so will help database engineers more fully understand the underlying data processing activities behind typical large-scale data analysis tasks. In this presentation, database developers will learn about how to use parallel pipelined PL/SQL table functions to build MapReduce-like capabilities in the Oracle Database.
The ability to bring in content from multiple disparate sources into a single view is an age old requirement for many, if not all organizations. The problem of providing timely and relevant business intelligence reports to users is almost as old. It's often an expensive undertaking to ensure reports are executed and made available to users in a palatable format. This usually requires specialized reporting tool and Web development knowledge. It's a huge burden for IT departments to try and satisfy the ever increasing thirst from the business for information. With the release of Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5 and the out of the box integration (with some configuration) with Oracle Web Center, organizations can now allow their users to pick and choose the reports they want to see in a straightforward, user friendly environment while still enforcing security over said reports and their content. This presentation will provide an overview of OBIEE and WebCenter functionality; demonstrating report and page building. Attendees will also see the configuration of the product integration and how report content can be embedded into WebCenter pages. Then how users can interact with the embedded reports in terms of drill down, across, and even editing from the WebCenter interface.
Oracle's flagship operational reporting tool, BI Publisher, can handle almost any task you throw at it. The regular stuff, it can do in its sleep be that a simple listing report, a letter, or a financial statement. How about going beyond the mundane and generating something more sophisticated? Dare I say, something more 'exciting'? Creating an automated consolidated budget book, pulling data and documents from multiple sources? Integrating a dynamic map image into the output? Delivering a document via an e-mail and dropping a copy into a document repository at the same time? How about generating a multi sheet Excel output with conditional formatting? Or producing 100,000 invoices, printing them, and shipping them out of the system to customers with a click? It can all be done with Publisher and its not that tough either. This session will cover some of the more advanced Publisher techniques and demonstrate how broad a set of capabilities Publisher has. Packed full of demonstrations and not too many slides, you'll learn tips, tricks, and techniques to build the report of your users' dreams taking you beyond the listing report.
Oracle Database 11g for Big Data: Foundation, Strategy, and Roadmap
Analyzing new and diverse digital data streams can reveal new sources of economic value, provide fresh insights into customer behavior, and identify market trends early on. But this influx of new data can create challenges for IT departments. To derive real business value from Big Data, you need the right tools to capture and organize a wide variety of data types from different sources, and to be able to easily analyze it within the context of all your enterprise data. Attend this session to learn how Oracle’s end-to-end value chain for Big Data can help you unlock the value of Big Data.
Speed Up Your Data Warehouse with In-memory Parallel Processing
The data warehouse space is always evolving. This session will explore the usage of in-memory technologies to speed up the data warehouse. As of Oracle Database 11g Release 2, Oracle provides transparent technology to leverage the aggregate memory in a clustered system like Exadata Database Machine. You will learn a number of things by joining this session. First you will get a general idea of the benefits of in-memory processing. Second, the session will dive into how to leverage the in-memory parallel processing capabilities of the Oracle Database for a data warehouse workload. The session will look under the hood and explain how and when we use in-memory parallel execution and what the benefits for your system can be.
Need to convert from Discoverer to OBIEE? Are your views truly ready for R12 or Fusion? Having performance issues? Is security being enforced or is it simulated? Having to customize your views? In this session, you will learn what options are out there that can replace Discoverer, see how you can use OBIEE for detailed transactional reporting, and see how EiS can convert your existing Discoverer reports AUTOMATICALLY!
R12 and Sub-ledger Reconciliation – Using Reporting Effectively to Make Month End Less Complicated
Just when you thought you had sub-ledger reconciliations figured out, R12 comes along. See the changes in R12 that will impact your reconciliations and how you can use a few reports to make the transition much easier.
Beyond Discoverer - So What Are Your Options with OBIEE?
Is there reporting after Discoverer? Are OBIEE and BI Apps really there for strategic reporting only? You can simply and easily use OBI and BI Server for detailed transactional reporting and replace Discoverer. Perhaps even converting your existing Discoverer reports AUTOMATICALLY!! Come along to this session and see just how easy it is to protect your investment in OBI.
Leveraging the Full Power of the Oracle XML DB Repository
This session will provide a detailed overview of the Oracle XML DB repository. It will show how the repository provides a powerful, flexible platform for managing XML and other forms of content and how to access content stored in the repository using industry standard protocols such as HTTP and WebDAV, as well as via SQL. The session will show how Access Control lists enforce security, and how to interface the repository with externally defined user communities. The session will demonstrate using Repository Events to store content in user schemas. Finally, the session will introduce two interoperable Content Management applications, one built with AJAX and XSL, the other with APEX, and a solution for performing file level backup and restore operations.
Customer Case Study: Real World Tuning an EBS Oracle Application Stack
This session will begin by introducing a customer and discussing how Datavail has solved one of their real-world database problems. The technology of Oracle's latest middle tier architecture often finds itself outside the skill set of a typical application DBA. This presentation will show real world EBS issues and highlight the methodology and tools used to find and fix them.
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. 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. This presentation is not rocket science but describes a vastly underutilized technique that is often easily implemented.
Certain operations, like lookup lists, 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? Periodically physically ordering all the data you have in the best possible order for the queries you expect to run on the data is silly. A periodic partial physical ordering of some data is not silly if it reduces overall costs and trades slack time work for improved runtime response. So far selective reordering has served my employers and clients well when it is the right thing to do in releases from 4.something through 11g of Oracle. The heart of the matter is that Oracle stores rows in blocks. When you run a query, what you want are the right rows. The fewer blocks you need to retrieve a read consistent image of in order to get the columns you want of the rows you want, the less it costs per row.
Safeguard Sensitive Data in EBS: A Look at Oracle Database Vault, Transparent Data Encryption, and Data Masking
Oracle E-Business Suite contains financial, operational, and human resource data that is vital to an organization. Organizations invest heavily to step up security against external threats, whereas protection against internal security threats is often less rigorous. This presentation examines three Oracle security offerings -- Database Vault, Transparent Data Encryption, and Data Masking -- that can be deployed in an Oracle E-Business Suite environment to protect against internal threats. Attendees will learn about the applicability and strengths of these tools, and their impact on common EBS administration tasks.
Exadata I/O Resource Manager - Ideal Technology for Database Consolidation
Resource management is the key to effective consolidation of multiple applications. Prior to Oracle Exadata Database Machine, there was no way to manage the highest-contention database resource: I/O capacity. In this session, discover how I/O Resource Management (IORM) is designed to allow a high-concurrency consolidated system to achieve predictable response times, even during peak usage.
Peering Through the Cloud: The Straight Goods on Oracle Exalogic
Oracle Exalogic promises an application platform that's scalable, reliable, and extremely fast. This technical deep dive will dissect the components of the Oracle Exalogic Elastic Computing Cloud and find out how the high-band with low-latency interconnect and dense compute server hardware work together with Oracle JRockit, Oracle WebLogic Server, and Oracle Exalogic cloud management software. Find out which types of applications benefit most and least from Oracle Exalogic. Learn about how Oracle Exalogic's cloud security and management infrastructure helps to efficiently share common resources in private cloud deployments.
Develop Mobile Apps Smartphones and Tablets: Converging Web and Native Applications
With the rapid advancement of mobile operating systems, developers can now use a variety of Web-based or device-native techniques to create compelling mobile applications to meet the demands of enterprise mobile users. However, to create mobile enterprise applications that support the mobile devices commonly found in enterprises today, developers basically have to develop the same application several times, using multiple tools, languages, and platforms. This session discusses how Oracle Application Development Framework and Oracle JDeveloper bring together Web and device-native technologies into a common and consistent development environment and deliver consistent and powerful composite mobile applications to end users.
Send/Receive "Shared-table" Events in Remotely Located JVMs
This presentation is geared towards experienced developers. It will show an efficient way to communicate db changes (DML) that occur to POJOs (DML) in one JVM and propagate the event to another JVM over JDBC connections. For example, application A does an insert to a "shared table" that application B is interested in receiving notification on. Upon commit, application B will be notified by the underlying AQ messaging subsystem from an insert event generated in application A and vice-versa. Hibernate's notification system is the source of these events that can be leveraged to propagate the event over Oracle Streams AQ using PL/SQL procedures and JDBC.
Data Replication and Protection Options - You Have More Than You Think!
In the old days, the DBA defined a requirement, then implemented the feature that provided that need. Today, many Oracle features have become so capable that determining which feature to implement has become almost as difficult as defining the requirement. This presentation will present the current options for data protection and replication. Different options are discussed in the context of how they replicate data and the protections and capabilities they provide. The discussion will cover physical and logical standbys, basic and advanced replication, and a couple of non-Oracle products. This presentation will provide the DBA with a set of tools and the knowledge of how to use each tool to protect and/or replicate their data.
Fact or Fallacy: Finding the Truth of Query Performance Problems
This presentation will use dba_hist views or Statspack views along with some statistical methods to determine if a query is experiencing performance degradation and timing of the degradation. Just as important, the session will answer the question of whether the degradation is anomalous.
To RAC or not to RAC: Evaluating Database Resiliency Alternatives
Many DBAs are faced with the question, “How do I make my database more resilient and incur less downtime each year? What are the available database options for High Availability (HA) and Disaster Recovery (DR) to satisfy my company’s specific yet growing business requirements?” This session is designed to walk a DBA through a step-by-step evaluation process where questions will be answered from start to finish.
Many times while developing APEX applications, you find yourself solving a problem and implementing the solution over and over. The APEX 4 plugin architecture gives you the tools to encapsulate the solution and reuse it. This presentation takes the requirement of presenting multiple SparkLine charts on a page and walks the attendee through the steps of implementing a plugin to encapsulate all the logic so that it can be reused with very little effort. Attendees will walk away with a better understanding of the process of creating a plugin from scratch.
Have you been told in classes and presentations for RAC, 'If an application runs well it will run will in RAC'? As we all either know or are finding out, this is not always the case. This presentation will focus on performance tuning tips specifically for a RAC environment. The session will dive into the 'normal' waits and how they can be different for RAC or incomplete, gc wait events - what they are and how to tune, patching recommendations, and general RAC recommendations to ensure you have the best running system you can.
As data volumes are growing exponentially these days, databases need to process more and more data in shorter amounts of time. Many disruptive technologies have also emerged such as flash-based storage, large server memory footprint, InfiniBand, etc. In such a rapidly changing environment, storage I/O performance tuning and planning easily becomes the task of applying best practices and "black magic" rules. In order to adopt a more sound, scientific approach to I/O performance diagnostics and planning, one needs to master the foundation - measuring I/O performance. This is exactly the focus of this presentation - practical I/O performance measurement and planning.
Many production engineers are facing the need to manage heterogeneous environments, making a complete monitoring solution a critical component of today's enterprise IT operations. Oracle Enterprise Manager provides end-to-end management for business applications, with plug-ins extending its management capabilities to an expanding variety of products. Free MySQL plug-in for Oracle Grid Control from Pythian has provided monitoring functionality for MySQL for years, but with the release of Oracle Cloud Control 12c, plug-ins can now become much more powerful and provide true management capabilities instead of plain monitoring. In this session, you will learn everything you need to monitor your MySQL database using your Oracle Enterprise Manager environment.
Arthur C. Clarke wrote that "any sufficiently advanced technology is indistinguishable from magic." That is true, and it sometimes makes troubleshooting seem like art. But it is not art; it is process—and this presentation uses a case study, such as resolving the ORA-03136 "connection lost" error, to demonstrate that process and to show how components such as ASH, typically thought of as performance tuning tools, are also useful diagnostic tools. Attendees will learn a forensic, empirical approach to troubleshooting and see a demonstration of a complex troubleshooting task resulting in a nonintuitive but empirically sound resolution.
Scaling to Infinity: Partitioning Data Warehouses on Oracle
Star schemas (a.k.a. dimensional data models) are demanded by BI analysts in data marts and data warehouses. Star transformations are the optimal join method to access star schemas in Oracle. Bitmap indexes are required by the star transformation process, but bitmap indexes quickly become literally infeasible without partitioning. Why isn't this documented? How do all these crucial pieces fit together? Find out what major features of Oracle Database are enabled by partitioning, as well as 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 and painfully gained understanding of data warehousing realities. It provides straight answers to help you utilize Oracle Database features to ensure data warehousing success.
Oracle XML Database - Design Concepts for XML Applications that Will Perform!
The relational world has a lot of best practices regarding coding applications and its design. Most of these best practices will not work while dealing with XML data or applying these principles in XML architectures. XML data on disk is very often ten to one hundred times faster than handling XML in memory. Why does this work and what are the principles behind this? This presentation will demonstrate and explain methods to make your XML application perform.
XML Indexing Strategies: Choosing the Right Index for the Right Job
The XML format has been defined and a choice has been made to store it in an XMLType format. Now it all comes down to choosing the right index to support your queries...but which index do you choose and based on which criteria? This presentation will explain advantages and disadvantages regarding using B-Tree, IOT's, XMLIndex, or Text Domain Indexes.
Using Oracle Execution Plans for Performance Gains
This presentation will discuss the different operators found in an execution plan, and how they consume resources. It will demonstrate the best methods for collecting execution plans, describe how to interpret them, and provide tips on tuning them for best performance.
In a rapidly changing software and technology environment, it’s important to know what Oracle licenses your company already owns; if your company is licensed properly; if you have adequate licenses for all of your environments; if there are any limitations to your licenses; how Oracle licensing influences your business and applications; and how well your existing licensing positions you for future growth. As Oracle continues to grow and acquire new products, it becomes increasingly important to be able to understand the cost and maintenance implications for the various products, product versions, virtualization, and hardware associated with these products. Find out more about how to keep an eye on your licensing and how to optimize when you are buying Oracle products. The presentation covers different product versions, license types, options, and terms that will help to develop an understanding of Oracle licensing and maintenance policies.
Are you one of the many Oracle customers that had UPK bundled with your ERP applications or latest upgrades? Learn how to take advantage of this highly robust eLearning authoring tool! Three key concepts of the session are: understanding the key elements of UPK Developer and Player outputs; learning how to build a training portal with different types of end user performance support programs that meet the needs of a variety of end users - novice to experienced super user; and how to use UPK during an ERP project lifecycle to support other project needs – requirements gathering, user scenarios, and testing.
Making the Most of Solid State Disk in the Oracle RDBMS
Solid State Disk (SSD) is rapidly becoming a mainstream technology and an almost indispensable ingredient in a high performance Oracle database. While SSD is often too expensive to replace all your database disk, judicial use of SSD in combination with magnetic disk can be a very cost effective way of accelerating Oracle database performance. This presentation will consider how best to use SSD in an Oracle 11g database to get the most bang for your SSD buck. You'll see examples of configuring SSD:
• as part of the 11gR2 database flash cache
• to improve IO for selected tables or partitions
• as part of a temporary tablespace to improve disk sort performance
• to accelerate redo log IO
• inside an Exadata system
Hadoop and Exadata are competing solutions to the increasingly contested world of "big data" management. This presentation will look at the business drivers behind the big data buzz, and look at the architectural solutions presented by each technology. The session will then look at options for using the two technologies to best effect and how Hadoop and Oracle - particularly Exadata - can inter-operate.
One morning somebody comes to your (database designer's) office saying "Dude, where's my database?". You ask questions and questions and finally realize, he/she has designed the application with UML and now he/she is wondering where to find the database (for coding the data classes). OK, the class diagram looks great (with UML colors and everything), but is that the database model? Did this person know how to design a database? Is designing the database the same thing as designing the application? And then you realize that they only have the analysis for their first increment and the class diagram is only for that. Is this project going to be a success? And where is the database?
Designing the database is still extremely important, even in agile projects. In this presentation, Heli will try to give some advice and important points on database design, especially if the project is agile and the final goal might be known only in the end of the project. The presentation is for all levels and all IT profiles including DBAs, developers, database designers, project managers,...anybody who is interested in database designing.
Performance management is a time-consuming and dreary activity in most organizations, but at DORA, we make it sexy. From soup to nuts, all performance planning, signatures, progress reviews, and evaluations are done entirely online. The face-to-face reviews are not, of course, but even those are facilitated by the electronic nature of the application. Built entirely in PL/SQL and JavaScript, DORA Performance Management is one of the very first unified apps to be offered statewide following the IT integration. Because of its versatility and usefulness, departments across the state are clamoring to be the next to use it, and rolling it out for each department takes only a couple of days. The rewards in time, space, and employee angst are enormous and makes every organization more efficient and capable.
Performance management is a time-consuming and dreary activity in most organizations, but at DORA, we make it sexy. From soup to nuts, all performance planning, signatures, progress reviews, and evaluations are done entirely online. The face-to-face reviews are not, of course, but even those are facilitated by the electronic nature of the application. Built entirely in PL/SQL and JavaScript, DORA Performance Management is one of the very first unified apps to be offered statewide following the IT integration. Because of its versatility and usefulness, departments across the state are clamoring to be the next to use it, and rolling it out for each department takes only a couple of days. The rewards in time, space, and employee angst are enormous and makes every organization more efficient and capable.
ADF Techniques from Oracle Fusion Applications Development
Oracle has just released its Fusion Applications – the next generation of Oracle Applications built with ADF and the Fusion technology stack. Come take a look at some of the UI design patterns used in the Fusion Applications, and examine how those design patterns were implemented using ADF. This presentation will be looking in depth at BC components, application module methods, managed beans, JSFF source code, and other features of JDeveloper.
This is a live-demo presentation of various tools and features of the Oracle10 and 11 databases. The presenter is an experienced trainer and will demonstrate a variety of these features using tools like TOAD and SQL*Plus. The attendee will gain valuable insights as to the many features of Oracle.
This hands-on course is aimed at the Oracle professional who wishes to increase their productivity by utilizing Toad. This half-day course will cover Toad for Oracle setup/options, Editor, Schema Browser, short cuts/templates/snippets/insights/SQL History, creating scripts, accessing/changing data, using Fast Reports, and additional features. Please bring your own laptop computer with Oracle RDBMS and the Toad products installed and ready to go. Power will be available at each seat. Free Software: Oracle11g Express download: http://www.oracle.com/technology/products/database/xe/index.html Toad download: http://toadfororacle.com/index.jspa trial or freeware Any questions…please contact Dan Hotka (Instructor) at Dhotka@earthlink.net
The Lean Software Startup and the Salesforce.com Platform
This presentation will show how the lean software startup can leverage the salesforce.com cloud platform to build full feature enterprise software applications at a fraction of the time and costs of traditional development. This introductory of the salesforce.com development platform terminologies and features, will focus on how to design and implement a minimum viable product or MVP. Unlike a prototype, an MVP is designed not to address design or technical issues, but to provide the base functionality to validate the business model by quickly building a complete set of base functionality that can be presented to potential customers for immediate feedback without investing large amounts of resources into a product that may not have a market. In some cases, MVPs address such a compelling need they go directly to products i.e. Craigslist. By leveraging the salesforce.com development platform, an MVP can be completed in a matter of days with little to no development resources. This session will cover the steps necessary to build an MVP in salesforce.com, including creating data objects, work flows, Web forms, dashboards, customer Web site, and iPad and iPhone applications.
There is no longer any reason not to be experimenting with using SOA Suite with E-Business Suite. Each new version of E-Business Suite has made it easier, and virtual machines have made installation of a working SOA Suite environment as easy as pushing a few buttons. Some easy network setup and they are connected and you can be building your first SOA process. This presentation will show you how to accomplish the setup in two hours and demonstrate the creation of an SOA process integrated with E-Business Suite.
Things Developers Wish Managers Knew and Managers Wish Developers Knew
The following observation has been in print longer than many current developers have been alive: “In many ways, managing a large computer programming project is like managing any other large undertaking -- in more ways than most programmers believe. But in many other ways it is different -- in more ways than most professional managers expect.” (Preface to First Edition of The Mythical Man-Month (1975)). Yet in all the time that this has been in print, knowledge of this basic truth does not seem to have changed the software industry very much, even as an entire generation of developers grew into the role of professional manager. This presentation is about things that developers wish managers knew and vice versa. It will present a chance to examine the challenges that both developers and managers face and the way they look to the other side. Observations in the discussion will include: • Myths about the value of code reuse • The limitations and blind spots of both managers and developers • Job-related training and who should pay for it • Corporate memory, the effects of a down economy, and what it means for both developers and managers. The goal of the presentation is to introduce observations from both points of view and to provide insights as to how each side thinks about an issue. It will discuss why events often do not unfold in an intuitive manner and share some lessons learned from both sides of the development/management aisle.
OMG! Identifying and Refactoring Common SQL Performance Anti-patterns
Large, complex Oracle applications typically have many moving parts and utilize a wide range of Oracle functionality. Such systems are prone to seemingly random performance issues, often under high loads, but other times without obvious reasons. This presentation will offer an eclectic mix of such problems, giving the attendee both the means of identifying and fixing them. Topics include SQL query and PL/SQL performance anti-patterns, Oracle Advance Queuing performance issues, Global Temporary Tables, RAC, database links, and more. Identification techniques will include inspection, use of AWR reports, and general access to V$/GV$ views. Fixes will range from code refactoring to setting init.ora parameters.
In this session, you will learn how to override the ADF Business Component Java classes to customize behavior to fit your needs, focusing on Application Modules. The session will start by creating updatable View Objects and placing the View Object instances in an Application Module. The session will then modify the Application Module Java classes, adding a few custom methods we want to expose to clients. After exposing the methods as data controls, the session will then use them within the JSF page. The session will discuss the bindings created, as well as what happens behind the scenes.
Getting Started with .NET and Oracle Database and What's New
This session introduces how .NET programmers can start building applications for Oracle databases. It discusses how to query and modify their Oracle databases using Visual Studio, plus query and modify data via ADO.NET. The session will highlight new and planned Oracle .NET features, including Entity Framework, LINQ, fully-managed ODP.NET, self-tuning, and Oracle Performance Analyzer. Step-by step demonstrations will illustrate these concepts.
Active Directory and Windows Security Integration with Oracle Database
This session conducts software demonstrations to show how easily Oracle Database integrates directly with Microsoft Active Directory to simplify name resolution and single sign-on and perform user and role management. With Oracle Identity Management, administrators can further centralize end-to-end lifecycle management of user identities across all resources, including Active Directory. The presentation explores these topics as well as Oracle Database integration with native Windows security.
Oracle Forms is a strong and viable product with years of future left. However, Oracle has “bet the farm” on the success of Fusion; Oracle’s rewrite of its Application stack using Java EE and Service-Oriented Architecture. A key tool in this development effort has been the JDeveloper tool and the Oracle Application Development Framework (ADF). Forms Developers wanting to “catch the new wave” are interested in adding JDeveloper and ADF to their repertoire. JDeveloper has come a long way from the tool that crashed during every Oracle demo session and has become a robust development tool for Java and more. ADF likewise has become a useful application development tool that is reminiscent of the simplicity of developing with Oracle Forms (reminiscent; still not all the way there, but much closer…). ADF provides graphic and declarative mechanisms used to develop data-based applications where most “grunt work” code is generated by the tools and actual coding is limited compared to normal Java EE development. This session will illustrate the ease with which Oracle Forms Developers can use JDeveloper and ADF can be used to create Java-based Web applications.
Oracle 11g for Developers: What You Need to Know or Oracle 11g New Features for Developers
Attendees are introduced to the new and improved features of Oracle 11g (both Oracle 11g R1 and Oracle 11g R2) that directly impact application development. Special emphasis is placed on features that reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: New SQL functions, virtual columns, result caching, XML improvements, pivot statements, JDBC improvements, and PL/SQL enhancements such as compound triggers.
Oracle WLS Application Security: Implementing the Superstition in JDeveloper
Web applications are usually open to a wide user base, so application security plays a very important role. Oracle WebLogic Server, a Java EE runtime container, provides Oracle Platform Security Services that enable developers to use standard Java security libraries to implement access control in their applications. This session explains application security concerns and techniques and discusses and demonstrates how to set up security support for Java EE and ADF Web applications. It also discusses how to store user credentials, tap into existing Lightweight Directory Access Protocol (LDAP) credentials stores, and set up security hooks in your application.
Deploying Applications to WebLogic Server Using JDeveloper and WLS Console
After developing and testing a Java Web application, you need to deploy it -- make it available to users. Deploying a Java EE 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. The Oracle WebLogic Server (WLS, formerly, Oracle Containers for Java EE--OC4J) is a standard Java EE runtime process to which you deploy Java-based applications for use in a Web runtime environment. This presentation explores the process of deploying to an Oracle WebLogic Server container. It outlines JDeveloper utilities and profiles that help you create an EAR file with all required libraries. The presentation then explains how to deploy the application using JDeveloper. It also discusses the benefits of, and techniques for, testing deployment on a local standalone server. In addition, the presentation describes and demonstrates the deployment services of the WLS Console and why you might choose it to deploy an application instead of using JDeveloper.
Using SQL Developer to Define and Deploy Your Data Models
This presentation will outline practical guidelines for the use of Oracle SQL Developer, and tips and tricks for getting the most out of it as a development, analysis, and database maintenance. In addition, this session will present an overview of key functionality and how Oracle SQL Developer integrates with other Oracle products and tools providing you with a development console.
An introduction to MySQL. Agenda includes: Oracle's Investment into MySQL, a high-level overview, familiarity with the key concepts, MySQL Authorization, Community, and Enterprise Editions along with Oracle integrations into other Oracle products.
High-Performance SQL Applications Using In-Memory Database Technology
This session provides a technical discussion and demonstration of Oracle TimesTen In-Memory Database and Oracle In-Memory Database Cache product capabilities. Learn how to use standard SQL and database APIs such as JDBC, ODBC, .NET, OCI, Pro*C, and PL/SQL to dramatically improve application response time and throughput. The presentation shows how to effectively extend an application to scale out transaction throughput and the effective size of cached data using an in-memory database cache grid. This session is ideal for database developers requiring maximum performance for new and existing applications, using well-understood and widely used database APIs.
Before you can write the SQL for multi-table joins, it is a good idea to be aware of the many access paths the optimizer can choose to access a single table. Given a simple heap table with two B-tree indexes, this presenter can think of twenty-three different possible execution plans that the optimizer might be able to produce, depending on the index definitions and the available statistics. The presenter can come up with a further sixty-six by applying a single strategy for rewriting the SQL. This presentation will look at a few of the less well-known options, and then show how to extend the range of possibilities by building on the examples supplied by Oracle.
The optimizer is very good at transforming your query into something that you didn't write; sometimes, though, Oracle's transformation is a bad idea; sometimes you can transform a query manually in ways that the optimizer cannot. This presentation examines a single, fairly simple query to see how many different things we can do to make it more efficient, using strategies which the optimizer, at present, may not consider. The review will consider the effects of changing the SQL and changing the indexes.
There are many different table access paths available to the Oracle optimizer, and many different transformations it can use to rewrite your query to allow for a more efficient join strategy. Nevertheless, there are things that the optimizer simply cannot do that human ingenuity can produce through careful engineering of SQL. If you are allowed to change the SQL, but are under pressure to leave the indexing untouched, there are various ways in which you can maximize the benefit you can get from the indexes - if you are prepared to work at the SQL. This presentation demonstrates how to do a star transformation on Standard Edition - in the complete absence of bitmap indexes. The presentation also looks at an example of running a data warehouse query as efficiently as possible on an OLTP schema. This presentation builds on the basis provided by "Single Table Access Paths" and "Optimizing a Two-table Join."
Thinking about Fusion Applications and What it Tells Us about Our Own Organization
They are finally here, and people want to see them. You will like Fusion Apps, but the business benefits for moving probably don't stack up yet. But you really liked the way it brought everything together. If only you could have that seamless process in your current HR system or your financials close was as slick? Well you can. The technology underpinning Fusion Apps - Fusion Middleware - can give you that in your enterprise. This presentation will look at what is giving you the different experiences in Fusion Apps and discuss how you can leverage it for your benefit.
Tuning Oracle SQL: A Step-by-Step Approach for Tuning SQL in Your Oracle Database
Poor performing SQL is always an issue for database developers and administrators. This presentation will provide a step-by-step approach for tuning SQL in your database. Oracle tools such as explain plan and tkprof tracing will be examined.
This session focuses on R12 upgrade vs. re-implementation considerations and a best practices approach to conducting an impact analysis for an R12 upgrade or re-implementation. The session also presents lessons learned and case studies from recent R12 projects.
JavaFX 2.0: Java in the Rich Internet Application Space
This presentation introduces Oracle Corporation’s JavaFX 2.0 Rich Internet Application (RIA) platform. The presentation covers JavaFX’s history, characteristics, capabilities, limitations and drawbacks, the JavaFX ecosystem, and potential opportunities and risks associated with JavaFX use. Oracle Corporation has invested heavily in development of JavaFX 2.0 and it is likely to be used in multiple products. JavaFX was announced at 2007 JavaOne Conference and was a dominant topic of 2008 JavaOne and 2009 JavaOne. Despite the fanfare, JavaFX adoption was slow among Java developers due to the use of a new scripting language and to problems with the deployment options. Oracle announced at JavaOne 2010 that numerous changes would be made to JavaFX 2.0 to deal with these shortcomings. JavaFX 2.0 is in beta as of this abstract’s writing, and is likely to be out of beta in time for Training Days 2012.
Service Oriented Architecture: How it Works and How to Implement it Successfully
Service Oriented Architecture is a new paradigm for software development that has proven to reduce the interoperability gap for legacy application, and has provided organizations with the ability to create reusable, company-wide Web services. This presentation will present a comparison of alternatives to SOA, explain why SOA is the best option, and will provide SOA best practices for analysis and design on SOA projects.
Configuration Management Database (CMDB): The Good, Bad, and Ugly
First Data Corporation is globally implementing a CMDB with the expected outcome of reducing MTTR, incidents caused by change, costs associated with hardware/software, and increasing service quality. The purpose of this presentation is to describe what is a CMDB, the benefits of a CMDB, impact of a CMDB on IT Service Management (ITSM) including incident, change, problem, and knowledge management; the interaction between a CMDB and IT Asset Management (ITAM); and lessons learned/best practices implementing a CMDB.
Agile methods are now well-established for transactional applications, but their appropriateness for data warehousing projects is still hotly debated. This presentation will outline the strategy that makes incremental data warehousing immanently doable. The presentation will describe how teams can accelerate enterprise data warehousing via three means: 1) Applying the Agile Manifesto to the way we work, fostering an iterative and incremental delivery method. 2) Wrapping this iterative method with newly streamlined versions of core MIS practices, such as requirements management and quality assurance. 3) Leveraging a new generation of data management products, to dramatically reduce the schemas and ETL modules we must build, yielding an Agile data warehousing architecture. When braided together, these three threads yield an Agile Data Warehousing for enterprise-class programs that, in a benchmark project, drove quality defects to zero while increasing programmer productivity by a factor of two.
End-to-End Java: Decide When to Adopt Java in the Database and Best Practices
The first part of this technical session describes: the rationale for Java in the database, its benefits in terms of security, robustness, and scalability; then its architecture, the JIT; the memory manager; how to move Java in the database; how to invoke it; how to extend database capabilities with tons of Java libraries (Lucene, Hadoop, etc). In the second part, you will hear the lessons learned from the largest deployment of a mission-critical application using Java-in-the-database, sustaining several thousands of concurrent users against a single database instance.
This presentation will be a look at some possible techniques to aid in refactoring PL/SQL. Methods for logging and tracing and program structure will be explored.
Real Application Testing - Never Get Caught by Change Again
This presentation will look at Real Application Testing Database Replay and SQL Performance Analyzer and show how these can help you avoid the pitfalls that come with changes, upgrades, hardware replacements, and platform changes.
An Overview of Oracle Spatial and Common ESRI Deployments with the Oracle Database
From complex geocoding engines used to route 911 calls in milliseconds to the navigation systems now commonly found in vehicles and smartphones, our world is becoming increasingly reliant on the data geographic information systems (GIS) contain and provide. Oracle’s Database and Spatial Engine are an ideal platform for a variety of GIS uses. This session will outline the differences between Oracle Locator and Oracle Spatial, the basic data structures of Oracle Spatial, where to find spatial content (both free and paid), and commonly used ESRI tools.
In our increasingly virtualized environments, it's ever more difficult to diagnose application defects—especially performance defects that affect response time or throughput expectations. Runtime diagnosis of defects can be an unbearably complicated problem to solve once the application is sealed up and put into production use. But having excellent runtime diagnostics is surprisingly easy if you design the diagnostic features into the application from its inception, as it is being grown, like you would with any other desired application feature.
Developing and Deploying Extremely Large Databases with Oracle 11gR2
Deploying and managing extremely large databases is an education beyond expectation. Many of the best practices we have all learned and used for smaller databases do not work or cannot be applied in the same way to databases in the hundreds of terabytes to petabyte range. Best practices publicized for general use are often not the best choice. Oracle ACE Director Dan Morgan will present two sessions that summarize a broad range of lessons learned while managing two 400+ TB databases for a very large telecommunications company. Using a combination of slides and SQL*Plus examples, Dan will share a number of trials and tribulations encountered on the journey and the solutions found. The first session will be specific to developer topics and the second to issues that will confront database administrators.
It has been ten years since the publication of the presenter's original Sane SAN whitepaper, and much has changed in the area of high performance database storage. In this major overhaul of the original topics of Sane SAN 2000, the presentation looks at the pros and cons of the various technologies available on the market today, and at approaches that maximize the performance of the storage tier and deliver predictable response times to the database. The session will also look at emerging trends in an attempt to steer new architectures in a direction that is compatible with the imminent paradigm shift in persistent storage driven by solid-state storage.
In this session, you'll learn about the components that make up the Fusion Middleware and Fusion Applications development platform - namely Oracle ADF, Oracle WebCenter, and the Oracle SOA Suite. Learn about the role of each component and how they work together, see a demo of the integrated development available through Oracle JDeveloper, and see the rich runtime experience that you can get for your own application.
Whatever the size or complexity of your team, productivity is key. Advances in application lifecycle management tooling have been invaluable to this in recent years. Attend this session to understand how to capitalize on these advances through JDeveloper's integration with Maven, Hudson, and Team Productivity Center. Learn through practical advice, tips, and demonstrations how to bring the benefits of continuous integration to your team to maximize better and quicker build, deploy, test, integrate, and feedback results, for greater productivity.
Getting the Most Out of Your ADF Application - Integrating ADF with SOA and BPM
A primary benefit of SOA (service-oriented applications) is reusability. If you have ADF business components containing business logic that you'd like to reuse, come to this session to learn how to integrate ADF applications with BPEL processes and BPM task flows. The session will rely heavily on demonstrations to illustrate integration hook points so that you'll be able to easily understand how to extend the usefulness of your organization's ADF applications.
Business Intelligence - Center of Excellence Case Study
Ever seen a Business Intelligence / Data Warehousing project gone haywire? How about doing it right from the start. The case study of a manufacturing company demonstrates the business value of Business Intelligence Center of Excellence (BI CoE) for an Oracle JD Edwards, OBIEE / Oracle DW, and Hyperion EPM shop. Learn the three stages - crawl, walk, and run steps to develop an in-house BI CoE and empower the enterprise to move up the BI Maturity curve. Learn about the process to setup and operate a BI CoE and how to deliver business value in a cost-effective manner.
In this session, attendees will learn about the recently released Oracle Database Appliance and how to make the best use of that for database consolidation and mixed workload environments in mid-sized environments. The speaker will take a deep dive into the appliance and explain its unique features. Attendees will also learn how this differs from Oracle Exadata product.
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. 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 and 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 incorporate customer examples to communicate the full BPM lifecycle, from the problem that needs to be solved, to solution techniques, to a specific implementation. Specifically:
• Introduce BPM, an approach for improving, automating, and optimizing business processes
• 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. Come see when and how BPM and Oracle BPM Suite 11g can help you improve the efficiency, visibility, and agility of your organization.
Real World Oracle ADF: Online Application Improves Patient Care
Oracle Application Development Framework (Oracle ADF) enables developers to build interactive, great-looking, and functional Web applications quickly without writing a great deal of code. The technology is exceptional, but technology for technology sake doesn’t solve real world problems. This case study and demo is about realizing and implementing the vision of a health care provider to improve patient care, and the role ADF had in the success of the application. The needs of the provider placed some demanding requirements on the solution: Short time-to-market, support for remote users, a rich, highly-functional UI, and role-based security. Yet these requirements had to be met on a budget. In addition, to remain a cost-effective solution for smaller agencies, it had to have a low cost to operate. All these requirements were met in a new application called El Perico. A review of the application and a demonstration will be used to exhibit how ADF enables high productivity for developers and users alike. The session will cover:
• The business problem
• Why ADF was chosen
• The role ADF played in the solution
• Lessons learned in developing with ADF and ADF Mobile. This will be followed by a demonstration of the application that is: • Web-based with a rich, functional user interface
• Delivered as a service, i.e., SaaS
• Works the way the users work • Can be delivered to a mobile device
I have a three-page Oracle Report and my users want to get it on the Web. How can I present the data in a cohesive way that makes sense visually but allows the user to see all of the same information? The presentation will take the audience step-by-step through converting the report while discussing possible approaches and demonstrating APEX techniques. Some of the techniques covered will be the capability to show or hide data, popup windows, tooltips, accordions, side-by-side regions, and printing.
The topic of building a generic version of Exadata comes up frequently. The idea is attractive because the hardware components used in Exadata are well-documented and readily available. One of the potential advantages of this approach is the components can be purchased for less than the list price for Exadata. Building it yourself also allows you to modify the hardware specifications as you choose. If you want faster CPUs or more memory, for example, you can make those changes. But is it really possible to reproduce (or come close to) the performance provided by Exadata? This presentation aims to answer that question. The presentation will compare the contribution of the various optimizations provided by the storage software vs. the contribution provided by the hardware components, including covering some scripts for monitoring/measuring Exadata optimizations. An on-line demonstration, which illustrates the features specific to Exadata, will also be included in the presentation.
Fusion Applications: Redefining the Technology Stack
This presentation will outline, in detail, the technological differences between E-Business Suite R11/R12 and Fusion Applications, the benefits realized by this new technology stack, and the skills needed by your organization to effectively implement and exploit these new technologies for your competitive advantage.
Forms to Struts 2, Spring and Hibernate: Value & Gotchas
This presentation outlines the use of Struts 2, Spring, and Hibernate as a target platform for the conversion of Oracle Forms applications. With the acquisition of Sun and Java by Oracle, the utilization of “pure” Java solutions has become a very viable and straightforward alternative for Oracle customers looking to modernize Oracle Forms applications. Unlike Oracle ADF, Struts 2, Spring, and Hibernate provide a more Java-centric approach to application development, allowing a different level of control for programmers than ADF. This presentation reviews the ins and outs of this alternative, using examples and experience from a real-world case study. The presentation will drill into how to leverage aspects of this architecture coming from the world of Forms. Specifically, how UI components, transaction architecture, and business logic components map to Forms. The presentation will also review some lessons learned in conducting a conversion from Forms to Struts/Spring/Hibernate. Lastly, this session will go through a comparison of Oracle ADF 11g and the Struts/Spring/Hibernate architecture and present a high-level comparison. This information will be helpful to users considering either option as a modern end-state for their Forms application. The intent is not to say one is better than the other, but is to provide the attendees with alternatives so that they can have some background to make an informed choice.
Oracle Application Express continues to grow in popularity. APEX 4.1 further extends our capabilities with several new features and enhancements to several existing features. This session will highlight these new features and include demonstrations wherever possible.
A Case Study: Tri-State's Enterprise Data Dictionary
The presentation will discuss team structure, the approach used to develop the data dictionary, and will also discuss how the data dictionary will be used in the execution of Tri-State's strategic IT plan. This presentation will also provide a demonstration of EDDIE, the Oracle APEX application that was developed to enable the enterprise to make effective use of the data dictionary.
An Oracle Warehouse and DSS DBA has numerous tools, some requiring additional licenses, some standard to any environment. When problems arise, often a DBA is expected to, not only identify, but also correct the problem without impact in short order. This presentation goes over a number of common Oracle errors and performance issues, showing what tools, tracing to AWR reports, along with how to utilize these to quickly assess a strategy to address problems when they develop to lessen the challenge to managing these types of environments.
OEM is the standard for most DBAs to monitor and interact with their database environments. This session will go over how to get the most out of Oracle Enterprise Manager by utilizing scripts and code outside of the OMS repository to allow more functionality, better reporting, and enhanced management features. Trouble-shooting issues when they arise will be reviewed during this session as well.
Traditional Oracle application developers and DBAs may be aware of a growing No SQL movement favoring Hadoop/HBase, MongoDB, Cassandra, and the like. But there is also a growing Not Only SQL movement that recognizes the need for both SQL and non-SQL approaches in solving problems, particularly Big Data problems. This talk will outline current trends in No SQL and point to examples of problems that can be more successfully solved with both SQL and non-SQL activities. No knowledge of no SQL databases is assumed. After a general survey of the field, the presentation will examine a series of use cases that highlight the approach.
Spanning the Oracle EBS Reporting Spectrum: Operational to Analytics
Discover how your company can address both real-time operational reporting and analytical (data warehouse) reporting using technology that is quick to implement as part of a cost effective, pre-built solution. This session will cover packaged reporting solutions for versions 11i and Release 12 of Oracle E-Business Suite that leverage existing investments in your current tools, including OBIEE, IBM Cognos, and SAP Business Objects.
The default Oracle storage structure for persisting data is the heap table. As one's data grows, heap tables become very inefficient for queries to return data. Indexes can be used on predicate columns to improve performance. Yet, the indexes may also grow very large. Partitions improve performance by segregating the data into smaller components. Partitioning our data has several benefits: Partition Pruning, Partition Maintenance and Independence, and Better Parallel Execution among them. In addition, to convert an existing heap table into a partitioned object does not require any modification to the application code. This presentation demonstrates the statistical evidence that partitions improve performance of queries (even when indexes cannot be used or created) through the use of the 10053 trace data. Range, hash, and list partitions are contrasted to the same data stored in heap tables. The presentation will show that the CBO treats the partitions as though they were smaller individual tables in the calculation of the costs. The presentation details the cost calculations from the traces to give us an understanding of why the optimizer picks the row source operations that it does, basically the partition scan or the full table scan.
Tired of getting called in the middle of the night because some custom PL/SQL concurrent program in an EBS environment abended with ORA-01403 and nobody has any idea where to go next? As a developer or a DBA, you rub your eyes and say to the angry user, "I don't know what happened...I need to look into it and get back to you." Of course, they want to know how soon. Why go through that when proper logging using FND_FILE could give information they need to help you (and me) resolve the issue quickly! Let's use FND_FILE properly (and yes, it is more work) and may be we can all sleep better because the support staff has what they need to fix the problem.
Joining Forces: How to Successfully Install & Configure Your Clustered WebCenter Environment
There are countless resources documenting the installation and configuration of Oracle WebCenter Spaces and WebLogic Server in a clustered environment. However, few combine these two tasks into one concise document. Users and administrators are given the puzzle pieces, but struggle to connect the components together. This presentation takes the guess-work out of the process and places a direct emphasis on building a step-by-step formula for success. This formula establishes a strong foundation of minimum requirements then forms a set of building blocks that make up the necessary components for a flexible, scalable, and complete WebCenter environment. At the end of this presentation, the Oracle user should have a clear understanding of the WebCenter and WebLogic concepts and how all of the components fit together for a seamless implementation.
Oracle Exalogic and Oracle Exadata—The Benefits Achieved
The SquareTwo Financial (S2F) CTO will present the methodology and results of Oracle Exalogic and Exadata business and technical benefits collected and achieved through a joint partnership started in January 2011. S2F is the first customer to migrate its core business application to the Exalogic and Exadata platform, consisting of an ADF-based Web front end, over 600 SOA processes, WebLogic (WLS) and jRockit, Oracle Internet Directory (OID), and a Data Warehouse. Once the desired results were proven in a three-month trial, development, testing, DR, and production were quickly migrated to two pairs of Exalogic and Exadata platforms. Gain the knowledge from those who have done it!
The Oracle Database Cloud Service gives you the world's leading database, instantly available, which you can use with your choice of development tools. The Database Cloud Service can grow as your needs change. The Database Cloud Service comes with Oracle Application Express, a rapid application development (RAD) tool, full support for Java applications, and a Web service wizard for quickly creating industry standard Web services to access your data.
This presentation will explore the fundamentals of using vSphere for monitoring databases running in a VMware environment. If you are using classic O/S type monitoring tools, you may be getting misleading information. Understand which metrics are important and how to get the data.
Oracle Business Intelligence Deployment and Change Management Best Practices
Once an Oracle Business Intelligence system has been deployed, administrators will need to migrate the system between environments, manage change to the repository and catalog, and place BI objects and metadata under version control. This presentation sets out a best practice approach to Oracle Business Intelligence project lifecycle and change management, using the 11g release and new features such as Oracle WebLogic Server's Administration Console and Scripting Tool, Oracle Enterprise Manager, and new BI features such as repository and catalog patching. It looks at migrating business intelligence and application server artifacts between environments and places this process within the wider context of database and middleware environment management.
The new Oracle Exalytics and accompanying Oracle TimesTen database makes it now possible to provide in-memory analytics on top of an Oracle data warehouse. This session looks at the internals of Exalytics and TimesTen, examines how the new in-memory features work, provides performance figures and benchmarks, and provides guidance on when to use Exalytics on top of an Oracle data warehouse, and OLAP, solution.
Oracle’s acquisition of Hyperion’s Essbase provides powerful analytic and calculation capabilities to Oracle's Business Intelligence Suite. Join us for this presentation where Edward will show you why Essbase is the best multi-dimensional (OLAP) solution for customers. He’ll demonstrate the advanced analytic capabilities, powerful calculation engine, and all of the features and functions of Essbase. With recent Essbase enhancements like Aggregate Storage Databases and XOLAP, the lines are blurring between relational and multi-dimensional storage and traditional relational reporting options. You’ll leave this session with a better understanding of what Essbase can do and when Essbase makes sense (and when it doesn’t) as a solution.
You’ve heard the hype – Oracle Hyperion Planning is THE leading budgeting and forecasting solution in the market. This is enabling technology to reduce your plan cycle time, increase timeliness of information for business decisions, and improve accuracy in forecasts. This session will cover two critical topics: the presenter will review and demonstrate the easy to use features and functions of Hyperion Planning along with its integration capabilities to Oracle’s EPM System and source ERPs. Next this session will show you how to jumpstart your Planning implementation today with reasonable costs and timelines. The presenter will review the preparation steps to get started and how to scope and implement your first phase of Planning. Don’t miss this chance to improve your budgeting and forecasting process!
Oracle Data Integrator for Oracle Warehouse Developers
Oracle Warehouse Builder (OWB) developers starting out with Oracle Data Integrator (ODI) often find what appears to be a similar ELT model to be worryingly different. This presentation aims to describe the points of difference between the familiar OWB mappings and process flows and ODI’s interfaces, procedures, packages, and load plans. As data warehouse developers and DBAs, we know that we need to move data around efficiently, so we will look at ways in which we can optimize the generated code to further imrove performance. In addition to an introduction of the ELT features of ODI, the talk aims to present strategies to move projects from Oracle Warehouse Builder to Oracle Data Integrator.
Oracle 11g: Learning to Love the Automatic Diagnostic Repository
Oracle 11g has introduced a whole new system of collecting diagnostic information, the Automatic Diagnostic Repository, or ADR. Gone are the familiar bdump, cdump, and udump directories, all hail our new XML overlords! Where’s my alert log? And why on earth is it producing so much trace data?!? Like it or not, the ADR is here. It’s time to embrace it with both arms to get the most out of our Oracle Databases. In this session, learn about the core ADR features that every DBA will want to be familiar with, including file locations, retention policies, and using adrci to view alert log information with some helpful filters. You’ll also learn about the Incident Packaging Service (IPS) and go through a live demonstration of IPS for sending problem and incident packages to Oracle Support.
The Cost Based Optimizer (CBO) is getting better and better in each release. However, there are still situations when the prepared execution plan is sub-optimal one. This presentation will discuss the available mechanisms like extended statistics, histograms, selectivity, and cost definitions for PL/SQL functions and packages, system statistics, execution plan stability, SQL profiles, and more. Although the CBO uses some of them automatically, there are many cases when one needs to change that automatics by applying proper values and thus helping the CBO to always produce near-optimal execution plans. The presentation will discuss how one can use the right mechanism for eliminating the performance bottleneck.
RAC background process performance is critical to keep the application performance. This session will demo techniques to review the performance of RAC background processes such as LMS, LMD, LMON, etc. using various statistics and UNIX tools. The presentation will also discuss why certain background processes must run in higher priority to maintain the application performance in RAC.
This session will introduce basic concepts such as cache fusion, conversion to RAC, protocols for interconnect, general architectural overview, GES layer locks, clusterware, etc. The session will also discuss the srvctl command and demo a few of these commands to improve the understanding.
This presentation will start to discuss and demo parallel server allocation, intra, and inter node parallelism aspects. The session will discuss the new parallelism features such as parallel statement queuing, parallel auto dop, and discuss the interaction of those features with RAC. The session will probe a few critical parameters to improve PQ performance in RAC.
NoSQL is a general name for a new type of database—one that throws away the relational model in favor of simplicity and scalability. This presentation aims to give you everything you need to know before adopting a NoSQL solution for your business. This session will review the concepts behind NoSQL databases, which problems it was designed to solve, when does it make sense to use it, and how to do so safely and effectively. The session will focus on Oracle's NoSQL database announced in OpenWorld 2011 and will discuss the algorithms and design patterns it uses to provide high availability and scalability.
Hadoop is an open source framework for distributed data analysis. It is also a major part of Oracle's recently announced Big Data Appliance. This presentation will discuss questions raised by traditional IT organizations as they are trying to move Hadoop from the development lab to the data center: Is Hadoop just another ETL tool? What unique value can Hadoop bring to the business? How does the data in Hadoop fit into data life cycle in the organization? And how can we connect the dots to arrive at a consistent and manageable BI architecture? This presentation is aimed at IT professionals who are interested in moving with their organization toward an era where big data is a strategic advantage.
Enterprise Manager Cloud Control 12c enhances the event functionality of earlier releases by grouping events into incidents. This presentation examines the incident management lifecycle in the latest release of Enterprise Manager, from creation to acknowledgement and resolution. Concepts are introduced in the presentation, then reinforced via live demonstration.
You use the GUI because you want to be productive, right? Do you ever get the feeling you're only really using a small fraction of what the database and SQL Developer have to offer? If so, then you've come to the right place. Stock up on tips guaranteed to save you time, and make your experience with your code and the database much more enjoyable. If you ever write SQL or PL/SQL, then this presentation is for you.
Oracle Application Express is truly an amazing and robust development platform, enabling developers to build applications to meet almost any requirement. But behind the scenes, this sophisticated development tool is quite simple. This session will explore the inner-workings of APEX and describe just what happens when you view or submit a page. The overall intention of discussing APEX at such a low level is to provide APEX developers - beginners and advanced alike - with a better understanding of the environment, which will enable them to build better applications.
Oracle GoldenGate 101: A Newbie's Dive into the Unknown
As Oracle GoldenGate gets more and more implementations world-wide, this presentation will help the uninitiated to understand the basics of the architecture, development, and implementation techniques. The audience will get a comprehensive overview followed by a demo and discussions.
OBIEE11g Clustering and High Availability: Hack Fest
OBIEE11g has made clustering configurations and scale-out very simple and easy. This presentation will look at the different architecture topologies typically found in the enterprise. Looking under the hood, you will find that things haven't changed all that much, but the glue that sticks things together is of quite a different flavour. Digging in to the details you can see some interesting things to hack ...
Bottoms Up! Building Your Enterprise Data Dictionary
This presentation will also provide the benefits gained from an Enterprise Data Dictionary, practical guidelines to start and successfully complete a project, key decision points required, techniques for building and analyzing your enterprise applications and data, and the presentation will define what an Enterprise Data Dictionary deliverable can look like. Attendees will gain an understanding of the overall Enterprise Architecture process and where the Enterprise Data Dictionary development may fit into their own IT strategic plans.
It’s coming! Don’t close your eyes. Face it head on. Ease your worries by attending this walkthrough of an upgrade from Release 11.5.10.2 to Release 12.1.3. The presentation will describe the tried and true tips and techniques when we upgrade – everything from “oops – did you know about these extra patches?” to ways to decrease your downtime. 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 technical upgrade steps with a few functional steps; understanding these steps helps all team members work toward a better upgrade.
Ruby and Oracle. You’re Going to Like the Way it Makes You Code
Ruby is one of many languages, such as Perl, PL/SQL, Pro*C, etc., that provides connectivity and interaction with your Oracle Database. Normally associated with Ruby on Rails, Ruby is also great for writhing standalone database programs. Ruby interacts with ActiveRecord (one of the underlying components of Ruby on Rails) to provide a simple, but elegant, object-oriented, interface to your RDBMS, Oracle in our case. The presenter has used all of the previously mentioned languages for more years that he cares to admit. Based on his experience over the last two years using Ruby with Oracle, he can safely say you might want to consider using Ruby with Oracle. This presentation will show you how, using Ruby and ActiveRecord, to:
• Connect to the database
• Create objects
• Introduce you to the ActiveRecord naming standards and show you how to use your own names if you wish
• Query the database using both SQL and the ActiveRecord methods
• Join tables and complex queries
• Insert, update, and delete data
• Output your results both to the screen and to a file
• Format your results to create both simple and complex reports.
This workshop will be to show people what is new and cool on the technology front. BYOL format - Bring your own laptop, at least 2GB RAM and 20 GB free disk space.
If people do not have a laptop with the pre-reqs they can still watch the demos ask questions and pick up the software.
Oracle High Availability & Disaster Recovery for Cloud Computing
Cloud Computing has taken the IT world by storm and is transforming applications, databases, data centers, and all aspects of computing as we know it. This talk discusses a meaningful strategy and architecture alternatives, on how Oracle High Availability (OHA) and Oracle Disaster Recovery (ODR) can be undertaken, as phased enterprise-wide Cloud Computing initiatives. In the area of OHA, we look beyond Oracle RAC to implement business continuity across data centers in a "geographically-dispersed Cloud." Given the distributed nature of available hardware resources (across data centers) in an enterprise's Cloud, OHA and ODR become that much more challenging and require alternatives.
Hailing Frequencies Open - An Introduction to Oracle Heterogeneous Services
In business today, applications run on multiple platforms, across multiple database systems. You may have your timekeeping application running on Windows with Microsoft SQL Server, yet your payroll system runs on Oracle on Solaris. Perhaps you have some other system using MySQL on Linux. If you need to have your Oracle system talk to both of them, how do you do it? Making Oracle talk to Oracle is easy. How do we make Oracle talk to these alien systems? The answer is Oracle Heterogeneous Services. Learn how to configure Oracle and your other database systems to talk together. Hailing Frequencies Open!
Most decisions are easy and have very little long term consequences. Other decisions are life changing and there is no going back. Picking a technology platform is an example of a tough choice that locks you in for the long term. Project managers often use a decision matrix with numerical score to make process objective and logical. This is essential, but not sufficient. The most sophisticated decision engine is the neural network inside of everyone’s head. It is good at fuzzy logic and pattern recognition, telling us things we can’t see in a two-dimensional decision matrix with a simple numeric score. A honeybee swarm provides a model of how to make a life-changing decision by a network of intelligent beings. If they pick the wrong location for their next home, they won’t make it through the winter. Bees travel a five-mile radius seeking out holes in trees, looking for the perfect home. They return to the swarm and make a group decision. Suddenly, thousands of bees fly together in one swarm to their new hive. This session will present the honey bee method for making important decisions using sophisticated quantitative measurements combined with a group process that has been perfected over millions of years.
For the past ten plus years, users of Oracle Primavera P6 and Contract Management have been using Sybase InfoMaker to create reports. And while InfoMaker has gotten the job done, it has not always been without some cursing and aggravation. Good news is on the way! As part of the move to unify internal technology, Oracle has been expanding the use of its BI Publisher set of reporting applications. It became the standard reporting tool for P6 with the release of version 8, and for version 14 of PCM. In this session, Daniel Williams compares InfoMaker to BI Publisher, and shows how to create a standard set of PCM reports using BI Publisher.
Top 10 Shocking Findings from Blue Gecko’s Oracle Health Checks
So you think you have seen it all. Backups taken from the filesystem without backup mode, default passwords, online redologs on compressed filesystems. These are just the tip of the iceberg. Prepare to be shocked and amazed by this top ten most hideous problems uncovered during health checks of new customers’ Oracle systems. But it’s not all doom and gloom. The presentation also examines how the customer got into the situation, and the best remedies for each of the problems the presenter discovered.
DB Time-based Oracle Performance Tuning: Theory and Practice
The fundamental concept of DB Time was introduced as part of the Server Manageability effort with Oracle 10g. This concept underlies or is significantly used by many of the manageability technologies of the Diagnostic and Tuning packs in both 10g and 11g, including ADDM, SQL Tuning Advisor, Access Advisor, and Enterprise Manager. This session will introduce the abstract theory of DB Time and its time-normalized sibling - Average Active Sessions. The process of performance tuning using DB Time will be discussed and compared with other current methodologies including those based on wait-events and SQL trace. The session will discuss the Active Session History (ASH) technology and its critical relationship to quantifying the expenditure of DB Time in an active system across many dimensions of interest to performance analysts.
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.
Karl Arao, Enkitec
Ronald Bradford, Effective MySQL
Kerry Osborne, Enkitec