Feed aggregator

Oracle NANVL Function with Examples

Complete IT Professional - Wed, 2016-09-21 06:00
The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number). It’s useful for floating-point numbers such as […]
Categories: Development

Oracle Open World 2016 – Day 3

Yann Neuhaus - Wed, 2016-09-21 02:39

On day 3 I visited various sessions about In-Memory and its many new features in 12gR2. Yesterday I already listed some new features of In-Memory. In this post I want to explain the new features more in detail:

 

In-Memory Join Groups:

Columns are specified, which are used to join tables:

CREATE INMEMORY JOIN GROUP V_name_jg (VEHICLES(NAME), SALES(NAME));

Those columns share the compression dictionary. My understanding on how this works is as follows: The joins occur on dictionary values rather than data. E.g. a dictionary with distinct values of car brands (column NAME in VEHICLES and SALES) may look as follows:

BMW 1
VW 2
Mercedes 3
Ford 4
Fiat 5
Dodge 6

The dictionary values are stored in the compression units instead of the real data:

1
1
2
3
3
3
4
5
5
6

Doing that for the 2 columns allows the joins to happen on the dictionary values rather than real values. Oracle talks about a speedup of a factor 2-3 when using Join Groups.

 

In-Memory expressions:

SQL expression results (NET in the example below) can now be stored as additional in-memory columns:

CREATE TABLE SALES (
PRICE NUMBER, TAX NUMBER, ...
NET AS (PRICE + PRICE * TAX )
)
INMEMORY;

All in-memory optimizations (e.g. vector processing or storage indexes) apply to the expression columns as well. When a SQL contains the expression then it can be taken from the column store without computing it:

SELCT SUM(NET) FROM SALES WHERE NET > 50;

Different types of expressions are possible:

  • Arithmetic expression
  • Logical expression (e.g. DECODE)
  • Type conversion (e.g. UPPER, TO_CHAR)
  • PL/SQL expressions

Two modes to define the expressions to populate (Manual and Auto) can be used:

Manual: Declare virtual columns for the desired expression (see example above). The parameter INMEMORY_VIRTUAL_COLUMNS defines if virtual columns are considered for inmemory:
INMEMORY_VIRTUAL_COLUMNS
= ENABLE: All user-defined virtual columns on the table or partition enabled for in-memory will be populated
= MANUAL: User-defined virtual columns must explicitly marked for INMEMORY (default)
= DISABLE: No user-defined column will ever be populated

Auto: Oracle detects frequent expressions automatically. I.e. the optimizer stores “hot” expressions (based on frequency and cost) in the expression statistics store (ESS). With the procedures IME_CAPTURE and IME_POPULATE in the package DBMS_INMEMORY the expressions are captured and declared as hidden in-memory virtual columns on the appropriate table. Expressions in the ESS can be checked by querying ALL|DBA|USER_EXPRESSION_STATISTICS.

 

In-Memory JSON

JSON columns and expressions on JSON columns can now be populated in-memory.

 

In-Memory on Active Data Guard

According Oracle, In-Memory on Active Data Guard was the most wanted feature from customers for In-Memory for 12gR2. I.e. the In-Memory column store can now be used on the Active Data Guard instance as well. The standby database can have different data (columns) stored in-memory than the primary. The decision on what columns to populate in-memory on the different instances is based on a service. I.e. on primary the following DDL may be used:

ALTER TABLE SALES INMEMORY DISTRIBUTE FOR SERVICE A;
ALTER TABLE SHIPMENTS INMEMORY DISTRIBUTE FOR SERVICE B;

Table SALES will be populated In-Memory on that instance, which has service A enabled and SHIPMENTS will be populated on the instance, which has service B enabled.

 

In-Memory Columnar Flash

On Exadata the In-Memory format can be used on the Flash Cache. I.e. an In-Flash Column store can be created. The advantage is that there is usually much more Flash than RAM and hence more data can be cached for In-Memory on Flash scans. To do that the CELLMEMORY segment attribute is available:

ALTER TABLE sales CELLMEMORY;
CREATE TABLE trades (...) CELLMEMORY MEMCOMPRESS FOR QUERY;

Restrictions in comparison to normal In-Memory:

  • The MEMCOMPRESS sub-clause only supports “FOR QUERY LOW” and “FOR CAPACITY LOW”.
  • There is no PRIORITY sub-clause.

 

