Feed aggregator

Monday at Oracle OpenWorld 2016

WebCenter Team - Mon, 2016-09-19 11:47
Normal 0 false false false EN-US X-NONE X-NONE

Once you have picked up your badges and as you are thinking of which direction to head in, remember you have the https://sites.oracle.com/oowdx/ handy on your mobile browser to keep a pulse on what’s happening and where. The site is also handy in getting a good glimpse on what’s coming up next!

And just for you, here’s quick glance at some of the sessions you might be interested in today:

Monday, September 19, 2016

Content and Experience Management: Roadmap and Vision [CON7256]
David Le Strat, Senior Director, Oracle
11:00 a.m. | Moscone West 2014

Oracle Integrated Cloud—Strategy/Vision for Journey to Cloud Transformation [GEN1806]
Steve Daheb, Sr. Vice President, PaaS & IaaS Business Groups, Oracle
12:30 p.m. | Moscone South 103

Content Management in the Cloud: Strategy & Roadmap [CON7257]
Thyaga Vasudevan, Senior Director, Product Management, Oracle
Edi Piovezani, Diretor de Tecnologia, Omni Financeira
Daniel Martins, Programmer / Developer, Accurate Software Ltda
12:30 p.m. - 1:15 p.m. | Moscone West—2014

Digital Experience in the Cloud: Strategy & Roadmap [CON7258]
Igor Polyakov, Sr Principle Product Manager, Oracle
Mariam Tariq, Sr Director Product Management, Oracle
1:45 p.m. - 2:30 p.m. | Moscone West—3000

Create an Employee Portal Using Oracle Documents Cloud Service/Oracle Sites Cloud Service [HOL7607]
2:30 p.m. - 3:30 p.m. | Hotel Nikko—Nikko Ballroom II (3rd Floor)

Scaling Innovation with Oracle Cloud Platform for Middleware—Roadmap/Vision [GEN7006]
Inderjeet Singh, EVP, Fusion Middleware Development, Oracle
4:15 p.m. | Moscone South 103

Hope to see you at these sessions. We encourage you to tweet along with #OOW16 and #OracleDX hashtags. And, see your tweets on https://sites.oracle.com/oowdx/

