Guerrilla Oracle: The Succinct Windows Perspective

Are you frustrated by your attempts to learn Oracle or improve your Oracle skills because of the sheer amount of technical documentation you have to wade through? This concise tutorial walks you step-by-step through the process, showing you exactly what you need to know to install, create, and support a successful Oracle 8i or 9i environment with Web capabilities.

download here
http://rapidshare.de/files/5930994/Guerrilla.Oracle-1st-03-Addison.Wesley.rar.html

Sybex Certification Kit CD1 = OCA-OCP Introduction to Oracle9i SQL

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:
* In-depth coverage of official exam objectives
* Practical information on using SQL in a real-world Oracle9i environment
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Writing basic SQL SELECT statements
* Restricting and sorting data
* Displaying data from multiple tables
* Aggregating data using group functions
* Producing readable output with iSQL*Plus
* Creating and managing tables
* Controlling user access


Download Here
http://www.megaupload.com/?d=YXKS506B

Sybex Certification Kit CD2 = OCA-OCP Introduction to Oracle9i SQL

Here's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide
* In-depth coverage of official exam objectives
* Practical information on implementing and managing Oracle9i databases
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Understanding Oracle architecture and its main components
* Identifying DBA administrative tools
* Setting up password file authentications
* Creating and managing Initialization Parameter Files
* Configuring OMF
* Create a database using Oracle Database Configuration Assistant
* Creating a database manually


hear
http://www.megaupload.com/?d=XLXTFIBZ

Sybex Certification Kit CD3 = OCA-OCP Introduction to Oracle9i SQL

Here's the book you need to prepare for Exam 1Z0-032: Oracle9i Database: Fundamentals II.
* In-depth coverage of official exam objectives
* Practical information on implementing and managing Oracle9i databases
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Identifying solutions included with Oracle9i for managing complex networks
* Using Oracle Net Services and client server connections
* Establishing web client connections through Oracle networking products
* Troubleshooting database connections
* Using and configuring the Oracle Shared Server
* Backing up, restoring, and recovering databases
* Configuring the database archiving mode
* Using Recovery Manager (RMAN)
* Loading data into, and transporting data between databases

download hear
http://www.megaupload.com/?d=JRXM2H3O

Sybex Certification Kit CD4 - Oracle9i Database Performance Tuning

Book Description
Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning.
This Study Guide provides:
* In-depth coverage of official exam objectives
* Practical information on optimizing Oracle9i databases
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Using Diagnostic and Tuning Tools
* Monitoring and Managing the Buffer Cache
* Optimizing Sort Operations
* Detecting and Resolving Lock Contention
* Diagnosing Shared Server Performance Issues
* Using Oracle Blocks Efficiently
* Tuning SQL Statements
* Configuring Resource Manager

Download Here
http://www.megaupload.com/?d=7CGZLQQH

Mastering Oracle SQL by Oreilly

If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.
This book shows you how to:
Leverage Oracle's vast library of built-in SQL functions
Query time-based data, and write joins involving date and time ranges
Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format
Use DECODE and CASE to implement conditional logic in your queries
Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
Join data from two or more tables using the newly supported SQL92 join syntax

Download Here
http://www.megaupload.com/?d=WMSCT1OS

In addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.

Precious few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that, showing you how to creatively leverage the full power of SQL to write queries in an Oracle environment.

Oracle 9i - The Complete Reference

Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. This volume explains how to implement all the components of Oracle9i.

This is a must-have reference for all Oracle professionals.

Download Here

http://www.megaupload.com/?d=YTJMYU1U
Size - 17.76 MB

Oracle PL SQL Programming 4th Edition - O'Reilly

For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.



The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Download Here
http://www.megaupload.com/?d=LIYQQU3F
Password: http://www.blueportal.org

Professional Oracle Programming - Wiley

# One of the only Oracle books to focus exclusively on database programming rather than administration
# Oracle owns sixty percent of the commercial database market
# Provides full coverage of the latest Oracle version, 10g-including new features such as regular expressions and the MODEL SQL clause-as well as versions 8, 8i, and 9i


