Feed aggregator

Corente DataCenter Setup

Pat Shuff - Tue, 2016-09-20 10:55
Yesterday we went through the theory of setting up a VPN to connect a subnet in our data center to a subnet in the Oracle Cloud. Today we are going to go through the setup of the Corente Gateway in your data center. We will be following the Corente Service Gateway Setup. Important, this lab has problems. Corente does not work with VirtualBox.

The first step that we need to do is ensure that we have a Linux server that we can install the services on in our data center. We will be installing these services on an Oracle Linux 6.7 release running in VirtualBox. To get started we install a new version from an iso image. We could just as easily have cloned an existing instance. For the installation we select the software development desktop and add some adminstration tools to help look at stuff later down the road.

According to the instructions we need to make sure that our user has sudo rights and can reconfigure network settings as well as access the internet to download code. This is done by editing the /etc/sudoers file and adding our oracle user to the access rights. We then run

modprobe -v kvm-intel
egrep '^flags.*(vmx|svm)' /proc/cpuinfo
to verify that we have the right type of virtualization needed to run the VPN software. It turns out that VirtualBox does not support nested virtualization which is needed by the Corente software. We are not able to run the Corente Gateway from a VirtualBox instance.

We need to follow a different set of instructions and download the binaries for the Corente Gateway Services - Virtual Environment. Unfortunately, this version was depreciated in version 9.4. We are at a roadblock and need to look at alternatives for connecting Corente Gateway Services from out sandbox to the Oracle Cloud.

I debated continuing on or showing different failed paths in this post. I decided that showing a failed attempt had as much value as showing a successful attempt. Our first attempt was to install the gateway software on a virtual instance using VirtualBox since it is a free product. Unfortunately, we can't do this since it does not support passing the virtual interfaces from the Intel Xeon chip into the guest operating system. The second attempt was to go with a binary specifically designed to work with VirtualBox and load it. It turns out that this version was decommitted and there really is not solution that works with VirtualBox. Tomorrow we will look for alternatives of running the gateway on a native Windows host and a MacOS host since I use both to write this blog. Installing a gateway on a physical host is not optimum because we might need to reconfigure ethernet connections. My preference is to stay in a sandbox but setting up an OracleVM server, VMWare server, or HyperV server would all be difficult at best. An alternative that we might look at is setting up our gateway server in another cloud instance and connecting one cloud vendor to another cloud vendor. It all depends on who exposes the hardware virtualization to their guest instances. More on that tomorrow.

Get Ready for the Hottest, New Machine Learning and Data-Powered Apps

Linda Fishman Hoyle - Tue, 2016-09-20 10:37

A Guest Post by Oracle Vice President Melissa Boxer (pictured left) 

Have you ever wondered how Pandora, Netflix, and Uber make it possible for you to create personalized music sets, find movies worth watching, or get from point A to B? These services are all powered by sophisticated machine learning algorithms that continuously learn about you—delivering what you need most, just when you want it.

A New Category of Apps

Now you can get the same amazing experiences with Oracle Applications. We are announcing a powerful new category of decision science and data-driven apps at OpenWorld that add value to our CX, HCM, ERP and SCM cloud applications.

You may have heard competitors announce product strategies with character names like Watson, Holmes, or Einstein. The difference between them and us is that we’re delivering real software and real apps, not just smart-sounding platforms that require customers to build solutions from scratch. Instead, Oracle is taking an applications-first approach in order to provide immediate value to our customers.  (Genius, I know.)

Intelligence Powered by Data

The key to these new apps is that they’re powered by enormous amounts of consumer and business data from Oracle’s Data Cloud—anonymized, of course. Data Cloud has over five billion profiles, 45,000 attributes, and reaches 90 percent of US online audiences with an active digital ID. The combination of data and decision science provides tremendous insight about an individual and others like them within a given context (e.g. temperature, location, social activity, and more). This means they can deliver smarter results at an individual level.

Adaptive and Continuously Learning

These apps are also adaptive. They continuously react, learn, and adapt to your changing needs and patterns. Let’s say you’re a regular coffee drinker and go to your neighborhood cafe every day. Wouldn’t it be nice if, on a hot day, your local coffee house sent you an offer for an iced coffee instead? That’s a smart app—understanding what you like and taking into account the context to make a highly personalized offer. And, the app will learn from your response and deliver something even more personalized the next time. This is just one example of the many ways these apps can be used across different domains and industries.

I feel strongly that Oracle is poised for incredible success as both a category maker and category leader in this emerging space. We have the largest data exchange, most complete applications portfolio, best decision scientists, and the first and only applications-first approach. No other vendor can touch that.

At OpenWorld, Vice President Jack Berkowitz and SVP Clive Swan (head of the AI team) will present a session entitled From Netflix to the Enterprise [CON7023] on Tuesday, September 20, 11:00 – 11: 45 a.m. in Moscone West, Room 2012. They will be showcasing all of our apps across CX, HCM, SCM, and ERP and reviewing our product architecture and roadmap.

 You can refer to the press release for more information. 

Oracle 12cR2 Optimizer Adaptive Statistics

Yann Neuhaus - Tue, 2016-09-20 10:13

When 12.1 came out, the major issue we encountered after migration was related to the new adaptive features of the optimizer: automatic reoptimization, SQL Plan Directives and the resulting dynamic sampling. Of course, Oracle product managers listen to feedbacks, ensure to provide workarounds or fixes and make things better for next release. Let’s see what has been announce on this topic for 12.2

Fixing vs. workarounds

