OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

Book Description
Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years, this book provides:

• Clear and concise information on advanced database administration with Oracle 10g
• Practical examples and insights drawn from the authors' real-world experiences
• Leading-edge exam preparation software, including a test engine and electronic flashcards

You'll also find authoritative coverage of key exam topics, including:

• Configuring Recovery Manager
• Understanding the Flashback Database
• Recovering from User Errors
• Working with Globalization Support
• Using the Scheduler to Automate Tasks
• Monitoring and Managing Storage
• Securing the Oracle Listener

Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace.

Buy this book

OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

I found the following download link and you can make use of it.

Download

Related Book

OCA: Oracle 10g Administration I Study Guide (1Z0-042)

Oracle9i: The Complete Reference

Book Description
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. This is a must-have reference for all Oracle professionals.

Book Info
Master all the powerful features of Oracle9i using the exclusive information inside this indispensable resource. Written by best-selling Oracle Press authors Kevin Loney and George Koch, this volume explains how to implement all the components of Oracle9i. A must-have for all Oracle professionals. Softcover. CD-ROM included.

Buy this book

Oracle9i: The Complete Reference

I found the following download link and you can make use of it.

Download

Related Book

Oracle9i DBA Handbook

Oracle Database 10g: The Complete reference

Book Description
Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

From the Back Cover

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.

Buy this book

Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)

I found the following download link and you can make use of it.

Download

Related Book

Oracle Database 10g DBA Handbook

OCA: Oracle 10g Administration Study Guide (1Z0-042)

Book Description
Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides:

• Clear and concise information on database administration with Oracle 10g
• Practical examples and insights drawn from the authors' real-world experiences
• Leading-edge exam preparation software, including a test engine and electronic flashcards

You'll also find authoritative coverage of key exam topics, including:

• Installing Oracle Database 10g Software
• Creating and Controlling Oracle Databases
• Administering Users
• Managing Schema Objects and Data
• Implementing Oracle Security Features
• Monitoring Performance
• Performing Database Backup and Recovery

Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace

Buy this book

OCA: Oracle 10g Administration I Study Guide (1Z0-042)

I found the following download link and you can make use of it

DOWNLOAD

Related Book

Oracle Database 10g OCP Certification All-In-One Exam Guide (Oracle Database 10g Handbook)

Oracle Database Foundations

Book Description
The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor.

Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include:

• Basic relational database concepts
• Reporting and querying using SQL*Plus and iSQL*Plus
• Creating and maintaining a database
• Managing user access and security
• Understanding Oracle database functions
• Using multiple tables in a query
• Restricting, sorting, and grouping data
• Optimizing database performance
• Creating backups
• Troubleshooting database errors

Buy this book

Oracle Database Foundations: Technology Fundamentals for IT Success

I found the following download link and you can make use of it

DOWNLOAD

Related Book

UNIX for Dummies

Oracle Index Management Secrets, Top Oracle Experts Discuss Index Management Techniques

This free Oracle ebook utilizes their substantial knowledge of Oracle indexing with combined experience; the world's best authors share their secrets for using Oracle indexes to turbocharge Oracle SQL execution speed. Not for beginners, this is an advanced guide for the senior Oracle DBA and dives far into the internal mechanisms of Oracle indexing.

This free ebook explained how to monitor and optimize Oracle index structures, how to automate index rebuilding, and the internal structures of Oracle indexes. Key Features, Learn to monitor index usage, Understand Oracle index internal structures, and Explore bitmap indexes, Automate index rebuilds, understand multi level index partitioning, Learn why database blocksize is critical for Oracle indexes, Explore Oracle index tree structures.

I found the following download link and you can make use of it

DOWNLOAD

Guerrilla Oracle: The Succinct Windows Perspective

Book Info
An introduction to the overall features of Oracle. At the end the reader will have developed a fully functional database, and will have a solid, well-rounded grasp of Oracle. Gets the reader up and running with Oracle quickly. Softcover.

From the Back Cover

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.

Guerrilla Oracle®: The Succinct Windows Perspective presents clear explanations of database, SQL, and Oracle fundamentals. Using a real-world, large-scale example to demonstrate essential tasks, the book follows the Oracle DBMS life cycle from business idea to functioning database.