Automatic Data Optimization (ADO) extended to In-Memory

The heatmap can now be used to define how long data should remain In-Memory or when In-Memory compression should be changed. I.e. in the maintenance window or on manual request (using the procedure DBMS_ILM.EXECUTE_ILM) Oracle checks if a policy has been met to e.g. flush data from the In-Memory column store.

ALTER TABLE sales ILM ADD POLICY ... NO INMEMORY AFTER 10 DAYS OF NO ACCESS;

That allows sliding windows of column store content based on access-time or time of creation. A customized policy function can also be created in PLSQL.

 

In-Memory Fast-Start

The In-Memory column store content can now be checkpointed to Securefile Lobs. When the DB restarts the population is faster (between 2-5x) as the data can immediately be loaded in memory without CPU-intensive compression activity. To activate In-Memory Fast-Start the procedure DBMS_INMEMORY_ADMIN.FASTSTART_ENABLE with a tablespace-name as parameter has to be executed. The tablespace should be 2 times the size of the in-memory column store.

 

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

DB Time

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I have been reading your questions/answers thread and like it. Want to ask you one simple question. Database Time= CPU Time +Non-Idle Wait; I see in my database, CPU Time is more all the time and Non-Idle Wait is less. say for exampl...
Categories: DBA Blogs

Materialized View

Tom Kyte - Tue, 2016-09-20 21:46
Hello Tom, What are the best practices with MV - <1> a) generate MV on the DB that owns base tables - and refresh MV and populate over the DB links to other DB's or b) Pull data from the source DB over the DB link and populate the MV from...
Categories: DBA Blogs

dynamic pl/sql - ora-00922

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I need to use dynammic sql in a stored procedure. I created an anonymous block to test it. The code fails at execute immediate with ORA-00922. But, when I run the code generated by the block, it works. Why doesn't it work in an anonymous bl...
Categories: DBA Blogs

Importing data from file to oracle databse via command prompt

Tom Kyte - Tue, 2016-09-20 21:46
Hi Experts, I am trying to load data from file into oracle database via command prompt throwing error like IMP-00038: Could not convert to environment character set's handle IMP-00000: Import terminated unsuccessfully I installed oracle 11g...
Categories: DBA Blogs

Listener Error Related on Web Server

Tom Kyte - Tue, 2016-09-20 21:46
Hello Chris, Conner and Tom, I am building two Apache/jBoss servers. These servers are connected to an Oracle database server version 12.1.0.1.0 on Windows 2012. 1. Web server one: The website is up and connected to the database. However, the ...
Categories: DBA Blogs

Is ROWNUM=1 on queries makes them faster all the time ?

Tom Kyte - Tue, 2016-09-20 21:46
Hi Chris/Connar, I have been checking on lot of contents in the Internet to find a "Simple Answer" for this and my final resort is AskTom. For tuning of the our PLSQL programs for our various application we have been using "ROWNUM=1" co...
Categories: DBA Blogs

Oracle EXISTS clause

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I have recently joined a new organization. Here I am facing performance issue for one of my stored procedure. The problematic sql in my procedure is, <i>SELECT iCustomerGroupSeqNo FROM Col_Cur_AgreementAlloc CCAA,V_Tmp_Allocationsumm...
Categories: DBA Blogs

how to install SQLCL on windows machine 86bit

Tom Kyte - Tue, 2016-09-20 21:46
hello Connor, I wanted to know if can guide me in right direction where by i may be able to download and install(Step By Step) Sqlcl. i heard about it thats its awesome tool and i really wanted to dig into it. I am using windows machine 86bit ...
Categories: DBA Blogs

Direct path reads of a FTS on a table slow - what could be the reason

Tom Kyte - Tue, 2016-09-20 21:46
We have two Oracle database instances X & Y with the same parameter / configuration. There is a table "bigtable" which has around 2 Million rows in both the databases. In a query, if the "bigtable" table is full scanned, we observe the below: 1) ...
Categories: DBA Blogs

Sorting By Nearest Future date

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I need to get the record of nearest future date as first record from the data set and rest by Ascending order For example: <b>Before Sorting : </b> Order Quantity Schedule Date 1 0 Jan-15-2016 2 0 NOV-20-2016 3 1 ...
Categories: DBA Blogs

