Oracle Exadata Survival Guide (Expert's Voice in Oracle)

By David Fitzjarrell

Oracle Exadata Survival Guide is a hands-on consultant for busy Oracle database directors who're migrating their ability units to Oracle's Exadata database equipment. The ebook covers the thoughts in the back of Exadata, and the on hand configurations for gains akin to clever scans, garage indexes, shrewdpermanent Flash Cache, hybrid columnar compression, and extra. you are going to know about functionality metrics and execution plans, and the way to optimize SQL working in Oracle's strong, new surroundings. The authors additionally disguise migration from different servers.

Oracle Exadata is speedy turning into the traditional for big installations reminiscent of these working facts warehouse, company intelligence, and large-scale OLTP structures. Exadata is like no different platform, and is new floor even for knowledgeable Oracle database directors. The Oracle Exadata Survival advisor is helping you navigate the fine details of this new platform, de-mystifying this impressive equipment and its unparalleled functionality. The publication takes a hugely useful strategy, now not diving too deeply into the main points, yet providing you with simply the perfect intensity of data to speedy move your abilities to Oracle's vital new platform.

  • Helps move your abilities to the platform of the longer term
  • Covers the $64000 floor with no going too deep
  • Takes a realistic and hands-on method of daily tasks

What you’ll learn

  • Learn the elements and easy structure of an Exadata desktop
  • Reduce facts move overhead by means of processing queries within the garage layer
  • Examine and take motion on Exadata-specific functionality metrics
  • Deploy Hybrid Columnar Compression to lessen garage and I/O wishes
  • Create worry-free migrations from present databases into Exadata
  • Understand and handle concerns particular to ERP migrations

Who this ebook is for

Oracle Exadata Survival Guide is for the busy firm Oracle DBA who has unexpectedly been thrust into the Exadata arena. Readers must have a valid snatch of conventional Oracle database management, and be ready to profit new points which are particular to the Exadata equipment.

Show description

Preview of Oracle Exadata Survival Guide (Expert's Voice in Oracle) PDF

Similar Computer Science books

Web Services, Service-Oriented Architectures, and Cloud Computing, Second Edition: The Savvy Manager's Guide (The Savvy Manager's Guides)

Internet providers, Service-Oriented Architectures, and Cloud Computing is a jargon-free, hugely illustrated rationalization of ways to leverage the swiftly multiplying prone on hand on the web. the way forward for enterprise depends on software program brokers, cellular units, private and non-private clouds, substantial facts, and different hugely hooked up expertise.

Software Engineering: Architecture-driven Software Development

Software program Engineering: Architecture-driven software program improvement is the 1st finished consultant to the underlying talents embodied within the IEEE's software program Engineering physique of information (SWEBOK) ordinary. criteria professional Richard Schmidt explains the normal software program engineering practices well-known for constructing tasks for presidency or company structures.

Platform Ecosystems: Aligning Architecture, Governance, and Strategy

Platform Ecosystems is a hands-on consultant that provides an entire roadmap for designing and orchestrating shiny software program platform ecosystems. not like software program items which are controlled, the evolution of ecosystems and their myriad members has to be orchestrated via a considerate alignment of structure and governance.

Additional resources for Oracle Exadata Survival Guide (Expert's Voice in Oracle)

Show sample text content

It definitely isn’t meant for actively up-to-date tables; the distance discount rates will be misplaced because of uncompressing the information, to permit the updates and recompressing on the decrease OLTP point. We’ll compress our common EMP desk for ARCHIVE excessive and spot what area rate reductions are generated:   SQL> -SQL> -- present garage for the EMP desk SQL> -- (this is just a try out desk for this instance) SQL> -SQL> decide on segment_name, sum(bytes) total_space 2 from user_segments three workforce by way of segment_name;   88 Chapter 6 ■ Compression SEGMENT_NAME TOTAL_SPACE ----------------------------------- ----------DEPT 65536 DUMMY 65536 EMP 713031680 EMP_IDX 478150656 SALGRADE 65536   Elapsed: 00:00:00. 02 SQL> SQL> -SQL> -- Compress the desk for archive excessive SQL> -SQL> -- word elapsed time to compress SQL> -SQL> adjust desk emp circulation compress for archive excessive;   desk altered. Elapsed: 00:00:38. fifty five SQL> SQL> -SQL> -- Index is now invalid SQL> -SQL> -- needs to rebuild to make it usable SQL> -SQL> -- be aware elapsed time SQL> -SQL> regulate index emp_idx rebuild;   Index altered. Elapsed: 00:00:39. forty five SQL> SQL> -SQL> -- present compression variety, garage for table/index SQL> -- at first after compression is enabled SQL> -SQL> decide upon table_name, compression, compress_for 2 from user_tables;   TABLE_NAME COMPRESS COMPRESS_FOR ------------------------------ -------- -----------DEPT DISABLED BONUS DISABLED SALGRADE DISABLED DUMMY DISABLED EMP ENABLED ARCHIVE excessive   89 Chapter 6 ■ Compression Elapsed: 00:00:00. 02 SQL> SQL> decide on segment_name, sum(bytes) total_space 2 from user_segments three workforce via segment_name;   SEGMENT_NAME TOTAL_SPACE ----------------------------------- ----------DEPT 65536 DUMMY 65536 EMP 4194304 EMP_IDX 260046848 SALGRADE 65536   Elapsed: 00:00:00. 01 SQL>   the distance discount rates are vast, taking the desk from its unique dimension of 680 megabytes all the way down to four megabytes, a reductions of ninety nine. forty-one percentage. utilizing ARCHIVE LOW rather than ARCHIVE excessive nonetheless produces outstanding effects:   SQL> -SQL> -- preliminary garage SQL> -SQL> decide on segment_name, sum(bytes) total_space 2 from user_segments three crew by means of segment_name;   SEGMENT_NAME TOTAL_SPACE ----------------------------------- ----------DEPT 65536 DUMMY 65536 EMP 713031680 EMP_IDX 478150656 SALGRADE 65536   Elapsed: 00:00:01. 31 SQL> SQL> -SQL> -- Compress for ARCHIVE LOW SQL> -SQL> -- word elapsed time SQL> -SQL> modify desk emp movement compress for archive low;   desk altered. Elapsed: 00:00:34. sixteen SQL> SQL> adjust index emp_idx rebuild;   ninety Chapter 6 ■ Compression Index altered. Elapsed: 00:00:48. forty four SQL> SQL> -SQL> -- those figures are kind of like these generated SQL> -- AFTER the HCC compressed facts used to be up-to-date the 1st time SQL> -SQL> opt for table_name, compression, compress_for 2 from user_tables;   TABLE_NAME COMPRESS COMPRESS_FOR ------------------------------ -------- -----------DEPT DISABLED BONUS DISABLED SALGRADE DISABLED DUMMY DISABLED EMP ENABLED ARCHIVE LOW   Elapsed: 00:00:00. 03 SQL> SQL> decide upon segment_name, sum(bytes) total_space 2 from user_segments three staff by way of segment_name;   SEGMENT_NAME TOTAL_SPACE ----------------------------------- ----------DEPT 65536 DUMMY 65536 EMP 8388608 EMP_IDX 260046848 SALGRADE 65536   Elapsed: 00:00:00.

Download PDF sample

Rated 4.95 of 5 – based on 36 votes