-
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."
-
Sounds great, providing it all comes to fruition and works.
MH
I remember when this place was cool.
-
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
-
Just remembered...
9i had 270 init parameters. 10G has 30!!!
-
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
-
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.
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|