Ravello

Yann Neuhaus - Tue, 2016-09-20 18:46

I’m at Oracle Open World and I’m rather focused on database rather than all those Cloud topics, but one product caught my attention at the Oracle ACED Briefing. Oracle bought Ravallo systems at the beginning of the year. What is Ravello? You have virtualized your applications on VMware and want to move them to the Cloud… without any changes.

Move your application

An application is not a single VM. It’s an ecosystem of VMs working together, linked by one or multiple network interfaces. Moving the virtual machines is easy, thanks to virtualization. But do you change the IP addresses everywhere? This is where you need another layer of virtualization.

Let’s see how it works. With Ravallo you can import your VMs easily. It can connect to your VSphere or you just import an ova. Once they are imported into Ravallo, you can start to build your application with a simple drag and drop of the concerned VMs.

The magic follows. Ravallo parses the VMs metadata and data to discover the ecosystem. Here his the result after having importing a database, two weblogic server servers, and a windows client:

2016-09-20 10.15.04

Not only the VMs are there. there is a network here with switches, routers, DNS, DHCP, a fenced network private to my application, all virtualized.

And there’s more: all IP addresses are the same in that private network than on my on-premises VMWare farm. That’s the point. Changing network interfaces, IP addresses, DNS, etc is a nightmare and you don’t have to do it.

This is only the design of the application. Once that application is defined, you can publish it to the Cloud: Oracle Public Cloud, Google one, or AWS.

And this is easy. You can choose that resources are optimized for cost or performance, and you even have an idea of the price:

2016-09-20 10.13.31 2016-09-20 10.13.13

Time to run our application. As it runs in an isolate environment, you can even run multiple instances of it. But how do you connect to it?

First, you can access the console to each VM from Ravallo though VNC.
For external access you create services that set NAT rules and allocate public IP addresses.

Ravallo is nested virtualization: two levels of hypervisors.

 

Cet article Ravello est apparu en premier sur Blog dbi services.

Oracle Beats Amazon Web Services in Head-to-Head Cloud Database Comparison

Oracle Press Releases - Tue, 2016-09-20 16:45
Press Release
Oracle Beats Amazon Web Services in Head-to-Head Cloud Database Comparison New Oracle Database-as-a-Service is 20 years ahead of Amazon Web Services

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

Oracle Executive Chairman and Chief Technology Officer, Larry Ellison today demonstrated that Amazon databases are 20 years behind the latest release of the Oracle Database in the Cloud. In his keynote presentation at Oracle OpenWorld 2016 in San Francisco’s Moscone Center, Ellison shared detailed analysis that showed that Oracle Database-as-a-Service (DBaaS) is up to 105X faster for Analytics workloads, 35X faster for OLTP, and 1000+X faster for mixed workloads than Amazon DBaaS. Ellison also showed that the Oracle Cloud is optimized for running Oracle Database while Amazon Web Services (AWS) is not. An Oracle Database running on the Oracle Cloud is up to 24X faster than an Oracle Database running on AWS.

“Oracle’s new technologies will drive the Cloud databases and infrastructure of the future,” said Ellison. “Amazon are decades behind in every database area that matters, and their systems are more closed than mainframe computers.”

Ellison also announced the availability of Oracle Database 12c Release 2 in the Oracle Cloud with the launch of the new Oracle Exadata Express Cloud Service. This service provides the full enterprise edition of the Oracle Database running on the database-optimized Exadata infrastructure. Starting at just $175 per month, Ellison showed this Cloud service is lower cost than similar offerings from Amazon. 

With the launch of Oracle Database 12c Release 2 in the Cloud first, Oracle has demonstrated that the Oracle Cloud is the most optimized, complete and integrated Cloud for Oracle Database. The latest release provides organizations of all sizes with access to the world’s fastest, most scalable and reliable database technology in a cost-effective and open Cloud environment. In addition, the world’s #1 database includes a series of innovations that add state-of-the-art technology while preserving customer investments and supporting their transition to the Cloud.

