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: MATERIALIZED VIES IN OLTP SYSTEM : GOOD OR NOT

Re: MATERIALIZED VIES IN OLTP SYSTEM : GOOD OR NOT

From: Andrey Kriushin <Andrey.Kriushin_at_rdtex.ru>
Date: Mon, 29 May 2006 15:37:41 +0400
Message-ID: <447ADD05.3080907@rdtex.ru>


On pure OLTP these are rarely if at all needed. As for hybrids (which are almost all of systems) it may benefit reporting part of the application at some expense for OLTP part.

Most limiting IMHO is using REFRESH ON COMMIT for "summaries", i.e. when some aggregates need to be updated online. Usually may lead to excessive TX locks when two or more transactions are updating different rows of underlying table, which are the inputs for the same single row in the summary.

HTH

Sachin Sethi wrote:
> HI
>
> *IT IS BENIFICIAL TO HAVE MATEREIALIZED VIES IN OLTP SYSTEM *
> *PLEASE HELP ME *
>
>
> Thanks & Regards
>
> Sachin Sethi
> Software Engineer
> Telserra , Gurgaon
> Suite 501, 5th floor,
> Pacific Squre, 32nd Milestone,
> NH - 8, Gurgaon -122 001,
> India, Tel: - +91-124-411-7071, Fax: +91-124-411-7079
> Mobile : +919899595255
> E-Mail :s.sethi_at_telserra.com
> URL: www.telserra.com <http://www.telserra.com>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 29 2006 - 06:37:41 CDT

Original text of this message

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