For mange er en BI-løsning synonymt med et avansert rapporteringsverktøy. Det er tilsynelatende også slik selgerne av BI-løsninger ser på verden. I dette foredraget setter vi blikket på hva som faktisk kreves av en komplett BI-løsning og dem som utvikler den. Hvorfor bør maskinvare, virtualisering, operativsystem, databaser, ETL, forretningslogikk og rapporter vurderes som en helhet? Vi vil definere behov og krav fra alle deler av organisasjonen. Fra IT-avdelingen til sluttbrukeren, fra A til Å.
There is a remarkable human condition where you can be both cold AND sweaty at the same time. It comes about 3 seconds after you press the Commit button and you realise that you probably needed to have a WHERE clause on that delete all rows from the SALES table SQL statement. Or it might come just after you run drop table on the Production database, when you were just so sure that you were logged onto the Test system. This session will discuss how you can use the FLASHBACK features in 10g and 11g to overcome this uniquely human condition
Ser hvilken retning Oracle ønsker å gå med databasen. Hva Oracle gjør for å videreutvilke mulighetene for Cloud infrastruktur. Tar også generelt for oss de viktigste nyhetene i neste versjon av Oracle Databasen.
This Oracle University Master Class discusses Parallel Execution, covering Parallel Query, DML and DDL. It begins by discussing the architecture for Parallel Exection in both Single Instance and RAC. It then describes Administration of parallelism, and the monitoring of Parallel exection SQL Statments. It then moves to the use of Automatic Parallelism introduced in 11g Release 2, covering the Administration and effects of Auto-Parallelismparameters, Automatic Parallelism behaviour, Parallel Statement queuing, use of The Resource Manager to control
per consumer group queuing and In-Memory Parallel Query.
"Application developers usually focus their efforts on languages other than SQL and PL/SQL most often writing in C##, Java, Ruby, Perl, and other languages. And, much of the time, they do not really understand the database with which they must work.
This one-day workshop will cover everything from architecture basic to advanced programming techniques and tuning to help application developers take maximum advantage of the database and to help them build high performance secure applications and avoid reinventing the wheel."
For mange er en BI-løsning synonymt med et avansert rapporteringsverktøy. Det er tilsynelatende også slik selgerne av BI-løsninger ser på verden. I dette foredraget setter vi blikket på hva som faktisk kreves av en komplett BI-løsning og dem som utvikler den. Hvorfor bør maskinvare, virtualisering, operativsystem, databaser, ETL, forretningslogikk og rapporter vurderes som en helhet? Vi vil definere behov og krav fra alle deler av organisasjonen. Fra IT-avdelingen til sluttbrukeren, fra A til Å.
Exadata Database Machine offers incredible query performance improvement opportunities via its suite of Smart Scan features … except when it doesn’t seem very “smart” at all! Join Oracle DBA and Oracle University instructor Jim Czuprynski as he demonstrates why Smart Scan sometimes decides to “play dumb” and how to make it respond properly to your commands to “play smart” instead.
This session will:
- Demonstrate how Smart Scan typically reduces query execution time
- Identify why Smart Scan sometimes has no choice but to “play dumb” and use normal retrieval methods instead of using storage indexes, full table scans, or fast full index scans
- Explore how to resolve these issues by helping Smart Scan to raise its “query IQ” whenever possible
1. Smart Scan: Exadata’s “Secret Sauce”
a. Smart Flash Cache
b. Storage Indexes
c. EHCC
2. Did Smart Scan really happen?
3. Why doesn’t Smart Scan get used all the time?
a. Banned Objects
b. “Small” Tables and Serial Direct Reads
c. Indexes and Histograms
d. Contending Workload Profiles
4. Helping Smart Scan To “See Better”
5. Conclusions
What is the threats and how do you protect you selves.
The level of protection on database level is normally an area of
improvement, despite the fact that data leakage from databases account for a major part of data breaches. In this session will demonstrate and discuss security alerts, patch strategy, password protection and defense in depth at
database layer.
For mange er en BI-løsning synonymt med et avansert rapporteringsverktøy. Det er tilsynelatende også slik selgerne av BI-løsninger ser på verden. I dette foredraget setter vi blikket på hva som faktisk kreves av en komplett BI-løsning og dem som utvikler den. Hvorfor bør maskinvare, virtualisering, operativsystem, databaser, ETL, forretningslogikk og rapporter vurderes som en helhet? Vi vil definere behov og krav fra alle deler av organisasjonen. Fra IT-avdelingen til sluttbrukeren, fra A til Å.
This presentation will cover Real Application Testing new features for RDBMS 12. Best practices for Consolidation and workload scaleup.
Oracle Exalytics is Oracle’s hardware/software platform for “speed of thought” analysis. This presentation looks initially at the architecture and capabilities of Oracle Exalytics and then goes through the development of an Oracle Exalytics application sourcing data from structured and semistructured sources, analyzed with Oracle Business Intelligence and Oracle Endeca Information Discovery. Aimed at developers looking to leverage this new in-memory platform, the session provides an end-to-end overview for developing fast, interactive, and highly visual applications with these new BI tools.
Ofte nevnes MySQL som et godt alternativ til Oracle. Er det rettferdig å sammenlikne dem? Her ser vi nærmere på hvilke likheter og ulikheter som finnes mellom disse to produktene
Mobile internet traffic is growing rapidly, driven by strong growth in the mobile device market. The concept of “bring your own device” (BYOD) is a growing trend for business IT. Few things are more hot for consumers than tablet devices and smart phones. On the other hand, few things are more challenging for business IT than tablet devices and smart phones. How do you enable your business applications for the mobile universe? What is Oracle’s strategy and solutions for mobile enterprise IT? How can you leverage your existing knowledge in Java / ADF to build modern mobile solutions for the enterprise?
Even the most sheltered DBA will have heard that in 2008 Oracle bought BEA and, in doing so, made WebLogic, rather than OC4J, their primary Java application server. Why does this matter? Well, even if you're not responsible for running Oracle middleware, as a DBA you may well be expected to set up Oracle Enterprise Manager (OEM) Grid Control which these days runs on WebLogic.
This session will introduce the WebLogic architecture and all the key terms you need to know. It will then guide you through a typical installation, using OEM as an example, and compare the installations for 11g Grid Control and 12c Cloud Control (anyone for whom the term ""WDJ7"" brings dread can breathe a sigh of relief with 12c!).
Finally the presentation will outline how to manage WebLogic and where to look if things are going wrong.
"Application developers usually focus their efforts on languages other than SQL and PL/SQL most often writing in C##, Java, Ruby, Perl, and other languages. And, much of the time, they do not really understand the database with which they must work.
This one-day workshop will cover everything from architecture basic to advanced programming techniques and tuning to help application developers take maximum advantage of the database and to help them build high performance secure applications and avoid reinventing the wheel."
Attendees are invited to bring their own pre-configured RAC systems running on their laptops; created either by following RAC Attack (racattack.org) or any other approach. If you've had problem's getting RAC working then this session presents the perfect opportunity to get some help from experienced RAC specialist. If you haven't had problems then even better! You're in a position to really start making the most out of your RAC test environment. Martin & Martin will cover the configuration of Fast Connection Failover with UCP for Java clients and ODP.NET for C# clients from your host Windows machine or a Windows VM (the Java part can equally be completed on Linux or Mac machines/VMs). They will cover "service" creation, know problems and testing. You will be expected to perform some preparation work in order to get the most out of this workshop, however, if you don't have your own RAC environment or appropriate equipment to create one before the class access will be provided to a shared demonstration environment.
This session explains the new features and performance enhancements in the 5.6 MySQL Server release candidate.
Break free of any pre-conceived APEX limitations and learn how the latest APEX 4.x features will allow you to create rich forms-like APEX applications using the most advanced JavaScript UI Web development frameworks. Learn new design techniques for managing large numbers of plugins, handling inter plugin communication, and how to turbo charge your productivity.
It is becoming more and more common for businesses to have to hide certain data from certain users, often for regulatory or legal reasons. Virtual Private Database and Row Level Security are powerful but under-used, free tools within Oracle to do this and are in many ways better than using Views.I will describe and demonstrate the basics of setting up and using Row Level Security, how to hide whole rows and also specific columns in rows, some of the problems that can occur and an overview of how this was used in a real, recent project.
No Developer is perfect, and Murphy's law is bound to show up sooner or later (often sooner than later). Most applications today are n-tiers using a connection pool on the application tier, and are therefore very hard to trace. With a little bit of collaboration between developers and DBAs tracing can be turned on very easily for your specific application module, a specific user or IP, customer, or any other metric of your choice.
The latest generation of Oracle Database brings exciting new technology that enables you to manage many databases as “one” and enables you to consolidate more databases onto a particular platform than would otherwise be possible. It enables very fast provisioning of a new database, or of a clone of an existing database, and very fast redeployment of an existing database to a new platform, and it introduces mechanisms for rapid patching and upgrade of the Oracle Database software. This hands-on lab shows how to realize these benefits using Oracle SQL Developer, and SQL statements.
This presentation will be a live walkthrough on how you could implement and setup a test bench with Oracle Application Testing Suite, a rich and easy-to-use testing solution for on-premise or cloud applications. When initial testing and load testing is done you need tooling for monitoring and following messages and transactions even in heterogeneous environments with Oracle Business Transaction Monitoring (BTM). Part two of this session shows how BTM automatically discovers message flows and content and how it is used to monitor SLAs and find and follow messages.
The EXPLAIN command of MySQL has for long been a very useful tool for understanding how MySQL will execute a query. MySQL Release 5.6 offers several new additions that both give more detailed information about query plans, and makes the plans easier to understand.
One of the new features that will be presented in this session, is a new variant of EXPLAIN that provides a structured presentation of the query plan in JSON format. We will give several examples of how the new structured output will make it easier to understand MySQL's query plans.
While MySQL so far has only supported EXPLAIN for SELECT statements, MySQL 5.6 will also support EXPLAIN for INSERT/UPDATE/DELETE statements. This presentation will also give insight into how one can take advantage of this new feature.
Finally, we will give an introduction to MySQL Optimizer Tracing. This is an advanced tool that will not only present WHAT query plan has been selected by the query optimizer, but also give information about WHY this particular query plan was selected.
Since APEX 4.1 we've got the built-in feature of the Data Loader. This feature isn't widely used yet and that is a shame. In this session you will learn all the nifty features of this particular piece of APEX functionality. Afterwards you will be able to use it yourself, making your life a lot easier and your users a lot happier.
Åpning av konferansen ved Frank Vikingstad. Samt presentasjon av årets sponsorer.
From EasySQL to CPUs - Oracle's Journey through Software Security Assurance
In 1994, Oracle suffered its first known product vulnerability and reacted by sending a patch to every customer on tape or those new shiny CDs. But Oracle's dedication to security famously goes back to its first customer, the CIA. Nearly twenty years and several product acquisitions later, Oracle's approach to security assurance, the effort to make all our products secure and vulnerability free, is still rooted in that history of putting protection of its customers first. This presentation will run through that history, pick out specific lessons from Oracle’s Software Security Assurance program that can help you assess the maturity of your own security practices, and consider what’s coming for security assurance.
I run a software business, I help my wife raise three children, and I like to think. I especially like to think in metaphors—to learn in one area and then apply that knowledge in another area that seems completely unlrelated. Raising children and running a business put everything in my mind to use; in fact, the jobs push me beyond my own capacity sometimes. In this talk, I’ll share some of the ideas that I’ve learned about raising a family from running my business, and vice versa. I’ll talk about why thinking clearly is more important than the right answer, how testing in schools should be more like good software testing, and what I’ve learned about the pursuit of happiness.
This case study will describe how an unmanageable 14 hour data warehouse load process was converted to use native Oracle features to reduce the execution time to under half an hour. As well as looking at the well-known technical features used, the presentation will highlight the organisational and operational challenges of implementing a new approach in a large commercial organisation and explain how they were addressed. The focus will be delivering fast and resilient solutions to business requirements using features that most customers have already paid for but may be unaware of.
Exadata is targeted by Oracle at both data warehousing and OLTP. But what can you expect from Exadata in an OLTP environment? What are the strengths and weaknesses?
This session focusses on the different layers for data storage with Exadata, how to use them and what performance to expect.
The Oracle Exadata database machine is positioned as both a resolution for data warehousing and online transaction processing (OLTP). But does Oracle Exadata give you a 10x plus performance improvement in any case, and specifically with online transaction processing type queries? This session focuses on doing online transaction processing on Oracle Exadata with particular attention on doing logical IO using the Oracle buffer cache and on doing physical IO in which the function of the flash cache is shown. The last part covers writing on the Oracle database machine, which also is important for performing OLTP.
So, if you want to understand more of the performance implications of using Oracle Exadata for OLTP like databases, this is the session to go to.
Virtualisation technology has provided a fantastic opportunity for IT professionals to educate themselves on Oracle technologies with a trivial budget. Test environments are often scarce, but it doesn't have to be this way. There are many options available for virtualisation and the appropriateness of each depends on what you wish to achieve. Numerous examples of what can be built, tested and evaluated on laptops and low cost desktop hardware are covered.
This presentation provides a summary of the Service Design chapter of the upcoming SOA Made Simple book. Services are key a key aspect of any SOA. Once you have identified what services your clients require, you can start designing these services by designing their operations, and the input and output of these operations. Service design principles indicate what qualities a service needs to have in order to be a usable building block in the architecture you are trying to achieve. When services are poorly designed or poorly implemented, your solution architecture will probably have little value for the business as well. What we need are sound design principles that help us as a service provider to create (re)useable services, and help us as service consumer to judge if the services that we use (or want to use) are well designed ones. This presentation includes several service design principles and quality-of-service aspects that can be used as checklist when creating, buying, or reviewing services. Such design principles include isolation and idempotency. Most important is that services need to be easy to use, must provide value, and that they can be trusted by (future) consumers.
For those of us who've suffered through Sarbanes-Oxley audits in order to ensure regulatory compliance, we know how tedious and time-consuming point-in-time data access for reporting purposes can be.Furthermore, what happens when point-in-time events are recalled that are made erroneous due to data tampering? How do you prove that point-in-time data has been altered by a privileged user? If privileged users are able to change point-in-time data and ultimately rewrite history then a company may as well have no change tracking regulations in place at all.Using Oracle 11g's Flashback Data Archive, you can apply total point-in-time control to your sensitive data. With a new flashback data archiver process, you can mine undo data that the instance is already generating. There's no extra overhead affecting transactions against tables being archived.Additionally, little to no programming effort is required. Gone is the need to design your own archive tables, write your own code, and debug your own triggers. This presentation will compare the effort required to create and maintain an application using Oracle 11g's Flashback Data Archive with that of the same type of application that provides similar capabilities using a homegrown solution. Additionally, improvements for Oracle 11g's Flashback Data Archive as of 11gR2 will be highlighted.
Oracle Business Intelligence, a component of Oracle Fusion Middleware, brings a metadata layer, shared/user-defined calculation, interactive dashboards and visualizations, and connectivity to Oracle Essbase multidimensional analysis. It shares security, an Oracle Application Development Framework (Oracle ADF) development environment, and management tools with the rest of the Oracle Fusion Middleware suite, so BI can be embedded into applications, business processes, and portals. This session shows BI functionality’s use in Oracle Fusion Middleware applications and business processes and how BI dashboards and other visualizations can be used in Oracle ADF applications. You’ll see what works, what’s not quite there, and how Oracle uses integration capabilities in Oracle Fusion Applications.
Creating high-performance as an attribute of complex software is extremely difficult business for developers, technology administrators, architects, system analysts, and project managers. However, by understanding some fundamental principles, performance problem solving and prevention can be made far simpler and more reliable. This paper describes those principles, linking them together in a coherent journey covering the goals, the terms, the tools, and the decisions that you need to maximize your application’s chance of having a long, productive, high-performance life. Examples in this paper touch upon Oracle experiences, but the scope of the paper is not restricted to Oracle products.
Most presentations are about cool, new technology or great things people have done and want to brag about.This one is not. It is about when technology breaks, things go wrong or projects fail. It is all based on real experiences. Mostly my own. They say you learn from your mistakes and maybe I have. At least, I have never been sacked so far... This is a chance for you to also learn from my mistakes or, at least, laugh at them.
Real Application Clusters are not just about avoiding unplanned downtime. They also help a lot with planned maintenance like hardware and operating updates and rolling patches. With the right setup, administrators do not need to get up for maintenance windows in the middle of the night to apply patchsets anymore. Using the right planning and strategy, routine tasks can be dealt with while the database is up and running. This presentation walks through the proper setup of applications, implementation of services and shows how perform maintenance in such a way that applications and end users do not even notice.
In this presentation, I will explain the architecture from Database Service Cloud and delivering a "live"demo from tools within the Database Cloud.
- Restful Web Services
- Data Upload /Download to the Database Service Cloud by making use of Application Express and SQL Developer
Generally speaking “case management” relates to the handling of activities pertaining to “cases” where a case can be a customer request or a complaint, delivery of a patient-care, a complex document processing, a non-trivial decision making, and the like. Ability to perform case management well rewards companies with superior customer satisfaction and competitive advantage, and hence the constant pursuit to improve this ability. However, a general framework for case management is far from simple. Case-related activities may be automated or human-tasks or a combination. Exact steps leading to the end-goal (often a resolution) of case activities are often not known a priori; depending on the evolution of the context of the case different case workers may have to perform different set of tasks in sequences that may sometime be non-repeatable albeit with in some rules and guidelines. All-in-all case management involves high degree of collaboration and context-dependent actions of “knowledge workers” some of which may be ad-hoc thus distinguishing itself from conventional BPM. This presentation will describe, using concepts and examples, how Oracle BPM Suite leverages its advanced platform-level features to facilitate execution efficiency and improvement of a wide variety of case management types and styles.
The public face of Oracle’s product security is its quarterly security patches or Critical Patch Updates and the occasional Security Alert that fix vulnerabilities that are being actively exploited “in the wild”. As well as reviewing Oracle's product vulnerability handling practices, this presentation will explain the core elements and challenges of the less public but broader and more important Oracle Software Security Assurance program including:
Oracle Data Integrator er et allsidig produkt som kan brukes på mange måter.
I dette foredraget vil jeg vise hvordan ODI brukes til ETL. Fremgangsmåten for ETLutvikling med ODI skiller seg fra OWB og andre tradisjonelle ETL-verktøy. Jeg vil drøfte hvordan vi kan nyttegjøre oss av disse forskjellene til å heve kvaliteten på ETL-arbeidet og vise hvor effektivt og dynamisk vi kan utvikle i ODI, om vi bruker verktøyet riktig. Det hjelper lite å ha en hammer tilgjengelig når du trenger tang og i ODI kan vi skape oss en tang om behovet melder seg. Jeg vil også vise hvordan verktøyet kan tilpasses behovet og komme med konkrete eksempler på effektiv utviklingsmetodikk med ODI.
Historien om hvordan NAV skulle serve opptil 700 konsulenter med databaser. En kort presentasjon av et stort prosjekt for modernisering av
Software hos NAV. Prosjektert kommer til å gå over mange år og vil ha stort behov for databaser undeveis, for å kunne levere dette har NAV implementert Database-as-a-Service. Dette består av en portal for bestilling av databaser og Database pools for provisjonering av databasene.
Dette har automatisert og standardisert prosessen rundt laging av databaser enormt hos NAV.
The query optimizers job is to generate an efficient execution plan. In this presentation we will give an introduction to the main building blocks and strategies of the MySQL Query Optimizer.
Ny versjon er på gang! Hva bør jeg kjenne til? Foredraget dekker stort og smått som kan forandre DBAens sin hverdag.
Nøkkelord: EM Database Express, CDB/PDB, Unified Audit Trail, SYSBACKUP/SYSDG/SYSKM, Data Redaction, RMAN table recovery,Multiple indexes, Usynlige kolumner, DDL logging, Partielle indeks mm.
En gjennomgang av oppsett og bruk av funksjonalitet tilknyttet ʺSQL Plan Management. Praktisk bruk demonstreres.
e-vita has been involved in several Weblogic 12c-projects. We will in this presentation give you some of the learnings from those projects. All of the projects were based on existing Application Server 10g-solutions. You win some - you lose some. Weblogic Server 12c incluces much more functionality that OC4J, but the 10g Application Server also included many products in the stack: Webcache, LDAP(OID), SSO etc. This is all functionality that you need to handle in the new architecture also.
The SQL injection problem is solved! Why does this problem still exists? By examples in a web application the problem will be explained in detail.
The Oracle Advanced Analytics option comes with two powerful predictive analytics tools. This presentation will have a look at how to get started with predictive analytics using the work-flows based Oracle Data Mining tool. The presentation will take the form of a demonstration of the Oracle Data Miner tool. It will commence with an overview of how to get started and setting up the tool and the database for data mining. The main part of the demonstration will concentrate on using Oracle Data Miner to create a number of predictive data mining models. Once we have identified our perferred predictive more the presentation will conclude with a demonstrataion of how you can use this predictive model on new data.
This general session takes a look at what's been new in the last year in Oracle Database Application Development tools using the Latest Generation of Database Technology. Topics range from Oracle SQL Developer and Oracle Application Express to Java and PHP.
With the release of APEX 4.2 we can develop applications for mobile devices like we've never done before. In this session you will learn (and see) how to develop an application that doesn't only look awesome, but is also full of functionality. Forms, Reports, transitions, etc. : After this session you can build everything you've seen in a native application yourself!
This Presentation focuses on the Global Management of resources in a RAC environment. It covers Library Cache, Row Cache, Result Cache and Buffer Cache coordination and management, discussing the concepts underlying the the control of access to resources from multiple instances. The talk focuses most on buffer cache fusion for various scenarios involving read and write access to the same block from multiple instances
With Java EE 7 cloud should have been added to the specification. Allowing for a broad ecosystem of PaaS providers to jump on the train. Because of the missing maturity and field experiences this has been delayed to EE 8. However there are some offerings on the market already. This talk throws light onto how they differentiate from each other and which ones are the right ones for Java EE. Featuring: CloudBees, OpenShift, Elastic Beanstalk, Jelastic and Oracle Java Service.
Abstract
Oracle virtual assemblies provide a great way to simply the deployment of enterprise-classmulti-tier applications and their configuration dependencies. Oracle Virtual Assembly Builder11gR1 can create Oracle virtual assembly packages by capturing the state of an installedapplication topology. Oracle Enterprise Manager 12c can deploy these assemblies in the cloudresulting in fully operational application stack within minutes. This session will walk youstep by step through the Oracle virtual assembly creation process. Then we will discuss theconfiguration of an infrastructure cloud based on Oracle VM and Oracle Enterprise Manager12c Cloud Control and demonstrate how to use Oracle Enterprise Manager 12c Cloud Control todeploy an assembly on the Oracle infrastructure cloud.
What to learn:
1. How to deploy applications in virtual environment with Oracle virtual assembly
2. How to create/edit Oracle virtual assembly using Oracle virtual Assembly builder 11gR13. The configuration of Oracle infrastructure cloud base on Oracle VM and how to deploy anassembly in on the Oracle infrastructure cloud using Oracle Enterprise Manager 12c CloudControl
Deployment in a Service oriented environment is slightly more complicated because the endpoints and other settings need to be changed when promoting the components through QA, Staging and production systems. The Oracle SOA suite offers different mechanisms for different components: Configuration plans for SCA components and customization files for the OSB. You can either deploy an artifact manually, or script the deployment using ant or WLST. This session will discuss the different settings you can adjust in configuration plans and customization files, a way of organizing these files in different situations and the use of scripting versus manual deployment.
There are a number of ways of applying a data mining model, developed using Oracle Data Miner (ODM), in SQL and PL/SQL. This presentation will demonstrate how to deploy your predictive model in your production database. When deployed we can use now use the ODM predictive model in batch processing and on individual records, thus allowing you to integrate the use of ODM into your applications. The presentation and demonstration will also show how you can perform what-if analysis using the ODM predictive models.
Mission-Critical IT solutions is now Mission-Essential. Downtime means los of sales and los of productivity. Oracle Engineered Systems is faster, more reliable and easier to manage. Oracle provides a new model in IT Support; Oracle Platinum that monitor and update the systems for Customers. Platinum Support is delivered with no additional cost to Premier Support. Share Norwegian Customer experience with Oracle Platinum Support.
Customer quote:
“The platinum services offering have been a great addition to Oracle Premier Support. This level of support is unique in my experience. We saw results very quickly. Our experience has exceeded my expectations.”
Vincent Biddlecombe, Chief Technology Officer, Transplace
For the last 2 years there were very interesting developments in storage technology, mainly around what is called SSD. NAND-flash based storage promises huge benefits due to the absence of rotational latency. I/O patterns should also not matter much anymore. This talk presents PCIe Flash Cards, FC-attached Flash Arrays (Violin, Fusion IO) and Enterprise Flash Drives and their pros and cons.
A collection of hints, tips, tools, features and techniques that over the years I’ve either seen, built myself or simply stolen from somebody smarter than myself.
Presently cloud computing momentum is quite high and is projected to grow even higher in the forthcoming years. As the adoption of cloud computing increases so does the requirement of integration involving applications in the cloud. Application integration in the context of cloud computing introduces some newer challenges and resurrects some of the old ones. Clouds represent a highly distributed environment and an integration task may involve a combination of applications that live in the cloud as well those that run inside a company’s firewalls. The integration engine itself may either be on-premise or in the cloud. Many operational requirements such exception-handling, end-to-end transaction visibility, performance, transactionality, security, high-availability and security can be big concerns in integrations that involve multi-app, multi-cloud and on- and off-premise situations. This presentation will summarize the major integration patterns in the cloud computing context; identify key challenges and discuss possible remedial strategies including the use of applicable Oracle integration technologies.
The threat landscape is constant changing, how do we address the security challenge.
Data security should not be a one time exercise, but a integrated in the way we work. Oracle has developed an Security Reference Architecture and a set of security assessment processes, and the session will give an introduction to these concepts.
Many companies uses both Twitter and Facebook in their contact with the customers. Such social medias are unstructured data sources that ought to be taken in to the BI solution for analysis. Bicon therefore set up an Endeca POC for one of their customers, with focus on two things:
• Which possibilities will Endeca give the customer when it comes to analysing unstructured “big data”?
• How does Endeca fit in with the architecture of the existing Data Warehouse and BI environment?
The presentation will be split in three parts:
• The main focus of this presentation is to explain how Endeca fits in with an already existing BI and Data Warehouse environment, in such a way that Endeca becomes more of an extension – rather than an addition – to the BI landscape.
• The presentation will also talk about the technical part of loading “big data” from social medias.
• Finally, there will be a live demo of the end-user tool. The demo is based on one of the use-cases in the POC.
The trace files generated by setting event 10053 are usually considered some of the longest and least understandable that Oracle generates. However, they are sometimes very useful in understanding why the Cost Based Optimizer has produced what appears to be a bad execution plan and recent versions have become more readable. This presentation will give you a taste of the trace file contents and encourage you to use them when analysing SQL performance issues. - What they are and how to generate them- Why they are useful and mostly harmless- Walk-through of example trace files to highlight overall structure and useful sections- Examples of problems that you can identify using 10053 trace files”
This presentation focusses on multiblock reads, the IO method for full scans for every version of the Oracle database. Whilst being a very old and common IO method, different functionality of this method has silently been introduced with version 11 of the database. Also new functionality with multiblock reads have been made default behavior and available with version 11 and again with version 11.2.
In this presentation I will cover the basics of SQL tuning. I will talk about using and understanding Explain Plan and what the COST of a step or statement really means. I will show you SQL Monitor and what it adds to understanding the Explain Plan. HINTs will be covered and the ways to use indexes and partitions to aid SQL performance. I will also cover come of the information the CBO uses to understand your database and decide on the execution plan. No prior tuning knowledge is required but by the end of the talk I aim to have shown you enough to understand generally how the CBO works and how to understand the Explain Plan and spot when things are wrong.
Continuous integration is a well known aspect of Java development projects. Key here is automated testing of all parts of the solution, back-end as well as front-end. In this session you will learn how to use not only the already better known automated back-end testing facilities for PL/SQL, but also how to automate testing of your user interface. Using this approach you can execute regression tests,aiming at a reliable and stable outcome.
The next Oracle database technology brings a wealth of key features for Java developers.
In the first part of the session, Java developers will learn about new enhancements for Java in the database including: the ability to choose Java SE 6 or Java SE 7 at database installation or migration, customizing the default Java security, JNDI, and Java logging.
In the second part of the session, Java developers will learn about new JDBC and Universal Connection Pool enhancements including: support for latest Java/JDBC standards, extreme scalability with support for Database Resident Connection Pooling (DRCP), Application Continuity and Transaction Guard that mask outages and guarantee maximum availability by minimizing disruption to users in Oracle Real Application Clusters (Oracle RAC) and Oracle Data Guard environments, and improved manageability.
En vanlig problemstilling ved ETL-utvikling er hvordan man på en enkel og sikker måte kan identifisere nye, oppdaterte og slettede rader i kildesystemet. Dette, sammen med brukernes krav om sanntidsdata i datavarehuset, gjør Change Data Capture (CDC) til en stadig viktigere del av virksomheters ETL-strategi. Oracle har flere produkter som kan benyttes til CDC, bl.a. Oracle Streams, Oracle Data Integrator (ODI) og Oracle Golden Gate. Dette foredraget vil fokusere på hvordan de to sistnevnte verktøyene kan brukes i kombinasjon for å spore endringer i kildesystemet og laste disse inn i datavarehuset.
PCIe SSD is an enterprise class high performance storage device. It is built with SLC NAND flashand designed for applications that require low latency and high IOPs (IO Per Second) operation.OLTP database workloads which require very low storage IO latency with many small randomread/write IO operations are the ideal cases to use PCIe SSDs to improve the performance.To understand how much PCIe SSDs can really improve OLTP database performance andthe related best practices, we have done a series of performance studies of using PCIe SSDfor various Oracle database configurations including PCI SSD as Oracle smart flash cache.This studies are based a single node Oracle 11g R2 database as well as a two node 11gR2Oracle Real Application clusters (RAC) database with Oracle Enterprise Linux 6.2 platform.This presentation is to examine each of these case studies and the compare the performanceimprovements of these cases.
What to learn:
Introduction to Solid State Disk technology and PCIe SSDs and their IO performancecharacteristics2. Use cases of using PCIe SSDs for Oracle database and the Performance analysis of the usecases3. The recommended best practices of using PCIe SSDs for optimizing Oracle databaseperformance
1.
Oracle Database Release 11.2.0.2 introduced several new features directly related to parallelization of SQL statements, including Auto Degree of Parallelism (ADOP) and In-Memory Parallel Execution (IMPE). Oracle DBA and Oracle University instructor Jim Czuprynski will demonstrate how to implement these latest parallelism features to provide maximum performance benefits - for DML as well as queries - within your Oracle 11gR2 database environments.
Through presentations and online demonstrations, this session will:
- Explore the new parallelism features, especially ADOP and IMPE, in Oracle Database 11.2.0.2
- Explain how to implement the appropriate initialization parameters, hints, and object decoration to influence parallelism for maximum effectiveness
- Demonstrate how to use the feature set of the DBMS_PARALLEL_EXECUTE package to apply these new parallelism features to DML statements
1. Parallelism in Oracle 11.2.0.2: A Whole New Ballgame
2. Object “Decoration”
3. Policies for Parallelism
a. PARALLEL_DEGREE_POLICY and PARALLEL_MIN_TIME_THRESHOLD
b. PARALLEL_THREADS_PER_CPU
c. PARALLLEL_TARGET_PERCENTAGE and PARALLEL_DEGREE_LIMIT
d. PARALLEL_SERVERS_TARGET and PARALLEL_QUEUE_TIMEOUT
4. Putting It All Together: Some Practical Demonstrations
5. Parallelizing Batch Operations
a. DBMS_PARALLEL_EXECUTE
b. “Chunking” Batch Operations in Parallel
6. Monitoring Parallel Execution
7. Conclusions
With every new release of the Oracle Database the majority of new features are not discussed by Oracle. This presentation will focus on those new features that are included in the base release and show, live in SQL*Plus, how to get maximum value from upgrading to version 12c.
There is a growing need to apply MapReduce analytics techniques to business data stored in RDBMS however, data shipping from RDBMS to a Hadoop cluster is generally a bad idea with lot of issues. How about bringing MapReduce/Hadoop to the RDBMS instead? There are many initiatives and projects in this area. The next release of Oracle database plans to furnish In-Database MapReduce. This session describes the implementation of a database resident Hadoop container, built-in the Oracle database RDBMS engine, which lets you drop-in and run Hadoop Mappers and Reducers directly against RDBMS tables. The major benefits of this implementation are: source compatibility with Hadoop, minimal dependency on Hadoop infrastructure, Java and SQL interfaces.The seamless integration of Hadoop MapReduce steps in SQL statements and OLTP, ease of development, deployment and administration (any DBA can deploy MapReduce/Hadop jobs).Furthermore MapReduce and Hadoop jobs running in the database get all the quality of services of the Oracle RDBMS and Exadata such as enterprise class security, data compression, and many more.
The latest generation of database technology brings PL/SQL enhancements in these categories: transparent performance improvements; new PL/SQL language features for better performance, new functionality, and improved programming usability; and new supplied package APIs. This session will explain improvements in PL/SQL-to-SQL interoperability, improvements in how PL/SQL subprograms can be invoked from outside of the database, new constructs to improve modularization, and new APIs to assist tracing and the diagnosis of run-time errors. Other improvements will also be described.
Note: Session 60 minutes
Lunch på egenhånd!
(Lunch on your own!)
We'll be taking a look at the Latest Generation of Database Technology and zeroing in on 12 high impact capabilities, looking at what they are and why they are relevant.
Oracle Strategy linked with global and local trends. How does the Oracle BI portfolio answer these trends and how do customers use them to adress new demands?
Observations from the Norwegian market – what are the main criteria of success in the eyes of the Oracle BI Team?
An australian client recently completed a migration of an extended distance RAC cluster from version 11 to 11.2 of Oracle database, in order to gain access to many of the new features and facilities offered in 11.2. This session details the challenges, the achievements, and the steps taken along the way in order to successfully migrated to the latest version of the Oracle database.
Abstract
Today in a database cloud that consolidates a large number of databases with different SLAs, anyunplanned outage can be devastating and a small planned downtime may not be acceptable. Theinfrastructure high availability becomes extremely critical to a database cloud. This session willstart with the system architect design and discuss the various techniques and options to achievethe high availability such as Oracle Clusterware/RAC, Data Guard and Oracle MAA. Then itwill explore the configuration best practices to ensure fault tolerance of the entire stack of theinfrastructure. It will also discuss the methods to reduce downtime during events like systemupgrade and migration and the troubleshooting during system outage.
What to Learn:
1. The high availability infrastructure architecture design: technologies and options
2. The configuration best practices of a high availability database cloud infrastructure3. How to reduce outage in operation or during system upgrade, migration and troubleshooting.
Learn how you can use Oracle Total Recall to easily access historical data in your applications. This presentation starts with a basic overview of Total Recall and Flashback functionalities and how developers and ISVs can use it in their applications including an introduction to the basic syntax of flashback queries. The second part of the presentation focuses on the inner workings of flashback archives, how Oracle makes use of partitioning and compression to achieve a great level of performance for these types of queries. Lastly, I will talk about best practices when dealing with flashback enabled tables like setting up testcases, exporting historical data to development databases, performing DML on those tables and other issues we have come across in the last two years.
As Oracle developers, we used to have only a hammer (Oracle Forms), so everything looked like a nail (a job for Oracle Forms). Today, we have both Application Express (APEX) and Application Development Framework (ADF), so we have to make a choice.The tool discussion tends to get bogged down in the relative merits of PL/SQL or Java, but this presentation will show that another important factor that should influence your tool choice is whether your application is user interface driven or data driven.- A data-driven application is one where the data structure determines the user interface. These applications are well suited for a wizard-driven, browser-based approach as used in APEX.- A user interface driven application is one that starts from a set of requirements to support a work process. This type of application is typically specified with detailed screen designs that are easier to implement with the flexible architecture of ADF.See this presentation to learn to recognize the different types of applications so you can choose the right tool.
Prior to the next database release (planned for 2013 calendar year), Fast Connection Failover and TAF allow failing over connections and queries but do not guarantee transaction outcome, failover transactions, or mask outages.
This session covers new upcoming Oracle database availability features including Transaction Guard for checking and guaranteeing transaction outcome, Application Continuity for attempting to mask outages by failing over connections and replaying session contexts, queries, transaction (DML), DDL, and so on) by failing over and session context replay handling outages. DBAs and Developers will learn how to setup and leverage these features for maximum application availability.
The Java EE 7 platform has a changed scope and will now be focusing on Productivity and HTML5. JAX-RS 2 adds a new Client API to invoke the RESTful endpoints. JMS 2 is undergoing a complete overhaul to align with improvements in the Java language. Long awaited Batch Processing API and Caching API are also getting added to build applications using capabilities of the platform itself. Together these APIs will allow you to be more productive by simplifying enterprise development. WebSocket attempts to solve the issues and limitations of HTTP for real-time communication. A new API is getting added to build WebSocket driven applications. Processing JSON structures is inherent in any HTML5 applications and a new API to parse, generate, transform, and query JSON is being added to the platform. JavaServer Faces will add support for HTML5 forms. There are several other improvements coming in this latest version of the platform. The Java EE 7 platform is scheduled to release in Q2 2013. Some of the implementations are already integrated in GlassFish. This talk will provide a code-intensive introduction to the updated Java EE 7 platform. Several live demos will be shown during the talk. Don't miss out on this session to learn all about how to leverage the new and exciting standards in building your next enterprise application.
Oracle Business Intelligence Foundation Suite inneholder en rekke integrerte verktøy. Det er imidlertid mange av disse verktøyene som ikke blir brukt så mye som de kanskje burde. Foredraget vil vise hvordan man kan være opportunistisk ved å bruke deler av funksjonaliteten, og ikke nødvendigvis alt.
Foredraget vil ta for seg praktiske eksempler (live demo) på hvordan man kan utnytte skjulte perler i OBI Foundation Suite.
First there were the v$ and x$ views. And tkprof. Then came bstat/estat, Statspack, ASH, ADDM, OEM, and plenty of third-party tools that look kind of like those tools. There are loads of OS tools too that have been around a long time, like top and sar and strace and pstack and gprof. And then there are the methods: OPIM, and YAPP, and Method R to name three. In this presentation, Cary Millsap gives a brief tour of the moving parts and reveals his own perspective about how all these parts should fit together.
This presentation will give an introduction to the architecture of MySQL. We will also give examples of different application areas where MySQL is used. The focus will be on aspects of MySQL that differs from traditional relational database systems like Oracle.
Oracle’s Unbreakable Linux Network (ULN) is a database application. It is the application that people who have purchased support for Oracle Linux and Oracle VM can use for obtaining rpms, subscribing to non-default channels, downloading errata, requesting Ksplice access, and managing multiple registered servers and CSIs while being guaranteed a certain level of support when and if things go wrong. This application, like many other database applications, has been built with multiple parts, both new and legacy. It is an amalgamation of C, Python, Java, PL/SQL and APEX using Oracle Linux, because using each helps accomplish something that assists the overall application in the long term. Does this sound like a familiar scenario? If so, you are in a common situation. And if not, you are probably one of those unfortunate IT staff members caught in a programmatic ideological war that serves the needs of the programmers more than that it serves the purpose of the actual application(s) currently being planned or worked upon.
This presentation is not so much about what ULN is or does, as an application, so much as it is about what each developer and DBA goes through when building and deploying a multi-piece application that must be maintainable, scalable, and globally available on a 24x7 basis.
When you are tasked to create an application the questions you should ask yourself are: How quickly can I reasonably build this application? How simply? How can I ensure maintainability? How can I assist scalability? How can I best serve the needs of my users in terms of reduced downtime? How flexible should I be towards different ways of accomplishing various development tasks? What is my budget and set of resources? And (perhaps, most importantly) when should I opt not to reinvent the wheel?
This presentation provides a case study overview using the ULN application through lecture and sample code. Topics to be discussed are:
• What legacy code was inherited and what was done with it? Why?
• In what ways are the multiple selected programming languages used to accomplish various ULN tasks? What problems do they avoid and what processes do they assist?
• How is the constant worry of seeking reduced downtime made easier?
• What sets of choices can be made given budget, resource and time restrictions (all rolled into the above)?
• How do you not allow these choices to ultimately impede sound application design?
This presentation addresses these questions and provides a case study overview through lecture and sample code.
This presentation assumes that you are considering or have already chosen Oracle Application Development
Framework (ADF) to build your enterprise application. The actual development work is the topic of countless
demos and tutorials – this presentation will cover ten tips to make your
enterprise ADF project a success. Topics covered include:
1 Component Catalog
2 Expectation Management
3 Proof of Concept
4 Application Architecture
5 Using ADF Extension Points
6 Development Wiki
7 The Nutcracker Role
8 Version Control
9 Build tools
10 ADF Logging
Keep these 10 tips in mind to avoid common mistakes and make your ADF project successful
The very latest release of Oracle Database brings exciting new technology that lets you manage many databases as “one”, and lets you consolidate more databases onto a particular platform than otherwise would be possible. It allows very fast provisioning of a new database, or of a clone of an existing database, and very fast redeployment of an existing database to a new platform; and it introduces mechanisms for rapid patching and upgrade of the Oracle Database software. Moreover, it lets you separate of the duties of the application administrator from the duties of the administrator of the Oracle-supplied system. The session will explain how this new technology works.
This session is a full on hacking session that complements Frits’ other session, About Multiblock Reads. It will cover the intricate task of how to perform advanced profiling of Oracle using function calls. Come learn how to research the Oracle database using function names on Linux X86_64. You will leave the session with valuable knowledge of the inner workings of not just the Oracle database, but any C program. This session will introduce you to how to setup and use your Linux environment for profiling. As there are no slides, you will find great value in the notes your take—so bring paper and pen!
There are very substantial benefits that can be leveraged by organizations that create a database infrastructure based on Oracle Database Appliances (ODAs) and ZFS Storage Appliances.
This presentation will focus on the real-world deployment of these technologies by one of the world's largest retailers and the benefits seen in cost, performance, and stability,
The new Oracle Cloud offering has been launched at last year's OpenWorld. Now it is finally time to get your hands dirty and learn everything you need to know to develop your own applications for Oracle's Java Service.
This presentation provides a case study for a Dutch government project in which the Oracle B2B adapter is used. Dutch government reference architectures prescribe WUS (Web Services based on SOAP and WSDL) and ebMS as standards for electronic message exchange between government organizations. OLO is a government facility that citizens and enterprises can use to request permits. OLO forwards these permit requests to applicable governments using ebMS. The case study presents on the integration of a Dutch province with OLO based on the ebMS protocol. The Oracle B2B adapter is used for this. The presentation dives into the specifics of ebMS, and the capabilities of Oracle B2B. We will then present on the steps that are required to configure B2B, and how to integrate B2B with Oracle Service Bus and SOA Suite. After this presentation you will know how you can use B2B and how to integrate it with your SOA landscape.
Når er databasen og systemet ditt sikkert nok? Hvilke spillregler bør følges for å gjøre systemet robust. Jeg bruker Oracles dokumentasjon 2-day Security Guide som utgangspunkt til denne presentasjonen.
