Feed aggregator

Submitted two abstracts for Oracle OpenWorld 2017

Bobby Durrett's DBA Blog - Wed, 2017-04-19 14:07

I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together:

  • Python for the Oracle DBA
  • Toastmasters for the Oracle DBA

I want to do these talks because they describe two things that I have spent time on and that have been valuable to me.

I have given several recent talks about Delphix. Kyle Hailey let me use his slot at Oaktable World in 2015 which was at the same time as Oracle OpenWorld 2015. Right after that I got to speak at Delphix Sync which was a Delphix user event. More recently I did a Delphix user panel webinar.

So, I’ve done a lot of Delphix lately and that is because I have done a lot with Delphix in my work. But, I have also done a lot with Python and Toastmasters so that is why I’m planning to put together presentations about these two topics.

I probably go to one conference every two years so I’m not a frequent speaker, but I have a list of conferences that I am thinking about submitting these two talks to, hoping to speak at one. These conferences are competitive and I’ve seen that better people than me have trouble getting speaking slots at them. But here is my rough idea of what I want to submit the talks to:

I’ve never gone to RMOUG but I think it is in Denver so that is a short flight and I have heard good things.

Also, we have our on local AZORA group in Phoenix. Recently we have had some really good ACE Director/Oak Table type speakers, but I think they might like to have some local speakers as well so we will see if that will work out.

If all else fails I can give the talks at work. I need to start working on the five speeches in my Toastmasters “Technical Presentations” manual which is part of the Advanced Communication Series. I haven’t even cracked the book open, so I don’t know if it applies but it seems likely that I can use these two talks for a couple of the speech projects.

Anyway, I’ve taken the first steps towards giving my Python and Toastmasters speeches. Time will tell when these will actually be presented, but I know the value that I have received from Python and Toastmasters and I’m happy to try to put this information out there for others.

Bobby

Categories: DBA Blogs

VirtualBox 5.1.20

Tim Hall - Wed, 2017-04-19 10:56

VirtualBox 5.1.20 has been released!

The downloads and changelog are in the usual places.

The installation on macOS Sierra and Oracle Linux 6 hosts went well and all seems to be working OK there.

I’m not 100% sure about the Windows 7 host though. The installation itself went fine, as did the installation of guest additions on a Linux VM running inside it. After a restart of the VM I attempted to do a yum update and the VM just seems to have died now. I can’t get more than a couple of commands out of it before it becomes unresponsive and has to be restarted. I think I’m going to have to remove and rebuild it. I don’t know if this was something I did, or something weird with VirtualBox.

That’s on my work PC and I’m not at work this week, so I was doing it over TeamViewer. I probably won’t have time to look at this again until next week. I’d be interested to know if anyone else has issues on Windows.

Happy upgrading.

Cheers

Tim…

VirtualBox 5.1.20 was first posted on April 19, 2017 at 4:56 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

SQL-on-Hadoop: Impala vs Drill

Rittman Mead Consulting - Wed, 2017-04-19 10:01
 Impala vs Drill

I recently wrote a blog post about Oracle's Analytic Views and how those can be used in order to provide a simple SQL interface to end users with data stored in a relational database. In today's post I'm expanding a little bit on my horizons by looking at how to effectively query data in Hadoop using SQL. The SQL-on-Hadoop interface is key for many organizations - it allows querying the Big Data world using existing tools (like OBIEE,Tableau, DVD) and skills (SQL).

Analytic Views, together with Oracle's Big Data SQL provide what we are looking for and have the benefit of unifying the data dictionary and the SQL dialect in use. It should be noted that Oracle Big Data SQL is licensed separately on top of the database and it's available for Exadata machines only.

Nowadays there is a multitude of open-source projects covering the SQL-on-Hadoop problem. In this post I'll look in detail at two of the most relevant: Cloudera Impala and Apache Drill. We'll see details of each technology, define the similarities, and spot the differences. Finally we'll show that Drill is most suited for exploration with tools like Oracle Data Visualization or Tableau while Impala fits in the explanation area with tools like OBIEE.

As we'll see later, both the tools are inspired by Dremel, a paper published by Google in 2010 that defines a scalable, interactive ad-hoc query system for the analysis of read-only nested data that is the base of Google's BigQuery. Dremel defines two aspects of big data analytics:

  • A columnar storage format representation for nested data
  • A query engine

The first point inspired Apache Parquet, the columnar storage format available in Hadoop. The second point provides the basis for both Impala and Drill.

