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 innovations in the back of Exadata, and the to be had configurations for beneficial properties resembling shrewdpermanent scans, garage indexes, clever Flash Cache, hybrid columnar compression, and extra. you are going to know about functionality metrics and execution plans, and the way to optimize SQL operating in Oracle's robust, new setting. The authors additionally conceal migration from different servers.
Oracle Exadata is quickly turning into the normal for giant installations resembling these operating info warehouse, company intelligence, and large-scale OLTP platforms. Exadata is like no different platform, and is new flooring even for knowledgeable Oracle database directors. The Oracle Exadata Survival consultant is helping you navigate the bits and bobs of this new platform, de-mystifying this remarkable equipment and its remarkable functionality. The ebook takes a hugely useful strategy, no longer diving too deeply into the main points, yet providing you with simply the proper intensity of data to fast move your talents to Oracle's very important new platform.
- Helps move your talents to the platform of the longer term
- Covers the real flooring with no going too deep
- Takes a pragmatic and hands-on method of daily tasks
What you’ll learn
- Learn the parts and simple structure of an Exadata computer
- Reduce info move overhead through processing queries within the garage layer
- Examine and take motion on Exadata-specific functionality metrics
- Deploy Hybrid Columnar Compression to minimize garage and I/O wishes
- Create worry-free migrations from current databases into Exadata
- Understand and tackle concerns particular to ERP migrations
Who this publication is for
Oracle Exadata Survival Guide is for the busy company Oracle DBA who has unexpectedly been thrust into the Exadata arena. Readers must have a legitimate grab of conventional Oracle database management, and be ready to benefit new points which are particular to the Exadata equipment.
Read Online or Download Oracle Exadata Survival Guide (Expert's Voice in Oracle) PDF
Best Computer Science books
Programming hugely Parallel Processors discusses uncomplicated recommendations approximately parallel programming and GPU structure. ""Massively parallel"" refers back to the use of a giant variety of processors to accomplish a collection of computations in a coordinated parallel method. The publication information quite a few innovations for developing parallel courses.
Disbursed Computing via Combinatorial Topology describes concepts for reading dispensed algorithms according to award successful combinatorial topology examine. The authors current a pretty good theoretical starting place proper to many genuine platforms reliant on parallelism with unpredictable delays, resembling multicore microprocessors, instant networks, allotted platforms, and web protocols.
"TCP/IP sockets in C# is a superb publication for someone attracted to writing community functions utilizing Microsoft . web frameworks. it's a exact mixture of good written concise textual content and wealthy conscientiously chosen set of operating examples. For the newbie of community programming, it is a solid beginning booklet; nevertheless execs reap the benefits of very good convenient pattern code snippets and fabric on themes like message parsing and asynchronous programming.
Extra resources for Oracle Exadata Survival Guide (Expert's Voice in Oracle)
ORACLE_HOME" echo "ORACLE_SID.... $ORACLE_SID" echo "*************************************************" echo; unset ORATAB unset GOOD_NAME unset I unset SHOW_DB unset selection unset DB_NAME unset OHOME unset ORASID Now that you've how to set the surroundings, the level is decided to create a flash-based disk workforce: [oracle@myexa1db01 dbm1 ~]$ . sid 1 - +ASM1 - /u01/app/11. 2. zero. 3/grid 2 - dbm1 - /u01/app/oracle/product/11. 2. zero. 3/dbhome_1 three - consumer - /u01/app/oracle/product/11. 2. 0/client_1 input choice via # or identify [dbm1]: 1 ******************************************************* ORACLE_BASE... /u01/app/oracle ORACLE_HOME... /u01/app/11. 2. zero. 3/grid ORACLE_SID.... +ASM1 ******************************************************* [oracle@myexa1db01 +ASM1 ~]$ sqlplus / as sysasm SQL*Plus: liberate eleven. 2. zero. three. zero creation on Tue Apr 30 10:11:09 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. fifty nine Chapter four ■ clever Flash Cache attached to: Oracle Database 11g company version free up eleven. 2. zero. three. zero - 64bit construction With the true program Clusters and automated garage administration techniques SYS@+ASM1> col direction layout a45 SYS@+ASM1> pick out course, header_status 2 from v$asm_disk three the place direction like 'o/%/flash%' four / course HEADER_STATU --------------------------------------------- -----------o/192. 168. 10. 5/flash_FD_00_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_01_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_02_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_03_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_04_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_05_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_06_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_07_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_08_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_08_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_10_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_11_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_12_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_13_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_14_myexa1cel01 CANDIDATE o/192. 168. 10. 5/flash_FD_15_myexa1cel01 CANDIDATE sixteen rows chosen. SYS@+ASM1> create diskgroup flash_dg redundancy common 2 disk 'o/%/flash%' three characteristic 'compatible. rdbms' = '11. 2. zero. zero. 0', four 'compatible. asm' = '11. 2. zero. zero. 0', five 'cell. shrewdpermanent. experiment. able' = 'TRUE', 6 'au_size' = '4M' 7 / Diskgroup created. SYS@+ASM1> A flash-based disk workforce is now on hand to be used. reckoning on the redundancy point in use (NORMAL, supplying one reproduction of the knowledge, or excessive, delivering copies of the data), the useable garage for facts may be onehalf to one-third of the entire house on hand. This makes flash-based disk teams significantly smaller than their disk-based opposite numbers. For this instance, do not forget that the complete on hand flash house used to be 264. 75GB. basic redundancy was once designated, so this flash disk team has approximately 132GB on hand. utilizing excessive redundancy, the whole on hand house will be approximately 88GB. 60 Chapter four ■ clever Flash Cache tracking tracking shrewdpermanent Flash Cache at the database servers is especially comparable, and simply as restricted, as tracking clever Scans from them, as just one metric is on the market from V$SYSSTAT that files flash cache job: “cell flash cache learn hits.