This content has been marked as final. Show 8 replies
user12050217 wrote:I have read the post twice but I am not sure that I still did understand that what's your question actually is?
I just want to know :
1.World's largest Oracle database in size.
2.World's most busy Oracle database in user connections per second/nano second.
3.World's most complex configured Oracle db having all features configured (which Oracle has provided till now) i.e.
100 DBAs and one db !
- One DBA is doing export, another is doing import
- One is looking into wait & latch
- One is adding ASM disk
- Someone is looking why there is gap in log shipping on standby db.
- Couple of persons are busy on SQL tuning
- One is doing trace 10053
- One is looking why RAC node <n> have issue
- Audit Vault, FGA
- 100th DBA Statspack, AWR
[url http://www.dbms2.com/2011/09/15/database-architecture-salesforce-com-force-com-and-database/]This guy says one of Oracle's competitors has the largest instance (what?) of Oracle in the world. I think he must be wrong. The problem is, when you get into very large databases, people start doing some strange things to work around database limitations, so you wind up with part of the database in some special kind of db engine and part in Oracle. Some large sites may not want it known what they do and use.
I am not sure just guessing that OP thinks that World's largest/busiest/complex DB's DBA is/are also member of this forum, so probably someone will reply :
- I am working on world's largest db i.e. N Tb... OTNUser<N>
- I am member of world's most busy db's DBA team... OTNUser<N>
- I am DBA for the world's most complex configured db... OTNUser<N>
Ok, anyway, if there is any user(s) comes here, what OP will get, thats the really a great question though !
Any gift to them from his side ?
user12050217 wrote:Silly season that side of the world?
I just want to know :
1.World's largest Oracle database in size.It is not the size of the database that makes it large. You can have a 100TB database with a billions of images - where access is via primary key to a single specific image at a time. Despite the 100TB size, this database is basically a mickey mouse type system as far as databases go. Nothing large ito transactions or data process about it.
BTW - this is exactly what Microsoft did in the 90's by claiming one of the first 1TB databases on the net running SQL-Server. It served satellite images. Which meant a few million rows in that 1TB and not few 100 million (like we had in an Oracle data warehouse a fraction that size and significantly "larger" at that time).
2.World's most busy Oracle database in user connections per second/nano second.I once showed J2EE developers that they could create a 1000+ Java sessions to an Oracle database running on a desktop PC.
Number of connections prove nothing.
3.World's most complex configured Oracle db having all features configured (which Oracle has provided till now)Oracle is not complex - except for those who are ignorant about client-server architecture, relational database concepts and Oracle fundamentals.