Cloudera Impala

We started blogging about Impala a while ago, as soon as it was officially supported by OBIEE, testing it for reporting on top of big data Hadoop platforms. However, we never went into the details of the tool, which is the purpose of the current post.

Impala is an open source project inspired by Google's Dremel and one of the massively parallel processing (MPP) SQL engines running natively on Hadoop. And as per Cloudera definition is a tool that:

provides high-performance, low-latency SQL queries on data stored in popular Apache Hadoop file formats.

Two important bits to notice:

  • High performance and low latency SQL queries: Impala was created to overcome the slowness of Hive, which relied on MapReduce jobs to execute the queries. Impala uses its own set of daemons running on each of the datanodes saving time by:
    • Avoiding the MapReduce job startup latency
    • Compiling the query code for optimal performance
    • Streaming intermediate results in-memory while MapReduces always writing to disk
    • Starting the aggregation as soon as the first fragment starts returning results
    • Caching metadata definitions
    • Gathering tables and columns statistics
  • Data stored in popular Apache Hadoop file formats: Impala uses the Hive metastore database. Databases and tables are shared between both components. The list of supported file formats include Parquet, Avro, simple Text and SequenceFile amongst others. Choosing the right file format and the compression codec can have enormous impact on performance. Impala also supports, since CDH 5.8 / Impala 2.6, Amazon S3 filesystem for both writing and reading operations.

One of the performance improvements is related to "Streaming intermediate results": Impala works in memory as much as possible, writing on disk only if the data size is too big to fit in memory; as we'll see later this is called optimistic and pipelined query execution. This has immediate benefits compared to standard MapReduce jobs, which for reliability reasons always writes intermediate results to disk.
As per this Cloudera blog, the usage of Impala in combination with Parquet data format is able to achieve the performance benefits explained in the Dremel paper.

Impala Query Process

Impala runs a daemon, called impalad on each Datanode (a node storing data in the Hadoop cluster). The query can be submitted to any daemon in the cluster which will act as coordinator node for the query. Impala daemons are always connected to the statestore, which is a process keeping a central inventory of all available daemons and related health and pushes back the information to all daemons. A third component called catalog service checks for metadata changes driven by Impala SQL in order to invalidate related cache entries. Metadata are cached in Impala for performance reasons: accessing metadata from the cache is much faster than checking against the Hive metastore. The catalog service process is in charge of keeping Impala's metadata cache in sync with the Hive metastore.

Once the query is received, the coordinator verifies if the query is valid against the Hive metastore, then information about data location is retrieved from the Namenode (the node in charge of storing the list of blocks and related location in the datanodes), it fragments the query and distribute the fragments to other impalad daemons to execute the query. All the daemons read the needed data blocks, process the query, and stream partial result to the coordinator (avoiding the write to disk), which collects all the results and delivers it back to the requester. The result is returned as soon as it's available: certain SQL operations like aggregations or order by require all the input to be available before Impala can return the end result, while others, like a select of pre-existing columns without a order by can be returned with only partial results.

 Impala vs Drill

Apache Drill

Defining Apache Drill as SQL-on-Hadoop is limiting: also inspired by Google's Dremel is a distributed datasource agnostic query engine. The datasource agnostic part is very relevant: Drill is not closely coupled with Hadoop, in fact it can query a variety of sources like MongoDB, Azure Blob Storage, or Google Cloud Storage amongst others.

One of the most important features is that data can be queried schema-free: there is no need of defining the data structure or schema upfront - users can simply point the query to a file directory, MongoDB collection or Amazon S3 bucket and Drill will take care of the rest. For more details, check our overview of the tool. One of Apache Drill's objectives is cutting down the data modeling and transformation effort providing a zero-day analysis as explained in this MapR video.
 Impala vs Drill

Drill is designed for high performance on large datasets, with the following core components:

  • Distributed engine: Drill processes, called Drillbits, can be installed in many nodes and are the execution engine of the query. Nodes can be added/reduced manually to adjust the performances. Queries can be sent to any Drillbit in the cluster that will act as Foreman for the query.
  • Columnar execution: Drill is optimized for columnar storage (e.g. Parquet) and execution using the hierarchical and columnar in-memory data model.
  • Vectorization: Drill take advantage of the modern CPU's design - operating on record batches rather than iterating on single values.
  • Runtime compilation: Compiled code is faster than interpreted code and is generated ad-hoc for each query.
  • Optimistic and pipelined query execution: Drill assumes that none of the processes will fail and thus does all the pipeline operation in memory rather than writing to disk - writing on disk only when memory isn't sufficient.
