Oracle 10g Data Warehousing:

Oracle 10g Data Warehousing

Book Description

New edition of successful book with Oracle employees and consultants as authors.

to download follow the link below:

http://rapidshare.com/files/260799230/oracle-10g-data-warehousing.pdf

Read more...

Oracle Performance Tuning for 10gR2, Second Edition:

Oracle Performance Tuning for 10gR2, Second Edition

Product Description

Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.

Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.

* Fully updated for version 10gR2 and provides all necessary transition material from version 9i

* Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning

* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective

to download follow the link below:

http://rapidshare.com/files/260799300/oracle-performance-tuning-for-10gr2-second-edition.pdf

Read more...

Oracle 10g RAC Grid, Services & Clustering:

Oracle 10g RAC Grid, Services & Clustering

Product Description

Grid architecture is Oracle’s 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 nodeconfiguration.

* Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database

version 10g Release 2

* Provides extensive coverage of usage, day-to-day functions and operations

* Includes tips and techniques such as script samples

to illustrate various features of RAC

* A jumpstart into all the key features of 10g R2 RAC

to download follow the link below:

http://rapidshare.com/files/260799229/oracle-10g-rac-grid-services-clustering.pdf

Read more...

Oracle 10g/11g Data and Database Management Utilities:

Oracle 10g/11g Data and Database ManagementUtilities

Product Description

Master twelve must-use utilities to optimize the efficiency, management, and performance of your daily database tasks

• Optimize time-consuming tasks efficiently using the Oracle database utilities
• Perform data loads on the fly and replace the functionality of the old export and import utilities using Data Pump orSQL*Loader

• Boost database defenses with Oracle Wallet Manager and Security
• A handbook with lots of practical content with real-life scenarios

to download follow the link below:

http://rapidshare.com/files/255159232/Orac10g_data.rar

Read more...

Oracle Database 10g: The Complete Reference:

The Ultimate Resource on Oracle Database 10g

Get thorough coverage of Oracle Database 10g from the most comprehensive reference available, published by Oracle Press. With in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. You’ll also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics.

• Install Oracle Database 10g or upgrade from an earlier version
• Execute SQL queries
• Perform complex searches easily with regular expression functions
• Implement security measures using Virtual Private Databases (VPDs)
• Move data with SQL*Loader and Data Pump
• Replicate data and aggregations using materialized views
• Execute flashback queries to recover data or see its changes over time
• Create triggers, stored procedures, and packages with PL/SQL
• Develop applications with JDBC and XML
• Work with Oracle Database 10g Real Application Clusters (RAC) and grid technologies
• Take advantage of the new tuning features

CD-ROM includes a searchable electronic book and all code examples from the book.

About the Author: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine’s Editors’ Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups.

to download follow the link below:

http://rapidshare.com/files/159476534/McGrawHill.Oracle.Database.10G.The.Complete.Reference.2004.ISBN0596006217.pdf

Read more...