Ellison shared detailed analysis during his keynote that showed how the new Oracle DBaaS delivers unparalleled performance for analytics, online transaction processing (OLTP) and mixed database workloads. In a direct comparison between Oracle DBaaS and Amazon databases, Ellison shared the following analysis:

  • Oracle Cloud Database is dramatically faster than Amazon Cloud Databases:
    • Oracle Cloud is up to 105X faster for analytics than Amazon Redshift
    • Oracle Cloud is up to 35X faster for OLTP than Amazon Aurora
  • Amazon is 20 years behind Oracle in database technology
    • Amazon Aurora is missing critical OLTP features that Oracle shipped 20 years ago, including scalable read-write clusters, parallel SQL and the ability to replicate encrypted databases
    • Amazon Redshift is missing critical analytics features that Oracle shipped 20 years ago, including table partitioning, materialized views, support for rich data types and sophisticated query optimization
  • Amazon databases do not support mixed workloads
    • Oracle runs analytics workloads 1000+ times faster than Amazon Aurora
    • Oracle runs OLTP workloads 1000+ times faster than Amazon Redshift
  • Amazon databases are more closed than IBM Mainframe databases, and are not compatible with on-premise enterprise database applications
    • Amazon Aurora, Amazon Redshift and Amazon DynamoDB only run on AWS
    • With AWS, organizations can’t use dev/test for on-premises, can’t use disaster protection for on-premises, management is incompatible with on-premises
    • Amazon databases are not compatible with existing enterprise database applications such as Oracle, DB2, SQL Server and Teradata and force organizations to throw away decades of on-premises investments

Ellison also demonstrated that AWS is not optimized for the Oracle Database:

  • Oracle Database is up to 24X faster for analytics on the Oracle Cloud Platform than on Amazon Web Services
  • Oracle Database is up to 8X faster for OLTP on the Oracle Cloud Platform than on Amazon Web Services
  • AWS has limited storage performance: Amazon Elastic Block Storage limited to 48,000 IOPs/nodes, which is 8X slower than Oracle Cloud; Amazon Elastic Block Storage limited to 800 MB/sec/node, which is 19X slower than Oracle Cloud
  • AWS cannot scale-out Oracle across nodes: AWS provides no support for Oracle Real Application Clusters

Oracle is the only vendor with true workload portability across on-premises and Cloud deployments. This helps ensure customers can continue to leverage their existing investment, keep costs down and easily benefit from the efficiency of Cloud. With proven continuous innovations and industry-leading performance across the entire platform from infrastructure to database, including support for mixed workloads, Oracle Data Management Cloud is the leader today and in the future.

Contact Info
Simon Jones
Oracle PR
+1.415.856.5155
sjones@blancandotus.com
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.

Trademarks

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

Tuesday at OpenWorld and JavaOne

OTN TechBlog - Tue, 2016-09-20 14:28
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}

Welcome to Tuesday from both the OTN Lounge and Java Hub!

We encourage you to stop by and contribute to the German artist Mirja Wellman’s masterpiece. This experience is located at both the OTN Lounge and Java Hub. Draw a shape on the Gluon JavaOne Community App and those images will be transferred to a CNC machine to cut into your own unique design. You can keep one part and the other will be contributed to the project.

Come to the Java Hub to meet Nao, a humanoid and programmable robot, created by Aldebaran Robotics. Learn how to program the robots of the future. Nao is also wearing the sticker that can earn a $10 donation to Girls Who Code with each selfie. Remember to add #DevelopersRule to your post!

The OTN Archbeat Blog has the various Oracle ACE sessions, including Agile, the Oracle Application Container Cloud, and a live demo on Integrating 10 Oracle PaaS Services.

There are Systems sessions being held throughout the day, but don’t forget to watch the CommunityCast interview about Rapid Application Deployment with Oracle VM Templates, 1:30 at the OTN Lounge.

Normal 0 false false false false EN-US JA X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Oracle and the Government of Maharashtra Sign Memorandum of Understanding to Help Accelerate Digital Transformation

Oracle Press Releases - Tue, 2016-09-20 11:30
Press Release
Oracle and the Government of Maharashtra Sign Memorandum of Understanding to Help Accelerate Digital Transformation A Center of Excellence powered by Oracle Cloud is designed to modernize government services and enable smart city solutions

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

Oracle CEO Safra Catz and Chief Minister of Maharashtra Shri Devendra Fadnavis

Oracle CEO Safra Catz and Chief Minister of Maharashtra Shri Devendra Fadnavis sign a Memorandum of Understanding to accelerate digital transformation and develop a smart city Center of Excellence powered by Oracle Cloud.

