how often the view get's updated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: how often the view get's updated

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    how often the view get's updated

    Hi ,

    I created a view based on three tables.I would like to know how often the view gets updated.

    The based tables will get updated every 2 to 5minutes.Will it get updated if We have new data in any table

    Can some one explain me

    thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: how often the view get's updated

    Originally posted by prodadmin
    Hi ,

    I created a view based on three tables.I would like to know how often the view gets updated.

    The based tables will get updated every 2 to 5minutes.Will it get updated if We have new data in any table

    Can some one explain me

    thanks
    What view? A materialized view?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401
    It's a regular view

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Regular view does not take any time. It is as good as you are fetching data from base tables. So it should be instantaneous. what made you think it takes 2-3 minutes? any test/observation?
    -- Dilip

  5. #5
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    thanks

    Thank you Dilip!!
    I was just guessing "will there be any delay?"
    I know materiliazed views updates depend upon the time we specify.

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Read the concepts manual, 'cos ithink you don't understand what a view is. It's just a query hidden inside a logical wrapper -- you selct from the view, the query get's executed.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width