Keynote: A New Era of Security Risks for the Modern Enterprise
Amit Jasuja,
Vice President Development
Security & Identity Management Oracle Corporation
New business demands are driving companies to externalize services, integrate with partners, and control the risk of online transactions. But a new wave of security challenges is confronting modern businesses amid a weak economic environment and a tough regulatory landscape. This session will highlight what’s ailing security in the modern enterprise and pinpoint some shortcomings with traditional industry solutions.
Amit Jasuja is responsible for driving Oracle’s go-to-market strategy for its identity management business. This responsibility encompasses product management, security solution development, security standards participation, partner and sales enablement, as well as overseeing development of Oracle’s directory services offerings—including Oracle Internet Directory and Oracle Virtual Directory. Prior to joining Oracle, Amit was vice president, product management at Netegrity. During his five years at Netegrity, his team was responsible for product planning and strategy for the company’s entire product line. A security industry veteran, Amit previously spent nine years at Oracle as director of development for multiple components of the Oracle database, including security.
Back by popular demand! University Sessions
Click
on the links below to view summaries and click on the presenter's name to view their biography.
Aires | Ault | Baer | Baker | Balaji | Bommarito| Brown |
Bruno | Burleson | Callan | Callaway |Caviness | Charlebois | Closson | Cook | Coulam | Cunningham |
Darrah | Dijcks | Dorsey | Fernandez| Fink |
Freeman, C. | Freeman, R. |Garmany | Garrison |Golden | Gorman |
Green |Haisley |
Harper | Hay | Horton l Hotka | Hughes |Iveslatt | Johnson | Katsaris |
Kellner |
King | Koletzke | Kuhn | Kutrovsky | Kyte | Lai | Laird | Lemme | Lilley |Lipowitz | Liu |Lowenthal | Marx l Millsap l Mishek | Morton | Munsinger | Needham
| Nørgaard |Osborn | Ostrowski | Poder | Portugal| Renner | Rosenblum |
Rice | Sauls | Scalzo | Senegacnik | Sengupta | Sewtz |
Shallahamer | Shamsudeen |
Sprowls | Straub | Swing | Trichler |Vaidyanatha | Vansant | Wilton | Wimsatt | Wood
| Tamara Aires, Verizon Business | Professional Development |
A Good Oracle Systems Analyst
What does it take to be a good Oracle systems analyst? Is being detail-oriented the key? How much background systems knowledge do you really need? What is the real duty of a systems analyst? We will explore these questions and much more. Being a good Oracle systems analyst isn't as clear cut as some might think. This session will explore from a manager's perspective, and from a lead developer's perspective, what is expected of a systems analyst and what set of skills is required to do the job well. We will discuss where the line is drawn between being a programmer and being an analyst, and why a company would specifically hire true analysts, versus programmer/analysts. We will also discuss the types of documents a systems analyst may be required to produce, as well as the role they play in the testing process.
Back
to the Top
| Mike Ault, Texas Memory Systems | Database Administration |
Is Oracle Tuning Obsolete?
In this presentation I will cover the new Oracle technologies that appear to make tuning of Oracle databases an obsolete skill. The pros and cons of each technology will be discussed and an overall rating given fo each. I will cover automation of the temporary tablespace, undo segments, memory management, SQL tuning and statistics, and profile management.
Back
to the Top
This session will outline the best practices for deploying a data warehouse on Oracle Database 11g in a clear "how-to" fashion, including detailed examples of schema design, partitioning strategies, and parallel query.
Back to the Top
Hermann Baer, Oracle Corporation
Things You Always Wanted to Know—Get the Best Out of Oracle Partitioning
Partitioning is a key technology for addressing the requirements of large data volumes, for data warehouse as well as OLTP environments. Benefits are not only for performance, but also increasingly for manageability and Information Lifecycle Management. This session will reveal best practices and designs used by successful customers. Furthermore, it will provide an insight into less known details of how to get the best leverage out of Oracle Partitioning.
Back
to the Top
Disk-array–based remote copy infrastructures have been available and in use for over a decade. When properly configured and deployed, they are capable of providing a very timely recovery from a variety of failures, including the loss of an entire data center site. Relying on a combination of well-understood technical issues, plus information from recent customer briefings and a commissioned study with IDC, HP has determined the key requirement: the remote copy of databases must be done in concert with the native RDBMS technology in order for the solution to be practical. This presentation provides a comprehensive set of test-proven best practices for properly configuring, deploying, and operating an Oracle 11g database with Oracle’s Automatic Storage Manager (ASM) on an HP Enterprise Virtual Array, using Continuous Access as the remote copy infrastructure.
This presentation extends the previous presentation to include the best practices for failover and failback in an Oracle 11g on EVA replicated environment. Specifically, this project addresses our findings upon investigating the following: Failover Scenario, Failback Scenario, and Link Failure Scenario. The methods and best practices described in this presentation are intended to be used to facilitate both the productive planning for and the timely deployment of a fully operational remote copy infrastructure—one that will have predictable performance characteristics, ease of operation, and satisfactory recoverability capabilities.
Businesses today cannot tolerate downtime. Downtime means loss of business, and ultimately loss of revenue to the company. The real challenge of achieving 24/7 availability comes from productively utilizing all the available resources, software, and hardware. This presentation is a case study of one such customer, whose storage array failed during the heavy transaction processing time. We quickly brought the database back up and subsequently got their entire system restored, all the while maintaining at least two copies of production databases. This presentation is a perfect example of how a mission critical production shop can utilize all Oracle HA features such as RAC, ASM, RMAN, and Data Guard to acheive maximum availability.
Back to the Top
How to Properly Utilize Outlines and SQL Profiles: Balance Between Plan Stability and Flexibility
Explore Oracle stored outlines and SQL Profiles like never before. Learn of practical usage cases. This paper will demonstrate and show specific, repeatable examples for your environment. Learn what to do, when to do it, and why it is done. Learn the difference between SQL Profiles and stored outlines. Experience the power of tools that allow for changing application performance without crazy init.ora parameters. Increase productivity; decrease exposure.
Back
to the Top
Building an SOA-based Virtual Operational Data Store (ODS) and Enterprise Service Bus (ESB)
Imagine building a virtual ESB based on SOA! This presentation demonstrates a virtual ODS/data warehouse and virtual ESB, which will provide you with the best of both worlds.
Back
to the Top
Changing the World with Oracle Web Services and the Service Oriented Architecture
This presentation will focus on the things you really need to know and care about with Web Services. This presentation will focus on a practical example of a Web Service application of the future.
Back
to the Top
Service-Oriented Architecture—SOA For The Dba
TUSC will present the current culture in service-oriented architecture (SOA) for the DBA and demonstrate a tool to help automate much of this process for you. What are the others doing? What are the first steps in this process? How do administrators “service-enable” existing services, using existing technology, and with your existing skills set. You can do this one service at a time with tools like Eclipse and JDeveloper (free integrated development environments—IDEs). For example, JDeveloper allows you to wrap an existing piece of PL/SQL (for the Oracle world) or Java code and expose it as a service. You'll need to learn about the IDE, about Java, about app servers, and plenty more to get going. That's enough of a dip into the ocean to get you going down the SOA path. Once you have services, you'll find countless ways of consuming those services. From data conversion to loosely coupled integration to mashups and portals to so much more—SOA will help you!
Back
to the Top
XML Publisher With Oracle EBS: Extending Functionality for Secure, Confirmed E-mail Delivery and E-mail, Fax and Printing of Oracle Database Attachments
Learn how to expand native Oracle EBS functionality (workflow, forms, and database technology) to automate e-mail/fax/print delivery of any document/volume of documents. Presentation includes: Pros/cons of the native e-mail/fax functionality of Oracle EBS and XML Publisher; advanced features such as the following: secured, confirmed e-mail delivery printing of Oracle database attachments; case studies presented by the customers themselves.
Back
to the Top
A Trip to the SPA—Inside the 11g SQL Performance Advisor
The declarative nature of the SQL syntax has always made it difficult to perform SQL tuning. The basic tenet of cost-based SQL optimization is that the person who writes a SQL query simply "declares" what columns they want to see (the SELECT clause), the tables where the columns reside (the FROM clause), and the filtering conditions (the WHERE clause). It's up to the SQL optimizer to always determine the optimal execution plan. This is a formidable challenge, especially in a dynamic environment. Once you create a workload (called a SQL Tuning Set, or STS), Oracle will repeatedly execute the workload, using sophisticated predictive models (using a regression testing approach) to accurately identify the salient changes to execution plans, based on your environmental changes. Using SPA, we can predict the impact of system changes on a workload, and we can forecast changes in response times for SQL after making any change, like parameter changes, schema changes, hardware changes, OS changes, or Oracle upgrades; any change that influences SQL plans is a good candidate for SPA.
Back
to the Top
Database Administration
Oracle 11g SQL Tuning Secrets
This presentation examines real-world techniques for improving the speed of SQL queries with a focus on the new Oracle11g SQL tuning features. The topics will include the new SQL workload replay, fully automatic SQL tuning, the “result cache” hint, new Oracle parameters that affect SQL performance, and changes to the new Oracle11g CBO costing approach. Presented by the author of High-Performance SQL Tuning by Oracle Press, this presentation will show actual case studies to illustrate the performance differences with these approaches to SQL tuning. Best of all, the presenter will share his proven SQL tuning secrets that ensure optimal SQL execution.
Discover BI Publisher
Abstract
Using DBMS_PROFILER
Abstract
Execution Plan Monitoring
Ever had a wonderfully behaving production system start performing poorly, only to find after hours of troubleshooting that a key query has inexplicably switched to a bad execution plan? With a little work you can have your own execution plan monitor up and running that will alert you when such a switch takes place. This can reduce the amount of time spent on diagnosing the problem when performance suddenly degrades. In this session, attendees will learn: essential concepts such as how SQL statements and execution plans are uniquely identified by sql_ids and plan_hash_values respectively; how to actively mine Active Workload Repository (AWR) data for changes in execution plans of queries, and raise an alert if such a change takes place; how to fine-tune which queries you monitor; how to accommodate multiple “acceptable” execution plans for the same query; how to use StatsPack data to accomplish the same goal if you are not licensed for AWR; and how to avoid certain Gotchas with execution plan monitoring (such as multiple child cursors w/different plans).
Load-Balancing in Oracle RAC
Oracle RAC is not quite the panacea for load balancing that most of us expected. Client side load balancing is random (not round-robin) and the server side can be confusing in its path. It takes a little work to find the right setup for client and server side load balancing. This session will present the basics of load balancing and then push into the uses of services and the load balance advisor for optimal use of RAC.
Managing Change in an Oracle Database Environment
Change is one of the few "constants" of database administration. Arguably the most important—but often under recognized—issue facing Oracle database administrators today is that to maintain database stability they must manage the changes that occur throughout their systems. It is self-evident that change—to hardware, software, applications etc. —is continually occurring throughout an IT organization; and being able to effectively manage these changes will both dramatically improve efficiency, as well as significantly reduce costs for the organization. This presentation will explore the methods we use to manage change within our databases at Green Shield and provide real-life examples of lessons we learned and pitfalls to avoid.
Oracle Exadata Storage Server. Introducing Extreme Performance for Data Warehousing.
Kevin Closson will present an overview of the Oracle Exadata Storage Server and HP Oracle Database Machine architecture and internals including performance analysis of typical workloads the Exadata Storage Server is solely capable of accelerating. The presentation will include comparisons to the typical storage architectures supporting Oracle Database workloads today. Attendees will leave with a good understanding of why, and how Exadata is what it is. Kevin will leave ample time for a fruitful question and answer session.
Performance Management from Crisis to Confidence; Utilizing Oracle’s Unified Method, Performance Management Track
When implementing any IT system, performance is a concern on every manager’s mind. But how to ensure performance will be there at go-live? We will examine the implementation of a typical Oracle system and blend the phases of the Oracle Unified Method (OUM); Performance Management Track (PT) into the overall implementation project plan. We will discuss the critical tasks of each the track’s phases as well as the gotcha’s. Load testing tools and their proper application will be introduced. From the proper execution of the Workload Characterization task, through Performance Testing; this paper covers the OUM PT sub-project end-to-end.
Bill Coulam, Church of Jesus Christ of Latter-day Saints
Unlocking Hidden Gems in Oracle Text
Come learn about Oracle Text and take some readily useable code examples home with you! Many Oracle practitioners have never had a need for Oracle Text, or so they thought. In reality most shops have or would have users clamoring for the advanced search capabilities provided by Oracle Text if they only knew they existed. We will briefly cover the major types of applications that can be built upon or enhanced by Oracle Text. But we will spend the majority of the hour diving deep into live demos and the code behind them. We'll spend some time being impressed by Text's search goodies like stemming, fuzzy, prefix, substring, multi-column, and multi-table (user datastore). CONTEXT grammar and CONTAINS queries will be covered as well. CTXCAT and CTXRULE systems will not be covered.
Avoiding the Perfect Storm
Experiencing extremely poor or inconsistent performance from your Oracle database server or mid-tier? Oracle Wait Events and AWR reports aren't really telling you why? If so, the problem often results from hardware and OS memory management issues, including swapping, even on systems with very large real memory. Learn how to identify these issues on various platforms and what to do about it. Learn from real field cases how various memory problems were diagnosed (or eliminated from consideration) and how they were resolved. The perils of memory management on virtual machine environments will also be explored in this presentation. While the emphasis is on database host systems, the information provided is applicable across a variety of platforms.
Top Down Performnance Management with OEM Grid Control
This presentation will demonstrate how OEM Grid Control helps to quickly spot high level performance anomalies, drill down, and discover root causes of performance problems. This presentation will demonstrate how to use groups and dashboards as well as AWR and ASM through OEM Grid Control.
Using OEM Grid Control Deployment Procedures
This presentation will give an introduction to OEM Grid Control's Deployment Procedures. It will show how to use out of the box deployment procedures and show how to customize Deployment Procedures and Directives.
The HP Oracle Database Machine is built for extreme performance for large-scale data warehouses. Anyone who is thinking about a data warehouse with Oracle should come to this session. Announced by Larry Ellison at Oracle OpenWorld, this is Oracle’s answer (and much more) to the data warehouse appliance hype. In this session you will learn the details of what this product delivers for you. You will see how pre-optimized and pre-configured software, servers, and storage make your life simpler. Learn how HP Exadata Storage speeds up your queries and other I/O intensive jobs, and how you can benefit from it without changing your data warehouse models.
The beauty of OWB is that you run your ELT in the database and have a distinct advantage on performance because of that architecture. But that does not mean you can completely ignore performance!! Industry trends show double-digit growth percentages on data volumes, so sooner or later you will be looking at tuning your ELT. We will discuss tips and tricks in Warehouse Builder to tune and deliver better ELT, but also look at some of the biggest bottlenecks in typical systems (read I/O). We will show some new features that help you in 11g and go into detail as to how to implement some basic best practices for better ELT. We will also go into detail on the benefits of using the new HP Exadata Storage coming with Oracle Database Machine. Note, if you have currently developed your ETL in PL/SQL, this may be just as useful for you.
with Michael Rosenblum, Dulcian, Inc.
Well designed Web applications can provide performance that is just as fast as their older client/server counterparts, but this requires a rethinking of application tuning strategies. Poorly performing Web applications are rarely or only marginally improved by tweaking the database and tuning the SQL statements. This presentation will discuss techniques that can be used to identify and resolve many common performance issues that arise when developing Web applications.
The Oracle Fusion Technology stack is large and complex encompassing many components. Some parts are free or nearly so such as JDeveloper, whereas other portions carry large licensing fees (WebCenter). What portions of the Fusion Middleware stack are organizations really using? How have their projects fared so far? This presentation will discuss the results of a number of projects from organizations that are using one or more parts of the Fusion Middleware technology stack.
Best Practices for Oracle Database Administration
What are the deliverables of the database administration role? How likely is it that the deliverables will be met if we cannot articulate them? In The Tao of Pooh, the clever little bear Winnie the Pooh, says, "If you don't know which to do, off all the things in front of you, then what you'll have when you are through, is just a mess without a clue." "Deliverables" are not the same as "current priorities" or "assigned tasks" because priorities and assigned tasks change from day to day. In this session, we discuss ten specific deliverables that do not change from day to day; the first is "databases that meet the needs of the business." One of the ten deliverables is a maintenance schedule and therefore we give special attention to the subject of database maintenance including backups, statistics, archiving, log file management, rebuilding, auditing, user management, capacity management, and patching.
Back
to the Top
Performance is poor, user sessions are 'hanging', management wants a diagnosis NOW! What do you do? Use the G2 method? Gather everyone in a conference room for a brainstorming session? Flush the shared pool, analyze everything and change a couple of database parameters? If it works (or fails), do you know why? More importantly, when performance is poor next week, can you repeat your actions with the same result? If a diagnosis process is not explainable and repeatable, it is undisciplined and unreliable. Diagnostic routines bring discipline to the troubleshooting and optimization process. This presentation covers some of the common undisciplined approaches, the foundations of and techniques for developing disciplined processes, and finishes with basic diagnostic routines and root cause analysis for Oracle sessions. The topics and methods are designed to enable the attendee to develop methods that are specific to their system, application, and situation.
During this session you will learn how to prevent problems before they occur! Optimize your systems based on the latest Oracle knowledge and best practices! Resolve your service requests faster! This session will concentrate on the preventive and proactive capabilities available to you via the My Oracle Support: configuration manager. Learn how these industry-leading enhancements can provide a desired proactive support experience and save your company money.
Oracle Database 11g is the newest version of Oracle's flagship database product. In this presentation Robert Freeman, author of Oracle Database 11g New Features will introduce you to Oracle Database 11g and several of the more impressive new features of the product. Robert will start with a discussion on upgrading to Oracle Database 11g. He will then discuss many of the new features available in Oracle Database 11g including: new diagnostic related features, new RMAN features, new memory related features, Oracle Flashback related features, database Replay, SQL performance analyzer, and many others!
Have you ever wanted to take a crack at writing your own Oracle book? In this presentation Oracle Press author Robert Freeman will discuss getting published in the Oracle world. In this presentation he will discuss how the publishing process works, how to get started with an idea, things to do, and some things not to do in your effort to get published. Finally the session will end with a Q and A session where you can ask any questions you like!
Oracle Streams is the premier replication method for Oracle databases. The Oracle Physical Standby is the fastest method to protect your data. Together they pose a set of unique issues and are sometimes difficult to manage. This presentation covers methods to implement and manage Oracle Streams Replication and Standby databases. We will cover failover and switchover requirements and methodologies.
Oracle Streams is the premier replication method for Oracle databases. The Oracle Physical Standby is the fastest method to protect you data. Together they pose a set of unique issues and are sometimes difficult to manage. This presentation covers methods to implement and manage Oracle Streams Replication and Standby databases. We will cover failover and switchover requirements and methodologies.
Oracle’s data compression helps solve an obvious problem of helping to conserve disk space. In addition, it can also improve performance for some operations. This presentation will give a fairly high-level overview of compression, along with tips on its use, and new compression features in Oracle 11g.
Douglas County Schools
Developing a Web service using BPEL to call an Oracle stored procedure will be demonstrated. The presentation will then address further integration possibilities using BPEL, SQL Server, and Java Stored Procedures to accomplish the same goal.
There are several errors present in many data warehouse implementations in Oracle. Central to these is the lack of use of partitioning, or (more prevalent) ineffective use of partitioning. Partitioning is crucial to data warehouses, but how do you use this complex functionality effectively? What other major features of Oracle does partitioning enable, and how and why? This presentation is the result of long practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements and painfully-gained understandings of data warehousing. It will provide straight answers and solid guidelines to best utilize Oracle DW features to ensure success. Data warehouses that utilize partitioning effectively often succeed, while data warehouses that are not designed to use partitioning effectively often die painfully.
The Automatic Workload Repository is a significant part of Oracle's tuning advisories introduced in Oracle10g and further enhanced in Oracle11g. Enterprise Manager makes extensive use of AWR to enable performance tuning, but like STATSPACK before it, there is a lot more important information within AWR which can be obtained. The presenter will briefly explain the structure of the workload repository and how it is populated, but will mostly show attendees how to extract more information from this rich source of tuning information using SQL*Plus. This type of knowledge makes the difference between a DBA who is out of ideas once Enterprise Manager fails to yield a solution, and a DBA who knows how to tease out important evidence to resolve practically any problem that arises.
Many organizations are missing out on the full power of Oracle middleware or fusion ware. This presentation is designed to help Oracle users understand the functional advantages of Identity Management (IM). In very simplistic terms, IM lets the organizational decision makers decide who gets access to what data, applications or any other system part and how data is used. IM contains five very useful functions: (1) increases security—inside and out, (2) cost effective regulatory compliance, (3) improves system responsiveness, (4) streamlines operations and administrative tasks, (5) reduces costs. Examples will be reviewed which demonstrate how IM accomplishes the five functions. References will be made to Oracle Flexible Architecture and the built-in connectors in Oracle Application Software which facilitate the set up of IM.
With the release of 11g, Oracle has added more features to help reduce the time it takes to back up, restore, and recover a database after a failure. Such features include multisection backups, faster backup compression, and undo optimization. Oracle has also introduced a couple of flashback features to decrease the amount of time to recover after a logical failure affecting certain tables. These features will all be presented, along with how they work and some example test figures demonstrating their benefit to the ever increasing number of 24x7 shops.
Sue Harper, Oracle Corporation
The next release of SQL Developer will incorporate logical and physical data modeling for Oracle and third-party databases (Microsoft SQL Server and DB2). This addition to SQL Developer allows database architects, database developers, and DBAs the flexibility of forward or reverse engineering database structures to provide graphical models of their databases. Developers can also create logical entity relationship diagrams, transform these to relational schema diagrams, define physical properties, and generate DDL. The tool supports extensive import and export options including importing from Oracle Designer, DDL, and the Data Dictionary. Users can work with large diagrams and create a variety of differently formatted displays of parts of those diagrams. SQL Developer Data Modeling also supports DataType and Multidimensional models. The session will be demonstration-rich, reviewing as much of the new product offering as time allows.
SQL Developer provides database developers with a powerful tool for database tasks. Users can browse, create, edit, and delete Oracle database objects; create, edit, and debug SQL and PL/SQL code; manipulate and export data; run reports and place files under version control. Time does not allow for every feature to be discussed, so the primary focus of the session is the demonstration which walks through a series of tasks users may encounter when working with the database. Supported throughout by source code control, the demo includes code editing support in the SQL Worksheet, how to create and edit database objects, and run reports. We look at migrating from a non-Oracle source and review existing Data Models.
Yes You Can Create a Conceptual Data Model in UML
This presentation will show you how to produce a high-quality conceptual entity/relationship model using UML. The result can be used in conversations with the business community ensuring that it correctly reflects the structures and requirements of the business.
Back
to the Top
Oracle Data Integrator (ODI) is a high-performance, flexible data integration platform that addresses today’s pervasive data integration requirements. ODI provides the capability to quickly integrate data from disparate systems, and is being used to meet the full spectrum of today’s data integration challenges. ODI, a key component of Oracle’s Fusion Middleware, is being teamed with SOA, Oracle Fusion Applications, Oracle BIEE, Oracle Essbase and Hyperion products, and other Oracle products. This presentation will present the capabilities of ODI and walkthrough the use of ODI to design and develop an ODI transformation scenario.
Have you migrated your business applications to Oracle10g from prior versions to have them suffer from unexplained performance issues? Dan will discuss a little-known index statistic and the impact this has on new tablespace features now available in Oracle10g. Dan will even provide a script that will help identify if your database environment is suffering from this issue.
This presentation will be packed full of practical examples from Dan’s book, The TOAD Handbook, and is a 'must see' for anyone involved with Oracle development.
Business intelligence applications are wonderfully powerful tools, but they are often so expensive that they actually deliver little or negative net value to our customers. In the last ten years, development teams for transaction applications have dramatically streamlined their delivery process by using agile methods, which revolve around the philosophy of maximizing the work “not” done. What would happen if we were to apply such an agile approach to BI projects? In this presentation, we explore accelerating data warehousing implementations via three means: (1) applying the agile manifesto to the way BI teams work, yielding an agile method for BI, (2) working smarter as we build BI modules by employing data warehousing patterns and frameworks, (3) minimizing the overall labor required by choosing unconventional data architectures and commercial, off-the-shelf data management products. When braided together, these three threads yield an Agile Data Warehousing approach, enabling BI professionals to deliver business intelligence applications through a process that is dramatically “cheaper, faster, and better.” Such acceleration not only benefits the current tier of major BI consumers, the Fortune 500, but also makes data warehousing affordable to far smaller organizations, the Fortune 500, and greatly expands the market for data management tools and services.
Oracle licensing can be very confusing. This overview will highlight the various Oracle Database licensing options and provide the audience with the ability to fine-tune their Oracle licensing options for their specific business needs. Much like SQL plan-management can be used to improve and control database performance and save cost, having a well tuned licensing scheme can save an organization a lot of money as well as position the database for future growth.
There has been a lot of buzz recently surrounding Ajax, commonly referred to as "Asynchronous Javascript”. With Ajax you can retrieve data from a Web server without refreshing the whole page, making your application run much faster. In this session, we’ll cover dynamic HTML and Ajax concepts and see it in action, pulling information from an Oracle database for display in a Web page. We will also explore the DoJo toolkit, an Ajax client side library. With DoJo, we’ll read data stores using JSON (JavaScript Object Notation), implement dynamic drag and drop, and use special effects such as fade in and out and other neat animations.
Information is arguably the most important commodity in an organization. Thus, it stands to reason that if the information is important, we need to make sure that the right people have access to the right information at the right time. If not, mission critical data can be compromised or may not be accessible to the right people. This presentation will cover the different authentication methods supported in Oracle Business Intelligence Enterprise Edition (OBIEE) and demo how the Oracle Identity and Access Management Suite can be used to authenticate users and manage access to OBIEE dashboards and reports.
There are a lot of frameworks available to build Web-enabled java applications. When you consider all the parts of a front-end application, the choices that need to be made can become overwhelming. Everything from choosing a persistence framework, a Web-service library, a screen-flow, field validation and format framework, and for a modern application, an Ajax library must be selected. Does your project have time to research which of the many frameworks should be used? And what about integrating all these components together? Are the frameworks compatible and working seamlessly together? What is needed is a solution that can be installed and immediately provide a developer the tools to build an application where all the underlying frameworks and libraries work seamlessly together. Welcome to Oracle Fusion Middleware 11g, specifically the Application Developer Framework (ADF). If you've looked at 10g ADF, it’s time for another look at what the newly released 11g has added to the toolbox. ADF provides a rich framework to build a front-end application. Although the framework includes many needed components for an application, for the purposes of this presentation we will concentrate on the robust Ajax enabled UI components that have been added to 11g. If you think its complex to create an Ajax enabled UI, think again.
Among the most promoted benefits of a service-oriented architecture (SOA) is the reuse of services and Web services. To achieve reuse developers must know: that a service is available, how to call it, what to expect in return, and they must trust it to work as advertised. The larger and more geographically dispersed a team of developers is, the more important it becomes to have centralized control of Web services. Oracle’s Service Registry provides a UDDI V3 compliant mechanism for publishing, categorizing, and discovering Web services. This session discusses the need for a registry and explores the setup and use of the Oracle Service Registry. Participants will learn how to publish and categorize Web services. In addition, attendees will learn how the Oracle Service Registry’s search mechanism may be used to discover Web services. By learning to properly use the Oracle Service Registry, teams of developers can achieve the reusability promised by SOA.
New features of the Oracle database geared to developers will be discussed and demonstrated. Attendees will be introduced to the new and improved features of Oracle11g/10g that directly impact application development. Special emphasis is placed on features that can reduce development time, make development simpler, improve performance, or speed deployment. Specific topics include: new SQL functions, regular expression improvements, virtual columns, new XMLType options, XML indexing improvements, SQL pivot statements, JDBC improvements, PL/SQL syntax enhancements, PL/SQL compiler, trigger improvements, PL/SQL Result Cache, case/accent-insensitive query, regular expressions, expanded LOBs, new data types (BINARY_FLOAT, BINARY_DOUBLE, etc.), new statistical functions, model clause, and the recycle bin. Attendees will be better equipped to create new applications or modify existing applications to take full advantage of Oracle11g/10g.
Oracle's current focus on implementing database and development features based on the Java language may have you thinking that you need to learn Java. However, if you are mainly familiar with PL/SQL, your first view of Java may be a bit discouraging because its object-oriented core makes it look very different. Also, you may wonder about where Java fits in the industry and how much Java you really need to know to create Web applications. This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures—classes and methods—as well as control statements, exception handling, datatypes, and variables. This explanation will act as a springboard for further study.
This presentation explains to PL/SQL developers who have had little or no exposure to Java, the basic concepts of and terms used in Java. The presentation provides an overview of the language and reviews the concepts of object orientation upon which Java is based. It also discusses the fundamental Java code structures—classes and methods—as well as control statements, exception handling, datatypes, and variables. This explanation will act as a springboard for further study.
Back
to the Top
Intro to MySQL for Oracle DBAs
Many companies use multiple database vendors to address varying requirements in an increasingly tough business environment. This presentation shows how to implement and use MySQL from an Oracle DBA’s perspective. Details will be given on DBA tasks such as installation, secure setup, user management, monitoring, performance, and troubleshooting a MySQL database.
Back
to the Top
The Answer to Free Memory, Swap, Oracle, and Everything
Do I have enough memory? Why is my free memory so low? Am I swapping to disk? Can I increase my SGA (db cache) size? Can I add another instance to this server? Are my system resources being used optimally? These are all questions that often haunt DBAs. This presentation is The Answer. It covers in detail the different types of memory, how to monitor memory, and how to use it optimally with Oracle. Multiple examples in the presentation demonstrate how certain actions on the database side cause different memory areas to be allocated and used on the OS side. Key underlying differences in operating systems approaches to managing memory will be highlighted, with special attention given to Linux, Solaris, and Windows. Using Linux as an example throughout, this presentation explains how to effectively use tools such as “top”, “vmstat”, and “/proc/meminfo” to look into a system’s allocation and use of memory.
Back
to the Top
From the dbms_obfuscation_toolkit, to dbms_crypto to transparent data encryption at the column level to tablespace encrypt and data pump encryption, we’ll cover them all. We’ll investigate which techniques should be used and under what circumstances they should be used. We’ll see how the keys are managed by the Oracle Database—or not in the case of the DBMS_ packages. We’ll discuss “why” you encrypt and when encryption just does not apply.
A hotly debated topic is, “Do I need to reorganize/rebuild indexes and tables?” We will discuss the times when a reorganization or rebuild is relevant, how to measure what you’ve done (to verify that the work performed did something useful!), and the best techniques for performing a reorganization of data.
Today many companies face the challenge of not being able to quickly and accurately answer the question “Who has what resource and why?” This issue becomes even more critical when the termination of resources is required in an urgent fashion. Oracle Identity Management (OIM) offers the capability to enterprises to manage user’s lifecycle in all available resources such as Microsoft Active Directory, Microsoft Exchange, and ERP systems. This presentation will give an overview of OIM, discuss its architecture, and show how it can help enterprises with identity management. Then, it will focus on how OIM allows users to self register to become new users or request additional resources. Users, with approving authority role, see these requests in their pending approval tasks queue. Upon approvals, resources are provisioned to users accordingly. OIM also allows requests for resources to be de-provisioned following the same model of approval.
In this session, we will take a tour of Cloud Computing. The tour begins with an explanation of what Cloud Computing is, followed by an exploration of the major categories of solutions. We then will survey the vendors that offer solutions in this space. Finally, we will look at case studies in which enterprises have used the Cloud with success. Attendees will walk away with an understanding of what Cloud Computing can do for their company.
Google Gadgets have become a popular widget technology that have been rapidly adopted by consumers. A gadget is a small Web page that encapsulates a feature like a stock ticker or flight status lookup. This session will discuss why it is beneficial to provide official corporate Google Gadgets, and an introduction to how to build them.
In this session understand how Fusion can apply to your current job role or possibly a future one. This is a growth area where IT professionals are being sought and could lead to your career enhancement. Learn where and how to be connected and grow your skills and expand your knowledge on your Fusion journey as well as supporting after upgrade or deployment.
As Oracle gets ready with Fusion Applications I am proud to have had a preview. What blew me away was the vision; all of the technology is here today and we will look at the skillsets required and how they are brought together. A joint presentation from both the application and technology perspective.
The 10053 event produces a tracefile detailing the statistics and calculations used by the Cost Based Optimizer (CBO) in the development of execution plans. The CBO takes a variety of inputs including optimizer statistics (e.g. NUM_ROWS and NUM_DISTINCT) and initialization parameters (e.g. DB_FILE_MULTIBLOCK_READ_COUNT and OPTIMIZER_INDEX_COST_ADJ). By varying initialization parameters and tracing queries using the 10053 event, we can see how these parameters affect the CBO's cost estimation and why certain plans are chosen over others.
Oracle Database Security in a Nutshell
In this session, the students will learn how they can use Oracle database features to meet the security and compliance requirements of their organization. The current regulatory environment of the Sarbanes-Oxley Act, HIPPA, the UK Data Protection Act, and others requires better security at the database level. The session provides suggested architectures for common problems. It covers four major areas of database security: (1) authentication, (2) authorization, (3) auditing, (4) encryption.
Back
to the Top
Tired of resetting passwords? Granting additional privileges? Filling out those endless periodic audits of user accounts? Make someone else do the work! Delegate database user management to your Active Directory administration group. This presentation will discuss new features in Oracle Identity Management 10.1.4.2 for managing Oracle Database users in Microsoft Active directory WITHOUT HAVING TO SYNCHRONIZE USERS TO OID! This new capability lets you go from project start to managing your database users in less than an hour. In this presentation we'll take a step-by-step approach to the integration including discussing your options along the way and the impact of the different choices you can make in architecting your solution.
While REST was originally coined as an acronym for Representation State Transfer, it is also very easy to think of it as a method for "resting" from the complexity and frustration commonly associated with the WS-* specifications. The WS-* specifications can be useful for ensuring services are implemented in a standard and widely supported way, but unfortunately they also have several disadvantages such as high level of complexity, inconsistent implementation, and even competing and contradictory concepts among different specifications. The REST approach to Web services promises and delivers an easier path for developing basic Web services. This presentation will provide an overview of the REST concept and contrast REST with the more formalized WS-* specifications. Support for REST principles and REST-based Web services in the Java-based Jersey project will also be discussed. The presentation will also offer some ideas regarding when REST is the more appropriate alternative and when REST is the less appropriate alternative for implementing Web services.
Adobe Integrated Runtime (AIR) is a platform that allows developers with Web development experience to easily bring their skills to desktop application development. AIR combines technologies commonly associated with the Web (such as HTML, CSS, JavaScript, Flex, and ActionScript) with advantages associated with the desktop (such as local storage and local file system interactivity). Applications written for AIR can take advantage of the ability of AIR to run on several different operating systems and provide a consistent user experience across those different environments. AIR also allows developers to easily migrate applications already written for the Web to the desktop. This presentation will provide an overview of Adobe Integrated Runtime and outline some of the main reasons a developer may choose to use AIR. The presentation will include some simple examples of AIR, including the adaptation of a Flex-based application into an AIR application and the adaptation of an Ajax/DHTML application into an AIR application.
To many application developers, a database is just a "data store" with an API that they call when they need to persist an object. It's an abstraction that makes sense from one perspective: in a world where you're expected to write dozens of new features every day in Java, PHP, or C#, who has the time or the inclination to dive into what's going on deep inside the Oracle Database? As a result of this abstraction, though, developers sometimes inflict unintended performance horrors upon their customers. The good news is that you can avoid most of these horrors simply by better understanding a bit more about what's going on inside the Oracle kernel. The trick is knowing which details you need to study, and which you can safely learn later. This presentation describes, from a developer's perspective, the most important code paths inside the Oracle kernel that can make the difference between an application that breaks down under load and one that can scale to thousands of users.
The presentation will start by going over what ASM is and how it can benefit an organization. Progressing forward, the basics of ASM will be covered including the requirements for an initial install which might include a full database upgrade. Concepts concerning what type of redundancy is available. The definition of Course and Fine in addition to High, Normal, and External redundancy will be looked at in detail. Questions such as "What can be put on an ASM volume?" "How is the structure created for the storage of spfiles, datafiles, undo, temp, archive redo logs, redo logs, and rman backups?" "What is a disk group?" will be answered. Backup and recovery solutions and architectures may have to be changed in an ASM environment. Several scenarios will be discussed in detail. Tools for using ASM effectively such as "ASMCMD" and "OEM" will be covered with live examples. What are the advantages of going to ASM. Comparing the advantages against technologies such as OCFS2 and raw devices for RAC and single instance environments will be covered.
Oracle continues to add more and more automated features and advisors to assist with diagnosing and fixing problems. Given all this automation and advice Oracle is providing, a question to ask is whether or not all this advice is "dumbing us down" or "smartening us up." Too often more automation can lead to using these features as a crutch and bypassing the acquisition of key skills and knowledge. Ideally, these features should be tools to help us do our jobs better instead of simply letting Oracle do them for us. The key is to know what help the advisors’ can provide and know how to use them properly and effectively. The risk is becoming trained to only follow the advisors output, but when a situation arises where our skills and knowledge are needed, it's not there. This presentation will review several cases where the Oracle SQL Tuning Advisor (in particular) isn't able to provide any help with identifying and correcting poorly performing SQL. We'll then review the knowledge and critical thinking skills needed by the DBA or developer to understand how to make the needed improvements to the code to provide enhanced performance.
This session provides an overview of the new Oracle Application Development Framework (Oracle ADF) 11g release. A framework that simplifies the development of Java-based applications with built-in solutions to simplify the creation of both business services and user interfaces, Oracle ADF, with Oracle JDeveloper, provides a visual and declarative development approach that provides unparalleled productivity for building enterprise applications. Oracle ADF is the framework at the base of Oracle's upcoming Fusion Applications and has been used by multiple organizations to increase their development productivity.
The new version of Oracle JDeveloper 11g along with Oracle ADF 11g takes productive development to a new level. Come and learn how you can build standard based SOA applications faster than ever before. This session reviews various new capabilities added to JDeveloper and uses demos to illustrate the development experience.
Bring your laptop and your questions to the Fusion Development hands-on session. You'll learn how to develop a Fusion application, using the Oracle Fusion Middleware stack— including Oracle JDeveloper, Oracle Application Development Framework (Oracle ADF), and the highly interactive ADF Faces user interface components. Make sure you have downloaded and installed the Oracle XE Database and Oracle JDeveloper 11g before you arrive to maximize the time you'll have to complete the tutorial.
Jeff will give a brief update for customers running Oracle on RHEL. Oracle has recently been focusing much of their Linux work on their version of RHEL (OEL), so this session provides an update from the RHEL engineering perspective. This session will provide an overview of ongoing certifications for which Red Hat is now responsible, including RAC certifications for the Red Hat Global File System (GFS) running on the Advanced Platform/Clustersuite infrastructure. The intent is to be as interactive as possible, so considerable time will be dedicated to open Q&A.
Ignorance != Bliss
When there are dramatic changes in the business environment there is a new sense of urgency for businesses and individuals to focus on value.
Inefficiencies cost money and the lack of a current skill set may be the difference between maintaining employment and an undesired career change.
In this presentation Oak Table Network co-founder and Ace Director Mogens Norgaard and Ace Director Daniel Morgan will discuss the current state of technical education as it applies to real-world environments and offer concrete recommendations with respect to how organizations can evaluate and upgrade their current talent and individuals can make sure that they have the skills they need for their career.
Back
to the Top
The quick tip session will briefly describe the conceptual framework which allows third-party tools to be incorporated into Oracle's Grid Control framework for monitoring and alerts. It will use Dell's OpenManage Server Administration tool to demonstrate incorporation of data collected by Dell's tool into Grid Control.
JDeveloper: Not as Scary as You Think
Oracle JDeveloper has become Oracle's flagship development tool. It covers so many Web-based technologies that it can be overwhelming to learn and understand. Oracle has, however, made it relatively easy to get started using the product by incorporating sophisticated "under-the-covers" technologies. These technologies make it easy for developers to create relational data-driven applications in Oracle JDeveloper while writing a minimum of code. The presentation will outline those technologies along with the EVA paradigm that will allow organizations to start building Oracle JDeveloper applications immediately.
Back
to the Top
Chris Ostrowski, TUSC—A Rolta Company
Web Services are the foundation of service-oriented architecture (SOA). Being able to create Web services from your existing applications can be a steep technical challenge, however. Web Services make use of numerous technologies (such as Java, XML, SOAP, et al) that many Oracle developers are not familiar with. This presentation will explain what Web services are, how to create them easily using both Oracle and commercial tools, and how to begin constructing your SOA environment.
This presentation gives you the knowledge of how to dig deeper from usual performance troubleshooting approaches like tracing and Oracle Wait Interface sampling. These classic techniques are often not adequate for diagnosing special cases involving bugs, Oracle instrumentation deficiencies, and operating system issues. We will look into techniques, scripts, and tools for sampling relevant execution statistics from inside and outside Oracle. We also use a simple non-intrusive stack profiling method for pinpointing where exactly in Oracle kernel the response time is spent. This all is wrapped into a practical troubleshooting method which has so far helped the author to accurately troubleshoot many issues related to hangs, bugs, and unexplained bad performance.
Even though SQL statements and their compiled execution plans are just declarations of what work needs to be done, when Oracle gets to execution of a SQL statement, all processing is done procedurally. Every rowsource, join method, and access path is internally just a loop, continuing as long as there is data flowing from its child rowsources. This session gives you an in-depth understanding of how Oracle SQL plan execution physically works, a step beyond just interpreting the logical view of execution plan trees. This should give you a good foundation for troubleshooting complex SQL performance issues, understanding in which cases one join method is better than another, and making more suitable physical design decisions.
Professional Development
This session will explain the concept of microblogging and show how it can be a productive tool in your daily life. The session will start with Twitter, a popular public microblogging platform, and show how people are using it for recreational and business purposes. Next, the session will discuss microblogging in the context of a corporate intranet and why it is a useful tool for the enterprise. The session will draw on experience with OraTweet, Oracle's internal microblogging platform.
This presentation is on how to realize the value of SOA and Web technologies when you are living in the world of Forms. We will outline the options ahead of people when considering upgrading their Forms or converting them to ADF, and insight on what makes sense now and down the road. The intent is to convey the landscape of Forms, where it is going, and how someone can thoughtfully embrace the promise that Fusion, through ADF, can bring to an organization. This session is applicable to developers, architects, or managers of any level.
PL/SQL Development with SQL Developer
This session focuses on SQL Developer’s PL/SQL support, initially reviewing editing PL/SQL, code templates, and snippets, and is followed by PL/SQL debugging, with particular reference to debugging remote applications. SQL Developer includes a variety of code formatting features that enhance working on the SQL Worksheet editor or the PL/SQL code editor. The session also reviews a variety of PL/SQL focused features, such as code refactoring and the PL/SQL hierarchical profiler, introduced in Oracle Database 11g. Finally we'll review a number of the reports available for reviewing and searching code.
Back
to the Top
Deep Dive into SQL Developer
Oracle SQL Developer provides database developers a convenient way to perform various database tasks and to manage database objects. This session focuses on a few aspects of the tool that users are either unaware of or use less frequently. These include Reporting, user defined extensions, migrations, Oracle Application Express integration, and version control. By focusing on a few features, we can pay more attention to some of the detail, such as reviewing the advanced reporting capabilities by allowing users to introduce graphical displays and master-detail reports. We will demonstrate building more complex master-detail reports, passing parameters, and drill down capabilities. We'll also show how you can tune SQL and the database using some of the latest reports introduced. We show you how to add new features to the product using SQL Developer's extensibility and delve into our own migrations extension. For Application Express users, we show a number of useful integration points between the two products.
Back
to the Top
The concept of using connection pools involves keeping a limited number of persistent sessions that serve incoming requests on “first-in/first out” basis. This strategy can be applied to some of the most critical issues (both client/server and N-tier) currently faced by existing database system technologies: However, despite handling old problems effectively, the use of connection pools introduces some new ones: This presentation discusses some core use cases implementing connection pools and including the topics of resource utilization, effective session management, read/write consistency, etc. Real-life examples will be included to pinpoint common hidden traps.
Enable Social Networking in your Enterprise
Social networking applications like Facebook and LinkedIn using Web 2.0 technologies are sprouting up all over the consumer Web. Such applications present a set of rich interactions between users and content. Applications that leverage aspects of social networking are beginning to show up the enterprise. These applications help improve employee productivity by helping users connect with subject matter experts and relevant content. This session includes a demonstration of an application that features social networking features for the enterprise.
Oracle WebCenter: A Platform for Building Web 2.0-Enabled Collaborative Applications
Web 2.0-enabled collaborative applications are penetrating the enterprise as they provide today's knowledge worker the means to effectively collaborate with other employees to get their work done. A major challenge that today's enterprises face is how to select the right framework for building such applications. Come to this session and learn how WebCenter can give you a head start in building collaborative applications that leverage its standard-based framework and rich set of Web 2.0 services.
Virtualization is a red hot trend—but what about for databases? The answer is YES, with the proper care and configuration Oracle on VMware is a reality. The author will present some of the best practices from his new book: Oracle on VMware—Expert tips for Database Virtualization.
TOAD users, come and see how to maximize both developer and DBA productivity using powerful shortcuts, overlooked features and advanced capabilities. This session will have you saying “wow—I didn’t know TOAD could do that (and so easily!)” You’ll learn easy yet extraordinary ways to make both new and veteran TOAD users more productive, and thus increase the value of TOAD usage within your company. Our goal will be to show you how to get the most out of your TOAD experience. And this session is being brought to you by people who know TOAD best—the product manager and product architect. There might even be time for some product future roadmap discussion and upcoming feature previews!
SQL Plan Management in 11g
SQL Plan Management was introduced in Oracle11g to guarantee execution plan stability and allow controlled execution plan changing. The presentation will discuss this new feature in conjunction with new mechanisms for gathering extended statistics and managing pending optimizer statistics.
Back
to the Top
How would you backup your 1 TB database in minutes before a major application upgrade? How would you recover the database in minutes if the upgrade goes wrong? Two options are discussed in this presentation: FLASHBACK DATABASE technology in Oracle 10g and above and snapshot technology from storage vendors such as Network Appliance. The architecture and workings of each of these technologies is discussed. Both technologies are expensive, you have to decide what works best for you.
Not sure which process is holding onto the listener port or preventing a filesystem from being unmounted? What is the PID of the offending session on the application server outside the database server? How to find system and hardware configuration information on various flavors of Unix? How to set up SSH keys or port forwarding to use Toad through a firewall or setup Unix Desktop on your laptop even though the server has no monitor or video card? Want to clean up the IPC resources of an Oracle instance that crashed without killing a running instance? Can't delete a file even as root on Linux? You'll learn many such tips and tricks in this session.
Oracle Forms was and still is a very popular development tool, but many organizations are looking to modernize to a purely Web-based solution. This session demonstrates the latest Oracle Forms conversion tool being built directly into Oracle Application Express. Starting with the Forms XML conversion file, the presentation demonstrates how you can generate HTML pages within Oracle Application Express. Oracle Forms developers will feel right at home with Oracle Application Express, given its similar declarative nature and use of PL/SQL.
This session will demonstrate advanced techniques in outputting your information to both the screen and printable reports. First will be a demonstration on expanding the basic functionality available with Interactive Reports. This will be followed by utilizing Flash charts with multiple data sets and some of the lesser used capabilities. Then to round it off developing complex reports with BI Publisher will be demonstrated.
Surveys indicate that most database servers operate at far less than their capacity allows, which means businesses are wasting money and IT is doing additional work. To counter this wastefullness, organizations are increasingly turning to server consolidation as one means of cutting redundant costs such as backups, monitoring, maintenance, various license fees, and technology standardization. But it’s not that simple. Due to different CPU speeds, CPU core numbers, workload peaks, software releases, and application dependance and security issues, what seems like a simple consolidation exercise can turn into a daunting challenge. The danger is if too many applications are consolidated onto too few or underpowered servers, the result is upset users and interrupted business processes. This paper is aimed at introducing server consolidation by enabling IT to understand the potential, the dangers, the complexities, as well as how to perform basic server consolidation.
The Oracle database is extremely complex software. Part of the solution to performance optimization is Oracle Corporation itself optimizing the core database kernel code. One such optimization is the introduction of Oracle’s patented in-memory undo (IMU). Essentially, instead of maintaining undo in Oracle segments, the undo is managed, as much as possible, in memory using structures optimized for in-memory operations. But as you will read, how Oracle does this is fascinating and foreshadows even greater things to come. But with any piece of code, there is always the possibility of a bottleneck, so this paper covers how to detect IMU performance issues and multiple ways to potentially solve the problem (in addition to just turning it off).
This paper focuses on a few new features introduced in Oracle version 11g. Features include but are not limited to, virtual columns, virtual indexes, CBO features, extended stats, sub-query transformation, faster lob, faster column addition, trigger enhancements, etc. Various test cases will be provided comparing performance improvements. Further, scalability improvements and issues with these new features will be discussed.
This presentation is to explore various RAC performance myths and show how battle among the nodes can cause worse performance issues. Some of myths covered, but not limited to : (1) Global cache performance issue? It must be an interconnect performance issue. (2) CPU hogging process? Throw that in report node; we are not worried about high CPU usage in there.(3) We’ve got many CPUs across many nodes and so use Inter instance parallelism to improve performance of parallel executions. (4) Use inter instance parallelism to create tables and indices efficiently. (5) Set sequence to nocache value in RAC environments to avoid gaps in sequence. (6) Our application is designed to generate much dynamic DDL. We are upgrading to RAC this weekend and we might need to call you if there are any issues! Quick, where is that off button? (7) We will cache the whole table in buffer cache and cache fusion should take care of moving blocks across nodes, too. So, small tables should not be indexed in RAC. (8) Bitmap index performance is worse compared to single instance. (9) If there are performance issues, convert from single instance to RAC.
Insight Into The Business Of Reusing Your Assets
As experienced SOA companies will attest, the scope of SOA is massive, and as companies start researching SOA, the concepts get deeper by the minute. Between all of the acronyms, terms, and technologies such as buses (ESBs), Message queues (JMS, MQueue), compliance, governance,and so many more, database administrator's and others get overwhelmed quickly. Each topic is its own Pandora's Box! The bottom line is, SOA is HUGE! But...it doesn't have to be. You don't have to boil the whole ocean to venture into SOA, you just need to dip your toe in to see how it feels first. This presentation will present the current culture in Service Oriented Architecture and demonstrate a tool to help automate much of this process for you.
Back
to the Top
Many organizations have begun either implementing or evaluating SOA strategies to tie together heterogeneous systems. It is important that these organizations use development tools that support that strategy. Application Express has supported consuming Web services since version 1.5. Starting with version 3.0 the feature Manual Web References was introduced to allow for maximum flexibility in interacting with Web services. This session will cover interactions with Web services based on consuming a WSDL as well as manual Web references. The demonstrations in this session will utilize a variety of Oracle products such as BPEL, JDEV, XML DB Native Web Services, and Stellent. The session will also cover cases where neither WSDL-based nor Manual Web references are appropriate and what you can do to still interact with Web services in Application Express. Finally, there will be a preview of Web service support planned in the next major Release of Application Express.
Parallel concurrent processing failover uses two mechanisms to detect a failure, dead connection detection and detecting a failure of the process monitor for the concurrent managers, otherwise known as PMON (not the pmon from the database); introduced with patch 6495206. Load balancing of the concurrent managers is critical if you expect parallel concurrent processing to function after the failover to the remaining node(s). A review of concurrent manager basics is covered before we discuss the topics of failover and load balancing. One of the key components used by concurrent processing is generic service management. The use of GSM with multiple nodes and seeded GSM services are discussed. Administering concurrent managers, control across nodes, starting and stopping the concurrent managers, and concurrent log files are skills needed to understand the configuration of PCP failover and load balancing. The primary tables that contain the concurrent processing data are investigated with a review of the phase and status types for concurrent requests. Each manager type is discussed: service manager, internal manager, standard manager, transaction manager,conflict resolution manager, and internal scheduler/prerelease manager. The failover and load balancing of these managers is central to the theme of this paper. Configuration of parallel concurrent processing and some configuration examples are followed by a practical approach to troubleshooting concurrent managers.
Oracle on Linux Installfest Covering: installing Oracle VM 2.1.2 manager and server, installing and using Oracle Database and Middleware on Linux, working with Oracle VM Templates. As usual the highlight will be the product demos by experts; we will also have installfest software kits courtesy of OTN for installfest attendees.
The SAN is guilty...Until Proven Otherwise!!! Part 1 and 2
Oracle Performance Management has a reputation of being part science, part art, and mostly wizardry. A system plagued with the fundamental problem of poorly configured SAN, is guaranteed to exacerbate any application-level problems with inconsistent I/O service times. Application response times, as a result, dip to sub-optimal levels. Diagnosing storage sub-system performance issues takes time, organization, discipline and a methodical approach. The configuration and performance of the various layers of storage sub-system needs to be understood and unraveled. This talk shares with you the core principles of performance management (including the methodology) utilized to determine, investigate, and implement "meaningful solutions" to real-world storage sub-system performance problems. This presentation will not only discuss the relevant concepts but also provide case studies that go into the required technical details.
Back
to the Top
Oracle has made a decision to use WebLogic Server as it's strategic application server going forward. For those that are familiar with OiAS and want to understand what's "in the box" of WebLogic, this is the talk for you. This talk will give an overview of what capabilities WebLogic has along with demos of some of the key features of the application server. At the end of this talk, attendees should understand the components of WebLogic Server, how it works, how it is managed, and how applications are developed on it.
Back to the Top
To become skilled in the area of troubleshooting and failure resolution, most Oracle professionals endure a wide variety of trials by fire in production environments, over many years. By learning to create realistic load levels and failure scenarios in test systems, Oracle professionals with little experience in troubleshooting and fault resolution can hone their skills without the customary stressful ordeals and business impact. In this session we will induce realistic problems, including hangs, spins, crashes and corruptions on a running Oracle 11g instance, then apply effective techniques for diagnosing and resolving those faults.
Most unplanned Oracle downtime and service reductions are caused not by the initial occurrence of a fault, but by the many subsequent occurrences of the same problem that take place before DBAs or support find a solution or workaround. Diagnosing a problem the first time it happens in a mission-critical environment is difficult even for the most experienced Oracle professionals. To address such circumstances, several new Oracle 11g features have been introduced under the umbrella of the diagnosability infrastructure. In addition, there are a variety of novel methods that make it possible to automatically detect and diagnose faults upon the first occurrence. Instead of suffering through dozens of failures from the same problem, mission-critical sites will benefit from implementing first-failure fault detection and diagnostics strategies as described in this session.
This session will help you understand data quality, how to conduct data profiling, and discuss options for starting a data quality or governance program in your organization. Data stored in a data warehouse or data mart must be trusted to have true actionability. When you bring data into your data warehouse, you need to first understand the structure and the meaning of your data, and then assess the quality and the extent to which you may need to cleanse and transform it. Once you know what actions you need to take, you then need to make the required corrections to the data, and put in place a means to detect and correct any more errors that might occur in future loads. Many organizations build a data warehouse to provide an integrated, reliable, and consistent version of the truth. Data is typically sourced from various systems and has to be extracted, cleansed, and integrated before being made available for users to query. The quality of the data loaded data warehouses and data marts is highly variable; however, the process of profiling your source data has been a time-consuming, manual process via custom programs or the purchase of an expensive third-party tool. This presentation will present data quality, and formation of a data quality program. The presentation will cover the following topics: data quality misconceptions, levels of data quality, data profiling and data dictionaries, and creating data stewardship/governance.
Performance events requiring DBA attention have been historically difficult to detect. Often, user complaints are the first indication of a problem. Traditional solutions set alert thresholds against system-level metrics. Problems with this technique arise on a number of fronts: shortage of quality performance indicators, thresholds are static while workloads may vary predictably, indicator metrics may be application or system dependent, appropriate thresholds may be workload dependent, and adjusting threshold settings over many databases is labor-intensive. The Oracle 11g Adaptive Thresholds feature addresses these issues by enabling databases to automatically determine and adjust meaningful alert thresholds for key performance metrics.