Drill Query Process

Like Impala's impalad, Drill's main component is the Drillbit: a process running on each active Drill node that is capable of coordinating, planning, executing and distributing queries. Installing Drillbit on all of Hadoop's data nodes is not compulsory, however if done gives Drill the ability to achieve the data locality: execute the queries where the data resides without the need of moving it via network.

When a query is submitted against Drill, a client/application is sending a SQL statement to a Drillbit in the cluster (any Drillbit can be chosen), which will act as Foreman (coordinator in Impala terminology) that will parse the SQL and convert it into a logical plan composed by operators. The next step is the cost-based optimizer which, based on optimizations like rule/cost based, data locality and storage engine options, rearranges operations to generate the optimal physical plan. The Foreman then divides the physical plan in phases, called fragments, which are organised in a tree and executed in parallel against the data sources. The results are then sent back to the client/application. The following image taken from drill.apache.org explains the full process:

 Impala vs Drill

Similarities and Differences

As we saw above, Drill and Impala have a similar structure - both take advantage of always on daemons (faster compared to the start of a MapReduce job) and assume an optimistic query execution passing results in cache. The code compilation and the distributed engine are also common to both, which are optimized for columnar storage types like Parquet.

There are, however, several differences. Impala works only on top of the Hive metastore while Drill supports a larger variety of data sources and can link them together on the fly in the same query. For example, implicit schema-defined files like JSON and XML, which are not supported natively by Impala, can be read immediately by Drill.
Drill usually doesn't require a metadata definition done upfront, while for Impala, a view or external table has to be declared before querying. Following this point there is no concept of a central and persistent metastore, and there is no metadata repository to manage just for Drill. In OBIEE's world, both Impala and Drill are supported data sources. The same applies to Data Visualization Desktop.
 Impala vs Drill

The aim of this article isn't a performance-wise comparison since those depends on a huge amount of factors including data types, file format, configurations, and query types. A comparison dated back in 2015 can be found here. Please be aware that there are newer versions of the tools since this comparison, which bring a lot of changes and improvements for both projects in terms of performance.

Conclusion

Impala and Drill share a similar structure - both inspired by Google's Dremel - relying on always active daemons deployed on cluster nodes to provide the best query performances on top of Big Data data structures. So which one to choose and when?
As described, the capability of Apache Drill to query a raw data-source without requiring an upfront metadata definition makes the tool perfect for insights discovery on top of raw data. The capacity of joining data coming from one or more storage plugins in a unique query makes the mash-up of disparate data sources easy and immediate. Data science and prototyping before the design of a reporting schema are perfect use cases of Drill. However, as part of the discovery phase, a metadata definition layer is usually added on top of the data sources. This makes Impala a good candidate for reporting queries.
Summarizing, if all the data points are already modeled in the Hive metastore, then Impala is your perfect choice. If instead, you need a mashup with external sources, or need work directly with raw data formats (e.g. JSON), then Drill's auto-exploration and openness capabilities are what you're looking for.
Even though both tools are fully compatible with Oracle BIEE and Data Visualization (DV), due to Drill's data exploration nature, it could be considered more in line with DV use cases, while Impala is more suitable for standard reporting like OBIEE. The decision on tooling highly depends on the specific use case - source data types, file formats and configurations have deep impact on the agility of the business analytics process and query performance.

If you want to know more about Apache Drill, Impala and the use cases we have experienced, don't hesitate to contact us!

Categories: BI & Warehousing

Live Twitter Chat on Headless CMS – Tomorrow!

WebCenter Team - Wed, 2017-04-19 09:14

You are invited! Have you heard the term "headless CMS" going around? Decoupled/headless CMS architecture is rising in popularity in the development world and we want to hear from you! If you have something to say about headless CMS or WCM, if you have questions on this topics, if you have experience working with coupled or decoupled CMS or WCM, if you've been following the discussions on this topic or if you are just interested in trying a Twitter Chat out for the first time, we invite you to participate in the live Twitter conversation on "Is headless CMS signaling the end of WCM?" @oraclewebcenter will be kicking off the live Twitter Chat on Thursday, April 20 at 10:00am PT / 1:00pm ET, and we hope to hear from you!

