Feed aggregator

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.

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
+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

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
+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

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

Pages

Subscribe to Oracle FAQ aggregator