Related tags: PLSQL [+], SQL [+], Programming [+], Pocket [+], Language [+], Edition [+], 4th [+], Reference [+], Mastering [+], 10g [+], Web [+], Suite [+], Services [+], RAC [+], Pro [+], PL [+], PHP [+], Grid [+], Development [+], Data [+], Collaboration [+], fundamentals, apress, Performance, Forecasting, DB, Apr, Administration, 1
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming.
This concise guide boils down the most vital PL/SQL information into an accessible summary of:
The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages.
Mastering Oracle SQL
By Sanjay Mishra, Alan Beaulieu
* Publisher: O’Reilly
* Number Of Pages: 321
* Publication Date: 2002-04
* ISBN-10 / ASIN: 0596001290
* ISBN-13 / EAN: 9780596001292
* Binding: Paperback
Publisher: O'Reilly Media, Inc.; 4 edition
Mastering Oracle SQL
By Sanjay Mishra, Alan Beaulieu
* Publisher: O’Reilly
* Number Of Pages: 321
* Publication Date: 2002-04
* ISBN-10 / ASIN: 0596001290
* ISBN-13 / EAN: 9780596001292
* Binding: Paperback
Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC.
Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.
The chapters are written to follow one another logically by introducing topics in the earlier chapters and building on the technology. Thus, it is advised that you read the chapters in order. Even if you have worked with clustered databases, you will certainly find a nugget or two that may be new to you. For the experienced reader, the book also highlights wherever applicable the new features introduced in Oracle 10g.
(more…)
Oracle PL/SQL Language Pocket Reference
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle’s PL/SQL language, including the newest Oracle Database 11g features. It’s a companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming. (more…)
