The BI Publisher SIG is gearing up for Collaborate 2016 in April and is looking for volunteers to share their experiences, tricks, tips, challenges, etc… with fellow users during our meeting in Las Vegas on Monday April 11th. Do you have a story to tell? Want to showcase a challenge? Want to brag about an accomplishment? We would love to have YOU, the actual user spend 10-15 minutes sharing your experiences/stories with (more...)
One particular technique that I will take as an example for this article is index compression. A good example in PeopleSoft is the tree node table, PSTREENODE. It drives many security and hierarchical queries. It is not updated very frequently, only as new trees are brought on. Many of the indexes are good candidates for compression. Oracle can (more...)
For a procedure (or function) in a package, you can assign default values only in the package specifications without assigning them in the package body:
SQL> CREATE OR REPLACE PACKAGE test_default_pkg AS PROCEDURE set_global (p_num IN NUMBER DEFAULT 1); END; / Package TEST_DEFAULT_PKG compiled SQL> SHOW ERRORS; No errors. SQL> CREATE OR REPLACE PACKAGE BODY test_default_pkg AS PROCEDURE set_global (p_num IN NUMBER) AS BEGIN NULL; END; END; / Package body TEST_DEFAULT_PKG compiled SQL> SHOW ERRORS; (more...)
Some of Dr. Pareto's work is based on the Pareto Principle: the idea that 80% of effects come from 20% of causes. In the real world, we continually see examples of the Pareto Principle.
I've been conducting one of my informal surveys (more...)
The title of the Contribute event/seminar was "Oracle Forms 12c: Built to last".
Indeed, Forms is built to last. It has been around for over 20 years and it's added to Oracle Fusion Middleware 12c, which is supported until 2023.
Oracle Forms is still running at a lot of Belgian companies looking at the turnout.
The ‘Year in Blogging’ reports have come through so I can see what posts and newsletter items garnered the most views.
PeopleSoft Tipster Blog
So, according to the summary, this blog was visited 130,000 times during the year, an average of ~350/day with the busiest day being just over double that at 749 visitors. About 50% of the traffic is from the US, 15% from India, and 5% from the UK and Canada.
Amazingly, the (more...)
Oracle did an update of the support document for Fusion Middleware.
Fusion Middleware 12c(12.2.x) is supported until October 2023(extended support).
Of course this includes Forms and Reports!
But you can also see that the premier support for Forms 11gR2 ends at the end of this year!
Just to remind you, the support is (almost)the same for premier and extended, but you'll have to pay an additional fee for extended support.
Even after a month of wearing the iWatch, I can't really point at one particular feature that makes it worthwhile. It's really more (more...)
I used the employees table from the HR demo schema for my examples which is already available in Live SQL, so you don't have to create anything but the functions used in the scripts.
I've created 4 scripts:
Wherever you roam
And admit that the waters
Around you have grown
And accept it that soon
You'll be drenched to the bone
If your time to you
Is worth savin'
Then you better start swimmin'
Or you'll sink like a stone
For the times they are a-changin'.
-- From Bob Dylan's "The Times They Are A-Changin'"
Spent some time with (more...)
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 (more...)
So, I suggested the DBAs to do strace (more...)
twm: unable to open fontset "-adobe-helvetica-bold-r-normal--*-120-*-*-*-*-*-*"
I found a solution on http://ubuntuforums.org/archive/index.php/t-1596636.html :
It was reported here for fedora: https://bugzilla.redhat.com/show_bug.cgi?id=509639. The workaround is to execute it with a specific shell variable:
$ export LANG
twm launches fine after this.