The live Twitter Chat would run about an hour long, and we look to have a meaningful conversation on the topic. So, if you have a Twitter handle, we encourage you to participate in the live discussion. Join or simply follow along using hashtag: #contentdgtl

And, if you have questions in mind, simply send those to us @oraclewebcenter and we will do our best to include or have those addressed by the Digital Experience community.

So, mark your calendar and please join us!

Live Twitter Chat
  • Topic: Is headless CMS signaling the end of WCM? 
  • Date: Thursday, April 20 (tomorrow!)
  • Time: 10:00am PT / 1:00pm ET
  • Hashtag: #contentdgtl
  • Host: @oraclewebcenter
We will archive and post the discussion shortly after the live event. Talk to you soon!

Live Twitter Chat on Headless CMS – Tomorrow!

WebCenter Team - Wed, 2017-04-19 09:14

You are invited! Have you heard the term "headless CMS" going around? Decoupled/headless CMS architecture is rising in popularity in the development world and we want to hear from you! If you have something to say about headless CMS or WCM, if you have questions on this topics, if you have experience working with coupled or decoupled CMS or WCM, if you've been following the discussions on this topic or if you are just interested in trying a Twitter Chat out for the first time, we invite you to participate in the live Twitter conversation on "Is headless CMS signaling the end of WCM?" @oraclewebcenter will be kicking off the live Twitter Chat on Thursday, April 20 at 10:00am PT / 1:00pm ET, and we hope to hear from you!

The live Twitter Chat would run about an hour long, and we look to have a meaningful conversation on the topic. So, if you have a Twitter handle, we encourage you to participate in the live discussion. Join or simply follow along using hashtag: #contentdgtl

And, if you have questions in mind, simply send those to us @oraclewebcenter and we will do our best to include or have those addressed by the Digital Experience community.

So, mark your calendar and please join us!

Live Twitter Chat
  • Topic: Is headless CMS signaling the end of WCM? 
  • Date: Thursday, April 20 (tomorrow!)
  • Time: 10:00am PT / 1:00pm ET
  • Hashtag: #contentdgtl
  • Host: @oraclewebcenter
We will archive and post the discussion shortly after the live event. Talk to you soon!

Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store

Oracle Press Releases - Wed, 2017-04-19 09:00
Press Release
Oracle Brings Oracle’s Flagship Databases and Developer Tools to the Docker Store Developers can easily access leading databases and developer tools as Docker containers to develop and deploy cloud-scale applications.

DockerCon, AUSTIN, TX.—Apr 19, 2017

Oracle announced today that it is collaborating with Docker to release  its flagship databases, middleware and developer tools into the Docker Store marketplace via the Docker Certification Program. Together, Oracle and Docker enable developers to quickly build cloud-native applications using Docker Enterprise Edition as their container platform and Oracle’s databases and developer tools immediately available as Docker containers through the Docker Store.. The Docker Certification Program is a framework for partners to integrate and certify their technology to the Docker EE commercial platform.

Effective immediately, developers can now pull images of Oracle products in Docker and quickly start developing, testing and deploying modern enterprise applications. Solutions offered include Oracle Database, Oracle MySQL, Oracle Java 8 SE Runtime Environment, Oracle WebLogic Server, Oracle Coherence and Oracle Instant Client, which are now all available in the Docker Store as enterprise-ready containers. 

As cloud computing continues to transform every business and industry, developers at global enterprises and emerging startups alike are increasingly leveraging container technologies to accelerate how they build modern Web, mobile and IoT applications. Because the need for new applications in the enterprise consistently outpaces development capabilities, modern developers need to be able to quickly develop, test and deploy their applications without worrying about their deployment environment. With the availability of Oracle in the Docker Store, developers are now free for the first time to deliver best in class secure, high-performance, and resilient applications in containers with confidence. Oracle is a long-time supporter of the Docker ecosystem with more than 100 images of Oracle products already available in the Docker Hub, including OpenJDK and Oracle Linux.

Developers can try these images immediately by downloading them on any public cloud or on-premises servers. With Oracle Cloud, developers can deploy these images on the cloud infrastructure of their choice: virtual, bare metal or managed containers. Developers can try the service and experience Oracle Cloud with $300 in free credits by visiting https://cloud.oracle.com/tryit.

“Docker is revolutionizing the way developers build and deploy modern applications, but mission-critical systems in the enterprise have been a holdout until now,” said Mark Cavage, Vice President of Software Development at Oracle. “Together with Docker, Oracle is bringing bedrock software to millions of developers enabling them to create enterprise-grade solutions that meet stringent security, performance and resiliency SLAs with the high level of productivity and low friction that they have come to expect from Dockerizing their application development stack."