Unfortunately, in most case, when a problem is encountered people put priority on it only until the issue appears as “solved”, and then close the problem. However for stability and reliability, this is not enough. There are two phases in problem resolution:

  1. Make broken things working again as soon as possible
  2. Ensure that the solution addresses the root cause and is in the same scope as the problem

If you stop after the first point, you don’t have a solution. You have a workaround, and two things will happen soon or later:

  • The problem will come back again
  • New problems will appear as side effects

So, when you upgrade to 12c from for example, the easiest way to fix a regression is to set optimizer_features_enable=’′. But when you do that, you did only the first step. Nothing is fixed. Actually, when doing that you didn’t even finish your upgrade job.
I’ve already blogged about how to fix an adaptive statistics issue and keep the fix in the same scope as the problem by:

so there are many combinations that depend on your context.

One parameter do not fit all

It’s easy to disable all new adaptive features and claim that the 12c optimizer is full of bugs. However there are two things that I’m sure:

  • The developers of the optimizer know their stuff at least 100x better than I do
  • They want to bring nice features rather than trying to break things

And they do something very nice: each individual feature can be enabled or disabled by a parameter. So there are lot of parameters. Some of them are undocumented just because at release time they don’t think they should have a different value other than default, except special situations guided by the support. But one set of default value cannot fit all environments. Are you doing OLTP or BI? OLTP likes stability, BI likes adaptive optimization. And probably your database has both OLTP and reporting workloads, and maybe at the same time. This is the first reason why one set of parameter cannot fit all. There’s another one you should think about before blaming the optimizer. Maybe they bring features that helps to make good applications even better. Maybe the set of default value is not chosen to fit the worst application design…
Let’s come back to the OLTP vs. BI example. Adaptive features are enabled by default for BI. You may spend more time on parsing in order to get the optimal execution plan. But then you complain that your OLTP spends more time on parsing… But you are not supposed to parse on OLTP! The overhead of adaptive features should not be a blocking problem if you parse your queries once and then execute them.

I tend to blog on encountered issues rather that on thinks that do not raise any problem. Because my job is to solve problems rather that stay looking at what works well. I’ve encountered a lot of issues with those adaptive features. But I have seen lot of application that had no problem at all when upgraded to 12c. When you disable the adaptive features, do you workaround an optimizer problem, or your application design problem?


In 12.1 only optimizer_adaptive_features is documented but it disables too many features. You may want to disable SQL Plan Directive and their consequences. But you probably want to keep adaptive plans as they are awesome and less prone of bad side effects. So in 12.2 this parameter has been split into two parameters: OPTIMIZER_ADAPTIVE_PLANS and OPTIMIZER_ADAPTIVE_STATISTICS

In addition to that, only OPTIMIZER_ADAPTIVE_PLANS is set to true by default. OPTIMIZER_ADAPTIVE_STATISTICS is false so by default you will not have the following 12c features: SQL Plan Directives, Statistics feedback, Performance feedback, Adaptive dynamic sampling for parallel query.

Here are the features enabled by OPTIMIZER_ADAPTIVE_PLANS:

optimizer_adaptive_plans TRUE FALSE _optimizer_nlj_hj_adaptive_join TRUE FALSE _px_adaptive_dist_method CHOOSE OFF _optimizer_strans_adaptive_pruning TRUE FALSE

If you want more information about them, I’ve written articles about adaptive join, adaptive PX distribution and adaptive star transformation bitmap pruning

Here are the features enabled by OPTIMIZER_ADAPTIVE_STATISTICS:

optimizer_adaptive_statistics FALSE TRUE _optimizer_dsdir_usage_control 0 126 _optimizer_use_feedback_for_join FALSE TRUE _optimizer_ads_for_pq FALSE TRUE

As you can see there is no “_optimizer_gather_feedback” here so the cardinality feedback coming from 11g is still there when you disable adaptive statistics. You may like it or not, and maybe want to disable cardinality feedback as well if you don’t want plans that change.

What if you already have some SPDs? as “_optimizer_dsdir_usage_control” is 0 they will not be used. And they will be dropped automatically after 53 weeks of no usage.


Cet article Oracle 12cR2 Optimizer Adaptive Statistics est apparu en premier sur Blog dbi services.

#OOW16: Session Preview: Cox Reimagines its Digital Workplace with Oracle WebCenter Portal

WebCenter Team - Tue, 2016-09-20 09:22

Here we are at day 2 of Oracle OpenWorld and we want to be sure you don't miss this session tomorrow with Cox Communications and Oracle Partner Fishbowl Solutions! We'll have a recap of the last few days tomorrow up on the blog.

Authored by Jason Lamon, Product Marketing Manager, Fishbowl Solutions

The promise of a digital workplace, one where employees from any location can connect with others, access applications, and find job-related information, has been a major reason why organizations have turned to enterprise portals. However, portals sometimes fail to fulfill on that promise and miss expectations because technology and features receive the focus instead of what users need from the portal. 

Cox Enterprises had this in mind when they launched their digital workplace initiative back in 2014. This initiative was targeted towards improving those information systems that Cox’s 60,000+ employees were currently or would be using most frequently to get their jobs done while enabling them to do their best work. As part of this initiative, Cox invested in WebCenter Portal as the platform to integrate systems and applications that employees needed to do their jobs, while improving the overall user experience through personalized content and mobile access. WebCenter Portal was targeted to be the system that would bring together the best in mobility, collaboration, personalization, and user-generated content to create a true, digital workplace where employees are productive and engaged. Overall, Cox’s portal objectives were:

  • Provide a gateway to knowledge resources and collaboration
  • Create a “one-stop shop” for information
  • Provide a single employee experience
  • Further leverage and extend WebCenter Portal and Content investment 