Guerrilla Oracle® gives you the foundation you need to build a functioning system and to begin exploring more complex technical topics. Along with a deeper understanding of the Oracle DBMS, you will learn the concrete skills, strategies, and techniques you need to make your database a reality.

You will learn how to:

• Install and configure the Oracle Database server on a Windows server
• Configure client PCs
• Install and define the Oracle Database software
• Create basic database security schemas and formalize backup plans
• Design a database and normalize the data
• Integrate a legacy system into the Oracle relational database model using SQL*Loader
• Create the tables
• Develop and modify Oracle Forms and Reports
• Program in SQL, SQL*Plus, and PL/SQL
• Perform major DBA responsibilities
• Enable remote access
• Prepare your database for Web access and e-commerce

The accompanying CD-ROM includes a complete set of the book's code samples, scripts, and examples.

Buy this book
Guerrilla Oracle: The Succinct Windows Perspective

I found the following download link and you can make use of it

DOWNLOAD

Oracle DBA Guide to Data Warehousing and Star Schemas

From the Back Cover

• The definitive, real-world guide to Oracle data warehousing
• Maximizing performance, flexibility, and manageability in production environments
• Hardware/software architectures, star schema design, partitioning, and more
• Industrial strength data loading and query optimization techniques
• By the world-renowned architect of 7-Eleven's multi-terabyte datawarehouse

Maximize Oracle data warehouse performance, flexibility, and manageability

Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment. Coverage includes:

• Data warehousing fundamentals for DBAs--including what a data warehouse isn't
• Planning software architecture: business intelligence, user interfaces, Oracle versions, OS platforms, and more
• Planning hardware architecture: CPUs, memory, disk space, and configuration
• Radically different star schema design for radically improved performance
• Tuning ad-hoc queries for lightning speed Industrial-strength data loading techniques
• Aggregate tables: maximizing performance benefits, minimizing complexity tradeoffs
• Improving manageability: The right ways to partition
• Data warehouse administration: Backup/recovery, space and extent management, updates, patches, and more

About the Author

BERT SCALZO is a product architect for Quest Software. As a member ofthe TOAD development team, he designed many of the features in the TOADDBA module. Scalzo has presented numerous papers on data warehousing andled or served on data warehouse special interest groups at Oracle eventsthroughout the past five years. He has worked for both Oracle Educationand Oracle Consulting, holds several Oracle Masters, a Ph.D. in ComputerScience, an MBA, and several insurance industry designations. Scalzodesigned 7-Eleven's multi-terabyte, star-schema data warehouse. He isauthor of The TOAD Handbook.

Buy this book

Oracle DBA Guide to Data Warehousing and Star Schemas (Prentice Hall PTR Oracle Series)

I found the following download link and you can make use of it

DOWNLOAD

Related Book

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin

Cost-Based Oracle Fundamentals

Book Description

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columnsand the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. Youll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.

The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

In Cost-Based Oracle Fundamentals, the first book in a series of three, Jonathan Lewisone of the foremost authorities in this fielddescribes the most commonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, youll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.

About the Author
Jonathan Lewis has been involved in database work for more than 19 years, specializing in Oracle for the last 16 years and working as a consultant for the last 12 years. Jonathan is currently a director of the UK Oracle User Group (UKOUG) and is well known for his many presentations at the UKOUG conferences and SIGs. He is also renowned for his tutorials and seminars about the Oracle database engine, which he has held in various countries around the world.

Jonathan authored the acclaimed book Practical Oracle 8i (Addison-Wesley, 2001), and he writes regularly for the UKOUG magazine and occasionally for other publications, including OTN and DBAZine. He also finds time occasionally to publish Oracle-related material on his website.

Buy this book

Cost-Based Oracle Fundamentals

I found the following download link and you can make use of it

DOWNLOAD

Related Book

Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions

Oracle Applications DBA Field Guide

Book Description

Administrators and managers as well as more advanced users will find plenty of hard facts for administering Oracle Applications in a work environment, but it's also quite portable and not the weighty tome you'd expect from such a survey.

