1 / 40

The Ever Changing & Growing World of Oracle

The Ever Changing & Growing World of Oracle. August 2008. Agenda. This is mean to be more of an open discussion No set time per topic - each topic has just enough info to spur questions and/or open a dialog – so talk Feel free to ask questions about other topics

theta
Download Presentation

The Ever Changing & Growing World of Oracle

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Ever Changing & Growing World of Oracle August 2008

  2. Agenda • This is mean to be more of an open discussion • No set time per topic - each topic has just enough info to spur questions and/or open a dialog – so talk • Feel free to ask questions about other topics • No cell phones with ringer turned on (use vibrate) • Email only during breaks under penalty of death • Most of this material represents our customers’ world

  3. Hardware 20th Century Many Choices Yellow?

  4. Hardware 21st Century - Early Many Choices Green?

  5. Hardware 21st Century - Future Single Word: Virtualization

  6. Virtual Private Server

  7. Databases are going virtual too! Regardless of what Oracle says or what platform they push (Xen), VMware (85%) and Hypervisor are/will-be major virtual platforms www.rampant-books.com/book_2008_1_oracle_vmware.htm

  8. What has Happened • Memory • Dirt Cheap (just bought 32GB RAM for my home server for $1300) • Large capacity – my server motherboard can go up to 64GB RAM • CPU • RISC versus CISC no longer an issue • It’s an all 64-bit World – needs to be primary platform (not 32-bit) • Multi-Core CPU’s reign: Cores Threads Total/CPU • AMD Opteron 4 1 4 • Intel Xeon 4 2 8 • Sparc T1 8 4 32 • Sparc T2 8 8 64 • Power 6 2 2 4 • Disk • Disk themselves pretty much the same (i.e. RPM, cache, etc) • Disk architecture highly advanced – really no more “DAS” Cluster to form cheap mainframes

  9. CPU Platform / Features / Limits

  10. What does all this mean for Quest? • Databases Commoditized – we knew this • Software Commoditized – e.g. open source • Hardware Commoditized – cheap & virtualized • Solutions Commoditized (“Virtual Appliances”) • Products: • Need to be cognoscente of virtual environment & focused there • Need to be able to peer within virtualized “black box” components • Looking for “commoditized” answers – i.e. Change X to improve Y • Approach: • Possible that days of software installers are coming to an-end • Throwing hardware at a problem easier & cheaper than tuning • Tuning at the lowest level (SQL) now seen as expensive & timely • Database servers no longer viewed as “islands onto themselves”

  11. Oracle Architecture This is a very streamlined version, there is actually much more these days – but this is enough to build on…

  12. Traditional RAC

  13. Virtual RAC – 50,000 foot view

  14. Virtual RAC – 10,000 foot view

  15. Storage Virtualization too!!!

  16. New Oracle Architecture Diagram Can’t really point to actual hardware for database anymore

  17. Mixed Databases too!!!

  18. Quest Questions • So what do database performance products tell us? • Quest Database Performance Tools • Spotlight for Oracle | MySQL | SQL Server • Spotlight for Oracle RAC • Spotlight for Oracle Xpert (prediction) • Performance Analysis for Oracle | SQL Server • Etc • Our tools monitor and diagnose at the database level • From prior slide though we said … • Need to be cognoscente of virtual environment & focused there • Need to be able to peer within virtualized “black box” components • Looking for “commoditized” answers – i.e. Change X to improve Y • Throwing hardware at a problem easier & cheaper than tuning • Tuning at the lowest level (SQL) now seen as expensive & timely • Database servers no longer viewed as “islands onto themselves” • Foglight if the customer says our tools focus too low

  19. Oracle has Radically Evolved (i.e. Mutated) • The database is almost an operating system itself • ASM replaces Logical Volume Manager and File System • OCFS • OS Files (external tables, 11g Secure Files, BFILE, XMLDB, etc) • Job Scheduler (replacement for older & limited dbms_jobs) • Resource Manager • Oracle also seems to think it’s a true platform vendor • Oracle Enterprise Linux • Oracle VM • OEM for managing non-Oracle software • Oracle Applications (e-business, Seibel, JD Edwards, Peoplesoft) • Oracle Fusion (i.e. middleware layer) • Let’s also remember that Oracle has been on a radical acquisition spree …

  20. Traditional DB Storage

  21. >= 9i Alternatives

  22. LVM vs. ASM 40 Files

  23. Recent Oracle Acquisitons

  24. Don’t forget SQL Developer 

  25. Data Warehousing

  26. DW Load Scenarios

  27. DW Load Approaches

  28. Parallel is KEY !!!

  29. DW Aggregates

  30. Star Schema

  31. SNowflaking

  32. Pre-11g Partitioning Post-11g

More Related