If you would like to hear directly from Cox Enterprises on the process they went through to realize their portal vision with Oracle WebCenter, make plans to attend this session: Cox Enterprises Reimagines Digital Workplace with Oracle WebCenter, which takes place on Wednesday, September 21st at the Marriott Marquis - Golden Gate C3. In this session, you will hear from Dave Longacre (senior management application integration) and Christine Chen (senior product manager) as they detail how the company’s initiative for a digital workplace has started to come together with WebCenter. Christine and Dave will share Cox’s overall vision for their digital workplace, how portal technology is used to integrate their collaboration and identity management systems, as well as the various activities that had to take place – from portal design and user journey mapping to content and collaboration integration – to achieve their objectives.

Fishbowl Solutions is privileged to be the WebCenter partner involved with Cox’s project, and Ben Evjen of Fishbowl will also participate in the presentation and provide more technical detail regarding constructing the portal for Cox’s digital workplace use case. We hope you will be able to join us.

Oracle Empowers Cloud Developers

Oracle Press Releases - Tue, 2016-09-20 07:02
Press Release
Oracle Empowers Cloud Developers New tools, services and initiatives support open, modern and easy cloud development projects

JavaOne, San Francisco, Calif.—Sep 20, 2016

Extending its support for the developer community, Oracle has unveiled the next generation of Cloud services and development tools at JavaOne 2016, as well as a range of developer-focused initiatives. By giving developers a choice of programming languages, databases, compute types, operating systems and virtual machines, integrated development environments (IDEs) and tools, Oracle provides developers with the choice and flexibility needed to quickly and easily build modern applications in the Cloud.

As Cloud deployment becomes the norm for enterprise workloads, developers need to build applications using microservices, APIs, containers, DevOps processes and platform capabilities that support analytics, integration, mobility and the Internet of Things (IoT). Oracle has enhanced its development tools and Cloud services, and introduced other new initiatives in order to give developers friction-free, instant and immersive access to the latest technologies in the Cloud.

At JavaOne 2016 in San Francisco, Oracle showcased major enhancements to the Java Platform and the introduction of MySQL, the world’s most popular Open Source database, to the Oracle Cloud Platform. In addition, Oracle shared details on new Oracle Cloud Platform services that are specifically designed to support developers, and launched a new Web portal, developer.oracle.com, that provides developers with a single place to find the tools, technologies and resources needed for any development project that uses Oracle technology.

Extended Commitment to the Java Platform

To help developers meet the demands of new cloud-based models, Oracle continues to work closely with key partners in the Java ecosystem to drive significant evolution of the Java platform.

Java Platform, Standard Edition (SE) 9 will include new capabilities as well as updates that support the latest development standards and specifications. Project Jigsaw will help developers make applications more scalable, more secure, faster and easier to maintain, while JShell will make it easier for developers to run and test snippets of code. Oracle continues to work closely with the OpenJDK Community to lay the groundwork for Java SE 9. More than 500 companies, organizations and individuals now contribute to the OpenJDK project and well over seven million lines of code have been developed.

Java Enterprise Edition (EE) future versions will support delivering an enhanced model for reactive programming that helps developers build large-scale distributed systems, which are built asynchronously, are loosely coupled and are event based. In addition, future releases will include multitenancy in Cloud environments and improved security, including support for new authentication models such as OAuth and OpenID Connect. Support for multitenancy in Cloud environments will also be part of the proposal, and a new configuration model supporting Docker and other container technologies will be introduced.

  • "We welcome the announcement of Java EE 8 for the Cloud and microservices," said Mitsuharu Nagayama, senior director of big data solutions and services of Hitachi. "Hitachi contributes to society through the Social Innovation Business. Cloud and microservices that activate IT assets are very useful to enable the realization of this. We are anticipating the continuous evolution of Java EE to provide these benefits."

  • "The move to Cloud has become a powerful trend among Fujitsu's customers," said Hideki Nozaki, vice president of application management middleware division at Fujitsu Limited. "With this major update to Java EE 8 focused on cloud and microservices, Fujitsu looks forward to providing its customers an update to its Java EE compatible Interstage application server, thereby simplifying their shift to the Cloud. We continue to work with the Java community to develop technologies that benefit society."

  • "We welcome Oracle's effort to leverage enhancements for cloud computing to Java EE 8,” said Nobuhiko Kishinoue, general manager of the cloud platform division at NEC Corporation. "NEC has successfully provided a Java EE compatible application server, WebOTX, providing mission critical web application infrastructure to Japan and other markets for more than 18 years. Recent movement to cloud computing including container and microservice technologies has a strong impact on enterprise systems. Oracle's new proposal enables us to help our customers transition to the cloud seamlessly, while preserving their existing investments in Java EE."

New Data Management Capabilities in the Cloud

Helping developers innovate and carry out digital transformation initiatives, Oracle launched Oracle MySQL Cloud Service. Built on the proven MySQL Enterprise Edition and powered by the Oracle Cloud, Oracle MySQL Cloud Service provides a simple, automated, integrated and enterprise-ready cloud service that enables organizations to securely and cost-effectively develop and deploy MySQL-based applications globally at scale.

The launch of Oracle MySQL Cloud Service brings the world’s most popular open source database to the Oracle Cloud Platform and extends the complete suite of cloud services that Oracle provides to help organizations rapidly build and deploy rich applications. Developers and Independent Software Vendors (ISVs) can rely on the most comprehensive MySQL offering in the cloud, with advanced features, tools and support to accelerate the time to market of their new modern applications.