“Enterprises have relied on Oracle’s technology to power their businesses for decades and their databases and middleware tools are used by millions of developers around the world,” said Marianna Tessel, EVP Strategic Development at Docker. “With this new partnership, developers looking to use containers for their businesses can now access the world’s most popular databases and developer tools and leverage the performance and robustness of Oracle in their applications, all in just a few clicks.”

For more information, please visit https://developer.oracle.com/docker

Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data. The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day.

For more information about Oracle Cloud, please visit http://cloud.oracle.com

Contact Info
Alex Shapiro
Oracle PR
+1.415.608.5044
alex.shapiro@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@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.

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 preceding 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.415.608.5044

Kristin Reeves

  • +1.415.856.5145

Come to the UKOUG PeopleSoft Roadshow

Duncan Davies - Wed, 2017-04-19 08:16

The UK Oracle User Group PeopleSoft Roadshow is nearly upon us. It’s my favourite PeopleSoft event in the UK’s calendar as you know that everyone there has a focus on PeopleSoft and the agenda is always really strong.

It’s 26th April (yes, a week today!) in the Crowne Plaza, London – the same as last time, which was a great venue.

Oracle US Speakers

In terms of Oracle speakers, we’re spoiled this year with both Marc Weintraub and Julie Alonso presenting.

Marc Weintraub

Pretty much everyone should know Marc by now, and he’s always good value. He’s giving multiple sessions including a PeopleSoft Update, Modernising with Fluid, Fully Executing on Selective Adoption and PeopleSoft in the Cloud.

Julie Alonso

A new speaker to those who’ve only attended UK PeopleSoft events is Julie Alonso. She is Product Management Director within PeopleSoft HCM Strategy and the brains behind the monthly PeopleSoft HR Newsletter (if you don’t know what this is, either see Julie on the day or drop me a mail and I’ll link you up). Julie is presenting on The Power of PeopleSoft HCM.

It’s great that Oracle are supporting the event with two such speakers, and it’s wonderful to see a new face on the circuit.

Cedar Speakers

We’ve also got a couple of speakers from Cedar on the agenda.

Graham Smith

As with Marc, everyone should know Graham by now. He’s a rare blend of techie that’s been around PeopleSoft for long enough to know the history behind just about everything, but has such fantastic enthusiasm that he’s always trying the latest tools and techniques. Graham is talking about Selective Adoption and the Oracle Cloud.

Sarah Hurley

For those with excellent memories, Sarah has spoken at a PeopleSoft conference before (on a custom recruitment front-end that Cedar built for a client) however that was a few years back. Sarah has been busy managing some of Cedar’s PeopleSoft projects in the interim and is giving learnings from a Fluid implementation for a client – Fluid Development – Getting to Grips with a Different Skill Set.

Other Speakers

Check out the agenda for the full listings, but in addition to the above we’ve got Paul Smit from Oracle Netherlands, Malcolm Hewlett from Excel4Apps and Ken de Landro talking about Hays’ automated PeopleSoft testing investigations.

If the above sounds like the sort of content that would interest you – and there’s something there for pretty much everyone – it’d be great to see you there. Book here.


Al Nahdi Drives Growth and Insight with Oracle Retail Cloud Services

Oracle Press Releases - Wed, 2017-04-19 06:00
Press Release
Al Nahdi Drives Growth and Insight with Oracle Retail Cloud Services From Spreadsheets to Packaged Applications, Saudi Arabian Retailer Drives Increased Productivity

Redwood Shores, Calif.—Apr 19, 2017

Today Oracle announced Saudi Arabian pharmacies’ retailer Nahdi Medical Company deployed Oracle Retail Advanced Science Engine Cloud Service, Oracle Retail Merchandising Solutions, and Oracle Retail Category Management. Nahdi is considered the largest pharmacies’ chain in Middle East and North Africa. Its mission is to exceed the expectations of 85 million guests across 125 cities by providing personalized high-quality health, wellness and beauty products and services through its expertise and extended reach.

Nahdi manages a huge and growing assortment of SKUs across 170 categories throughout its stores. The volume of data forced Nahdi to adopt a scalable and smart planning solution. With the deployment of Oracle Retail, Nahdi gains the ability to segment customers, cluster stores and understand the effects of demand transference without having to recruit a full team of scientists with transaction-level data experience. Powerful scientific insights are delivered in a digestible format for the business user through personal-based dashboards. Prior to selecting Oracle, Nahdi planners spent time navigating a manual process using Excel spreadsheets and in-house databases. Today Nahdi is able to optimize the planning team’s productivity with standardized and automated planning processes. 

