Oracle Service Cloud Release Recordings Now Available! – August 2016

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...)

Lost Concatenation

This note models one feature of a problem that came from a client site recently from a system running 12.1.0.2 – 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...)

Oracle Text, Oracle R Enterprise and Oracle Data Mining – Part 1

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...)

A Neural Network Scoring Engine in PL/SQL

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.


Introduction

Machine learning and neural networks in particular, are currently hot topics in data processing. Many tools and platform are now easily available to work and experiment  (more...)

Watch Latest CommunityCast – Look back on KSCOPE 2016

<p> </p> 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]

VMWare, but I use Virtualbox!

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… :))

itcrowd1

Adding a VM in VMWare

Importing an OVA is pretty simple in VMWare.  In the VMWare Fusion application, click on File, Import and (more...)

Preventing a SPOF with CMAN 12c

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...)

Fixing SQL plans on ADG using SQL Profiles

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...)

What’s new in Oracle BPM and Process Cloud Service? SOA & BPM Partner Community Webcast – tormorrow July 26th 2016

image


Attend our July edition of the SOA & BPM Partner Community Webcast live on July 26th 2016 at 16:00 CET.

What’s new in Oracle BPM and Process Cloud Service? Digital Process Apps made Simple

During this session, we will be joined by Sujan Balachandran, Product Manager for Oracle BPM and Process Cloud Service (PCS). The session will cover

· Empower Business User using BPM Composer

· What is Business Architecture? How can it help (more...)

EBS Release 12.x certified with Safari 9 on Apple OS X

Apple logoOracle E-Business Suite Release 12.1.3 and 12.2.4 or higher are now certified with Apple Mac OS X with the following desktop configurations:
  • Mac OS X 10.11 ("El Capitan" version 10.11.5 or later 10.11 updates)
  • Mac OS X 10.10 ("Yosemite" version 10.10.2 or later 10.10 updates)
  • Safari version 9 (9.1.1 or later 9.x updates)
  • Oracle JRE 8 plugin (1.8.0_91 (more...)

Understanding Positive Pay

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 […]

An Introduction to Oracle Stream Analytics

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...)

LittleArduinoProjects#220 Arduino gcc toolchain

The Arduino IDE is the most convenient way to get started with Arduino, but it does obscure the underlying mechanics of building software for an Arduino.

How to do it from scratch? This is my experiement and guide to building software for an Arduino from the command line. I use a Mac and homebrew, so it is somewhat MacOSX-specific.

As always, all notes, schematics and code are in the Little Electronics & Arduino Projects repo (more...)

ICS Integration Patterns (Part 1 of 3): Map My Data by Antonis Antoniou

clip_image001

Oracle 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...)

How to Find the Row That Has the Maximum Value for a Column in Oracle

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 […]

PeopleSoft Guest User Security

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:

For the GUEST (more...)

Securing Application Express when using Oracle REST Data Services (ORDS)

If you are using Oracle REST Data Services as the "PL/SQL Gateway" for Oracle Application Express, ensure that your ORDS configuration includes the following line:

wwv_flow_epg_include_modules.authorize

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...)

POUG 2-day event

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.

Hope to see you there! Should be fabulous.

 

poug_speakers_1poug_speakers_2


Filed under: Administration, Appearances Tagged: group, (more...)

GoldenGate 12.2 Object Exclude

1.8 Details of Support for Objects and Operations in Oracle DDL

The following tables are excluded by default.

  "*.AQ$*", // advanced queues
  "*.DR$*$*", // oracle text
  "*.M*_*$$", // Spatial index
  "*.MLOG$*", // materialized views
  "*.OGGQT$*",
  "*.OGG$*", // AQ OGG queue table
  "*.ET$*", // Data Pump external tables
  "*.RUPD$*", // materialized views
  "*.SYS_C*", // constraints
  "*.MDR*_*$", // Spatial Sequence and Table
  "*.SYS_IMPORT_TABLE*",
  "*.CMP*$*",  (more...)

Video Tutorial: XPLAN_ASH Active Session History – Part 9

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.