In addition, Oracle is introducing Oracle NoSQL Database Cloud Service and Oracle Exadata Express Cloud Service. Oracle NoSQL Cloud Service provides a high performance, key-value database supporting JSON, Java, Node.js and Python developers for transactional and Big Data applications. Oracle Exadata Express Cloud Service provides low cost, fully managed access to Oracle Exadata.

New Cloud Platform Capabilities for Developers

Extending its commitment to helping developers build and deploy rich applications in the Cloud, Oracle has extended Oracle Cloud Platform with new Oracle Cloud Platform Services and major new enhancements to Oracle Infrastructure-as-a-Service (IaaS). New and enhanced Cloud services to support developers include:

  • Oracle Application Container Cloud Service: Now includes PHP native runtime support to help developers quickly deploy, run and scale PHP web applications in the Cloud.

  • Oracle API Platform Cloud Service: Enables developers to create, secure and manage APIs (for API first applications such as those built using microservices) with zero code and end-to-end transaction insight. The innovative new service will enable developers to run an API gateway either on-premises, within the Oracle Cloud, or on third-party cloud platforms.

  • Oracle Mobile Cloud Service: Now includes support for chatbots that deliver intelligent and contextual conversations across multiple messaging channels, enabling developers to enhance the user experience on mobile apps.

  • Oracle Container Cloud Service: Expands Oracle’s support for Docker containers by enabling developers to easily run, orchestrate and manage containers in the Cloud. Oracle now offers pre-built containerized images for its products to help developers adopt Oracle technologies inside containers for development, testing and production environments.

  • Oracle Solaris: As a member of the Open Container Initiative, Oracle highlighted how it will be bringing native Docker support within Oracle Solaris. Containers will leverage Solaris key features such as security, efficient virtualization, ZFS cloning, smart file system and multi-platform compatibility for both SPARC and x86 systems.

New and Extended Developer Community Initiatives

Reinforcing its commitment to working with the developer community, Oracle is launching a number of developer-focused initiatives at JavaOne 2016. They include:

  • New Developer Roadshow: Beginning in January 2017, Oracle will launch Oracle Code, a developer roadshow that will include technical sessions, hands-on labs and interactive experiences. Events are planned in 20 cities including San Francisco, Sao Paulo, Bangalore and Prague. 
  • New Developer Portal: The new developer.oracle.com will direct users to free trials, downloads, documentation, tutorials, an extensive list of developer tools and resources, and an active community of users. 
  • Oracle Academy: Engages educators and more than three million students in 110 countries annually in computer science (CS) education and activities. By supporting the White House’s CS for All and Let Girls Learn initiatives, Oracle encourages a diverse range of students to become tomorrow’s technology innovators, developers and coders.
  • Oracle Cloud Marketplace: Provides quick and easy access to 450 OSS tools, frameworks and platforms that developers can use to build on Oracle Cloud Platform.
  • Oracle Technology Network (OTN) Summit: Oracle will continue to offer the OTN Summit, a virtual event series that brings together Oracle presenters with Oracle ACEs and JavaChampions to deliver hands-on-content. Content on demand is available here: community.oracle.com/community/technology_network_community/OTNSummit/
Contact Info
Simon Jones
Oracle PR
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Simon Jones

  • +1.415.856.5155

Oracle Unveils Low Code Platform to Easily Extend SaaS Applications

Oracle Press Releases - Tue, 2016-09-20 07:00
Press Release
Oracle Unveils Low Code Platform to Easily Extend SaaS Applications Visual application development platform enables business users and developers to extend services and build new applications with little to no coding

Oracle OpenWorld, San Francisco, Calif.—Sep 20, 2016

Oracle today unveiled Project Visual Code, a complete cloud-based application platform for low-code development. With this innovative new platform, customers can quickly and easily build and publish bespoke, stand-alone applications or extend applications by visually creating and publishing new integrated applications to meet any business need.

The real-time enterprise has made it necessary for organizations to rethink application development in order to keep up with rapidly changing demands. IT teams are often stuck with a backlog of work, which means the business can’t always get applications delivered quickly enough to capitalize on new opportunities presented by digital transformation. To help solve this challenge and democratize app development, Oracle has introduced Project Visual Code, which enables business users to quickly and easily develop and extend enterprise applications.

“Businesses need to be dynamic to remain relevant in today’s fast-paced business environment,” said Bill Pataky, vice president of product management for tools and frameworks at Oracle. “Project Visual Code introduces an effective way for business users to innovate in tandem with IT. It enables business users to extend and enrich off-the-shelf applications and build new solutions that can increase business efficiency and drive better results.”

“More than ever before, AD&D pros must obsess over their user interface designs. Today, customers and employees expect to access applications from a wide range of devices, putting additional pressure on developers. Low-code vendors employ familiar drag-and-drop, WYSIWYG techniques to speed user interface (UI) creation,” wrote Forrester analysts John Rymer and Clay Richardson in The Forrester Wave™: Low-Code Development Platforms, Q2 2016. The report goes on to say that many vendors “support responsive design, which automatically adapts forms and UIs based on the user's device and screen resolution.”

With the new Project Visual Code, customers will be able to utilize a library of responsive user interface components and complete applications – made available in the Oracle Cloud Marketplace—to add features that can be embedded directly into their own applications, environments or even existing Oracle Cloud applications. With minimal coding needed and intuitive visual design capabilities, business users and citizen developers can easily create the applications they need on their own, with little to no involvement from their IT department.

Built on a standards-based architecture, the new platform also enables customers and partners to create a rich ecosystem of modular user interface building blocks as well as complete applications. In addition, with its best-in-class mobile development features, the new platform enables the creation of on-device mobile applications that work even in disconnected mode.

