The Oracle Service Cloud 2016 August release is here!
Check out our two recorded sessions to review the Service Cloud platform changes and get a feeling of the features and enhancement packages. The sessions are intended for a technical audience, more specific for consultants, application engineers, solution consultants, CSMs, BDMs, customer care, upgrades but also to anyone else wanting a look at the solution changes.
Session one covers topics like: Highlights of Policy Automation, Forum (more...)
This note models one feature of a problem that came from a client site recently from a system running 184.108.40.206 – a possible bug in the way the optimizer handles a multi-column in-list that can lead to extremely bad cardinality estimates.
The original query was a simple three table join which produced a bad plan with extremely bad cardinality estimates; there was, however, a type-mismatch in one of the predicates (of the (more...)
A project that I've been working on for a while now involves the use of Oracle Text, Oracle R Enterprise and Oracle Data Mining. Oracle Text comes with your Oracle Database licence. Oracle R Enterprise and Oracle Data Mining are part of the Oracle Advanced Analytics (extra cost) option.
What I will be doing over the course of 4 or maybe 5 blog posts is how these products can work together to help you gain (more...)
Topic: In this post, you will find an example of how to build and deploy a basic artificial neural network scoring engine using PL/SQL for recognizing handwritten digits. This post is intended for learning purposes, in particular for Oracle practitioners who want a hands-on introduction to neural networks.
Machine learning and neural networks in particular, are currently hot topics in data processing. Many toolsand platform are now easily available to work and experiment (more...)
For more great content form the OTN community managers be sure to subscribe to all the OTN YouTube Channels today!
OTN Archbeat - https://www.youtube.com/user/OTNArchBeat
OTN Database Community - https://www.youtube.com/user/OTNDatabasechannel
OTN Systems Hub-... [Read More]
A number of emails I received about trying out Delphix Express was regarding VMWare. Many of my followers had used Virtualbox for a long time and we all know, no one likes change, (OK, maybe me, but we know how abnormal I am anyway… :))
Adding a VM in VMWare
Importing an OVA is pretty simple in VMWare. In the VMWare Fusion application, click on File, Import and (more...)
I have already written about the use of Connection Manager 11.2 to govern access to a database. While researching this piece I have updated the original post so that it’s relevant for 12c as well.
Although the idea of using Connection Manager is tempting, the obvious first question is about high availability of the process. After all, if the gatekeeper to your database environment fails, you are effectively closed for business. One option would (more...)
With Active Dataguard setup, many of the read only applications runs on ADG and sometime the SQLs that are used by these applications runs into bad plans. ADG being a read only database, its not possible to create a baseline or a profile on ADG.
One of the way to have good plan for SQLs running on ADG is to make them run on primary first and fix the plan by creating profile or baseline (more...)
Positive Pay can best be described as a fraud prevention program or tool. Technology has increasingly facilitated the ability of criminals to create counterfeit checks and false identification that can be used to engage in fraudulent check activities. As a result, companies must adopt practices to protect against check fraud. Positive pay can provide this […]
Oracle Stream Analytics (OSA) is a graphical tool that provides “Business Insight into Fast Data”. In layman terms, that translates into an intuitive web-based interface for exploring, analysing, and manipulating streaming data sources in realtime. These sources can include REST, JMS queues, as well as Kafka. The inclusion of Kafka opens OSA up to integration with many new-build data pipelines that use this as a backbone technology.
Previously known as Oracle Stream Explorer, it is (more...)
Integration Cloud Service (ICS) is another powerful yet simple Cloud
platform offering by Oracle that simplifies the development of cloud and
hybrid integrations (applications in the cloud and on premises). The
entire integration development and operational lifecycle is managed
through a web based service console offering a point and click
integration and monitoring experience without having to write a single
line of code. Furthermore Oracle ICS supports various industry
standards like SOAP and REST (more...)
Do you need to find the data for a row which has the maximum value for a specific column in Oracle? Learn how to do it and see some alternative answers in this article. The Table Structure Let’s say you have a table called sales_volume that looks like this: CITY START_DATE SALES El Paso 27/May/15 […]
Being hospitable and welcoming to guests is usually considered good manners. That said, being a gracious host does not mean you should be careless with your security.
With regard to PeopleSoft application security, the user GUEST is a default account created with the installation of PeopleSoft. When performing a PeopleSoft security audit, several attributes of the GUEST user are reviewed, including the following - take a look today at your settings:
It is important that you do this, and let me explain why.
Fundamentally, the APEX "engine" is really nothing more than a big PL/SQL program running inside the Oracle Database. When a browser makes a request for a page in an APEX application, that request is mapped (more...)
Just a quick post to let you know I will be speaking, with a lot of other Oracle ACE and other excellent speakers at the Pint with/Polish Oracle User Group (Chapter IV), taking place on 7th/8th October in Warsaw. Click on Buy Ticket link to see some of the other speakers, or look at the images below.