Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Suggestions on MV Implementation !!!!!!!

RE: Suggestions on MV Implementation !!!!!!!

From: Jack Silvey <jack_silvey_at_yahoo.com>
Date: Mon, 24 Jun 2002 05:33:21 -0800
Message-ID: <F001.00485479.20020624053321@fatcity.com>


Madhu,

I would have two snapshots and one synonym. Have the webpages point to the synonym, and the synonym point to one of the snapshots while the other is refreshing. When the other is finished refreshing, recreate the synonym to point to the refreshed one and start the refresh on the other. The outage will be very brief, on the order of less than a second.

The same thing can be accomplished via a view, but since you are not changing the presentation of the data a synonym might be a simpler choice.

On later versions of Oracle any stored procedure that relies on this synonym will become invalid when you drop and recreate the synonym, however, they will automatically recompile when they are run again.

This process can lead to very brief outages on the webpage, if someone just happens to hit the webpage at the exact instant that the synonym is being recreated. I think that this might be a cost you have to bear to have the quick refresh capability you are talking about. You might be able to figure out how to briefly restrict access to the database/website/webpage during that split second, or just do your synonym swap at 3AM when no one is looking.

hth,

jack


Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jack Silvey
  INET: jack_silvey_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jun 24 2002 - 08:33:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US