Oracle’s Project Visual Code includes:

  • Builder: Oracle provides a visual tool for creating and hosting Web and mobile business applications through a no-code-required, browser-based development approach. This new version enables the creation of reusable applications that can be exported and imported between customers. It also introduces the ability to integrate reusable UI components and external services.
  • UI Design System: A new visual design system complements modern layouts and supports a responsive approach for multi-channel applications.
  • UI Component Architecture: Leveraging Oracle’s open source JavaScript Toolkit, reusable components can be designed and used to build native mobile and web applications.
  • Business Objects: Developers and business users can build applications over any REST based service or leverage the platform to easily create new objects for any custom data requirements. This enables users to create their own business objects and set validation rules, or take advantage of Project Visual Code’s scripting capability to define any rule their business requires.
  • Application Marketplace: Customers and partners can access, share and sell complete applications as well as functional UI components with specific capabilities, all built on the new Project Visual Code. Within the Oracle Cloud Marketplace, public catalogs allow partners and developers to open up new revenue streams and sell their components and applications, while private catalogs enable organizations to create an internal repository of shared resources to be used among various departments.

Project Visual Code enables me to create a complete application including database and rich responsive UI in minutes without writing a single line of code,” said Luc Bors, technical director at eProseed. “I like the fact that as a professional developer, I can add more advanced capabilities with a bit of JavaScript code.”

"As Oracle introduce more and more APIs from its SaaS applications through the Service Catalogue, I can incorporate them in my own business applications,” said Debra Lilley, vice president of Certus cloud services at Certus Solutions. “The similar UI experience and single sign-on makes this the ideal tool for building simple and very quick extensions to SaaS."

Contact Info
Simon Jones
Oracle PR
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Simon Jones

  • +1.415.856.5155

Oracle Open World 2016 from a PeopleSofter point of view: Sunday 18th and Monday 19th

Javier Delgado - Tue, 2016-09-20 06:36
In every crisis there is an opportunity.

This is what I thought as I woke up for the second day in a row before 2.30am due to my jet lag here in San Francisco. So I decided to use this marvellously quiet time to write my first blog article about my experience here at Oracle Open World 2016.

Sunday was good to warm up our engines. We completed the event registration. I am saying we because as I was very lucky to come here with two of my colleagues (César García Galán and Carmen Larrumbide) plus Daniel Plaza from Consum.

Unfortunately I missed Sasank Vemana's session on Sunday morning on hacks for PeopleSoft Development. I read on Twitter that it was a great session. On Monday I had the opportunity to meet Sasank personally and it is easy to see he has a lot of knowledge share (you can check his blog for some samples).

Then I attended a very interesting session on PeopleSoft HCM Networking [SIG7845] conducted by Christina Yue from the Quest International User Group. I found this session very valuable, mainly because of customers' willingness to share their experiences and challenges with PeopleSoft HCM.

Next on the menu was the welcome keynote featuring Larry Ellison among others. There is no much point in me describing the contents as you can access the recorded keynote here. Attending his keynotes is always an interesting experiences. Two things surprised me in this case:

  • The number of times he mentioned Workday as a way to compare Oracle Cloud Application growth against theirs. I have attended the same opening keynote two years ago, and it is surprising how much the time dedicated to hit Workday increased. I guess this is the ultimate recognition of the strength of the competition between them, which I think it is good for the industry.
  • The focus on making Oracle a leading provider of Infrastructure as a Service, directly competing with Amazon Web Services. This will be a tough one for Oracle from my point of view, but one thing you cannot deny about Larry is that he is never shy on the challenges he picks.
Monday was more intense from a PeopleSoft point of view. I have attended a couple of general sessions in which you could sense that on premise applications like PeopleSoft are totally secondary in Oracle applications strategy. Still, I have to say that the PeopleSoft team at Oracle did a great job putting up a great sessions agenda for this event. So kudos for Marc Weintraub and the rest of the PeopleSoft team at Oracle.

There is no better event guide for Oracle Open World as a PeopleSoft professional than the session held by Marc Weintraub and Greg Parikh: PeopleSoft Talk Live! Your Event Guid [CON7031]. This gave a quick overlook of what are going to be the hot topics regarding PeopleSoft in this event, of which I have noted:
  • Elastic Search
  • Cloud Manager
  • Fluid interface
  • Selective adoption
Also some interesting announcements were made. I've particularly found interesting the launch of Spotlight Series videos giving in-depth reviews of certain topics. You can find them in PeopleSoft Information Portal. Another very interesting announcement is that sample PeopleSoft Test Framework scripts will be delivered with PeopleSoft images from now on. You can check this in My Oracle Support.

Just a bit later, I attended the great Graham Smith session on PeopleSoft Cloud Architecture and its Practical Applications and Use Cases [CON3672]. I have always been a fan of Graham's PeopleSoft blog, so being able to attend one of his sessions was a great experience. There are more of his sessions to come, so this is just the beginning!

My day ended with our own session about how we improved User Experience through the use of PeopleSoft Fluid [CON2405]. This was my first experience presenting at Oracle Open World and it certainly was a great one. I would like to thank Consum and Daniel Plaza for giving us the opportunity of sharing the lessons learned in our Fluid project with them in this session.

The only thing I regret about speaking at Oracle Open World is that our session was at the same time Jim Marion's one: Getting the Most of PeopleSoft: PeopleSoft PeopleTools Tips and Techniques [CON7070]. I guess it was a great one as usual. I can't wait until his presentation is released in the conference site!

This is all for today. Stay tuned for other updates. I would prefer sleeping a bit more, but acceptance is the way to happiness.