# The authors are well-known as Oracle gurus-Greenwald is the author of Oracle in a Nutshell and the coauthor, with Stackowiak, of Oracle 9 Essentials
# Shows how to use Oracle data and data structures to build robust, scalable database applications using Java, SQL, and PL/SQL

Download Here
http://www.megaupload.com/?d=UY5RE7RY
Password: http://www.blueportal.org

Oracle DBA Made Simple: Oracle Database Administration Techniques

Oracle Dba Made Simple: Oracle Database Administration Techniques (Oracle In-Focus Series)
Mike Ault
ISBN: 097407165X
Publisher: Rampant Tech Press - 2003-08

Download Here
http://www.megaupload.com/?d=ECP0SZBW
Password : www.blueportal.org

Oracle Space Management Handbook

Author: Don Burleson (Editor)
ISBN: 0974435503
Publisher: Rampant TechPress - August 2003



Download Here

http://www.megaupload.com/?d=25CJY4PW
Password : www.blueportal.org

Oracle Index Management Secrets: Top Oracle Experts Discuss Index Management Tec

Author: Donald K. Burleson Jonathan Lewis Lisa Fernandez Daniel Liu Mike Hordilla
ISBN: 0974071692
Publisher: Rampant TechPress - January 2003



Download Here
http://www.megaupload.com/?d=8R59TJFI
Password : www.blueportal.org

Oracle SQL Internals Handbook

Author: Don Burleson (Editor)
ISBN: 0974435511
Publisher: Rampant TechPress - August 2003



Download Here
http://www.megaupload.com/?d=X2UOKSR8
Password : www.blueportal.org

VTC Oracle Performance Tuning 1Z0-033 Tutorials Video Training

VTC Oracle Performance Tuning 1Z0-033 Tutorials

Title:Oracle: Performance Tuning (1Z0-033) Author:Gavin Powell Sku:33582 ISBN:1-932808-34-5 Duration:11 hrs / 194 lessons Compatibility:Win XP, 2000, 98, NT, Mac OS X, OS 9
Introduction Welcome
Prerequisites for this Course
About this Course pt. 1
About this Course pt. 2
Oracle Tuning Documentation

What is Performance Tuning?
Who Tunes and What Do They Tune?
The Different Stages of Tuning
Development/Testing/Production
Statistics and Performance Evaluation
Goal Oriented Tuning
Common Problems pt. 1
Common Problems pt. 2
Performance Versus Integrity
Oracle Enterprise Manager (OEM)


Performance Tools
The Alert Log
Process Trace Files
User Trace Files
Setting Up Tracing
TKPROF
Manually Collecting Statistics
STATSPACK and Collecting Statistics
Collecting Statistics in OEM
Introducing the Wait Event Interface
What to Tune

Tuning the Shared Pool
The Shared Pool
Shared Pool Efficiency
Shared Pool and Reserved Shared Pool
Library and Dictionary Cache Hit Ratios
Pinning Objects in the Shared Pool
The Large Pool
Caching Cursors
OEM and the Shared Pool
Performance Views

The Database Buffer Cache
Database Buffer Cache Efficiency
OLTP Versus Data Warehouse
Configure the Database Buffer Cache
Examine the Database Buffer Cache
The Buffer Cache Hit Ratio
Processes and the Buffer Cache
How to Tune Buffer Cache
How Else to Tune Buffer Cache
Free List Contention
Multiple Database Writers and Slaves
Monitor Buffer Cache and Subset Pools
OEM and the Database Buffer Cache
Performance and Metadata Views

Other Buffers
Tuning the Redo Log Buffer
Sizing the Redo Log Buffer
The Java Pool
Configuring Automatic PGA Memory
Configuring Manual PGA Memory
Tuning PGA Memory
Changing SGA Memory Online
SGA_MAX_SIZE
Changing Non SGA Memory Online
Performance Views

