10 Times ( Oracle caching component )
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: 10 Times ( Oracle caching component )

  1. #1
    Join Date
    May 2005
    Posts
    129

    10 Times ( Oracle caching component )

    Has anybody ever heard of it? I am told it was purchased by Oracle and that I should consider using it instead of a large pre-joined summary table after I put the nail in the coffin on using Materialized views for this project.

  2. #2
    Join Date
    Jan 2004
    Posts
    162
    Er... that would be "Times Ten" not "Ten Times".

    Do I recall SlimDave posting a blog about testing this out or am I dreaming?

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Yes, but it's not got very far yet ...

    So what were the reasons for rejecting the MV then?
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Mmmmmm. More layers, extra complexity, harder to support...

    It sounds like a good idea to me. Where do I sign up?

    I was under the impression that this purchase was the first step in improving the app server caching system.

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    May 2005
    Posts
    129
    Quote Originally Posted by slimdave
    Yes, but it's not got very far yet ...

    So what were the reasons for rejecting the MV then?
    Dave its reservation availability the problems with synching outweigh the gains. In fact we will leave out those aspects and just pre-join the other 20 tables and batch changes, then pre-join at night. There is nothing left for the mview to do we dont need query rewrite as we are always going against the rollup and we dont need auto synch.

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    So you produce a precalculated result set every 24 hours or so then? And you actualy query against that during the day?
    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