Some 10G Intresting features.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Some 10G Intresting features.

  1. #1
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Some 10G Intresting features.

    Well, i have been out for too long now.

    Just attended a 10G session recently conducted by Oracle and found some intresting features of 10G which i would like to share with all you. Don't have the documents yet in hand so trying to recollect whatever was i can remember.

    o Improved RMAN Backups.

    No longer do we need to maintain those archive logs and incremental backups in 10G.

    Take a initial complete backup, then take incremental backups. Intresting part is that the incremental backups can be applied to the first complete backup (the RMAN backup dump), so that the last complete backup is just a day behind or few hours behind.

    o FlashBack Database.

    Like the flashback query we can flash back the database it self. Flash back database 2 hours back and kaaboom you have the database as it was 2 Hrs back.

    o Data Management.

    Just have to provide a disk volume to create a tablespace and Oracle will intenally strip and mirror the data across the disks. Its something like :

    Code:
    Data is stripped and mirrored across disks. 
    
    Stripping.
    
    Same copy of data is spread across disks to avoid disk contentions. 
    A copy of data a is available as a1, a2, a3 on Disk1, Disk2 and Disk3. 
                --------  -------- --------
                |a1    |  |  a2  | |    a3|
                |  b2  |  |    b3| |b1    |
                |    c3|  |c1    | |  c2  |
                --------  -------- --------
                 Disk1      Disk2   Disk3
    
    Mirroring.
    
    In case Disk1 goes down the data is available on Disk2 and Disk3.
                --------  -------- --------
                |a1    |  |  a2  | |    a3|
                |  b2  |  |    b3| |b1    |
                |    c3|  |c1    | |  c2  |
                --------  -------- --------
                  \  /       /\       /\
                   \/        ||       || 
                   /\        ||       ||
                  /  \       ||       ||
                 Disk1     Disk2    Disk3
    o OEM
    No need to create a seperate repository for OEM. It will be there in the same database.

    Other intresting features are related to performance, where a internal repository will be maintained to monitor the database all the time. Well ORCALE Development team says that maintaining this repository would cause 5% overhead to the database. So Not sure about this.

    There are others as well which im not able to recollect at the moment.

    Till then cheers!
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  2. #2
    Join Date
    Jan 2001
    Posts
    3,131
    Sounds great, providing it all comes to fruition and works.

    MH
    I remember when this place was cool.

  3. #3
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    I went to a preview last week too...interesting stuff.

    Some other things I remember:
    Query Rewrite - It will pick out the "worst" SQL, and then suggest how to fix it. If you accept, anytime that sql is run, Oracle will run it IT's way instead. So no more complaining about bad 3rd party SQL.

    A note about the RMAN backups - A gothcha is that all of the backup information is stored on disk... not tape. The estimate I heard was that you will need 2-3x your DB size in extra storage for this feature. Same thing goes for Flashback Database if I remember correctly.

    OEM - I've heard you still need the repository, just that there's no Management Server to mess with. Also, there WILL be 32-bit agents so you can monitor 8i and 7 databases with a 10G OEM. (For those of us who can't monitor our 32 bit unix DBs with 9i OEM).

    That's all I can remember right now....

    Jodie

  4. #4
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334

    Just remembered...

    9i had 270 init parameters. 10G has 30!!!

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by Mr.Hanky
    Sounds great, providing it all comes to fruition and works.

    MH
    Amen.

    And provided that Oracle Suport Services at least recognise the names of some of these new features
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  6. #6
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by jodie
    I went to a preview last week too...interesting stuff.

    A note about the RMAN backups - A gothcha is that all of the backup information is stored on disk... not tape. The estimate I heard was that you will need 2-3x your DB size in extra storage for this feature. Same thing goes for Flashback Database if I remember correctly.

    Jodie
    That is one hell of a gotchya!! Pretty useless for large DB's.


    MH
    I remember when this place was cool.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    Re: Just remembered...

    Originally posted by jodie
    9i had 270 init parameters. 10G has 30!!!
    until, of course, you get into the _super_secret and _undocumented parameters...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jan 2001
    Posts
    3,131

    Re: Re: Just remembered...

    Originally posted by marist89
    until, of course, you get into the _super_secret and _undocumented parameters...
    Or 10g version 2.



    MH
    I remember when this place was cool.

  9. #9
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    until, of course, you get into the _super_secret and _undocumented parameters...
    True! Just like the RBO is not supported in 10G (But it's still there - just in case you REALLY want to use it!)

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