— Midwest Book Review, California Bookwatch

Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux serversall in an easy reading and quick-to-navigate format.

Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Applications Release 12 and Fusion.

About the Author
Paul Jackson has over 10 years' experience as a developer and Oracle DBA. Paul is the Program Director for the ATS SIG. He is a very active member of the Oracle community through memberships of Ohio Valley Oracle Applications User Group (OVOAUG), International Oracle User Group (IOUG), and the Oracle RAC SIG. Elke Phelps is an Oracle Certified Professional with over 12 years' experience administering Oracle products. She is the Founder and presiding President of the Oracle Applications User Group's Middleware SIG--formerly the ATS SIG--and is responsible for conducting meetings at the annual OAUG and Oracle Open World conferences. This yields a unique medium for access to the Oracle Applications users and provides name recognition in the user community. Elke is the author of several whitepapers and is a technical presenter at many international conferences.

Buy this book

Oracle Applications DBA Field Guide

I found the following download link and you can make use of it

DOWNLOAD

Related Book

Oracle E-Business Suite Financials Handbook (Osborne ORACLE Press Series)

Expert Oracle JDBC Programming

Book Description

With Oracle in the process of de-supporting SQLJ, JDBC is now really the only recommended means of interfacing between Java and Oracle. Consequently, this book is a must have for any developer building an Oracle Java application.