Tuning I/O: Physical File Structures
Datafiles/Tablespaces/Objects
Control Files and Recoverability
Distribution of Database Files
Dividing Data Across Tablespaces
Oracle Partitioning
Tablespace Storage Structures
Dictionary Managed Tablespaces
Locally Managed Tablespaces
Finding Tablespace Problems
Redo and Archive Log Files pt. 1
Redo and Archive Log Files pt. 2
Physical Structures in OEM
Performance Views
Metadata Views

Tuning I/O at the Block Level
Segments
Extents and Blocks
The High Water Mark
Reclaiming Unused Space
Row Chaining and Row Migration
Reorganizing Indexes
Detecting Problems With Indexes
Metadata Views

Read more to download


Part 1
http://rapidshare.de/files/10468368/VTC_-_Oracle_Performance_Tuning_1Z0-033_Tutorials.part1.rar

part 2
http://rapidshare.de/files/10467988/VTC_-_Oracle_Performance_Tuning_1Z0-033_Tutorials.part2.rar

Part3
http://rapidshare.de/files/10473951/VTC_-_Oracle_Performance_Tuning_1Z0-033_Tutorials.part3.rar

Part4
http://rapidshare.de/files/10470428/VTC_-_Oracle_Performance_Tuning_1Z0-033_Tutorials.part4.rar

Part5
http://rapidshare.de/files/10472098/VTC_-_Oracle_Performance_Tuning_1Z0-033_Tutorials.part5.rar

Oracle Real Application Clusters - Digital Press

Clustered configuration first hit the scene nearly 20 years ago when Digital Equipment Corporation (DEC) introduced the VaxCluster. Until now, the topic of Real Application Clusters (RAC) implementation had never been fully explored. For the first time, Murali Vallath dissects RAC mysteries in his book Oracle Real Application Clusters to enlighten and educate readers on the internals of RAC operations, cache fusion, fusion recovery processes and the fast reconfiguration of RAC.
This book provides comprehensive coverage of the features, technology and principles of RAC that is part of the Oracle9i release of Oracle's RDBMS product. It is divided into three main parts: application/database design, development and maintenance life cycles.
Compared to its predecessor OPS, the architecture behind RAC implementation have changed significantly. Vallath discusses Oracle9i features in a RAC implementation with respect to usage and design considerations, as well as those parameters that are and are not applicable. Areas covered include partitioning, indexes, tablespace management, transaction management, backup and recovery principles. Performance tuning with examples, troubleshooting and problem solving scenarios are covered in detail, as well as discussions on the migration process from a single instance database to RAC and migration from an OPS implementation to RAC.

Download Here
http://rapidshare.de/files/11374865/Oracle_Real_Application_Clusters_-_Digital_Press.rar.html


Password: www.blueportal.org

Expert Oracle Database Architecture

Thomas Kyte, "Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions", Apress | ISBN 1590595300 | 2005 Year | PDF | ~3 Mb | 768 Pages


This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Expert Oracle Database Architecture is the first of a three-book series that completely explores and defines the Oracle database. It covers all of the most important Oracle architecture features, including:
Files, memory structures and processes
Locking and latching
Transactions, concurrency and multi-versioning
Tables and Indexes
Datatypes
Partitioning and parallelism

Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book.

Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focuses solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you.

In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

http://rapidshare.de/files/12571529/Expert_Oracle_Database_Architecture.rar.html

Expert Oracle Database 10g Administration

Sam R. Alapati, "Expert Oracle Database 10g Administration", Apress | ISBN 1590594517 | 2005 Year | PDF | ~7 Mb | 1304 Pages

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples--not just "showcase" examples.

This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle DBA needs to build and admisiter complex Oracle 10g databases.

http://rapidshare.de/files/12565911/Expert_Oracle_Database_10g_Administration.rar.html

Oracle SQL Jumpstart with Examples - Digital Press

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database
* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them as developers and database administrators

Download Here
http://rapidshare.de/files/12845966/Oracle_SQL_Jumpstart_with_Examples_-_Digital_Press.rar.html

Password: www.blueportal.org

test

test