Oracle and the Government of Maharashtra today signed a Memorandum of Understanding (MoU) intended to accelerate the state’s digital transformation initiatives. Leveraging Oracle Cloud solutions, Oracle and the Government of Maharashtra will develop the State’s smart city program, with the goal of making the State’s urban landscape more livable and inclusive, while driving economic growth.

According to the MoU, Oracle and the Maharashtra Government will create a Center of Excellence (CoE) to help accelerate its smart city program and modernize the Government’s technology solutions. The CoE, housed in Mumbai, will serve as a research platform to design, develop and test new capabilities that will deliver better government-to-citizen (G2C) and government-to-business (G2B) services. Benefiting from the power of the Cloud, the CoE will enable rapid innovation with minimal capital expenditures. In addition, the CoE will offer a flexible and scalable common framework, as well as a team of experts, allowing individual cities to scale and replicate its solutions.

The proposed projects, to be finalized before the end of the calendar year, include:

  • Smart city in a box
  • Mobile platform for service questions
  • Unified app development for services like drivers license renewals or property tax payments
  • Digital platform to deliver smart city services across the state
  • Connected infrastructure across all devices, kiosks and citizens
  • Infrastructure services for equipment and IT
  • Resources to manage transportation logistics, including analytics, asset tracking, fleet management
  • Resources to manage utilities, including water and power

Many of these projects will support the government’s e-services[1] program aimed at citizens, visitors, business establishments and government officials. Both Oracle and the Government of Maharashtra will invest in IT infrastructure, training and skillset resources as well as management of the CoE.

The Government of Maharashtra, the largest state economy in India[2], initiated a program in April to develop 10 smart cities[3], adding to the 33 announced by the central government in the 100 smart cities initiative[4].

“Cloud computing has changed the landscape of governance. It has the power to enable inclusive growth and to transform the state into a digitally empowered society,” said Shri Devendra Fadnavis, chief minister, Government of Maharashtra. “Together with Oracle, we want to build a new, efficient, transparent and inclusive system that benefits our people. The CoE is a step in that direction and will make more government services available with the click of a button. I look forward to working with Oracle on this important mission.”

“We are thrilled to further our commitment in India by working with the Government of Maharashtra and the Prime Minister of India, Shri Narendra Modi, to help position India as a world-class design and manufacturing epicenter. The Cloud Center of Excellence powered by Oracle will play a key role in improving the lives of the people of this state,” said Safra Catz, CEO, Oracle Corporation. “By moving to the Cloud, the Government has the opportunity to create a digitally empowered society and a growing knowledge economy. We look forward to making this partnership a success.”

This follows Oracle’s recent commitment with the Prime Minister of India, Shri Narendra Modi, to support the country’s global digital leadership. Oracle unveiled a massive, state-of-the-art campus centered in Bengalaru, nine incubation centers throughout India, and an initiative to train more than half a million students each year to develop computer science skills.

[1] Source: http://indianexpress.com/article/pune/maharashtra-to-launch-50-online-public-services-on-october-2/
[2] Source: http://www.thehindu.com/business/Economy/maharashtra-is-biggest-state-economy-says-report/article7937851.ece
[3] Source: http://www.smartcitiesprojects.com/maharashtras-22-smart-cities-integrated-plan-naina/
[4] Source: http://www.livemint.com/Politics/kMLIQKW3xIqOUzFJ5sZadN/Smart-cities-More-names-of-cities-to-be-announced-today.html,
Source: http://www.livemint.com/Politics/eER1ilL9HJY6QF5k2skS3J/Smart-cities-the-first-20.html

 
Contact Info
Deborah Hellinger
Oracle
+1.212.508.7935
deborah.hellinger@oracle.com
Vandana Shenoy
Oracle
+91.124.6226782
vandana.shenoy@oracle.com
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.

Trademarks

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

Deborah Hellinger

  • +1.212.508.7935

Vandana Shenoy

  • +91.124.6226782

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
12.1

So, when you upgrade to 12c from 11.2.0.4 for example, the easiest way to fix a regression is to set optimizer_features_enable=’11.2.0.4′. 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?

12.2

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.

Pages

Subscribe to Oracle FAQ aggregator