Why Bother

Jonathan Lewis - Tue, 2016-09-20 05:16

This note comes to you prompted by “Noons” in a recent twitter exchange

In response to a complaint by Lukas Eder about having to educate people in 2016 that there is no (performance) difference between count(*) and count(1), Nuno  asked me to blog about my claim that this non-difference is a good educational example on at least three different counts.

One thing I won’t count in the list of three is an actual demonstration of the non-difference. I would be surprised if anyone reading this blog needed a proof of the point, but if you’re interested here are a few examples from my past writings – including a couple where the problem becomes subtler and the “non-difference” stops happening:

You’ll notice that the earliest note I’ve published on the blog dates back 8 years or more; and one of the notes references back to a FAQ dated 2001 published on my old website. So why bother making a fuss about this non-difference when it ought to be common knowledge and really isn’t worth the effort.

  • There is a huge amount of garbage on the internet about how Oracle works and what you can to do make it work better, so when you demonstrate to someone that claims can be backed up by proof and an idea that they’ve picked up from the internet is wrong it might make them pause for thought the next time they read some unjustified claim that really matters.
  • This is a delightfully simple example to use to demonstrate how you can get a little extra information from an execution plan that could help you understand the cause of a performance problem.  (I could make the same comment about being able to get something helpful a 10053 trace file, but I won’t claim that as reason number 3)
  • Starting even with this extremely simple example that proves one point we can see what happens as we push the boundaries of what we know. Thinking about this problem teaches us how to come up with new questions and modified examples which enhance our understanding of the product.

Frankly I find it extremely tedious how often I have to explain mechanisms that I first described in Practical Oracle 8i – it can be teribly depressing to see how ignorant people can be – but there are always new people starting their careers in Oracle, the manuals they look to are more concerned with describing how to use GUIs than with explaining the technology, and the old garbage on the internet won’t go away. New arrivals have little previous experience for telling the difference between fact and fiction until someone provides the demonstration – so we keep repeating the simple examples.

My favourite quote about the internet came by way of Terry Pratchett (in “The Truth”): A lie can run round the world before the truth has got its boots on.”

You just have to keep hammering away at the truth.


DOAG 2016, Schulungstag: Oracle Grid Infrastructure

Yann Neuhaus - Tue, 2016-09-20 04:11

Wie auch in den letzten Jahren werden wir auch dieses Jahr wieder einen Schlungstag an der DOAG ausrichten. Dieses mal wird sich alles um die Oracle Clusterware (“Infrastruktur & Middelware” –> “Oracle Grid Infrastructure”) drehen: Los geht es mit den Anforderungen an Netzwerk, Speichersysteme, Betriebssystem und Kernel Parameter, denn nur wenn die Basis auch stimmt arbeitet eine Cluster-Lösung auch verlässlich. Wie immer bei uns wird es zahlreiche Live Demos geben, denn zeigen ist immer besser als nur erzählen. Es geht dann weiter mit der Architektur, der Installation, Konfiguration und dem Betrieb der Lösung. Natürlich gehen wir auch detailliert auf die Fehlersuche und Analyse ein. Am Ende des Tages sollte jedem klar sein was genau die Oracle Clusterware ist, wofür man sie einsetzen kann und sollte und auf was genau zu achten ist. Oracle selbst setzt die Clusterware bei fast allen Engineered Systems sowieso schon ein, also lieber gleich wissen worauf es ankommt.
Wer dann immer noch das Gefühl hat mehr Praxis zu benötigen kann sich gerne unseren Workshop zum selben Thema ansehen.

Wir freuen uns jetzt schon auf die zahlreichen Besucher an der DOAG 2016.


Cet article DOAG 2016, Schulungstag: Oracle Grid Infrastructure est apparu en premier sur Blog dbi services.

Comparison of schema in controlled environment

Tom Kyte - Tue, 2016-09-20 03:26
I learnt that some of the production objects were missing. At that point I decided to change the password of the schema in production so that the comparison can be done with the Stage environment and the extent of damage to the production system can ...
Categories: DBA Blogs

Returning matching or highest row in a SELECT statement

Tom Kyte - Tue, 2016-09-20 03:26
I'm trying to retrieve only two rows when joining these two table. In table A: I have an ID and Date In table B: I have an ID and Timestamp. My select is retrieving 4 rows, however, I want to pick the timestamp from table B that matches the ...
Categories: DBA Blogs

What does "//" in jdbc connection string mean?

Tom Kyte - Tue, 2016-09-20 03:26
Hi AskTom team. I'm testing a jdbc connection to database in my java application. When I use the following form: <code>jdbc:oracle:thin:@myhost:1521/myservicename</code> everything's fine, my java application connects to the db. When I ...
Categories: DBA Blogs

sets of ORA-603/604/1000/6512/4088 errors

Tom Kyte - Tue, 2016-09-20 03:26
Hello All, The question here is how does Oracle handle cursoring with a trigger? Th emax cursor error is happening during execution of the following simple code: CREATE OR REPLACE TRIGGER TNT_OWNER.TRG_USC_ABI_MESSAGE_EMAIL AFTER INSERT OR U...
Categories: DBA Blogs

Move data from one table to other in PLSQL procedure

Tom Kyte - Tue, 2016-09-20 03:26
HI tom, i have one master table which has more record . i need to move that record into temp table while moving data if any error appear i need to save that row in error table. how to do this ?
Categories: DBA Blogs

Slow Full Table Scan on an IO sufficient machine