/* 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-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Calibri","sans-serif";}

Oracle Database 12.2 – PDBaaS

Yann Neuhaus - Mon, 2016-09-19 10:27

It’s official, Larry Ellison made the annoucement at first keynote and the database product team at oracle has released the version and the documentation publicly. Oracle Database Exadata Express Cloud Service is the ‘Cloud First’ environment for 12.2

Documentation

Documentation is there: Cloud > Platform > Data Management > Exadata Express
The 12.2 new features available in that ‘Cloud First’ are documented here

Cloud First

We knew it, 12.2 comes ‘Cloud First’ which means that you cannot download it but you can use it on a Cloud Service. This is in my opinion a very good idea. We will not upgrade all our databases to 12.2 so it’s beter to test it and cloud services are good for that.
However the way it is released is quite limited:

  • There is no free trial. You have to pay for the minimum service to test it (175$/month)
  • Features are very limited because the service is a PDB, not a full database
PDBaaS

This Oracle Database Exadata Express Cloud Service is a fully managed service, wich means that you are not the database administrator. Oracle manages the system, creates and administrate the database. You are a user.
Actually, when you create a service, a Pluggable Database is provisioned for you and you access only this PDB. It addition to that, for security reason, all features that may interact with the other PDBs or the system, are locked down. For example, you cannot use Data Pump because it writes files on the server. All limitations are documented here.
If you wonder how those limitations are implemented, it’s a new 12.2 multitenant feature called lockdown profiles, and resource manager that can isolate PDB memory. I presented that yesterday at Oracle Open World and there is more information about it in new book to come.

Options

Features are limited but you have most of options available: In-Memory, Data Mining, Advanced Compression and Hybrid Columnar Compression, Data Redaction, etc. And it’s an Exadata behind so you have SmartScan.

You can think of it as the ‘Schema as a Service’, but with a PDB instead of a schema.

You access to it only through SQL*Net (encrypted) and can move data to and from using SQLDeveloper.

Shapes

When you see ‘Exadata’, ‘In-Memory’, and all those options, you probably think about a service for very big database and high CPU resources. But it is not. This service is for evaluation of the 12.2, testing, developement, training on very small databases (few hundred of GB). And only one OCPU (which is an intel core with two threads). It’s hard to imagine more than one user on this. Maximum memory being 5GB it’s also hard to imagine In-Memory here.

So the goal is clearly to test feature, not to run workloads. You can go live with it only if your production is not critical at all (database is backed up daily).

Express

The ‘Express’ part is the simplicity. Prices are easy to calculate:

  • 175$/month for 20GB of storage and one OCPU. This is ‘X20′ service.
  • Next level is the ‘X50′ service at 750$/month, so x2.5 times the storage for x4.2 the price. Still one OCPU.
  • Highest level is ‘X50IM’ at 950$/month, which is the same but with larger memory.
Non-Metered

It is a non-metered service: whether you use it or not you pay per month. But don’t think you can do whatever you want within that month as the transfer of data is limited. You can transfer the volume of the database only a few times per month.

So what?

The utilization is simple: you don’t need a DBA. This is the main point: automation and fast provisioning.
Developers will love that. Giving them full options is a good marketing idea. Once the application is designed to use In-Memory, Compression, etc. theses options will be required for production as well.

Today, developers need more agility and are often slowed down by the operations. And that’s a major reason why they go to other products that they can install and use themselves easily: Postgres, Cassandra, MongoDB, etc. Oracle Database is to fat for that: look at the time you need to create a database, catalog, catproc, etc. A first answer was the Oracle XE edition which is easy to install anywhere. Now with this Express Cloud Service Oracle gives to possibility to provision a small database in minutes which requires no further administration.
Actually, this is the whole idea behind the multitenant architecture: consolidate all those system objects created by catalog/catprocg into a common location (CDB$ROOT) and have light PDBs with only user data.

Final remark. Currently 12.2 is available on on that service but there are no doubts that a full 12.2 will come within the next months.

 

Cet article Oracle Database 12.2 – PDBaaS est apparu en premier sur Blog dbi services.

SQL Server 2016: Dynamic Data Masking and database role

Yann Neuhaus - Mon, 2016-09-19 10:19

Last week, dbi services organized an event named “SQL Server 2016: what’s new?” in Lausanne, Basel and Zurich. I would take the opportunity to say again a big thank you to everyone which joined us.
During my session some questions concerning the new functionality Dynamic Data Masking were asked. In fact data are masked for some roles and not for some others.
Let’s try to clarify that.

I will use the same script I used during the event to initialize the database, create the table and fill-in my table with some rows:

-- Create database
USE MASTER
GO
CREATE DATABASE DDM_TEST
GO

-- Create the Confidential table
USE [DDM_TEST]
GO

CREATE TABLE [dbo].[Confidential](
[ID] [int] NULL,
[Name] [nvarchar](70)NULL,
[CreditCard] [varchar](16)NULL,
[Salary] [int] NULL,
[Email] [nvarchar](60)NULL
)ON [PRIMARY]

-- Insert some rows
INSERT INTO [dbo].[Confidential] VALUES ('1','Stephane','3546748598467584',113459,'sts@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('2','David','3546746598450989',143576,'dab@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('3','Nathan','3890098321457893',118900,'nac@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('4','Olivier','3564890234785612',98000,'olt@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('5','Alain','9897436900989342',85900,'ala@dbi-services.com')
INSERT INTO [dbo].[Confidential] VALUES ('6','Fabrice','9083234689021340',102345,'fad@dbi-services.com')

I will create some masks for confidential columns with the following script:

-- create data masking for confidential columns with masking functions
USE DDM_TEST
GO

ALTER Table Confidential
ALTER COLUMN Salary ADD MASKED WITH (FUNCTION = 'random(1, 150000)')
ALTER Table Confidential
ALTER COLUMN CreditCard ADD MASKED WITH (FUNCTION='partial(1,"XXXX",2)')
ALTER Table Confidential
ALTER COLUMN Email ADD MASKED WITH (FUNCTION='email()')

I create now a user and add him to db_datareader role:

-- Create a user named TestDemo and add this user to the db_datareader role
USE DDM_TEST
go
CREATE USER TestDemo WITHOUT LOGIN
USE [DDM_TEST]
GO
ALTER ROLE [db_datareader] ADD MEMBER [TestDemo]
GO

Let’s try to visualize the Confidential table with my user:

DDM_res1

Member of the db_datareader role are able to query the Confidential table but cannot see masked columns without masks.
Let’s try to add my user to the db_datawriter role and rerun my query:

DDM_res2

Same, and it’s normal as db_datawriter cannot change read possibility, but the user is now able to insert data in the Condifendial table like this for example:

DDM_res3

But, it cannot view in clear text data that it has inserted.
The only way to visualize data without masks is to be a member of the db_owner role:

DDM_res4

Conclusion is clear, in order to be able to view masked columns user has to be member of the db_owner role in the database containing the table.
Happy masking ;-)

 

Cet article SQL Server 2016: Dynamic Data Masking and database role est apparu en premier sur Blog dbi services.

Analysing Social Media Data for the Lightyear Foundation - Part 2

Rittman Mead Consulting - Mon, 2016-09-19 09:57

In my last post, I described the basics around connecting to social media data sources using Python. This is in aid of collating information for the Lightyear Foundation, a charity specialising in science education in the UK and Ghana. In this blog, I will demonstrate how to use those integrations to record data into a PostgreSQL database. I've chosen this database in so as to keep everything free and open source.

One of the downsides with some of the publicly available APIs is that they only store a certain amount of history. These makes analysing long term trends a bit more difficult. By recording the data periodically, in an ETL-like fashion, we can circumvent this. Given the vast amount of data available for social media it would not be appropriate to store all of the data in a relational database. Instead, we can store summary statistics for long term trend analysis.

All of the code used in this blog is on this public Git repository. You are welcome to download this and poke around as you follow the blog. Note that there is configuration in config.ini and a keys/google-api.json file required in order to get these working yourself.

Database Integration

The Python module psycopg2 was used to execute transactions against the PostgreSQL database with Python. The script lyf/psql.sql contains a host of functions I wrote to perform useful database and ETL actions.

  • psql.truncate : Truncates a table.
  • psql.insert : Inserts a single row to a table.
  • psql.upsert : Updates a row to a table if a matching key is found, else inserts the row.
  • psql.update : Updates values in a table based on matching keys.
  • psql.delete : Deletes rows from a table based on a WHERE clause.
  • psql.lookup : Updates columns based on a lookup to another table. Useful for assigning foreign keys from natural keys.
  • psql.load_csv : Loads data from a CSV file into a table, mapping header names in the file to columns in the table.
  • psql.query : Executes a SQL statement and returns the data.
Google Analytics

For Google Analytics (GA), there is availability of many dimensions and metrics but I have chosen merely a useful subset to put into a star schema.

Dimensions

For efficiency, I wrote a method to dynamically load dimension tables from a tsv file.

table    ga_dims columns keys  
d_ga_source    "ga:sourceMedium,ga:source,ga:medium,ga:socialNetwork"  "source_medium,source,medium,social_network"    "source_medium"  
d_ga_platform    "ga:operatingSystem,ga:deviceCategory,ga:operatingSystemVersion"    "os,device_category,os_version" "os,device_category,os_version"  
d_ga_geo    "ga:continent,ga:subContinent,ga:country,ga:countryIsoCode,ga:region,ga:cityId,ga:city" "continent,sub_continent,country,country_code,region,city_id,city"  "city_id"  
d_ga_page    "ga:pageTitle"  "page_title"    "page_title"  

The column table refers to the table name in the PostgreSQL schema, which are created manually before executing the script. ga_dims is a comma separated list of GA dimension codes. Note that this is an upper limit of 7 dimensions allowed for a GA API query. columns is another list of equal length describing the mapping to the columns in the database table. Finally keys is a comma separated list of which columns are unique natural keys for the database table. This is so the script can perform updates as well as inserts.

This input file is parsed by load_ga_dims.py which executes a Google API query for each dimension and upserts the records into the database. Essentially, the ETL for this process is defined quite simply by the TSV file and can be changed with relative ease. It doesn't have the scope, flexibility or scale as ODI or Informatica, but for a quick, free version it will suffice.

Fact

The fact table is much simpler to load as we just need to execute a single GA query which specifies only the dimension natural keys and the metrics. The script load_ga_fact.py will go and fetch the dimension warehouse key (always integer) as well as any metrics specified in the file. I've opted for:

  • Sessions
  • Bounces
  • Bounce Rate
  • Average Session Duration
  • Session Duration
  • Page Views
  • Time on Page

Finally there is an integer date ID and some denormalised attributes: Longitude and Latitude. With Google its easy to retrieve a "full load" as the API allows querying of history as well as incremental loads which filtered for today's date. Below is an example query returning the total session time and number of sessions by continent for Jan 2016:

select  
    dt.year_month, 
    geo.continent, 
    sum(session_duration) as total_time, 
    sum(ga.sessions) as sessions
from  
    f_ga_daily ga
    inner join d_ga_geo geo on geo.geo_id = ga.geo_id
    inner join d_date dt on dt.date_id = ga.date_id
where dt.yyyymm = 201601  
group by dt.year_month, geo.continent  
order by dt.year_month;  

Sessions by Continent

Facebook

The extract I wrote for Facebook was much simpler, using date as the sole dimension. If required, dimension tables could be created for posts and videos or other similar data, but in this case we just want to look at trends over time. The measures selected are:

  • Total Likes
  • Total Posts
  • Total Videos
  • Total Video Likes
  • New Posts
  • New Videos
  • Impressions
  • Reach
  • Engaged Users
  • New Likes
  • New Unlikes
  • Video Views
  • Page Views
  • Post Likes

There's no way of extracting history data from Facebook's API, so we need to load data regularly using f_facebook_daily.py. Below is a time series query of likes and reach for a few days:

select  
    dt.date, 
    sum(total_likes) total_likes,
    sum(new_likes) likes, 
    sum(engaged_users) engaged_users,
    sum(reach) reach from
f_facebook_daily fb inner join d_date dt on dt.date_id = fb.date_id  
group by date  
order by 1;  

Time Series - Facebook

Twitter

The Twitter API is not as rich as the Google or Facebook APIs and is limited to only 15 queries an hour. For my ETL scripts this shouldn't matter, but once again no history is available. The script for this load is f_twitter_daily.py. The measures we've got are:

  • Total Followers
  • Total Following
  • Total Tweets
  • Followers
  • Following
  • Tweets
select  
    dt.date, 
    sum(total_followers) total_followers,
    sum(total_following) total_following, 
    sum(total_tweets) total_tweets,
    sum(tweets) tweets from
f_twitter_daily tw inner join d_date dt on dt.date_id = tw.date_id  
group by date  
order by 1;  

Time Series - Twitter

YouTube

The data for videos and views over time are stored in a flatten fact table. Given the small number of attributes for videos and the lack of interconnectivity with the other information, I just denormalised on them onto the fact table. For measures we have:

  • Total Views
  • Views
  • Total Likes
  • Likes
  • Total Dislikes
  • Dislikes

Once again this is loaded incrementally, storing records for each video for each day. The incremental loading script is f_youtube_daily.py. The below query shows how many views the videos got by month:

select  
    dt.year_month,
    sum(yt.views) views
from  
    f_youtube_daily yt
    inner join d_date dt on dt.date_id = yt.date_id
group by dt.year_month  
order by 1, 2;  

Video Views By Month

MailChimp

The MailChimp API allows extraction of information about subscriber lists and campaigns. f_mc_lists_daily.py will load in today's fact data as well as updating the subscriber list dimension. The measures include:

  • Members
  • Unsubscribed
  • Cleaned
  • Total Members
  • Total Unsubscribed
  • Total Cleaned
  • Total Campaigns
  • Open Rate
  • Average Subscribe Rate

Below is an example query showing a snapshot of the subscriber list data as of 9th September 2016.

select  
    dt.date,
    ml.name,
    sum(mc.total_members) total_members,
    sum(mc.total_campaigns) total_compaigns,
    avg(mc.open_rate) open_rate
from  
    f_mc_lists_daily mc
    inner join d_date dt on dt.date_id = mc.date_id
    inner join d_mc_lists ml on ml.list_id = mc.list_id
where date = '2016-09-09'  
group by dt.date, ml.name  
order by 1, 2;  

Subscriber List Snapshot

Summary

Now we've got all these different facts, we can write BI style summary queries to compare all of the data, or provide regular reports. This is a query across multiple fact tables conforming on the date dimension. It shows summary statistics for each fact per month.

with  
ga as  
(
    select dt.year_month, sum(ga.sessions) as sessions, avg(ga.avg_session_duration) as avg_session_duration
    from
        f_ga_daily ga
        inner join d_date dt on dt.date_id = ga.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
),
fb as  
(
    select dt.year_month, last(total_likes) as total_likes, sum(fb.reach) as reach
    from
        f_facebook_daily fb
        inner join d_date dt on dt.date_id = fb.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
),
tw as  
(
    select dt.year_month, last(total_followers) as total_followers
    from f_twitter_daily tw
    inner join d_date dt on dt.date_id = tw.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
),
yt as  
(
    select dt.year_month, sum(views) as views, last(total_views) as total_views
    from
        f_youtube_daily yt
        inner join d_date dt on dt.date_id = yt.date_id
    where dt.year = 2016
    group by dt.year_month
    order by 1
)    
select  
ga.year_month, ga.sessions as web_views, ga.avg_session_duration as avg_web_view_dur, fb.reach as fb_reach,  
fb.total_likes as fb_likes, tw.total_followers as twitter_followers, yt.total_views as total_yt_views, yt.views as yt_views  
from  
ga  
    inner join fb on ga.year_month = fb.year_month
    inner join tw on ga.year_month = tw.year_month
    inner join yt on ga.year_month = yt.year_month;

Summary

So there we have it, a open-sourced ETL package for a handful of social media sites that will track history. The final tables can be used as a source for any reporting tools you want, and the data can all be tied together by date. This is particularly useful for showing summary trends over time. However, I don't store even a fraction of the amount of data that we can get in real time from the APIs. The next blog entry will show how to use open source technologies to visualise this data as well as the real time information.

Categories: BI & Warehousing

#OOW16 #OPN Cloud Managed Service Provider Program

As #OOW16 is currently in progress with a lot of new things and announcements still coming up, Oracle Partner Network yesterday announced the new Oracle Cloud Managed Service Provider (MSP) Program,...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Oracle Transforms the Cloud Infrastructure Market

Oracle Press Releases - Mon, 2016-09-19 07:10
Press Release
Oracle Transforms the Cloud Infrastructure Market New Cloud services deliver unparalleled choice, performance and flexibility

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

Oracle today introduced the broadest array of Infrastructure-as-a-Service (IaaS) offerings in the industry, which include bare metal cloud servers that are 11.5X faster and 20 percent cheaper than the fastest solution offered by the competition. The new additions to the Oracle Cloud Platform enable customers to get the best of both multi-tenant and single-tenant environments and include Oracle Bare Metal Cloud Services, Oracle Ravello Cloud Service, Oracle Container Cloud Service and enhancements to existing Oracle Cloud services.

While the business benefits of the public cloud are increasingly clear, organizations face a myriad of performance, security and management concerns that mean they can’t simply abandon all of their existing IT practices and move all workloads to a multi-tenant cloud world. The latest enhancements to Oracle’s IaaS portfolio help organizations address this challenge by providing the ability to harness the benefits of Cloud while retaining many of the benefits provided by a corporate data center.

Oracle Bare Metal Cloud Services are a high-scale public cloud offering and include bare metal cloud servers in a fully virtualized network environment. The innovative new services deliver high performance database-as-service, network block storage, object storage and VPN connectivity. In addition, Oracle Bare Metal Cloud Services provide a secure, private and high-performance software defined Virtual Cloud Network (VCN) that allows customers to treat Oracle Bare Metal Cloud Services as a secure and elastic extension of their on-premise network. Additionally, Oracle Bare Metal Cloud Services maximize network throughput by providing direct connectivity between compute and storage nodes.

The regional deployment of Oracle Bare Metal Cloud Services consists of three completely fault-independent availability domains, enabling customers to build high availability, high durability applications in the Cloud. Oracle Bare Metal Cloud Services seamlessly interoperates with existing Oracle Cloud Platform offerings, helping customers build mission critical applications that take full advantage of available services on the Oracle Cloud.

Built on the foundation of the most modern datacenter, network and server infrastructure, the Oracle Bare Metal Services are designed with a fundamentally differentiated approach to Cloud platform development that gives customers choice and flexibility on their journey to the Cloud. This included ultra-dense compute servers that provide the industry’s best performance for enterprise workloads as well as the highest IOPS and the highest bandwidth storage servers available anywhere in public cloud offerings. As a result, Oracle customers can achieve 10X the throughput and IOPS of the best offering on competing Clouds, at a lower price. In addition to high performance, by not having software run on the compute hosts, Oracle is able to reduce potential points and deliver the best possible security available in Cloud.

Further extending the Oracle Cloud Platform, Oracle also announced Oracle Ravello Cloud Service, the general availability of Oracle Container Cloud Service and several significant enhancements to existing Oracle IaaS offerings.  

Oracle Ravello Cloud Service is the first cloud service in the industry that enables organizations to take enterprise VMware and Kernel-based Virtual Machine (KVM) workloads and run them in the public cloud without any changes. With Oracle Ravello Cloud Service, customers can run VMware natively on public cloud without requiring VM conversion, application reconfiguration or networking changes. It is also the only service in the industry that allows enterprises to have full L2 and L3 networking flexibility in the public cloud.

Oracle Container Cloud Service provides organizations with a Docker-compatible way to deploy application stacks with a single click. Registry integration capabilities, enterprise-grade application orchestration, and application scheduling and service scaling capabilities make the Oracle Container Cloud Service a uniquely compelling option for cloud developers.

Oracle has also introduced Oracle FastConnect – Standard and Partner editions – to help customers reliably and securely connect their datacenter to the Cloud. With the addition of Oracle FastConnect, Oracle now offers some of the broadest connectivity and peering options available in the industry, including IPsec VPN for easy setup, MPLS to connect to existing enterprise networks and Fast Connect for quick peering.

Oracle Cloud Platform offerings now also support Oracle MySQL Cloud Service, Oracle Big Data Cloud Service and Oracle Event Hub Cloud Service in addition to unparalleled support for Oracle’s existing Platform-as-a-Service offerings.

“As more and more enterprises leverage the Cloud, they want a simple, seamless way to migrate their large and complex IT infrastructures to the Cloud, and to use the security and management controls that their IT teams already know,” said Thomas Kurian, president of product development, Oracle. “The latest additions to the Oracle Cloud Platform enable organizations to seamlessly connect their existing resources to the Oracle Cloud using Virtual Cloud Network (VCN) and select from a wide variety of compute services including bare metal, virtual machines and engineered systems as if it were a part of their own datacenter.”

“We have been very impressed by how easy it is to use Oracle’s Bare Metal Cloud Services. The DataStax Enterprise clusters we’ve deployed are running blazingly fast, with sub-micro second latency, and these are key business drivers for us,” says Ben Lackey, lead partner at DataStax. “Additionally, the multiple availability domains per region, allows us to bring our mission critical, high availability workloads to Oracle’s Bare Metal Cloud.”

“We are excited about the results we are seeing with Oracle’s Bare Metal Cloud, with regard to the architecture, performance and scalability,” said Patrick Sullivan, managing partner and Oracle global technology lead at Accenture. "This enhances our clients’ ability to accelerate their journey to the Cloud.”

For more information, please visit us at http://cloud.oracle.com.

Contact Info
Alex Shapiro
Oracle
+1.650.607.1591
alex.shapiro@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

Alex Shapiro

  • +1.650.607.1591

Oracle Unveils Unmatched Cloud Platform Based on #1 Database and #1 Middleware to Accelerate Move of Enterprise IT to the Cloud

Oracle Press Releases - Mon, 2016-09-19 07:08
Press Release
Oracle Unveils Unmatched Cloud Platform Based on #1 Database and #1 Middleware to Accelerate Move of Enterprise IT to the Cloud New Database-as-a-Service and Platform-as-a-Service offerings make it easier to move, secure and optimize workloads, development and data in the cloud

Fully compatible from entry-level to the largest critical database workloads

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

Oracle today announced a series of major innovations across the Oracle Cloud Platform that are designed to give organizations the confidence they need to run their most critical applications in the Cloud. At the heart of Oracle’s Platform-as-a-Service (PaaS) is Oracle’s new Database-as-a-Service (DBaaS) based on Oracle Database 12c Release 2. Oracle’s new database is being made available in the Cloud first, providing businesses of all sizes with access to the world’s fastest, most scalable and reliable database technology in a cost-effective and flexible Cloud environment.

For nearly 40 years, more than 300,000 customers have trusted Oracle database technology to run database applications. Today, Oracle is bringing that speed, scale and reliability to the Cloud with a new DBaaS offering. Oracle Database 12c Release 2 is fully compatible from entry-level to the largest database workloads and enables businesses to take advantage of on-premise-grade capabilities to run database development, small to mid-sized business and departmental applications, as well as enterprise applications in the Cloud.

Oracle today also unveiled new enhancements and Oracle Cloud Platform offerings including comprehensive tools for all application development models. This includes simplified migration and extension of enterprise workloads in the Cloud, tools for Cloud native, and low-code development. PaaS enhancements unveiled today also include nineteen new Cloud services including: Container Cloud Service, Oracle Identity Cloud Service, Oracle Internet of Things Cloud Service, Big Data Cloud Services and Oracle Analytics Cloud Services.

Today’s announcements by Oracle come at a time when many organizations have found themselves wanting to leverage the cost and simplicity of the Cloud but have yet to make the move. Concerns about security, scale and complexity, uncertain migration paths, fragmented toolsets, and inconsistent user experiences have left many businesses sitting on the sidelines in search of a Cloud offering with the on-premise-grade capabilities enterprise IT requires. With today’s announcements, Oracle is delivering the end-to-end capabilities enterprises need to take full advantage of the Cloud.

“Oracle Cloud Platform enables developers, IT, and line of business leaders to easily leverage the Cloud for any workload,” said Thomas Kurian, president of Oracle product development. “Oracle Cloud Platform offers an integrated offering across IaaS, PaaS, and SaaS, because that’s what the enterprise customer demands. Oracle makes it easy to run our open standards based Platform as a Service in the public cloud with high performance and availability.”

Next Generation Database-as-a-Service

Today’s release of Oracle’s world’s number one database, Oracle Database 12c Release 2, coming first in the Cloud, marks a new era of magnitude and innovation for the enterprise. Building on its unique multi-tenant architecture and in-memory technology, Oracle’s flagship database is poised to exceed today’s requirements and future-proof enterprise against the exponential data sprawl of tomorrow with faster analytics workloads and unrivalled support for database magnitudes up to hundreds of terabytes.

Oracle Database will also help reinvent productivity for DevOps while bolstering security by enabling rapid setup and teardown of new databases as well as advanced configuration to combine the world-class performance of Oracle Exadata engineered systems with Oracle’s unique pluggable database technology. This next-generation standard of performance is now available as an entry-level solution for small to medium sized databases in production, development and testing—starting at just $175 per month with Oracle Exadata Express Cloud Service.

For enterprises to build on top of the world’s number one database, Oracle today released a range of new PaaS services that make it easier to develop, move, manage and connect in the Cloud.

New Approaches for Cloud Application Developers

With Oracle PaaS, developers have more choice than ever to develop on-premise or in the Cloud, using a variety of languages and services. Oracle’s Application Container Cloud Service now includes support for PHP, along with Node.js and Java. Applications composed from multiple PaaS services can be created, scaled and managed as a single unit with the new Oracle Cloud Stack Manager. In addition, enterprises can migrate Java EE apps to the Cloud automatically using Oracle AppToCloud while adding capabilities like active standby and increasing cluster size as the application is moved to the Cloud. Anyone can author complete applications from a browser without coding skills, using the Oracle Application Builder Cloud Service low-code development platform to extend services with pre-populated Oracle Software-as-a-Service APIs or custom services from a common REST API catalog.

Oracle Developer Cloud Service also makes collaboration between developers easier by integrating with popular collaboration tools like Slack, Hipchat, Hashicorp's Packer and Terraform and including agile management features for managing sprints, tasks and backlogs.

Oracle Mobile Cloud Service now provides actionable insights and engagement across multi-channels and micro locations to improve the customer experience. It also provides an intelligent and contextual Chatbots experience across multiple messaging channels like Facebook Messenger, Slack, Kik and others.

Proactive Cloud Security with Identity and Analytics

Oracle Identity Cloud Service is a new Cloud-native security and identity platform that quickly integrates with Cloud applications using open standards and allows user identities to be managed across Cloud and on-premise deployments.

Security is further enhanced with the new Oracle Security Monitoring and Analytics Cloud Service in the new Oracle Management Cloud that uses machine learning to help identify threats and provide early warnings. Oracle Management Cloud is the first fully integrated tool to manage the lifecycle of enterprise applications. It uses machine learning to monitor and analyze end-to-end operational data across heterogeneous environments, detect anomalies and help ensure performance and compliance.

Simplifying Application and Data Integration across Multiple Clouds and On-Premise

Developers can use Oracle API Platform Cloud Service to create, secure and manage their APIs with zero code and pre-built analytics charts, while being able to run the API gateway within the Oracle Cloud, on-premise or on third party clouds. Zero-code orchestration for Cloud to on-premise integration is also now available with Oracle Integration Cloud Service which includes more than fifty pre-built adapters for apps including Ariba, Concur, LinkedIn, Salesforce, Slack, Twilio, Twitter and more.

Oracle’s Data Integration Cloud Service offers streaming replication and extract, transform and load capabilities for a variety of use cases including data migration and to support data warehouse style workloads that move data across PaaS, including Oracle Database as a service, Oracle Big Data Cloud Service, and even non-Oracle DBaaS. Oracle Data Integration Cloud includes a unified design environment for developing MapReduce transformations, transforming structured data and developing Hive-based transformations, all in a single utility. Oracle delivers an industry first in its ability to replicate data in near real-time or in batches from on-premise to the Cloud or from one Cloud to another.

Using Oracle Internet of Things Cloud Service, customers can deploy out-of-the-box IoT applications such as Asset Monitoring, Production Monitoring, Fleet Monitoring or Connected Worker. The IoT Cloud service delivers simplified connectivity through device virtualization, streaming and predictive analytics. This combines in-motion data collected from devices, at-rest contextual data residing in the ERP and CRM applications and pre-existing integrations with business applications like Oracle Service Cloud, Oracle E-Business Suite, Oracle’s JD Edwards and Oracle’s PeopleSoft.

Big Data and Analytics Unleashed in the Cloud

Oracle Big Data Cloud Services adds many new services and capabilities including support for Apache Hadoop, Apache Spark, Apache Kafka, and NoSQL technology. Oracle Big Data Cloud Service Compute Edition is a fully managed, elastic service, providing a platform for big data management and analytics. Oracle Event Hub Cloud Service is a fully managed, elastic service that supports the loading, processing and analysis of streaming data and the development and deployment of streaming applications. Oracle DataFlow ML Cloud Service supports streaming and batch data movement and transformations, with machine learning recommendations for mapping, profiling, and enriching big data. Oracle NoSQL Database Cloud Service delivers predictable high performance for the most demanding NoSQL applications. Finally, Oracle Big Data SQL Cloud Service offers one fast SQL query on all big data stored in Hadoop, multiple NoSQL databases and Oracle Database.

Oracle Analytics Cloud lets enterprise empower anyone to ask any question of any data using any device, in the Cloud, on-premise, or both. This includes Oracle Essbase Cloud Service, a new Cloud solution that enables enterprises to transform unreliable spreadsheet-based processes into streamlined collaborative models in minutes. Adding to rich visualization and self-service discovery capabilities, Oracle Data Visualization Cloud Service now interprets data to automatically create smart insights and make business more productive. It includes smart data connectors to more than 40 sources, self-service data preparation and packaged analytic applications for sales, marketing, human resources and finance.

Contact Info
Alex Shapiro
Oracle
+1.650.607.1591
alex.shapiro@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

Alex Shapiro

  • +1.650.607.1591

Oracle Unveils Its Next Generation Cloud Strategy: Intelligent Applications

Oracle Press Releases - Mon, 2016-09-19 07:06
Press Release
Oracle Unveils Its Next Generation Cloud Strategy: Intelligent Applications Oracle adds to its industry leading Cloud portfolio with new SaaS Cloud services and enhancements

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

Building on its position as the industry’s leading Cloud Applications provider, Oracle today unveiled its strategy for next generation Software as a Service (SaaS) Cloud offerings that blend third-party data with real-time analytics and behavioral inputs to create Cloud Applications that adapt and learn. The result: intelligent Cloud Applications that automatically offer individualized recommended actions and streamline the tasks of business users such as human resource or finance professionals. 

Called Adaptive Intelligent Applications, these next generation Cloud offerings are based on the insights contained within Oracle’s Data Cloud, which is a collection of more than 5+ billion consumer and business profiles, with over 45,000 attributes. When activated, these new Adaptive Intelligent Applications use Oracle’s web-scale data and apply advanced data science to learn and ingest data about an organization’s users and their behaviors to deliver targeted information to customers and employees. The insights from these deep analytics build a knowledge base that helps improve business results across organizations.

R “Ray” Wang, principal analyst at Constellation Research said: “There is a huge opportunity to monetize digital business through machine learning applications and analytics, and Oracle’s large corpus of data, strong expertise in data science, massive compute power, industry and domain expertise, and breadth of application solutions make it well-suited to be a leader in the quickly growing space.”

“A company’s data is its most valuable weapon. To remain competitive today, companies must access their information in real time to intelligently forecast and grow,” said Steve Miranda, Oracle’s executive vice president of applications development. “Oracle Adaptive Intelligent Applications leverage anonymized information from our extensive Data Cloud to optimize existing Cloud Application functionality. When this is combined with a company’s own data, we are able to provide unparalleled customized insights to help enhance business performance.

Oracle Adaptive Intelligent Applications have direct benefits for functional business units, providing them with actionable business and customer insights to make more informed decisions:

  • Finance professionals can nimbly negotiate best supplier terms, while optimizing cash flow needs and balancing costs—especially during critical financial events such as the end of a quarter or for a high volume of payables.
  • Human Resources recruiters can automatically identify best-fit candidates in the shortest time and HR managers can create job descriptions that will help candidates more efficiently find the best and most well-suited positions.
  • Marketing and Commerce managers can drive higher conversion rates, lift, repeat purchases, and ultimately, revenue, with smart, contextual offers and recommended actions for individual consumers.
  • Supply Chain managers can automatically find the best options to distribute goods around the world, while optimizing costs and price for both the buyers and the transporters to provide the best value freight and transportation options for enterprise shippers.

“Within the foreseeable future, every enterprise application will be a smart application that intuitively learns from interactions with an enterprise’s data. Oracle’s new Adaptive Intelligent solutions take this value proposition a step further. They are set apart from others by allowing the intelligent applications to learn from billions of anonymized consumer and business profiles available from Oracle.” said Dave Schubmehl, research director of cognitive systems and content analytics for IDC. 

Building on its industry-leading suite of Cloud Applications, Oracle further expanded its SaaS portfolio with additional new Cloud Applications and enhancements that span sales, marketing, finance, human resources, and other areas of business. Some of the new offerings include: 

  • Oracle Engagement Cloud, part of Oracle’s Customer Experience Cloud portfolio, is a new offering, which combines Oracle’s sales and service capabilities in one, providing a unique combination of sales automation, service request management, knowledge management, and customer self-service. Oracle Engagement Cloud enables organizations’ employees to deliver both sales and customer services from a single screen, powering a one-stop customer experience. Oracle Engagement Cloud helps improve customer satisfaction and loyalty, while increasing up-sell opportunities, particularly for organizations providing high-touch and high value customer engagements, such as wealth managers, enterprise sales reps, or managers who need access to service request in industries such as financial services, high tech and industrial manufacturing, consumer goods, and communications.
  • Oracle Financial Consolidation and Close (FCCS) Cloud, part of Oracle’s Enterprise Performance Management Cloud portfolio, enables Chief Financial Officers at organizations of all sizes to minimize risk, provide transparency, and ensure accurate results of the close. Able to rapidly deploy in weeks, Oracle FCCS provides CFOs the operational agility they need to effectively communicate their financial results to internal and external stakeholders, to quickly consolidate the operating results of an acquired business to help ensure compliance, and to scale globally without a need to re-implement core financial processes or systems.
  • Oracle Revenue Management Cloud, part of Oracle Enterprise Resource Planning (ERP) Cloud, increases visibility into the status and value of contracts, delivers compliant revenue recognition, and creates configurable and auditable revenue entries. The solution allows companies to adhere to the ASC 606/IFRS 15 core principles, accelerating the transition to the new accounting standards. Oracle ERP Cloud’s new enhancements deliver new support to Chief Financial Officers (CFOs) and their organizations with revenue recognition standards and multi-period accounting capabilities. Driving efficiencies and controls, Oracle ERP Cloud also enables organizations to scale globally with multi-language, multi-GAAP, multi-currency, and localization extensions that can transform finance organizations. As the most complete, modern, and proven ERP Cloud solution, Oracle ERP Cloud’s rapidly expanding customer base includes strong momentum in the public sector and with state and local governments.
  • Oracle Student Cloud’s new Oracle CX for Higher Education uses Oracle’s intuitive mobile technology to help recruiters boost their pipeline by targeting and qualifying best-fit prospects via social, email, and SMS CRM capabilities. Oracle Student Recruiting Cloud’s embedded analytics also help improve forecasting and monitor and optimize recruiters’ performance in their territories. Student Management Cloud is Oracle’s first application of student information systems (SIS) in the Cloud. It provides a student management roadmap and the foundation for nontraditional university functionality in a comprehensive, next-generation SIS that supports changing academic models by managing flexible academic structures, personalized learning, just-in-time intelligence, and BYOD access.
  • Oracle Human Capital Management Cloud’s latest release provides healthcare solutions to manage complex labor rules and contractual terms that enable customers to define eligibility rules for core Human Resources and criteria for benefits, absence, time, and labor and payroll. Oracle also helps provide an added layer of auditing, which can be easily managed in the Cloud. Additional global and industry extensions for higher education, retail, manufacturing, public sector, and professional services, also make it easier for multinational organizations to deploy and configure the solutions with expanded localizations for 99 countries.
  • Oracle Internet of Things Cloud collects data and conducts analysis in real time. Line of business users, such as Manufacturing Plant Managers, can monitor real-time quality control, get early insights into predictive maintenance needs, improve worker and equipment safety, and optimize yield through Oracle’s IoT Cloud Applications.
  • Oracle Supply Chain Management Cloud updates enable increased flexibility, reduced costs, and improved performance and visibility across the business. This comprehensive foundation allows forward-thinking organizations to optimize their global supply chains from ideation to design, to order capture, to manufacturing and planning, to shipping and logistics. Leverages the additional insights available through capabilities such as the Internet of Things and Oracle Data Cloud, Oracle offers the Intelligent Supply Chain.
Contact Info
Joann Wardrip
Oracle
+1.415.867.6018
joann.wardrip@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

Joann Wardrip

  • +1.415.867.6018

Oracle Announces the Industry’s Most Comprehensive Offering for Analytics in the Cloud

Oracle Press Releases - Mon, 2016-09-19 07:04
Press Release
Oracle Announces the Industry’s Most Comprehensive Offering for Analytics in the Cloud Oracle Analytics Cloud is a comprehensive set of capabilities spanning packaged content, expert models, and data services as well as platform, applications and infrastructure

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

Oracle today announced a number of innovations in analytics that give organizations a unified and complete suite of Cloud services to unlock value from their data. The new Oracle Cloud services enable businesses to fundamentally transform the way they generate insights from people, algorithms, processes and machines and deliver them to their users with intuitive visualizations, creative narratives and predictive outcomes using expert models and adaptive learning.

The industry's only end-to-end solution for business analytics, Oracle Analytics Cloud includes a high performance analytic processing infrastructure at scale; a broad suite of tools for data preparation, discovery, visualization and collaboration; a pre-packaged suite of domain-specific machine learning models; packaged best-practice analytic key performance indicators (KPIs) to run your business; and large scale, curated public data sets all designed for analytics.

“Public Cloud deployments of business analytics software are still in relatively early stages of adoption. However, the market for Cloud deployments are expected to grow at a rate 5x greater than on-premises and other deployment methods. Oracle Analytics Cloud embraces the emerging hybrid data management and analytics architecture, delivers self-service data access and analysis, and will embed cognitive/AI functionality. These capabilities make the company well positioned to take advantage of this market opportunity.” Dan Vesset, group vice president, Analytics and Information Management at IDC.  

Oracle is the only company that unifies all these components of a modern analytics foundation including:

High Performance Infrastructure for Analytics at Scale

Oracle provides a complete set of very high-performance, elastically scalable infrastructure services designed for analytics processing on data of various types, shapes, and speeds:

  • Infrastructure: hyper-efficient compute, block and object storage infrastructure in the Cloud provides the best performance and scalability for analytic processing.
  • Elastic Analytics Platform: elastic Hadoop, Spark, and data streaming using Kafka allows customers to create elastic clusters to process data with MapReduce and Spark.
  • Flexible Data Storage: includes high-performance Object Storage, HDFS, Oracle Database and key-value/NoSQL engines.
  • Smart Options for Data Ingestion: includes streaming for high speed real-time and event data, and high-volume data replication across varied sources.
Powerful Capabilities for Data Preparation, Discovery, Visualization, and Collaboration

Built on the high-performance analytics infrastructure, Oracle provides a complete suite of tools to enable anyone in the company to derive insights and share them: 

  • Data preparation to ingest, profile and cleanse data using a variety of algorithms.
  • Data flow allows data stewards to prepare, transform and aggregate data and then run machine-learning models at scale.
  • Data discovery makes it easy for subject matter experts to collaborate with data science teams, blending intelligent analysis at scale, machine learning, and statistical modeling.
  • Data visualization empowers anyone to visualize any data and glean insight on any device, on premises and in the cloud.
  • Data collaboration offers everyone proactive conversational content and drives ongoing interaction around smart insights.
  • Data-driven interfaces enable application developers to extend, customize and embed rich analytic experiences in their application flow.
Packaged Analytics and Machine Learning Models

Extending intelligence across the enterprise requires knowing the right metrics to measure and getting the guidance to understand those metrics in every aspect of the business. Unlike other vendors who provide platforms without data or expertise, or only offer artificial intelligence as the solution, Oracle delivers data, intelligence and expertise together. This includes hundreds of person years of analytical expertise tailored to multiple industries and business functions, embedded in core applications and extensible via a cloud-based analytics platform:

  • 8,000+ best practice KPIs for roles across a variety of functions including sales, marketing, service, finance, human resources and supply chain.
  • Optimized solutions with pre-built analytics for the largest portfolio of industry specific solutions including Communications, Construction and Engineering, Education, Financial Services, Health Sciences, Hospitality, Manufacturing, Retail and Utilities.
  • Smart Applications that adapt based on packaged machine learning and artificial intelligence algorithms to provide intelligent predictions and recommendations.
  • Domain-specific applications for industries such as asset monitoring, production monitoring of manufacturing and supply chain systems, fleet management and connected workers.
  • A collaborative Oracle Cloud community for users to share analytics and expertise by exchanging data models, machine learning solutions, and algorithms.
Packaged Curated Data Sets to drive Analytics

To drive more effective marketing, selling, e-commerce and customer service, Oracle also offers packaged and highly curated data sets to drive more effective business processes and more targeted analytics.

  • Oracle Data Cloud: the world’s largest data marketplace intelligently aggregates and normalizes data across more than 5 billion global consumer profiles, with over 45,000 different dimensions from 1,500 providers. This unique data marketplace gives enterprises deep insight into their customers and prospects and can be activated through a suite of adaptive intelligent applications powered by deep learning models that operate at web-scale to learn about users and their behaviors.

“Competition in the cloud is changing,” said Thomas Kurian, president of product development at Oracle. “Inexpensive computing and storage are important, but the real game changer is creating business value through better insight. Only Oracle ties all the data, technologies, and expertise together to deliver that value for our customers. It’s that simple.”

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

ClubCorp, eHarmony and Lyft Tap Oracle Cloud to Help Accelerate Innovation and Lower Costs

Oracle Press Releases - Mon, 2016-09-19 07:02
Press Release
ClubCorp, eHarmony and Lyft Tap Oracle Cloud to Help Accelerate Innovation and Lower Costs Top global and innovative digital brands choose Oracle to run their businesses

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

From the world's largest companies to industry disrupters and leading consultancies, Oracle Cloud is redefining the future of enterprise software and helping to transform businesses around the world. Boingo Wireless, SUPERVALU, and Telefonica UK, are just a few of the many organizations who have selected Oracle to help them take advantage of the Cloud to drive innovation and gain a competitive advantage. Oracle Cloud is experiencing exceptional growth and now has more than 20,000 customers.

This week at Oracle OpenWorld 2016, featured customer speakers ClubCorp CIO Patrick Benson and HSBC Global Services CFO Joanna Fielding will share their stories on stage with Oracle CEO Mark Hurd. Additionally, as part of more than 2,500 innovative sessions, customer and partner speakers from top global brands and emerging companies will talk about how they are using Oracle Cloud to help drive success, including Airbnb, American Airlines, American Express, Arby’s, Coach, The Clorox Company, Comcast, DocuSign, eHarmony, Facebook, FedEx, Gap, Goldman Sachs,  Hilton Worldwide, Hyatt Hotels, IDEA Cellular, JCPenney, Lyft, McGraw-Hill Education, MoneyGram, Orange, Pandora Media, NBCUniversal, Nintendo of America, SGS, Skanska, Sur La Table, T-Mobile, Tippett Studio, Twitter, United Airlines, Vodafone, Volkswagen AG and Wells Fargo.

“Our customers see significant advantage in a comprehensive, integrated suite of Cloud capabilities across all layers of the Cloud,” said Thomas Kurian, president, Oracle. “But where we really differentiate is by integrating the layers in unprecedented ways. There is tremendous power in that integration as it provides customers with unparalleled choice, flexibility and security.”

ClubCorp Selects Oracle Cloud

With a portfolio of more than 200 golf and country clubs and business, sports and alumni clubs in 26 states, the District of Columbia and two foreign countries, ClubCorp is the largest owner and operator of private golf, country clubs and business clubs in the US. The clubs in its network serve more than 430,000 members and 20,000 employees.

ClubCorp is modernizing its IT environment and migrating to the Oracle Cloud to run a mix of Oracle and non-Oracle workloads. Additionally, newly acquired clubs and members will be on-boarded more quickly and seamlessly to optimize profit.

“We anticipate that moving our entire IT environment to the Oracle Cloud will have an incredible impact on our business model in many ways, including our ability to serve our clubs and their members,” said Patrick Benson, CIO, ClubCorp. 

Oracle Cloud enables organizations to move their enterprise workloads to the Cloud while providing their customers with a portfolio of highly innovative and accessible cloud-based services to capitalize on key transformative technologies such as big data analytics, social, mobile and IoT.

For additional information, visit Oracle Cloud and connect with Oracle Cloud on Facebook and Twitter.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@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

Nicole Maloney

  • +1.650.506.0806

Accenture and Oracle Expand the Accenture Oracle Business Group to Include Infrastructure-as-a-Service Offerings

Oracle Press Releases - Mon, 2016-09-19 07:01
Press Release
Accenture and Oracle Expand the Accenture Oracle Business Group to Include Infrastructure-as-a-Service Offerings Accenture becomes the first cloud managed service provider across Oracle’s public cloud

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

Accenture (NYSE: ACN) and Oracle (NYSE: ORCL) have announced that infrastructure-as-a-service (IaaS) offerings will now be available through the Accenture Oracle Business Group, adding to the already-existing software-as-a-service (SaaS) and platform-as-a-service (PaaS) capabilities. The expansion of capabilities further positions Accenture as Oracle’s largest global systems integrator (GSI) and a leader in Oracle Public Cloud.

The Accenture Oracle Business Group was launched in April 2015 to deliver industry-specific solutions built on the Oracle Public Cloud that help clients with their digital transformation goals, realize the benefits of the Cloud faster and help reduce risk. Following an initial focus on the public, financial and hospitality services sectors, the combined business group has grown to support federal, insurance, health, higher education, oil and gas, and utilities industries. The extension to IaaS now means that the robust set of industry solutions will be available across a comprehensive Cloud suite of offerings, including both Oracle and non-Oracle workloads.

“Oracle is expanding their Cloud capabilities at an impressive pace, and we are pleased to now provide joint clients with a complete suite of offerings and industry solutions through the Accenture Oracle Business Group,” said Paul Daugherty, Accenture’s chief technology officer. “The addition of new IaaS offerings reflects our ongoing commitment to help clients achieve value through Oracle’s Cloud solutions and solidifies Accenture’s position as the first managed services provider for Oracle’s Cloud portfolio.”

“The growth of the Accenture Oracle Business Group showcases the continued strength of our more than two decade relationship with Accenture,” said Thomas Kurian, president of product development at Oracle. “Oracle is excited to announce Accenture as the first partner in our new Cloud Managed Service Provider Program. We look forward to Accenture’s ongoing role as a leading service provider for migration, implementation and managed services within Oracle’s Public Cloud to help mutual clients on their journey to the Cloud.”

With the addition of IaaS to the Accenture Oracle Business Group, Accenture has launched the following offerings:

  • Accenture migration services factory for Oracle IaaS
  • Accenture database performance lab for Oracle IaaS
  • Accenture managed services for Oracle Public Cloud (across SaaS, PaaS and IaaS)

Accenture will also migrate several of its Oracle offerings to Oracle IaaS and delivering them through the Accenture Oracle Business Group. The offerings will be supported on Oracle IaaS and include Accenture Enterprise Services for Government, Accenture Foundation Platform for Oracle and Accenture Life Sciences Cloud.

Accenture has been widely recognized by analyst firms as a leading Oracle implementation and managed services GSI. With this extension to IaaS, Accenture has achieved the prominent position of a leading Oracle services provider across Oracle’s Cloud portfolio—spanning SaaS, PaaS, and IaaS (including Oracle Cloud Machine).

The Accenture Oracle Business Group has been especially successful in its inaugural year with more than 70 clients added. The growth of the combined business group strongly positions the deep technology expertise of Accenture and Oracle’s expansive set of Cloud solutions to help these pioneering leaders effectively move to the Cloud.

Accenture has more than 52,000 Oracle-skilled consultants around the world who help accelerate digital transformation by implementing Oracle-based business solutions and new business processes that can develop and evolve as their digital business grows. Accenture has teamed with Oracle for more than two decades and is a Diamond and Global Cloud Elite-level member in Oracle PartnerNetwork. For more information on the Accenture and Oracle relationship, please visit www.accenture/oracle.

Contact Info
Candice van der Laan
Oracle
+1.650.506.0814
candice.van.der.laan@oracle.com
Oriana Branon
Accenture
+1.415.537.5032
oriana.branon@accenture.com
About Accenture

Accenture (NYSE: ACN) is a leading global professional services company, providing a broad range of services and solutions in strategy, consulting, digital, technology and operations. Combining unmatched experience and specialized skills across more than 40 industries and all business functions – underpinned by the world’s largest delivery network—Accenture works at the intersection of business and technology to help clients improve their performance and create sustainable value for their stakeholders. With approximately 375,000 people serving clients in more than 120 countries, Accenture drives innovation to improve the way the world works and lives. Visit us at www.accenture.com.

About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) is Oracle's partner program that provides partners with a differentiated advantage to develop, sell and implement Oracle solutions. OPN offers resources to train and support specialized knowledge of Oracle’s products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to be recognized and rewarded for their investment in Oracle Cloud. Partners engaging with Oracle will be able to differentiate their Oracle Cloud expertise and success with customers through the OPN Cloud program—an innovative program that complements existing OPN program levels with tiers of recognition and progressive benefits for partners working with Oracle Cloud. To find out more visit: http://www.oracle.com/partners.

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.

Copyright © 2016 Accenture. All rights reserved. Accenture, its logo, and High Performance Delivered are trademarks of Accenture.

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

Candice van der Laan

  • +1.650.506.0814

Oriana Branon

  • +1.415.537.5032

Oracle Partners Accelerate Innovation and Customer Success in the Cloud with Oracle

Oracle Press Releases - Mon, 2016-09-19 07:00
Press Release
Oracle Partners Accelerate Innovation and Customer Success in the Cloud with Oracle New Oracle Cloud Managed Service Provider Program pairs partner services with Oracle’s leading cloud platform to drive datacenter transformation for customers in the cloud

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

Companies are increasingly looking to the Cloud to stay competitive and drive datacenter transformation. However, many lack the internal skillsets and resources needed to manage complex Cloud migrations and ongoing maintenance, or have the need to shift those resources to areas of strategic innovation. Enabling customers to speed up success in the Cloud with support from the right partner and platform, Oracle PartnerNetwork (OPN) today announced the Oracle Cloud Managed Service Provider (MSP) Program.

Available to partners with the skills and infrastructure to build, deploy, run and manage both Oracle and non-Oracle workloads, the program enables OPN members to offer a complete managed service solution for workloads running on Oracle Platform as a Service and Infrastructure as a Service.

The partner will be able to buy Oracle Cloud Platform based on the unique needs of the customer, package their MSP services, and sell the integrated solution through a streamlined business model. Partners reap the benefits of building their services on a world-class Cloud infrastructure and customers get the complete solution they need to optimize their Cloud initiatives—helping reduce risk, cost and complexity.

Early partners participating in the program include Accenture, Atos, Capgemini, Cognizant Technology Solutions, Deloitte Consulting, LLP, Dimension Data, Fujitsu, Hitachi Consulting, Infosys Limited, PwC, Tata Consulting Services, Tech Mahindra Limited, and Wipro Limited.

“Cloud represents a huge opportunity for our partner community and Oracle will continue to innovate new programs and offerings that help them grow and thrive in the Cloud,” said Sanjay Sinha, vice president, Platform Products, Oracle. “The new MSP program is a win-win for our customers and partners, as it enables us to work in tandem to provide the solutions and services needed to accelerate time to value and success in the Cloud.”

Sample services provided by Oracle Cloud MSP partners can include: cloud advisory, service migration, DevOps, provisioning and orchestration, monitoring, incidence and change management, and Cloud optimization, among many others.

“Cloud represents the new tech battle ground as companies of all sizes look to modernize their infrastructure to stay competitive,” said Steve White, program vice president, Channels and Alliances, IDC. “The new Cloud MSP program from Oracle offers partners and customers an avenue to pair leading services with Oracle’s Cloud platform to help orchestrate this evolution to the Cloud in an efficient model.”

Helping Partners Grow their Business in the Cloud

Demonstrating the strong market demand for Cloud MSP support, a recent report from 451 Research found that Managed Services at Cloud Service Providers are expected to grow from $17B in 2014 to $43B in 2018.

To participate in the program, partners must meet a specific set of criteria. This includes meeting the conditions of an Oracle Cloud MSP Partner Validation Checklist, which will be audited by a third party, as well demonstrate a minimum level of competency in Oracle IaaS and PaaS products. 

Oracle Cloud MSP partners will receive sales and go-to-market support, and can promote their offering with specific Oracle Managed Service Provider branding. OPN also today unveiled the Oracle Cloud MSP Knowledge Zone providing partners with key enablement resources and support throughout their engagement in the program.  

Partners interested in becoming an Oracle Cloud Managed Service Provider can also learn more at: http://bit.ly/2cLgNFt

Contact Info
Candice van der Laan
Oracle
+1.650.506.0814
candice.van.der.laan@oracle.com
About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) is Oracle's partner program that provides partners with a differentiated advantage to develop, sell and implement Oracle solutions. OPN offers resources to train and support specialized knowledge of Oracle’s products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to be recognized and rewarded for their investment in Oracle Cloud. Partners engaging with Oracle will be able to differentiate their Oracle Cloud expertise and success with customers through the OPN Cloud program—an innovative program that complements existing OPN program levels with tiers of recognition and progressive benefits for partners working with Oracle Cloud. To find out more visit: http://www.oracle.com/partners.

The Oracle Cloud Marketplace offers an intuitive user interface to browse and search for available applications and services, as well as user ratings and reviews to help customers determine the best business solutions for their organization. With its new automated application installation features, customers can easily deploy provider business applications from a centralized cloud interface.

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

Candice van der Laan

  • +1.650.506.0814

Hear What Partners Are Saying About the New Oracle Cloud Managed Service Provider Program and Oracle Cloud

Oracle Press Releases - Mon, 2016-09-19 07:00
Press Release
Hear What Partners Are Saying About the New Oracle Cloud Managed Service Provider Program and Oracle Cloud

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

“Our Oracle experts have deep experience and expertise in helping clients plan, adopt and implement Oracle Cloud initiatives as the foundation of a digital transformation,” said John Cooper, vice president and Oracle Solution Practice Leader, Cognizant. “As a member of the Oracle Cloud Managed Service Provider Program, we are focused on expanding our long relationship and extensive work with Oracle as we develop innovative Cloud solutions, platforms and services that can help our clients accelerate their move to a more nimble, competitive enterprise infrastructure designed for the digital era.”

“The Oracle MSP program provides Dimension Data an avenue to expand our global services and offer enterprise wide Cloud solutions to our clients on any workload,” said Scott Gibson, group executive, Digital Practice, Dimension Data. “This speaks to the heart of Dimension Data where connecting our clients has been core to our business for 30 years. The Oracle MSP program enhances our reach and enables our team to operate at a new level, regardless of location. This MSP program solidifies the Oracle relationship with Dimension Data, an ever increasing strategic focus.”

"Oracle and Fujitsu have a 30+ year business relationship helping customers solve business challenges through technology solutions. Both companies are committed to driving Digital Transformation and offer a clear path to the Cloud,” illustrates Ananth Kondalraj, vice president Oracle Practice at Fujitsu America, Inc. “Leveraging the Fujitsu Digital Business Platform, MetaArc and Software Cloud Services Management, with Oracle’s Cloud infrastructure—in one streamlined package – offers customers the strong foundation needed to migrate and manage critical workloads in the Cloud, with less cost and complexity, allowing for more flexibility in technology deployments.”

“We are excited to be part of Oracle Cloud Managed Services Partner program (MSP) to help enterprises build a scalable hybrid IT model  leveraging Wipro’s BoundaryLess Data Center (BLDC) platform to accelerate their digital journey,” said Kiran Desai, senior vice president and business head, Global Infrastructure Services (GIS), Wipro Limited. “The BLDC platform provides end to end life cycle services across Oracle IaaS and PaaS to help customers enhance speed of execution and improve business performance.”

“As clients across the world are looking at migrating to the Cloud environment, Tech Mahindra, a specialist in digital transformation, consulting and business reengineering is uniquely positioned to help them in this journey by being part of the Oracle Cloud Managed Service Provider (MSP) Program,” said Pritam Parvatkar, senior vice president and global head, Strategic Alliances of Tech Mahindra Ltd. “We are looking at building a deeper relationship with Oracle by leveraging Oracle’s leading cloud infrastructure for clients across the world.”

“Accenture is excited to be the first partner in Oracle’s new Cloud Managed Service Provider Program,” said Paul Daugherty, Accenture’s chief technology officer. “As a leading global systems integrator, Accenture looks forward to building on our 25-year long relationship to help joint clients move to the Cloud quickly, easily and with less risk.”

Contact Info
Candice van der Laan
Oracle
+1.650.506.0814
candice.van.der.laan@oracle.com
About Oracle PartnerNetwork

Oracle PartnerNetwork (OPN) is Oracle's partner program that provides partners with a differentiated advantage to develop, sell and implement Oracle solutions. OPN offers resources to train and support specialized knowledge of Oracle’s products and solutions and has evolved to recognize Oracle’s growing product portfolio, partner base and business opportunity. Key to the latest enhancements to OPN is the ability for partners to be recognized and rewarded for their investment in Oracle Cloud. Partners engaging with Oracle will be able to differentiate their Oracle Cloud expertise and success with customers through the OPN Cloud program—an innovative program that complements existing OPN program levels with tiers of recognition and progressive benefits for partners working with Oracle Cloud. To find out more visit: http://www.oracle.com/partners.

The Oracle Cloud Marketplace offers an intuitive user interface to browse and search for available applications and services, as well as user ratings and reviews to help customers determine the best business solutions for their organization. With its new automated application installation features, customers can easily deploy provider business applications from a centralized cloud interface.

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

Candice van der Laan

  • +1.650.506.0814

New ORAchk & EXAchk Versions 12.2.0.1.1 Released

Syed Jaffar - Mon, 2016-09-19 06:29

New ORAchk & EXAchk v12.2.0.1.1 release is out now with so many new features. Its easy to use and upgrade.

Below is the blog entry about the new release and features by RAC Assurance Development team at Oracle:

https://www.linkedin.com/pulse/new-orachk-exachk-versions-122011-released-gareth-chapman?trk=hp-feed-article-title-publish

Creating a Web App – One Year On

Complete IT Professional - Mon, 2016-09-19 06:00
One year ago I decided to create a web app for an organisation a friend of mine works with. I’d like to share where it’s at and what I’ve learnt. One Year On I wrote a post where I decided to create a web app. It’s a customised reporting tool for a group of sports […]
Categories: Development

connecting subnets

Pat Shuff - Mon, 2016-09-19 02:07
This week we are going to focus on connecting computers. It seems like we have been doing this for a while. We have looked at connecting our desktop to a cloud server (Linux and Windows). We have also looked at hiding a server in the cloud so that you can only get to it from a proxy host and not from our desktop or anywhere on the cloud. In this blog we are going to start talking about changing the configuration so that we create a new network interface on our desktop and use this new network interface to connect through a secure tunnel to a second network interface on a compute cloud. A good diagram of what we are trying to accomplish can be seen below.

Note that there are three components to this. The first is Corente Gateway running in your data center. The second is Corente Gateway running in the Oracle Cloud. The third is the Corente App Net Manager Service Portal. The basic idea behind this is that we are going to create a second network as we did with hiding a server in the cloud. We initially setup one instance so that we could access it through a public IP address 140.86.14.242. It also has a private IP address for inside the Oracle Cloud of 10.196.135.XXX. I didn't record the internal IP address because I rarely use it for anything. The key here is that by default a subnet range of 10.196.135/24 was configured. We were able to connect to our second server at 10.196.135.74 because we allowed ssh access on the private subnet but not on the public network. When this blog was initially written Oracle did not support defining your own subnet and assigned you to a private network based on the rack that you got provisioned into inside the Cloud data center. As of OpenWorld, subnet support was announced so that you could define your own network range. One of the key feedbacks that Oracle got was that customers did not like creating a new subnet in their data center to match the Oracle subnet. They would rather define their own subnet in the Oracle Cloud to match the subnets that they have in their own data center.

Let's take each of these components one at a time. First the Corente Gateway running in your data center. This is a virtual image that you download or software components that you install on a Linux system and run in your data center. The concept here is that you have a (virtual) computer that runs in your data center. The system has two network interfaces attached. The first can connect to the public internet through network address translation or is directly connected to the internet or through a router. The second network interface connects to your private subnet. This IP address is typically not routable like a 10. or 192.168. network. There is not mistake that your are hoping to get to a machine on the internet because these networks are non-routable. The key is that the Corente Gateway actually has a listener that looks for communications intended for this non-routable network and replicates the packets through a secure tunnel to the Corente Gateway running in the Oracle Cloud. All of the traffic passes from your local network which is non-routable to another network hundreds or thousands of miles away and gives you the ability to talk to more computers on that network. This effectively gives you a private virtual network from your data center to a cloud data center.

Rather than using a software virtual gateway you can use a hardware router to establish this same connection. We are not going to talk about this as we go through our setup exercises but realize that it can be done. This is typically what a corporation does to extend resources to another data center, another office, or a cloud vendor for seasonal peak periods or cheaper resources. The benefit to this configuration is that it can be done by corporate IT and not by an individual.

The key things that get setup during this virtual private network connection are name parsing (DNS), ip routing (gateways and routers), and broadcast/multicast of messages. Most VPN configurations support layer 3 and above. If you do a arp request the arp is not passed through the VPN and never reaches the other data center. With Corente it uses the GRE tunneling protocol which is a layer 2 option. Supporting layer 2 allows you to route ping requests, multicast requests, and additional tunnel requests at a much lower and faster level. As we discussed in an earlier blog, Microsoft does not allow layer 2 to go into or out of their Azure cloud. Amazon allows layer 2 inside their cloud but not into and out of their cloud. This is a key differentiator between the AWS, Azure, and Oracle clouds.

The second component of the virtual private network is the Oracle Cloud Corente Gateway. This is the target side where the gateway in your data center is the initiator. Both gateways allow traffic to go between the two networks on the designated subnet. Both gateways allow for communication between servers in the data center and servers in the Oracle cloud. When you combine the VPN gateways with the Security Lists and Security Rules you get a secure network that allows you to share a rack of server and not worry about someone else who is using the Oracle Cloud from accessing your data center even if they are assigned an IP address on the same subnet. When you define a Security List or Security Rule, these exceptions and holes allow for traffic from computers in your account to access the VPN. No one else in the same rack or same cloud data center can access your VPN or your data center.

The third component is the app net management service portal. This portal establishes connections and rules for the other two components. When you install each of the components it communicates with the admin portal to get configuration information. If you need to change a configuration or keys or some aspect of the communication protocol this is done in the admin portal and it communicates to the other two components to update the configuration. This service also allows you to monitor traffic and record traffic between the Oracle Cloud and your data center.

The network resources for your data center installed service will look like

with br0 being your public facing connection and br1 connecting to your subnet in your data center. A similar configuration is done in the Oracle Cloud but this is pre-configured and can be provisioned as a public image. The only thing that you need to configure is the subnet address range and relationship with the app net management service portal.

Today was a lot of theory and high level discussions. Tomorrow we will dive into configuration of the gateway in your data center. The day after that we will look at provisioning the gateway in the Oracle Cloud and connecting the two. Just a quick reminder, we talked about how to establish a connection between your desktop and a cloud server. By going the a VPN configuration we will get around having to hide a server in the cloud. We can setup all of our servers to have private network links and only open up web servers or secure web servers to talk to the public internet. We can use ssh and rdp from our desktops at home or in our offices to communicate to the cloud servers. Setting up the VPN is typically a corporate responsibility and giving you access to the resources. What you need to know are what cloud resources you have access to and how much money you have in your budget to solve your business problem.

Oracle 12cR2 SQL new feature: LISTAGG overflow

Yann Neuhaus - Mon, 2016-09-19 02:00

LISTAGG was a great feature introduced in 11g: put rows into line with a simple aggregate function. 12cR2 adds an overflow clause to it.

What happens when you have so many rows that the LISTAGG result is too long?

SQL> select listagg(rownum,',')within group(order by rownum) from xmltable('1 to 10000');
select listagg(rownum,',')within group(order by rownum) from xmltable('1 to 10000')
*
ERROR at line 1:
ORA-01489: result of string concatenation is too long

An error at runtime, and we don’t like runtime errors.

If you want to manage the overflow, it’s not easy: run a first query that sums the length and then calculate how much can fit

SQL> select v.*,4000-size_current from (
2 select n,
3 sum(length(n||',')) over(order by n rows between unbounded preceding and current row)-1 size_current,
4 sum(length(n||',')) over(order by n rows between unbounded preceding and 1 following)-1 size_next
5 from (select rownum n from xmltable('1 to 10000'))
6 ) v
7 where size_current between 4000-50 and 4000;
 
N SIZE_CURRENT SIZE_NEXT 4000-SIZE_CURRENT
---------- ------------ ---------- -----------------
1012 3952 3957 48
1013 3957 3962 43
1014 3962 3967 38
1015 3967 3972 33
1016 3972 3977 28
1017 3977 3982 23
1018 3982 3987 18
1019 3987 3992 13
1020 3992 3997 8
1021 3997 4002 3
 
9 rows selected.

Here you can see that values above 1020 will not fit in a VARCHAR2(4000).

In 12.2 you can manage the overflow in two ways

You can choose to raise a runtime error:

SQL> select listagg(rownum, ',' on overflow error)within group(order by rownum) from xmltable('1 to 10000');
select listagg(rownum, ',' on overflow error)within group(order by rownum) from xmltable('1 to 10000')
*
ERROR at line 1:
ORA-01489: result of string concatenation is too long

But you can also choose to truncate the result:

SQL> select listagg(rownum, ',' on overflow truncate '' without count)within group(order by rownum) from xmltable('1 to 10000');
 
LISTAGG(ROWNUM,','ONOVERFLOWTRUNCATE''WITHOUTCOUNT)WITHINGROUP(ORDERBYROWNUM)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,
103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,
178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,
253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,
328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,
403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,
478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,
553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,
628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,
703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,
778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,
853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,
928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,10
02,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,

You may want to add some characters to show that it has been truncated:


SQL> select listagg(rownum, ',' on overflow truncate '...' without count)within group(order by rownum) from xmltable('1 to 10000');
 
LISTAGG(ROWNUM,','ONOVERFLOWTRUNCATE'...'WITHOUTCOUNT)WITHINGROUP(ORDERBYROWNUM)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,
103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,
178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,
253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,
328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,
403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,
478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,
553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,
628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,
703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,
778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,
853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,
928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,10
02,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,...

And you may even show the number of values that are not displayed:


SQL> select listagg(rownum, ',' on overflow truncate '...' with count)within group(order by rownum) from xmltable('1 to 10000');
 
LISTAGG(ROWNUM,','ONOVERFLOWTRUNCATE'...'WITHCOUNT)WITHINGROUP(ORDERBYROWNUM)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,
103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,
178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,
253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,
328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,
403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,
478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,
553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,
628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,
703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,
778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,
853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,
928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,10
02,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,...(8985)

The nice thing is that the truncation is adapted to the information displayed:


SQL> select listagg(rownum, ',' on overflow truncate 'blah blah blah...' with count)within group(order by rownum) from xmltable('1 to 10000');
 
LISTAGG(ROWNUM,','ONOVERFLOWTRUNCATE'BLAHBLAHBLAH...'WITHCOUNT)WITHINGROUP(ORDERBYROWNUM)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,
103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,
178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,
253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,
328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,
403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,
478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,
553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,
628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,
703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,
778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,
853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,
928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,10
02,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,blah blah blah...(8988)

The “,blah blah blah…()” takes 20 characters, the count may take up to 24 characters, so the truncated value cannot be larger than 4000-20-24=3956. From the first query we run we see that we have to truncate after the value “2012”. There’s no dynamic evaluation of the count size.

If all the values fit, then it’s not truncated. In the first query we have seen that values up to 1021 takes 3997 characters:


SQL> select listagg(rownum, ',' on overflow truncate 'blah blah blah...' with count)within group(order by rownum) from xmltable('1 to 1021');
 
LISTAGG(ROWNUM,','ONOVERFLOWTRUNCATE'BLAHBLAHBLAH...'WITHCOUNT)WITHINGROUP(ORDERBYROWNUM)
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,
103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,
178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,
253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,
328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,
403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,
478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,
553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,
628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,
703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,
778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,
853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,
928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,10
02,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021

In summary

After the delimiter string you can add:

  • ON OVERFLOW ERROR which is the default. Same behavior as in previous releases.
  • ON OVERFLOW TRUNCATE with a string that is added in case of truncation (default: ‘…’) and optionally WITH COUNT (or WITHOUT COUNT which is the default)

The full syntax is in the documentation

 

Cet article Oracle 12cR2 SQL new feature: LISTAGG overflow est apparu en premier sur Blog dbi services.

Les 24 heures du PASS (24HOP) – édition francophone

Yann Neuhaus - Mon, 2016-09-19 01:46

24hour_pass

Je n’ai pas encore blogué sur le sujet mais il est temps de le faire. Cette année, aura lieu la première édition francophone des 24h du PASS  les 20 et 21 septembre 2016. L’idée est plutôt simple: proposer une série de 24 webinaires gratuits de 10h jusqu’à 22h (heure française)  pendant 2 jours. C’est l’occasion de recevoir et d’échanger les dernières informations autour de l’administration et du développement des bases de données, des nouvelles tendances côté Business Intelligence et du Cloud.

Qui dit événement Francophone dit aussi speakers de la communauté francophone avec du contenu en Français. Pour ma part, c’est avec plaisir que j’échangerais avec vous autour de 2 sujets: tempdb et bonnes pratiques ainsi que des columnstore et leur implication dans les nouvelles tendances d’architecture BI avec Thoi Dung TSP Microsoft Switzerland.

C’est aussi l’occasion de remercier les sponsors et Isabelle sans qui ce type d’événement n’aurait certainement pas lieu.

Aucune raisons de ne pas vous inscrire!

Au plaisir d’échanger avec vous au cours de cet événement!

 

Cet article Les 24 heures du PASS (24HOP) – édition francophone est apparu en premier sur Blog dbi services.

Video Tutorial: XPLAN_ASH Active Session History - Part 11

Randolf Geist - Sun, 2016-09-18 15:00
The next part of the video tutorial explaining the XPLAN_ASH Active Session History functionality continuing the actual walk-through of the script output.

More parts to follow.


SQL Plan changes

Tom Kyte - Sun, 2016-09-18 14:46
I'm in a large organization, and we have many environments (Dev, Sys Int, User Acc and Prod). Many times, our code is moved from one environment to the next, and somehow the execution times skyrocket. (Example, 21 seconds to over an hour). We some...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator