The Apple Watch Arrives

Ho hum, Apple released a Watch on Friday. I haven’t see this kind of nerd frenzy since Google Glass finally reached its first Explorers.

The Watch has transcended nerd-only fandom to reach regular people’s consciousness too, e.g. when I wore the Basis Peak, several people asked if it was *the* Watch.

Well, Noel (@noelportugal) and Thao (@thaobnguyen) are both test-driving their Watches now, so look for their initial impressions (more...)

OAUX Emerging Technologies RD&D Strategy

Speaking of strategies, Misha (@mishavaughan) asked me to write up an article–not a post, there’s a difference–describing how this team goes about its business, i.e. researching, designing and developing solutions for the emerging technologies that will affect our users in the near and not-so-near future.

eleven

You can, and should, read the resulting article over at the mothership, Usableapps (@usableapps). Check it out:

New emphasis on emerging technology shapes Oracle’s user (more...)

Columns, Columns Everywhere


"Many of the things which can never be, often are."
- Norton Juster, The Phantom Tollbooth 

Oracle’s most recent database release has an interesting problem involving ANSI joins and tables having 500 or more columns. Yes, this is likely a rare situation in OLTP systems but it exists, nonetheless. [Data warehouses are different and it’s likely that tables of 500 columns or more could exist.] It was brought to light in a forum (more...)

Are We Ready for the Apple Watch?

So, apparently Apple is launching a watch soon, which has people asking us, i.e. Oracle Applications User Experience (@usableapps), what our strategy is for the watch of watches.

If you read here, you probably already know we’ve been looking at smart watchessuper watches, and wearables of all kinds for a few years. So, the strategy is already in place.

Build a framework that does most of the work and (more...)

Cool Machines: RU 800-S Rail Refresher

The kid in me loves this behemoth so very much, h/t to Kottke. This rail refresher is a Swietelsky RU 800-S.

There are lots of videos showing this dream machine at work.Possibly Related Posts:

Four Weeks with the Basis Peak

Right after I finished wearing the Nike+ Fuelband for three weeks, I moved straight on to another wearable device, the Basis Peak.

The Peak falls into a category Ultan (@ultan, @usableapps) calls the “super watch,” a term that nicely differentiates watches like the Peak (and the Fitbit Surge) from fitness bands (e.g. Jawbone UP24, Nike+ Fuelband, Fitbit Flex), smartwatches (e.g. Android Wear, (more...)

The Fitbit Surge: Watching Where the Super Watch Puck Goes

Editor’s note: Here’s a review of the Fitbit Surge from Ultan (@ultan, @usableapps); if anyone can road-test a fitness tracker, it’s him. As luck would have it, the Surge is on my list of wearables to test as well. So, watch this space for a comparison review from a much less active person. Enjoy.

I’ve upgraded my Fitbit experience to the Fitbit Surge, the “Fitness Super Watch.”

Why?

I’ve been (more...)

Conference Recaps and Such

I’m currently in Washington D.C. at Oracle HCM World. It’s been a busy conference; on Wednesday, Thao and Ben ran a brainstorming session on wearables as part of the HCM product strategy council’s day of activities.

brainstorm

Then yesterday, the dynamic duo ran a focus group around emerging technologies and their impact on HCM, specifically wearables and Internet of Things (IoT). I haven’t got a full download of the session yet, but I hear the discussion was (more...)

Extra-cost Option?


"Just because you have a choice, it doesn't mean that any of them 'has' to be right."
 Norton Juster, The Phantom Tollbooth 

In an Oracle forum that I frequent a user posted that he found cardinality values to be severely inflated when using an analytic function. This user posted an example that will be used here to demonstrate the problem. It will also be used to demonstrate another issue that can make this problem (more...)

NoSQL Joke and DBA humor

Once, a very long time ago, I told an old joke about SQL and it was a huge success (not really).
This week I heard a joke that is slightly related to that joke and it made me giggle for a couple of minutes.
Those who know me, knows that I really like to hear jokes but I’m really terrible at telling them – but let’s go for it anyway.

2 DBAs NoSQL walk into (more...)

Merge, Right?


"There are no wrong roads to anywhere."
 - Norton Juster, The Phantom Tollbooth 

Oracle can do some, well, strange things when fixing issues caused by the optimizer. For 10g releases up to 10.2.0.x Oracle chose to silently ignore a message and eliminate an outer join on the MERGE statement under certain conditions. Let’s examine this and see exactly what Oracle implements.

Occasionally in a 10046 trace file generated from 10g releases (more...)

Learn how free new tool sqld360 can tell you so much about your favorite SQL!

New tool sqld360 is now available! Mauro Pagano released this cool new tool a few hours ago. And yes, it is free for all!

So, what is sqld360? Well, it is an install-nothing free software that tells you a lot about one SQL statement. And if your site has an Oracle Tuning Pack or Diagnostics Pack license, then you get a lot more from sqld360. Sample snapshot below shows you the dynamic menu for a (more...)

What’s The Password?

A very interesting question was posted in one of the forums I participate in:


is there any way how I can revoke the right from a normal user to change it's own password in the database?

This, obviously, sparked a fairly lively thread (which I will not re-post here) regarding security and the underlying reason such a request was made. The user who posted the original question continued in the thread to explain:


Of course  (more...)

How to Open an Email Client with PeopleCode

When there's an email id displayed on a page, wouldn't it be cool for your users to be able click on it and have their email client (like Microsoft Outlook) open up a blank mail with the email id and subject line filled in? Here's how to do it in PeopleCode.

How Can I Compress Thee


“You can swim all day in the Sea of Knowledge and not get wet.” 
― Norton Juster, The Phantom Tollbooth 

In previous posts compression options have been discussed, and now it’s time to see how Oracle performs basic compression. It isn’t really compression, it’e de-duplication, but it does result in space savings for data that won’t be modified after it’s ‘compressed’. Let’s look at how Oracle saves space with your data.

Oracle de-duplicates the (more...)

Primary on FileSystem and Standby on ASM

For one of the client, standby server went down. We had another standby server which was kept down for more than a month. Decision was taken to start the server and apply incremental SCN based backup on the standby database.

The standby was on ASM and the Primary on filesystem.Incremental backup was started from the SCN reported by below query

select min(fhscn) from x$kcvfh;

Once the backup completed, it was transferred to standby, standby (more...)

Why do you need to gather CBO Statistics?

As I help a peer with a SQL Tuning engagement, I face the frequent case of: “We do not want to gather CBO schema object statistics because we don’t want our Execution Plans to change”. Well, the bad news is that: not gathering stats only gives you a false sense of safety because your Execution Plans can change anyways. The reason has to do with Predicates referencing values out of range. Typical cases include range (more...)

Finding SQL with Performance changing over time

I upgraded my database a couple of weeks ago and now my users complain their application is slower. They do not provide specifics but they “feel” it is running slower. Sounds familiar?

Every once in a while I get a request that goes like this: “how can I find if some SQL on my database is performing worse over time?”

It is very hard to deal with the ambiguities of some problems like “finding (more...)

Oracle Open World 2014 Presentations Download

Oracle has made the presentations used at Open World 2014 available for download this time too. Here are all the ones that are related to PeopleSoft.

DBMS_SCHEDULER jobs running an hour late – DST/BST issues!

This week one of our developers highlighted the fact that the DBMS_SCHEDULER on one of our 11.2.0.3 databases was running jobs an hour later than scheduled until just recently, when the clocks went back (26/10/2014) for British Summer Time (BST) …and now they’re running on-time again! I’d not seen this before, and at first I thought we

Read More...