Oracle Database 10g DBA Handbook

Oracle Database 10g DBA Handbook
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 737
Release: 2005-04-14
Genre: Computers
ISBN: 0071770437

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Oracle Database 10g The Complete Reference

Oracle Database 10g The Complete Reference
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 1393
Release: 2004-09-28
Genre: Computers
ISBN: 0071770496

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.

Oracle Data Warehouse Tuning for 10g

Oracle Data Warehouse Tuning for 10g
Author: Gavin JT Powell
Publisher: Elsevier
Total Pages: 499
Release: 2011-04-08
Genre: Computers
ISBN: 008045917X

“This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience. - Tim Donar, Author and Systems Architect for Enterprise Data Warehouses Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ultimate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame. A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. * Takes users beyond basics to critical issues in running most efficient data warehouse applications * Illustrates how to keep data going in and out in the most productive way possible * Focus is placed on Data Warehouse performance tuning

Oracle Database 10g Insider Solutions

Oracle Database 10g Insider Solutions
Author: Arun Kumar
Publisher: Sams Publishing
Total Pages: 0
Release: 2005
Genre: Computers
ISBN: 9780672327919

This book highlights tips, tricks, shortcuts, and best practices for Oracle Database 10g. It assumes the reader has a good working knowledge of the Oracle database and now wants to know the inside tricks to Oracle Database 10g. Written by a trio of Oracle experts with more than 30 years experience, this book is chock full of information and tips that suit the needs of today's DBAs, database architects, and developers who want to make use of the latest and greatest in Oracle Database 10g.

HOWTO Secure and Audit Oracle 10g and 11g

HOWTO Secure and Audit Oracle 10g and 11g
Author: Ron Ben-Natan
Publisher: CRC Press
Total Pages: 460
Release: 2009-03-10
Genre: Business & Economics
ISBN: 1420084135

This guide demonstrates how to secure sensitive data and comply with internal and external audit regulations using Oracle 10g and 11g. It provides the hands-on guidance required to understand the complex options provided by Oracle and the know-how to choose the best option for a particular case. The book presents specific sequences of actions that should be taken to enable, configure, or administer security-related features. It includes best practices in securing Oracle and on Oracle security options and products. By providing specific instructions and examples this book bridges the gap between the individuals who install and configure a security feature and those who secure and audit it.

Oracle 10g Developer

Oracle 10g Developer
Author: Joan Casteel
Publisher: Course Technology Ptr
Total Pages: 508
Release: 2007
Genre: Computers
ISBN: 9781423901365

Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. With real-world examples and a straightforward writing style, this is a valuable resource for anyone preparing for the new Oracle Certification exam, or simply looking to master the PL/SQL programming language with Oracle.

OCA: Oracle 10g Administration I Study Guide

OCA: Oracle 10g Administration I Study Guide
Author: Chip Dawes
Publisher: John Wiley & Sons
Total Pages: 670
Release: 2006-02-20
Genre: Computers
ISBN: 0782150756

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

Oracle Database 10g New Features

Oracle Database 10g New Features
Author: Mike Ault
Publisher: Rampant TechPress
Total Pages: 556
Release: 2003
Genre: Computers
ISBN: 9780974071602

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

Oracle Database 10g: A Beginner's Guide

Oracle Database 10g: A Beginner's Guide
Author: Ian Abramson
Publisher: McGraw Hill Professional
Total Pages: 417
Release: 2004-04-21
Genre: Computers
ISBN: 0071706771

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux
Author: Julian Dyke
Publisher: Apress
Total Pages: 828
Release: 2011-01-11
Genre: Computers
ISBN: 1430229594

Pro Oracle Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle’s industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You’ll learn to troubleshoot performance and other problems. You’ll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation. RAC is a complex and powerful technology. It demands expertise in its deployment. You can’t just “wing it” in creating a RAC solution. Julian and Steve have earned the right to term themselves expert—in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. Rigorous and technically accurate content Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting Up-to-date with the very latest RAC features