Many Java developers tend to treat Oracle as a "black box"; as a consequence, developers tend to write incorrect, non-scalable code. If you don't intimately know how Oracle works and expects you to program, you might avoid Oracle extensions to the standard for fear of your code becoming database-dependent. If you give in to that fear, you'll miss out on the extensive out-of-the-box functionality that Oracle offers. This book teaches you how to build efficient, high-performance, and robust Oracle-based JDBC applications. You'll discover the full details of Oracle's implementation of the JDBC 3.0 standard (what it supports, what it doesn't and what extensions Oracle provides), and more.

This book tackles issues head-on, detailing concisely and clearly the vital details of Oracle's architecture and mode of operation that directly impact the manner in which JDBC applications should be written. Only when armed with this knowledge, a willingness to exploit the database to its full potential in your JDBC code, and the ability to use Oracle's SQL and PL/SQL features when appropriate, is it possible to write truly efficient, robust, scalable and high performance applications.

About the Author
R.M. Menon has worked with Oracle database for over eleven years, eight of which have been at Oracle Corporation. Menon works as a Project Lead in the core technology division of Oracle. For the past five years, Menon has used JDBC and other J2EE technologies extensively as part of his work. He believes in the philosophy of proving all assertions, and has strived to follow this philosophy rigorously in his book. When he is not doing research on Oracle, Menon learns Indian classical vocal music and performs at local cultural events as a singer. Occasionally, he also dabbles in sketching portraits, and drawing paintings and cartoons.

Buy this book

Expert Oracle JDBC Programming

I found the following download link and you can make use of it

DOWNLOAD

Related Book

Oracle Database Programming Using Java and Web Services

Oracle Data Warehousing and Business Intelligence Solutions

Book Description

Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations.

From the Back Cover
Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools

Data warehouses are the core technology that businesses use to capture, store, and analyze vast amounts of business data, and Oracle has emerged as the leading database platform. Its business intelligence tools make it considerably easier to analyze data to support marketing, sales, and other initiatives. Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools.

You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations.

Serving as a single reference that aims to help you avoid many common pitfalls while gaining professional success, Oracle Data Warehousing shares best practices for:

• Leveraging Oracle technologies to design, build, and manage data warehouses
• Integrating specific database and business intelligence solutions from other vendors
• Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more
• Handling typical data warehouse performance challenges
• Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk

The companion Web site contains all the same code used throughout the book, plus links to related sites.

Wiley Technology Publishing Timely. Practical. Reliable.

Buy this book

Oracle Data Warehousing and Business Intelligence Solutions

I found the following download link and you can make use of it

DOWNLOAD

Related Book

Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

The Oracle Hacker's Handbook: Hacking and Defending Oracle

Book Description
David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

From the Back Cover
Knowledge is power, and the power can be yours

While Oracle continues to improve the security features of its product, it still has a long way to go. David Litchfield has devoted years to relentlessly searching out the flaws in this ubiquitous database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems.

Like The Shellcoder's Handbook and The Database Hacker's Handbook, this in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle. It shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

• Discover how to deal with the security flaws revealed in the Oracle RDBMS
• Explore some never-before-published forays into Oracle security holes and learn to defend them from attack
• Learn why independent security assessments are not necessarily a guarantee of safety
• See how Oracle 10g Release 2 has improved its security features and where the flaws remain

Buy this book

The Oracle Hacker's Handbook: Hacking and Defending Oracle


I found the following download link and you can make use of it

DOWNLOAD

Related Book

The Database Hacker's Handbook: Defending Database Servers

Relational Database Index Design and the Optimizers, DB2, Oracle, SQL Server

Book Description
Improve the performance of relational databases with indexes designed for today's hardware

Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. Unfortunately, the reality is that the improved hardware hasn't kept pace with the ever-increasing quantity of data processed today. Although disk packing densities have increased enormously, making storage costs extremely low and sequential read very fast, random reads are still painfully slow. Many of the old design recommendations are therefore no longer valid-the optimal point of indexing has come a long way. Consequently many of the old problems haven't actually gone away-they have simply changed their appearance.

This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design.

This book is intended for anyone who wants to understand the issues of SQL performance or how to design tables and indexes effectively. With this title, readers with many years of experience of relational systems will be able to better grasp the implications that have been brought into play by the introduction of new hardware.

An Instructor's Manual presenting detailed solutions to all the problems in the book is available online from the Wiley editorial department.

An Instructor Support FTP site is also available.

Buy this book

Relational Database Index Design and the Optimizers

I found the following download link and you can make use of it

DOWNLOAD

Related Book

Applied Mathematics for Database Professionals (Expert's Voice)

Forecasting Oracle Performance

Book Description

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place.

Application over mathematical proofs…

If you’re an IT practioner who appreciates application over mathematical proofs than you’ll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda.

A practical and hands-on training course in a book…

This book is a kind of training course. After reading, studying, and practicing the material covered in this book, you to be able to confidently, responsibly, and professionally forecast performance and system capacity in a wide variety of real-life situations.

How to avoid being on the Wall Street Journal’s front page…

If you are more management minded (or want to be) you will be delighted with the service level management focus. Forecasting makes good business sense because it maximizes the return on IT investment and minimizes unplanned down time. To those who think forecasting is a waste of money. Well…obviously they’ve never been on the evening news because their company lost millions of dollars in revenue and brand destruction because of poorly performing or unavailable systems.

It’s about equipping you…

Without a doubt you will be equipped to deal with the realities of forecasting Oracle performance. But this book gives you more. Not only will you receive a technical and mathematical perspective, but also a communication, a presentation, and a management perspective. This is career building stuff and immensely satisfying!

What you’ll learn

This book is a “how to” book filled with examples to transform theory and mathematics into something you can practically apply. You will learn how to use a variety of forecasting models, which will enable you to methodically:

• Help manage service levels from a business value perspective,
• Identify the risk of over utilized resources,
• Predict what component of an architecture is at risk,
• Predict when a system will be at risk,
• Develop multiple risk mitigating strategies to ensure service levels are
• maintained
• Characterize a complex Oracle workload.

Who is this book for?

I.T. professionals who must ensure their production Oracle systems are meeting service levels, in part, through forecasting performance, identifying risk, and developing solutions to ensure systems are available without wasting budget. Readers include database administrators, I.T. managers, developers, capacity planners, systems architects, systems integrators.

About the Author
Craig Shallahamer has over 18 years of experience working in Oracle--empowering others to maximize their Oracle investment, efficiencies, and performance. In addition to being a consultant, researcher, writer, and keynote speaker at Oracle conferences, he is the designer and developer of OraPub's Advanced Reactive Performance Management and Forecasting Oracle Performance classes. He is also the architect of HoriZone, OraPub's service-level management product.


Buy this book

Forecasting Oracle Performance


I found the following download link and you can make use of it

DOWNLOAD

Related Book

Applied Mathematics for Database Professionals (Expert's Voice)