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.
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.
"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...)
Build a framework that does most of the work and (more...)
There are lots of videos showing this dream machine at work.Possibly Related Posts:
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...)
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.”
I’ve been (more...)
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.
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...)
"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...)
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...)
"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...)
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...)
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...)
“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...)
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...)
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...)
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...)