Nov 2: 11.1.0.7 Fun
Well, I make that about 4 weeks since I installed 11.1.0.7 on my laptop on, yes, Vista but the weeks have flown by and I've only had a very quick play with it.
It was released along with another few ports that I was surprised to see appear so quickly, specifically AIX. As I'm working at an AIX site at the moment, I'm used to the long wait for 'Tier 2' ports to appear. It's usually about 6 months minimum. In a fit of wild speculation based on no solid information, I'd venture that the Linux port was ready long ago but was held back for Openworld as part of the Exadata announcement, which meant that the other porting teams caught up and were able to release soon after Openworld. As I said, wild speculation, but most of the Exadata blog posts I've seen in the past month seem to be similarly uninformed which is all the more surprising when there are plenty of white papers online. Frankly, you'd think if someone sets themself up as an industry analyst, they would take the time to read public information before they start spouting opinions. I suppose that's probably why I'll never make it as an industry analyst.
So what's in 11g that would have given some of the Exadata game away if it had been released before Openworld? Here are a few little fun details.
Because of the OEM performance presentations and the course, one of the first things I do is take a look at DB Control for any new update (and I need to remember to respond to Noon's post one day soon). At the bottom of the main Performance Page for the instance in the 11g screens is a tabbed section that includes an I/O tab which is one of the most noticeable improvements in 11g.
What may or may not be obvious from a small graphic is that the first of the I/O types listed in the key in the right hand side is 'Smart Scan', but I don't expect I'll be seeing that appearing in graphs on my laptop any time soon
While I was at it, I thought I'd see if there were any Exadata-related parameters or timed events.
Just a bit of fun, but nowhere near as much fun as Real Time SQL Monitoring. Now *that's* a feature worth upgrading for!
It was released along with another few ports that I was surprised to see appear so quickly, specifically AIX. As I'm working at an AIX site at the moment, I'm used to the long wait for 'Tier 2' ports to appear. It's usually about 6 months minimum. In a fit of wild speculation based on no solid information, I'd venture that the Linux port was ready long ago but was held back for Openworld as part of the Exadata announcement, which meant that the other porting teams caught up and were able to release soon after Openworld. As I said, wild speculation, but most of the Exadata blog posts I've seen in the past month seem to be similarly uninformed which is all the more surprising when there are plenty of white papers online. Frankly, you'd think if someone sets themself up as an industry analyst, they would take the time to read public information before they start spouting opinions. I suppose that's probably why I'll never make it as an industry analyst.
So what's in 11g that would have given some of the Exadata game away if it had been released before Openworld? Here are a few little fun details.
Because of the OEM performance presentations and the course, one of the first things I do is take a look at DB Control for any new update (and I need to remember to respond to Noon's post one day soon). At the bottom of the main Performance Page for the instance in the 11g screens is a tabbed section that includes an I/O tab which is one of the most noticeable improvements in 11g.
What may or may not be obvious from a small graphic is that the first of the I/O types listed in the key in the right hand side is 'Smart Scan', but I don't expect I'll be seeing that appearing in graphs on my laptop any time soon
While I was at it, I thought I'd see if there were any Exadata-related parameters or timed events.
SYS@TEST11> select name, value from v$parameter
2 where name like '%cell%';
NAME
----------------------------------------
VALUE
--------------------------------------------------------------------------------
cell_partition_large_extents
DEFAULT
cell_offload_processing
TRUE
cell_offload_parameters
cell_offload_compaction
ADAPTIVE
cell_offload_plan_display
AUTO
SYS@TEST11> select name, wait_class from v$event_name where name like '%cell%';
NAME WAIT_CLASS
---------------------------------------- --------------------
cell smart table scan User I/O
cell smart index scan User I/O
cell statistics gather User I/O
cell smart incremental backup System I/O
cell smart file creation User I/O
cell smart restore from backup System I/O
cell single block physical read User I/O
cell multiblock physical read User I/O
Streams miscellaneous event Other
9 rows selected.
Just a bit of fun, but nowhere near as much fun as Real Time SQL Monitoring. Now *that's* a feature worth upgrading for!
Oct 26: UKOUG 2008
Oct 4: Belgium Seminar Cancelled
Unfortunately, the two day performance course I was due to be teaching in Belgium in a couple of weeks has been cancelled. It also means that I won't be getting to see the DUDE as soon as I thought 
Comments
Mon, 10.11.2008 10:24
Yup, been there, seen that. On a related point, I've seen people run into [...]
Sun, 09.11.2008 08:41
Hans-Peter, I'm afraid I don't but I'm sure I've seen something similar [...]
Sat, 08.11.2008 20:21
I haven't come across this myself, but thanks for another example of the [...]