The last PeopleSoft Update Manager (PUM) images have been delivered in two formats: the traditional VirtualBox image and a newly introduced format: NativeOS.
NativeOS takes advantage of PeopleTools 8.55 Deployment Packages (DPK), which is the cornerstone for the PeopleSoft Cloud Architecture. This new cloud architecture facilitates the deployment of PeopleSoft applications in the cloud, not only covering Oracle Public Cloud but also other providers such as Amazon Web Services (AWS), Google Cloud and Microsoft (more...)
Very happy and honored to speak in OTN Yathra 2016 tour, along with many Oracle ACE and ACE Directors. This is my first tour as ACED, and thank you AIOUG and OTN for having me. I am looking forward to meet many of you, who I know only through twitter or facebook. I will be presenting […]
I've released PHP OCI8 2.0.11 (for supported PHP 5.x versions) and
2.1.1 (for PHP 7) to PECL. Windows DLLs on PECL been built by the PHP release team.
The updated OCI8 code has also been merged to the PHP source branches
and should land in the future PHP 5.6.21 and PHP 7.0.7 source bundles,
PHP OCI8... [Read More]
To execute Groovy expression in ADF 12c (to call Java method from Groovy), you must specify trusted mode. Read more about it in my previous post - ADF BC 12c New Feature - Entity-Level Triggers. Setting mode to trusted, works in most of the cases. It doesn't work if we want to execute Groovy expression (calling Java method in ViewRow or Entity class) for custom property. In a case of custom property and Groovy calling (more...)
Most people are aware of this standard referential integrity control, namely you can’t delete the parent if children exist
SQL> drop table PAR cascade constraints purge;
SQL> create table PAR ( p int primary key, data int);
SQL> insert into PAR
2 select rownum, rownum
3 from dual connect by level <= 7;
7 rows created.
SQL> drop table CHD purge;
SQL> create table CHD ( c int (more...)
It’s hackathon weekend at Fishbowl Solutions. Fishbowl’s consulting and development teams – the hackers – along with members of the sales and marketing teams join forces to collaborate on and develop new software applications. While the overall goal of the hackathon may be to produce usable software, the event also is a great learning opportunity for participants and results in a lot of fun.
This is Fishbowl’s 4th annual hackathon and previous events have produced (more...)
A developer reported a problem with a %TYPE declaration which was returning PLS-00302 in an Oracle 10 database. The cause turned out to be a variation on a problem which I have already reported. However, as it took me some time to work out, I have reproduced it below. First I created a user, called USER1, who would own a table:
While disasters do occur every now and then, many production deployments lack a disaster recovery (DR) system. Oracle Database Appliance makes a great solution for deploying a disaster recovery system (especially for production ODA deployments) for the following reasons.
1. Easy to setup (setup entire DR site in... [Read More]
I sometimes get a double-take when I do a blog post or tweet or show a picture of SQL Developer running on my Mac. My Macbook is my personal machine: I don’t normally do live-demo’s on it, but I almost always do my blog posts and screenshots from there.
For official webcast stuff and conferences, it’s... [Read More]
First of all, what are partially applied functions? There’s a little bit of theory here. The concept of partially applying functions stems from the functional way of programming. There it’s tightly linked with a concept called currying. Currying says that every function can be written as a function with only one parameter. By currying and un-currying you can achieve this goal. If this sounds very hard and complex, do not fear, in essence it’s quite (more...)
One of my customers that recently upgraded to 12c hit a bug that I think is good to be aware of. Note that as the title of this post states, the problem only occur in 126.96.36.199. At least, I wasn’t able to reproduce it in any other version.
To reproduce it you simply need a composite partitioned table with a non-partitioned or global-partitioned index. In other words, if all your indexes are (more...)
Topic: This post is about profiling and performance tuning of distributed workloads and in particular Hadoop applications. You will learn of a profiler application we have developed and how it has successfully been applied to tuning Sqoop to improve the throughput of data transfer from Oracle to Hadoop.