Search

Top 60 Oracle Blogs

Recent comments

August 2013

Looking for past posts?

My previous blog had out grown the limited area of just Oracle. The current blog will cover broader areas of data mobility, agility and visualization.

If there are past posts that you are looking for, please drop me a line and I will prioritize them for posting on this blog.

 

 

Death of the Storage Array

When I wrote this article for The Register in October 2010, there was a torrent of naysayers and witch hunters spewing their opinions in the comments section. I don’t have a problem with that, I was only expressing an opinion myself, after all. I don’t actually own a time machine and so any of my … Continue reading "Death of the Storage Array"

Death of the Storage Array

When I wrote this article for The Register in October 2010, there was a torrent of naysayers and witch hunters spewing their opinions in the comments section. I don’t have a problem with that, I was only expressing an opinion myself, after all. I don’t actually own a time machine and so any of my … Continue reading "Death of the Storage Array"

Death of the Storage Array

When I wrote this article for The Register in October 2010, there was a torrent of naysayers and witch hunters spewing their opinions in the comments section. I don’t have a problem with that, I was only expressing an opinion myself, after all. I don’t actually own a time machine and so any of my … Continue reading "Death of the Storage Array"

Fast refresh of aggregate-only materialized views with SUM – algorithm

In this post I will illustrate the algorithm used by Oracle (in 11.2.0.3) to fast refresh a materialized view (MV) containing only the SUM aggregate function:

create materialized view test_mv
build immediate
refresh fast on demand
with rowid
as
select gby        as mv_gby,
       count(*)   as mv_cnt_star,
       sum  (dat) as mv_sum_dat,
       count(dat) as mv_cnt_dat
  from test_master
 where whe = 0
 group by gby
;

Note that count(dat) is specified - you could avoid that if column dat is constrained to be not-null (as stated in the documentation), but I'm not covering that corner case here.

The MV log is configured to "log everything":

ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support

So, how many of you do hate the dialog below?

Good news – there is a fix! (or well, a hack around it ;)
Before showing the fix, you can vote & give your opinion here:
Do you love or hate the MOS “page expired” dialog? The fix is actually super-simple. The page expiration dialog that grays out the browser screen is just a HTML DIV with ID DhtmlZOrderManagerLayerContainer, overlaying the useful content.

ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support

So, how many of you do hate the dialog below?

Good news – there is a fix! (or well, a hack around it ;)
Before showing the fix, you can vote & give your opinion here:
Do you love or hate the MOS “page expired” dialog? The fix is actually super-simple. The page expiration dialog that grays out the browser screen is just a HTML DIV with ID DhtmlZOrderManagerLayerContainer, overlaying the useful content.

C-MOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support

So, how many of you do hate the dialog below?

MOS page expired dialog

Good news – there is a fix! (or well, a hack around it ;)

Before showing the fix, you can vote & give your opinion here:

ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support

So, how many of you do hate the dialog below?

Good news – there is a fix! (or well, a hack around it ;)
Before showing the fix, you can vote & give your opinion here:
Do you love or hate the MOS “page expired” dialog? The fix is actually super-simple. The page expiration dialog that grays out the browser screen is just a HTML DIV with ID DhtmlZOrderManagerLayerContainer, overlaying the useful content.

ShowMOS: How to get rid of the annoying “The Page has Expired” dialog in My Oracle Support

So, how many of you do hate the dialog below?

Good news – there is a fix! (or well, a hack around it ;)
Before showing the fix, you can vote & give your opinion here:
Do you love or hate the MOS “page expired” dialog? The fix is actually super-simple. The page expiration dialog that grays out the browser screen is just a HTML DIV with ID DhtmlZOrderManagerLayerContainer, overlaying the useful content.