“The implementation of Oracle Retail increased the accuracy of planning and forecasting the merchandising figures. We are able to plan and execute better assortment of products across our stores to improve our guests’ satisfaction,” said Dr. Khalid Tadlaoui, Vice President of Information Technology, Nahdi Medical Company.

“The proliferation of data can be overwhelming, and it becomes increasingly important for retailers like Nahdi Medical Company to leverage and invest in solutions that understand how to drive insight through embedded science, business intelligence and analytics into solutions and processes,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “Oracle Retail is incredibly proud to provide this competitive advantage as cloud services, accelerating speed to market and driving productivity.”

Oracle PartnerNetwork Gold Level Partner Logic Information Systems accelerated a smooth cloud implementation and guided the customer through business process change. Logic developed a Retail Data Extractor to extract data correctly and cleanly from the installation of Oracle Retail Merchandising Systems for the cloud implementation. Logic delivered training programs to empower the business and technical teams. 

"It is a privilege to work with a retailer like Nahdi who is using science to leverage the performance and availability of each individual product to satisfy their guests and who also places an importance that their employees have access to critical planning information without wasted time sifting through Excel and manual processes,” said Amber Naqvi, President, Logic Information Systems.

Contact Info
Judi Palmer
Oracle (US)
650-784-7901
judi.palmer@oracle.com
Gaurav Bhatnagar
Oracle (Middle East)
+97143909094
gaurav.b.bhatnagar@oracle.com
About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

About Logic Information Systems

Since 1997, Logic has been the trusted systems integration partner to leading retailers around the world. With an exclusive focus on Oracle Retail, and a team of more than 750 expert consultants who bring a unique balance of real-world retail and IT experience, Logic is equipped to understand and deliver on a retailer’s business and technology goals. Working with Logic, retailers benefit from people, process, and technology solutions that increase efficiency, profitability and deliver a world-class experience for shoppers.

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.

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

Judi Palmer

  • 650-784-7901

Gaurav Bhatnagar

  • +97143909094

Compress Basic Table

Tom Kyte - Tue, 2017-04-18 20:06
Tom, I need help. -If I create a table with COMPRESS BASIC on the partitions and then I insert data from another table does not decrease the size. -Now if I create a table from another with a: CREATE TABLE AS SELECT * FROM TABLE_2 And COMPRESS ...
Categories: DBA Blogs

Swap memory

Tom Kyte - Tue, 2017-04-18 20:06
Hi Team, In which case Oracle uses Swap memory. If we set Memory_target=10G parameter Oracle allocates SGA + PGA which that 10G only. Thanks & Regards Krishna.
Categories: DBA Blogs

Can I optimize the auto extend operation by changing the resizing value?

Tom Kyte - Tue, 2017-04-18 20:06
Hi, I'm using Oracle database 12.1.0.2.0 on Windows 64-bit The alert log is showing many "Resize operation completed for file#..." messages and the "Resource monitor" is showing I/O intensive usage. select * from DBA_DATA_FILES shows that the IN...
Categories: DBA Blogs

How to remove the duplicates records which are in two different columns of a single table.

Tom Kyte - Tue, 2017-04-18 20:06
I have table called "DUPLICTAE" which contains the below records. I need the below desired ouput... <code>COL1 | COL2 :----- | -----: banglore | chennai kolkata | pune chennai | mysore pune | banglore mysore | kolkata mumba...
Categories: DBA Blogs

Loading a file in External Table with a fields more than 4000 characters

