Search

Top 60 Oracle Blogs

Recent comments

January 2014

WPtouch Mobile Plugin

A big shout out goes to Amardeep Sidhu, who pointed me to WPtouch to me recently. Install and activate this plugin and your WordPress blog is mobile aware, presenting a trimmed down view on mobile devices.

It really is that simple. No messing involved. If you have a WordPress blog, you may want to have a play with this plugin.

Cheers

Tim…

Public Speaking Tip 6 : How to handle questions (crowd control)

Handling questions was certainly one of the things I most feared when I started speaking at conferences. If there is one thing you take away from this post, it should be this.

“Never bullshit!”

Here’s a comment Jonathan Lewis left on my first post in this series.

“I think a very important thing to believe before anything else is that it’s perfectly acceptable to say “I don’t know” or “I’m not sure” if someone asks a question you can’t answer immediately.”

It sounds so simple, but it takes a surprising degree of confidence to say this when you are in front of an audience.

Here are some general thoughts on handling questions and basic crowd control.

Interesting post-install steps for Oct 2013 12.1.0.1.1 PSU

I have already written about RAC/Grid Infrastructure related patching of 12.1.0.1.0 to 12.1.0.1.1, aka the October 2013 PSU for the database.

This post is a follow-up for pure RDBMS-only installations. I initially thought it wasn’t worth blogging about it (and hence the lag between the posts) but I came across an interesting post-apply step that is required for the databases: datapatch.

This is a new tool to run post the Patch Set Update installation against the non-CDB.

UPDATE: Oracle discourages the application of the patch set for RAC/GI on Multi-Tenant.

Here is the reference output for a non-CDB:

Index Hash

I’m afraid this is one of my bad puns again – an example of the optimizer  making a real hash of the index hash join. I’m going to create a table with several indexes (some of them rather similar to each other) and execute a query that should do an index join between the obvious two indexes. To show how obvious the join should be I’m going to start with a couple of queries that show the cost of simple index fast full scans.

Here’s the data generating code:

Public Speaking Tip 5 : Deliver what you say you will!

Go to a conference and I can guarantee you will hear people complaining about sessions they sat through that bare no resemblance to the title or the abstract.

It’s not easy to come up with an eye catching title and abstract, but don’t fall into the trap of trying too hard, then failing to deliver on the day. It’s better that you are honest and don’t get selected, than promise people an enlightening experience and fall short.

Demo Links To All Older Posts Now Accessible (Chains)

OK, for a quite some time (too long probably !!!) people have been sending me emails and leaving comments that they have been unable to access a number of the demos to my older posts and those listed in my Presentations and Demos page. I previously would write an article but include a demo that […]

Date to Timestamp Conversion during PeopleTools Upgrade

This blog posting describes a script to convert Oracle date columns to Timestamps as used from PeopleTools 8.50 but only rebuilding those indexes that reference those columns, rather than drop and recreate every index in the system, thus producing a significant saving of time during the upgrade.

(A longer version of this article is available on my website)

I am working on a PeopleSoft upgrade project.  We are going from PeopleTools 8.49 to 8.53.  One of the things that happens is that some date columns in the Oracle database become timestamps.

Date to Timestamp Conversion during PeopleTools Upgrade

This blog posting describes a script to convert Oracle date columns to Timestamps as used from PeopleTools 8.50 but only rebuilding those indexes that reference those columns, rather than drop and recreate every index in the system, thus producing a significant saving of time during the upgrade.

(A longer version of this article is available on my website)

I am working on a PeopleSoft upgrade project.  We are going from PeopleTools 8.49 to 8.53.  One of the things that happens is that some date columns in the Oracle database become timestamps.

Importance of Feedback

4386925065_1ef4a396b8_z

photo by  Idaho National Laboratory

The human brain works so well because it calculates outcomes as it takes actions feeding back the current results compared to the expected results  which allows immediate corrections if the two are not aligning.