Tom Kyte - Tue, 2016-09-20 03:26
Hi Tom, I am spotting a performance bottleneck when performing Full Table Scan on all the tables. Take a small table example, SQL> SELECT COUNT(*) FROM schema.frozen_woappoint; COUNT(*) ---------- 1767373 SQL> select segment_name,...
Categories: DBA Blogs


Tom Kyte - Tue, 2016-09-20 03:26
hi , below insert query is causing deadlock.. insert into T_POLICY_GEN_CUST (UPDATE_TIME, INSURED_FLAG, PAYER_FLAG, INSERT_TIME, POLICY_ID, PARTY_ID) values (:1, :2, :3, :4, :5, :6) can you please give me some detailed information about why this...
Categories: DBA Blogs

Oracle Open World 2016 – Day 2

Yann Neuhaus - Tue, 2016-09-20 03:10

Day 2 is the first official day of the Oracle Open World (OOW) 2016. As a parallel event the Oak Table Network organized his Oak Table World (OTW) close to the Open World. I attended several sessions from OOW and OTW:

Jeremy Schneider: Ansible

Ansible is a very light software written in Python, which allows automation in deploying applications and managing systems. The main goal of the developer of Ansible Michael DeHaan was to make the process of deploying software and managing systems much simpler than it is with Puppet or Chef. Jeremy Schneider showed a demo on how easy it is to manage many systems with such an easy and still very effective tool, which uses ssh to connect to the servers and execute commands. It was impressive to see and I feel I have to check with my customer running on Redhat, if Ansible could not be an alternative to Puppet.

Frits Hoogland: Drilldown into logwriter mechanics

What happens when a user executes a “COMMIT;” ? Yes, we know that the logwriter is triggered to write the data to disk. But what happens in detail? By using the debugger dbg on Linux and setting break points in various modules, Frits could show in a very technical session what exactly happens when the foreground process runs in polling mode (i.e. instead of having the Log-Writer triggering the foreground process that the data is persistent on disk, the foreground process is polling SCN-information to detect that the data is on disk). See here.

Wei Hu, John Kanagaraj: High Availability and Sharding Deep Dive with Next-Generation Oracle Database

What is Sharding? According Oracle there is a need for World Scale applications to have a farm of independent databases. I.e. instead of 1 giant DB, the DB is partitioned into many smaller DBs (shards) running on different hosts. In contrast to RAC the data is not shared, i.e. every machine has its own disks (shared nothing hardware). So each shard stores a subset of the data. For performance reasons read-mostly data (e.g. a lookup table) is replicated between the shards. The applications have to be designed in a way that workload can be routed to a specific database in the farm. There is a choice of the sharding method: System managed (consistent hash), Composite (range-hash, list-hash) and User defined (range, list). Based on a sharding key (in the example below the CustId) the data is distributed among the shards:


In case a new shard is added, the data needs to be redistributed. That move of data is initiated automatically or manually (by the DBA). When it’s automated the system uses RMAN Incremental Backups and Transportable Tablespaces to redistribute the data.

Enhancements with Active Data Guard:

Improved Data Protection:

  • High speed DB compare (whole DB or individual data files) between Primary and Standby. Validates that primary and standby is physically the same, by doing a compare at the physical level.
  • RMAN validation and repair of blocks on standby that were invalidated by non-logged operations (e.g. direct path loads) on the primary.
  • Improved automatic block repair.

Active Data Guard enhancements:

  • During switchover/failover the read-only sessions remain connected and become read/write after the Active Data Guard becomes
  • Primary. That avoids a reconnect strorm after the switchover/failover.
  • In-memory DB now possible on Active Data Guard. The columns defined for In-Memory can be different on Primary and STandby.
  • Support of Diagnostic Pack (AWR), Tuning Pack and SQL Plan Analyzer on the Standby System.
  • Passwd file on standby is automatically updated.
  • Standby-first encryption: Can encrypt tablespaces on standby first, switchover and then encrypt on old primary, so that encryption can be enabled without much downtime.


Nigel Bayliss: Upgrading to Oracle 12c without Pain.

Nigel talked about new 12.2 Optimizer features. In 12cR1 the Optimizer adaptive features (adaptive plans and adaptive statistics with SQL Plan directives) were controlled by 1 parameter: OPTIMIZER_ADAPTIVE_FEATURES. In 12cR2 the adaptive plans and adaptive statistics have their own parameters: OPTIMIZER_ADAPTIVE_PLANS (default TRUE) and OPTIMIZER_ADAPTIVE STATISTICS (default FALSE). I.e. in 12cR2 adaptive plans are enabled by default. SQL Plan Directives will still be created, but are not used by default. So the new default settings are closer to the 11g behavior as SQL Plan Directives are not used.
For migrations to 12cR2 Nigel provided specific cook books to follow to avoid plan changes initially (use SQL Plan Baselines to fix e.g. 11g plans) and then evolve to 12c.

Juan Loaiza: Oracle Database In-Memory: What’s New and What’s Coming

New features are:

  • Faster In-Memory joins: Join Groups can be defined. They specify columns, which are frequently used to join tables. The columns share the compression dictionary. The join occurrs on dictionary values rather than data: CREATE INMEMORY JOIN GROUP V_name_jg (VEHICLES(NAME), SALES(NAME)); That should bring up to 2.3 times faster join processing.
  • Precomputed expressions (e.g. Price + Price * Tax) can be cached In-Memory as user defined virtual columns. I.e. using such an expression in the query can gain from In-Memory data access.
  • In-Memory on Active Data Guard (see above).
  • In-Memory columnar format can be used on Exadata Flash Cache.
  • Data lifecycle management of In-memory data. I.e. policeis can be defined to evict cold data from the In_memory Column Store.
  • On engineered systems the IM column data can be persisted on storage. After a restart the data can be loaded faster in memory.

Cet article Oracle Open World 2016 – Day 2 est apparu en premier sur Blog dbi services.

Oracle 12cR2 Long Identifiers

Yann Neuhaus - Tue, 2016-09-20 01:14

This morning during Gerald Venzl presentation of “What’s New for Developers in the Next Generation of Oracle Database” at Oracle Open World, one feature has been acclaimed by a full room: 12.2 show the end of identifiers limited to 30 characters.


We knew it would happen because in 12.1 all data dictionary views have 128 bytes length character strings:

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
SQL> desc dba_objects
Name Null? Type
----------------------------------------- -------- ----------------------------

but that’s only the dictionary metadata. Impossible to reach that limit:

SQL> create table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" as select * from dual;
create table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" as select * from dual
ERROR at line 1:
ORA-00972: identifier is too long

It is only annoying as the default column format do not fit in the screen:

SQL> select owner,object_name from dba_objects where object_type='TABLE';


In 12.2 you can create longer identifiers:

SQL> create table "ThisIsAVeryLongNameThatIsAllowedInTwelveTwoC" as select * from dual;
Table created.
Table altered.

But be careful, the limit is in bytes – not in characters. If we have multibytes characters, the limit can be reached earlier:

ERROR at line 1:
ORA-00972: identifier is too long

So what?

The goal is not to abuse and put the longest names possible. But allowing more that 30 characters can be easier to match table names with Java class names for example.

Oracle 7

I wanted to show that those 30 characters limits was very old, so I ran a 7.3.3 oracle version that lies on my laptop and displayed the same describe of DBA_OBJECTS:
Identifiers were 30 characters there. But look at object name: those 128 bytes are there for more than 20 years!


Cet article Oracle 12cR2 Long Identifiers est apparu en premier sur Blog dbi services.

Oracle Open World 2016 – Day 1

Yann Neuhaus - Tue, 2016-09-20 00:29

Oracle Open World 2016 started on Sunday. The first day is always reserved for presentations provided by members of the various Oracle User Groups. However, the last part of the day is the first Keynote from Larry Elison. But let’s start by some of the sessions I visited Sunday:

Ludovica Caldara: Migrating to Oracle Databases 12c: 300 databases in 300 days.

Ludovica provided a presentation about the experience he gained during the migration project of 300 databases to 12c: Issues they faced and things to consider when migrating to 12c.
The main recommendations to avoid performance issues after the migration to 12c were related to SQL Plan Directives. I do not want to go into too much detail on the topic, but one issue Ludovica’s customer faced in terms of SQL Plan Directives was related to high CPU utilization at specific, fixed times when a system-job called the function DBMS_FEATURE_AWR. For details on this subject see here.
Other things to consider are the Oracle recommended patches from MOS-Note 2034610.1 (Things to Consider to Avoid Poor Performance or Wrong Results on

Franck Pachot: Single-Tenant Oracle Database 12c: Multitenant Features for All Editions

In his excellent session Franck presented about some good reasons to go to Single-Tenant databases instead of running the deprecated Non-Container databases (i.e. the only way DBs could be run up to 11gR2 with 1 DB per Instance). Among other things the possibility to transport a database to another machine by un-plug and plug-in and 12.2.-security features were mentioned (use of the new lockdown profile, which can e.g. disable database options for a pluggable database).

Mauro Pagano: SQLd360: SQL Tuning Diagnostics Made Easy

Being very excited about the free software SQLd360 Mauro developed (see here), he enthusiastically presented the history of tuning single SQL-statements during the various phases of available tools and database features:

  • 1998, when not much data was available about the history of a SQL-statement
  • 2007, when SQLTXPLAIN became very popular
  • today with the availability of SQL_MONITOR and Active Session History

Bottomline is that SQLd360 should be the tool to use today to tune a single SQL-statement, because of various advantages compared to SQLT(XPLAIN) (took the following list from here):

  • not necessary to install something on the database
  • SQLd360 is 100% free software, while SQLT requires a My Oracle Support (MOS) account, and some consultants and third parties may struggle to obtain a valid login for MOS or would have to use their client’s credentials.
  • SQLd360 makes use of newer technologies including Google Charts, presenting the metadata in a very “Wow!” way, while SQLT focuses on HTML tables.
  • SQLd360 is 13X smaller in terms of lines of code, and it pretty much does the same job as SQLT
  • SQLd360 is much faster to execute than SQLT.

Sunday Keynote by Larry Ellison:

Remark: I do not talk about the Cloud here (almost all of the Keynote was news about Oracle’s Cloud), as I want to concentrate on what’s coming on the DB-side.

First info on Oracle DB 12c Release 2:

  • Multitenant
    Agility with on-line clones and on-line relocate
    4095 PDBs possible (255 in 12.1)
  • Sharding: A shared nothing architecture where databases on different nodes form a logical database.
    It provides elastic scalability with native sharding for global-scale applications.
  • In-Memory
    Column-Store on Active Dataguard
    Increased performance (up to 60x faster than 12.1)

Cet article Oracle Open World 2016 – Day 1 est apparu en premier sur Blog dbi services.

Slides Available - End-to-End Cloud: Oracle Java Cloud, Oracle Mobile Cloud Service, Oracle MAF, and Oracle JET [CON2388]

Andrejus Baranovski - Mon, 2016-09-19 17:03
I have completed my OOW'16 session [CON2388] today. For those of you who could not attend it, check slides online (I will post sample code later, read more about the session here):


Subscribe to Oracle FAQ aggregator