Tom Kyte - Tue, 2017-04-18 20:06
Hi Tom, I have a file with the following structure: <code>+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= 2017-03-01 16:17:08 : INFO : (65193 | WRIT...
Categories: DBA Blogs

Oracle Buys Moat

Oracle Press Releases - Tue, 2017-04-18 16:09
Press Release
Oracle Buys Moat Creates the World’s Most Comprehensive Cloud Platform for Marketing Data and Analytics

Redwood Shores, Calif.—Apr 18, 2017

Oracle today announced that it has signed an agreement to acquire Moat, the fastest-growing digital measurement cloud company. Moat will join Oracle Data Cloud, which uses data and analytics to enhance media for leading marketers and publishers. The combination of Oracle and Moat will connect data to consumer attention for better media experiences and business outcomes.

Moat will remain an independent platform within Oracle Data Cloud, providing trusted measurement, analytics, and intelligence to the world’s largest brands including Nestle, Procter & Gamble, and Unilever, and leading publishers such as ESPN, Facebook, NBCUniversal, Snapchat, and YouTube. Moat’s enterprise client base and industry-leading attention analytics and intelligence suite provide a strong complement to Oracle Data Cloud’s audience targeting and measurement solutions.

“I am thrilled to welcome CEO Jonah Goodhart and the entire Moat team to Oracle Data Cloud,” said Eric Roza, SVP and GM of Oracle Data Cloud. “Moat has grown its attention analytics business by over 100% in the past year, providing actionable insights around viewability, brand safety, non-human traffic, and ad creative to over 600 publisher, brand and agency clients. With the Moat acquisition, Oracle Data Cloud now offers brands and publishers a full suite of targeting and measurement solutions to improve the outcome of virtually every type of digital advertising campaign.”

“It is with great enthusiasm that we join forces with Oracle Data Cloud,” said Jonah Goodhart, CEO and Co-Founder of Moat. “When Oracle approached us about working together, we began to see the huge potential to jointly drive innovation. At our core, we believe there is an opportunity to fundamentally improve marketing and storytelling by brands and publishers through better data and analytics.”

More information about this announcement is available at www.oracle.com/moat.

Oracle is currently reviewing the existing Moat product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of Moat’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Moat or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and Moat, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of Moat, anticipated customer benefits and general business outlook. When used in this document, the words “anticipates”, “can”, “will”, “look forward to”, “expected” and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or Moat, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or Moat may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or Moat. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor Moat is under any duty to update any of the information in this document.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@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.

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

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

April 2017 Critical Patch Update Released

Oracle Security Team - Tue, 2017-04-18 15:00

Oracle today released the April 2017 Critical Patch Update.

This Critical Patch Update provides fixes for a wide range of product families including: Oracle Database Server, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, Oracle Industry Applications, Oracle Fusion Middleware, Oracle Sun Products, Oracle Java SE, and Oracle MySQL.

Oracle recommends this Critical Patch Update be applied as soon as possible. A summary and analysis of this Critical Patch Update has been published on My Oracle Support (Doc ID 2252203.1)

For More Information:

The Critical Patch Update Advisory is located at http://www.oracle.com/technetwork/security-advisory/cpuapr2017-3236618.html

My Oracle Support Note 2220314.1 is located at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2252203.1 (MOS account required).

How to make dashboard for Informix database

Nilesh Jethwa - Tue, 2017-04-18 14:25

Informix is a secure database, optimized for or OLTP, IoT and is forging new frontiers with its unique ability to seamlessly integrate SQL, NoSQL/JSON, time series and spatial data. Reliability, flexibility, ease of use, and low total cost of ownership makes Informix the best in class enterprise database available in the market.

Instant Visibility. A Informix dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Informix SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.

  • Better Decision Making
  • Gain Competitive Advantage
  • Enhance Collaboration
  • Spotting potential problems
  • Merge with data from Excel Dashboards
  • Live SQL against database
  • No need for Data-warehouse or ETL
  • Leverage the speed and stability of your powerful database.

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-informix-sql

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

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

Oracle Warehouse Management Cloud Update Helps Businesses Scale Logistics to Meet Multi-Channel Demand

Oracle Press Releases - Tue, 2017-04-18 07:00
Press Release
Oracle Warehouse Management Cloud Update Helps Businesses Scale Logistics to Meet Multi-Channel Demand Momentum of Cloud WMS Solution Touted in Top Industry Analyst Reports

Redwood Shores, Calif.—Apr 18, 2017

Oracle today announced a new supply chain cloud functionality that helps businesses master challenging warehouse fulfillment issues in order to help outpace their competition. Version 8 of Oracle Warehouse Management Cloud (the former LogFire Warehouse Management System) has the latest functional user experience and integration enhancements that provide a comprehensive view of inventory from supplier to the distribution center (DC) to store shelves.

With Forrester research reporting that the total cloud market value is expected to top $236 billion dollars by 2020, and Transparency Market Research reporting the cloud WMS market is expected to expand from $1.2 billion in 2015 to $4.1 billion by 2024, Oracle is well-positioned to help companies on their journey to adopt SCM cloud solutions.

With Version 8, Oracle continues to lead the industry in modernizing application release cycles by leveraging 100 percent cloud architecture to offer access to frequent solution improvements similar to the easy updates with leading consumer applications.

“LogFire has conclusively proven the viability and compelling value proposition of their cloud-based WMS. The Oracle WMS Cloud is a no-compromise solution built from day one for the cloud. It enables companies to thrive in today’s dynamic, interconnected, omni-channel fulfillment economy,” said Jon Chorley, CSO & group vice president, SCM product strategy at Oracle. “Version 8 continues our dedication to providing customers with the very latest logistics execution capabilities, which now also gives them the ability to leverage other compelling cloud solutions from Oracle.”

Oracle Warehouse Management Cloud recently garnered attention for their offering in two different industry analyst reports. Both reports lauded Oracle’s position and commented on increased cloud WMS adoption across industries. The first is the IDC research on WMS in the Cloud and second is the 2017 Gartner Magic Quadrant for Warehouse Management Systems, which placed Oracle in the Leaders Quadrant.

Chorley continued, “We believe that 2017 is the year cloud computing in Warehouse Management Systems will go mainstream. Our positioning in the Gartner and IDC reports affirms that businesses are comfortable transitioning their fulfillment operations to the cloud. We’re taking every opportunity to introduce the value of the cloud to our customers to help them grow their businesses.”

At Oracle’s recent major supply chain conference—the Modern Supply Chain Experience in San Jose, California – Oracle users saw this technology first hand. Customers packed into sessions in order to learn more about the future of their industry and how the cloud will be transforming everything from sourcing and manufacturing to transportation, warehousing, and even store shelves.

For more information, please see the Gartner Magic Quadrant1 and IDC’s WMS in the Cloud report2.

For additional information on Oracle Supply Chain Management (SCM) Cloud, visit Facebook, Twitter or the Oracle SCM blog.

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

1. Gartner, “2017 Magic Quadrant for Warehouse Management Systems,” by C. Dwight Klappich, Simon Tunstall, February 13, 2017. Oracle has acquired distribution rights for this report, expiration March 2018.
2. IDC, “WMS in the Cloud,” by John Santagate, January 2017. Oracle has acquired distribution rights for this report, expiration March 2018.

Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
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.

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 preceding 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.650.607.1343

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

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

3 Ways to Make Paperwork Less Difficult

WebCenter Team - Tue, 2017-04-18 06:54

Authored by: Sarah Gabot, Partner Marketing Manager, HelloSign

Let’s face it--paperwork, regardless of whether it’s on paper or in the cloud, is no fun. It still takes time and effort to prepare, and if you’re getting it signed, you’re often sitting waiting for the document to return. 

Believe it or not, you can make the paperwork even simpler with the help of an eSignature tool. 

We’ve listed out three ways you can make paperwork less painful. You can immediately begin applying these to the HelloSign for Oracle Content and Experience Cloud integration today. 

Avoid manually reviewing documents with data validation 
Human error happens. People accidentally input the wrong information or have typos when filling out forms. That’s why HelloSign created data validation

Data validation is a feature that prevents users from entering incorrect information. For example, if you require the user to type in his or her social security number, you know that only nine numbers are acceptable. No letters. Exactly nine numbers. 

Using this feature, when the documents return, there will be fewer errors to comb through and less back and forth between you and the signer. 

Increase signer completion rates with mobile-friendly signing
Nearly everybody has a smartphone these days. Being able to handle tasks on-the-go on a smartphone has become a requirement for most people. Signing documents is no exception. 

HelloSign’s signing experience is mobile-friendly. Instead of having to pinch on a small screen, the signer experience is intuitive with responsive pages. There’s also progress tracking that shows how many total (and remaining) required fields are left. 

A more mobile-friendly experience means that your signers are more inclined to complete the document faster. 

Save time by auto-filling documents. 
For certain documents, there are fields that you, the document preparer, can pre-fill. For example, if you have a templated document like an offer letter, you can pre-fill fields in the document (eg. job title, salary number) in HelloSign for Oracle CEC. 

It’s a quick way for you to prepare standardized documents without having to recreate it every time. 

Try it out yourself! 
See for yourself how you can simplify paperwork flows using Oracle Content and Experience Cloud and HelloSign. To learn how to get started, email our sales team at oracle-sales@hellosign.com or speak to your Oracle Account rep.

Pages

Subscribe to Oracle FAQ aggregator