[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::rdb_wish

Title:Oracle Rdb Wishes and Suggestions
Notice:Please READ note 1.0 before using WRITE or REPLY
Moderator:NOVA::SMITHI
Created:Fri Apr 07 1989
Last Modified:Mon Jun 02 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:809
Total number of notes:4111

805.0. "Multithread area additions - on ALTER" by NOVA::SANTIAGO (I was a teenage net-random.) Tue May 20 1997 14:00

    Like on create database, allow alter database to mutltithread area
    additions
    
    /los
T.RTitleUserPersonal
Name
DateLines
805.1HOTRDB::LASTOVICAUse a fork Luke!Tue May 20 1997 15:005
    assuming that you've reserved some storage slots, this basically exists
    today.  Just use seperate processes (one per storage area).  This is
    even better because one could use multiple nodes of a cluster for
    increased speed.  In any case, how important, from a business
    perspective, is this?
805.2NOVA::SANTIAGOI was a teenage net-random.Tue May 20 1997 16:1021
    it'll be growing in importantance; we should adopt parallelism in every
    thing we do.
    
    granted we're embarking on new territory, but with the migration of
    transitional systems to datawarehouses, I'm predicting a need to add a
    years worth of storage to an existing environment.
    
    [a transitional system's data is volatile and usually tied to a cyclic
     business activity, whereas the d/w is more trend time/series oriented]
    
    Also, don't assume clusters are the computing model as single node Rdb7
    perform better, and allow faster control/recovery of 2pc transactions.
    
    [that is it's perceived faster to have the rdbserver rollsback vs. a 
     cluster transition and 2pc recovery]
    
    It'll be a few years yet before clusters regain thier position after
    memory channel and key s/w (i.e., Rdb7) adopt them and have been market
    proven
    
    /los
805.3HOTRDB::LASTOVICAUse a fork Luke!Wed May 21 1997 16:3811
    I guess what I meant was that you've got multithreaded area additions
    already.  You just do it via seperate processes rather than just one. 
    This has the added benifit of allowing multiple CPUs to take part (in
    one node or in a cluster).
    
>It'll be a few years yet before clusters regain thier position after
>memory channel and key s/w (i.e., Rdb7) adopt them and have been market
>proven.
    
    VMS engineering doesn't seem to see things the same way that you do!
    
805.4NOVA::SANTIAGOI was a teenage net-random.Fri May 23 1997 12:5110
    well, the last 5 or so years I was the VMS partner (a field technical
    laison w/ engineering) for the eastern states region, and they never
    listened then either; maybe they listen to the customer base? market?
    oracle?
    
    anyhow, getting back to the wish, the ability to simply perform the
    addition could require a single addition clause and be available across
    a host of platforms
    
    /los
805.5NOVA::SMITHIDon't understate or underestimate Rdb!Fri May 23 1997 13:2511
~    anyhow, getting back to the wish, the ability to simply perform the
~    addition could require a single addition clause and be available across
~    a host of platforms

If it was easy it would have been done.  The fact that it was hard to do in
ALTER DATABASE meant that it was deferred.  It is already on our wish list but
falls way below other features which we believe are more useful to customers.

thanks for the wish

Ian