Oracle-Books.com | |
Home > DBA > Administration | |
Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard
By: Scott Jesse, Bill Burton, Bryan Vongray Hardcover - 1308 pages (April 14, 2011) McGraw-Hill Osborne Media Written by Oracle insiders, Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC, and Data Guard teaches you how to use the latest high availability (HA) products and features in Oracle Database 11g Release 2 to build practical and cost-effective solutions. Based on a DBA-centric approach and providing a conceptual understanding of each topic, the book includes “HA Workshops”—step-by-step instructions to walk you through specific implementatio ns that are inspired by real-world case studies. This Oracle Press guide concentrates on explaining Oracle Database 11g technologies and practices to database administrators, covering general availability, real application clusters (RAC), disaster planning and recovery. You will learn how to implement an effective HA solution that addresses both unplanned and planned causes of downtime and achieve a truly fault-tolerant infrastructure. |
|
Achieving Extreme Performance with Oracle Exadata
By: Rick Greenwald, Robert Stackowiak, Maqsood Alam, Mans Bhuller Paperback: 432 pages (February 11, 2011) McGraw-Hill Osborne Media (Oracle Press) Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and m igration are included in this authoritative resource. |
|
Achieving Extreme Performance with Oracle Exadata [Kindle Edition]
By: Rick Greenwald, Robert Stackowiak, Maqsood Alam, Mans Bhuller Electronic: 432 pages (February 11, 2011) McGraw-Hill Osborne Media (Oracle Press) Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and m igration are included in this authoritative resource. |
|
Pro Oracle Database 11g Administration (Expert's Voice in Oracle)
By: Darl Kuhn Paperback: 720 pages (December 29, 2010) Apress Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle DBA. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won't leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn't about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have “buck stops here” responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself t o the level of Professional Oracle Database Administrator. |
|
Pro Oracle Database 11g RAC on Linux
By: Martin Bach, Steve Shaw Paperback: 840 pages (September 30, 2010) Apress 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 feat ures 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 perform ance 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. |
|
Oracle Database Administration for Microsoft SQL Server DBAs
By: Michelle Malcher Paperback: 352 pages (September 1, 2010) McGraw-Hill Osborne Media (Oracle Press) Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. |
|
Oracle Database Administration for Microsoft SQL Server DBAs [Kindle Edition]
By: Michelle Malcher Electronic: 352 pages (September 1, 2010) McGraw-Hill Osborne Media (Oracle Press) Use your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. |
|
Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions
By: Thomas Kyte Paperback: 832 pages (July 26, 2010) Apress Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. 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'll find that there are few information managem ent problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. 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. |
|
Oracle Database 11g - Underground Advice for Database Administrators
By: April Sims Paperback: 348 pages (April 8, 2010) Packt Publishing Today DBAs are expected to deploy and manage large databases with quality service and little to no downtime. The DBA's main focus is on increasing productivity and eliminating idle redundancy throughout the enterprise. However, there is no magic set of best practices or hard and fast rules that DBAs need to follow, and this can make life difficult. But if DBAs follow some basic approaches and best practices, tasks can be performed more efficiently and effectively. This survival guide offers pre viously unwritten underground advice for DBAs. The author provides extensive information to illuminate where you fit in, and runs through many of the tasks that you need to be watchful of, extensively covering solutions to the most common problems encountered by newcomers to the world of Oracle databases. The book will quickly introduce you to your job responsibilities, as well as the skills, and abilities needed to be successful as a DBA. It will show you how to overcome common problems and pr oactively prevent disasters by implementing distributed grid computing-scalable and robust-with the ability to redeploy or rearchitect when business needs change. Reduce downtime across your enterprise by standardizing hardware, software, tools, utilities, commands, and architectural components. |
|
Oracle PL/SQL: Expert Techniques For Developers and Database Administrators [Kindle Edition]
By: Lakshman Bulusu Electronic: 352 pages (February 17, 2010) Charles River Media Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to O LAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, suc h as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards tha t can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book. |
|
Expert Oracle Practices: Oracle Database Administration from the Oak Table
By: Pete Finnigan, Alex Gorbachev, Randolf Geist, Tim Gorman, Connie Green, Charles Hooper, ... Paperback: 592 pages (January 20, 2010) Apress This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company's investment in Oracle Database technologies. You'll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than lettin g it manage you. |
|
Expert Oracle Practices: Oracle Database Administration from the Oak Table [Kindle Edition]
By: Pete Finnigan, Alex Gorbachev, Randolf Geist, Tim Gorman, Connie Green, Charles Hooper, ... Electroni: 592 pages (January 20, 2010) Apress This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company's investment in Oracle Database technologies. You'll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than lettin g it manage you. |
|
Oracle Database 11g: The Complete Reference
By: Kevin Loney Hardcover: 1656 pages (December 16, 2008) McGraw-Hill Osborne Media (Oracle Press) Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in the most comprehensive reference available. Starting by establishing critical database concepts and with in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology. The Complete Reference covers SQL, SQL Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java p rogramming in the Oracle environment. The book includes valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics. All code from the book will be available for download. |
|
Beginning Oracle Database 11g Administration: From Novice to Professional (Beginning from Novice to Professional)
By: Iggy Fernandez Paperback: 400 pages (December 15, 2008) Apress Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success. |
|
Oracle 11g Grid & Real Application Clusters: Oracle 11g Grid Computing with RAC
By: Mike Ault, Madhu Tumma, Byran Jones, Steve Karam Hardback: 700 pages (December 1, 2008) Rampant Techpress Covering all areas of Oracle Grid computing, this guide is indispensable for any Oracle DBA who is charged with configuring and implementing Oracle 11g Grid with server blades. This comprehensive manual presents a complete method for the installation, configuration and design of Oracle Grid and 11g RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. Also demonstrated is the use of Oracle Grid using t he Enterprise Manager Grid control utility. |
|
Oracle Utilities: The Definitive Reference
By: Bert Scalzo Paperback: 300 pages (December 1, 2008) Rampant Techpress Targeted toward experienced Oracle professionals who need to perform powerful system-wide operating system on their Oracle databases, this definitive guide includes details on all of the Oracle utilities, including an experts-only section on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. Approaching Oracle Utilities from a functional perspective, this guide adds value by explaining the "why" and "how" for the use of all Oracle Utilities. Additionally, the book also covers Oracle tuning utilities and all areas of Oracle database administration, including ADDM and the SQL tuning advisors and the traditional command-line tuning utilities, as well as secrets for database migration, and detailed tips for using Oracle OS utilities. |
|
OCP Oracle Database 11g: Adminstration II Exam Guide (Exam 1Z0-053)
By: Bob Bryla Paperback: Pages (November 12, 2008) McGraw-Hill Osborne Media (Oracle Press) This Oracle Press certification exam guide offers detailed coverage of all of the official exam objectives on the Oracle Certified Professional Administration II exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. Real-world examples, practice questions, and chapter summaries help certification candidates learn the material. The CD-ROM contains two practice exams and an electronic copy of the book. |
|
Oracle Database 11g: A Beginner's Guide
By: Ian Abramson, Michael Abbey, Michael J Corey Paperback: 512 Pages (November 12, 2008) McGraw-Hill Osborne Media (Oracle Press) This fully revised beginner's guide covers the fundamental concepts of Oracle Database 11g. Through self-paced tutorials, you will learn about database essentials, the role of the administrator, high availability, and large database features. An in-depth introduction to SQL and PL/SQL is also included. Oracle Database 11g: A Beginner's Guide walks you, step-by-step, through database setup, administration, programming, and backup and recovery. A configurable sample database available online prov ides additional support for projects and examples. |
|
Expert Oracle Database 11g Administration
By: Sam R. Alapati Paperback: 1276 Pages (November 10, 2008) Apress A comprehensive handbook for Oracle database administrators (DBAs) using the latest release of the Oracle Database (Oracle Database 11g). All key aspects of database administration are covered, including backup and recovery, day-to-day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Also offers primers on Linux/Unix, data modeling, SQL, and PL/SQL. |
|
Oracle 11g New Features: Get Started Fast with Oracle 11g Enhancements
By: Brian Carr, John Garmany, Lutz Hartmann, V. J. Jain, Steve Karam Paperback: 300 pages (September 1, 2008) Rampant Techpress Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs an d Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager. |
|
OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052) [Kindle Edition]
By: John Watson Electronic: 733 pages (May 19, 2008) McGraw-Hill Osborne Media (Oracle Press) A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration. |
|
OCA Oracle Database 11g: Administration I Exam Guide (Exam 1Z0-052)
By: John Watson Paperback: 733 pages (May 19, 2008) McGraw-Hill Osborne Media (Oracle Press) A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration. |
|
OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050) [Kindle Edition]
By: Sam R. Alapati Electronic: 523 pages (May 4, 2008) McGraw-Hill Osborne Media (Oracle Press) A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion. |
|
OCP Oracle Database 11g: New Features for Administrators Exam Guide (Exam 1Z0-050)
By: Sam R. Alapati Paperback: 523 pages (May 4, 2008) McGraw-Hill Osborne Media (Oracle Press) A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion. |
|
Oracle PL/SQL: Expert Techniques For Developers and Database Administrators
By: Lakshman Bulusu Paperback: 320 pages (April 23, 2008) Charles River Media Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to O LAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, suc h as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards tha t can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book. |
|
Oracle 10g Database Administration Concepts & Implementation Made Simple
By: Asim Abbasi Paperback: 384 pages (March 1, 2008) Takveen The Topics Covered In This Book Are: Visualizing the Complete Oracle Environment, SQL: Structured Query Language, Oracle Database Concepts, Oracle Instance Concepts, Oracle in Action, Complete Oracle System Design: Steps of Implementation, Oracle Database Design, Oracle Network Administration, Oracle Database Management, Oracle Backup & Recovery Techniques, Oracle Performance Tuning. Everything in this book is covered in a step by step manner by first building reader s concept using analogi es, real world examples and then taking him/her to the steps of design implementation. The book covers Oracle 10g Database Administration for both Unix as well as Windows OS. The concepts and most of the stuff discussed in this book are equally good for other Oracle versions including 11g. |
|
Oracle Database 11g DBA Handbook [Kindle Edition]
By: Bob Bryla Electronic: 670 pages (December 6, 2007) McGraw-Hill Osborne Media (Oracle Press) The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more. |
|
Oracle Database 11g DBA Handbook
By: Bob Bryla Paperback: 670 pages (December 6, 2007) McGraw-Hill Osborne Media (Oracle Press) The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more. |
|
Oracle Database 11g: New Features for DBAs and Developers [Kindle Edition]
By: Sam R. Alapati Electronic: 602 pages (November 15, 2007) Apress This is an amazingly comprehensive and detailed book about the new features of the Oracle 11g edition. I'm very surprised that the authors could publish this big a book (over 600 pages) on just the new features of the Oracle 11g database so soon after Oracle Open World in November. |
|
Oracle Database 11g: New Features for DBAs and Developers
By: Sam R. Alapati Paperback: 602 pages (November 15, 2007) Apress This is an amazingly comprehensive and detailed book about the new features of the Oracle 11g edition. I'm very surprised that the authors could publish this big a book (over 600 pages) on just the new features of the Oracle 11g database so soon after Oracle Open World in November. |
|
Oracle Database 11g New Features [Kindle Edition]
By: Robert G. Freeman Electronic: 362 pages (November 5, 2007) McGraw-Hill Osborne Media (Oracle Press) Your Must-Have Guide to Everything New in Oracle Database 11g. Realize the full potential of Oracle Database 11g with help from the experts. Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code sample s, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components. Improved Automated Memory Management capabilities. New database design features, such as virtual columns, tablespace encryption, and true table-level data compression. New Database Advisors for data recovery a nd repair, partitioning, and streams performance. New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer. Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization. Improved auditing and security capabilities. Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements. |
|
Oracle Database 11g New Features
By: Robert G. Freeman Paperback: 362 pages (November 5, 2007) McGraw-Hill Osborne Media (Oracle Press) Your Must-Have Guide to Everything New in Oracle Database 11g. Realize the full potential of Oracle Database 11g with help from the experts. Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code sample s, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components. Improved Automated Memory Management capabilities. New database design features, such as virtual columns, tablespace encryption, and true table-level data compression. New Database Advisors for data recovery a nd repair, partitioning, and streams performance. New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer. Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization. Improved auditing and security capabilities. Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements. |
|
Oracle Essentials: Oracle Database 11g (Essentials)
By: Rick Greenwald, Robert Stackowiak, Jonathan Stern Paperback: 406 pages (November 1, 2007) O'Reilly & Associates The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. Oracle is an enormous system, with myriad technologies, options, and releases. Most users-e ven experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. |
|
Pro Oracle Spatial for Oracle Database 11g [Kindle Edition]
By: Ravikanth V. Kothuri Electronic: 824 pages (October 29, 2007) Apress Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in todays mobile and highly connected world. |
|
Pro Oracle Spatial for Oracle Database 11g
By: Ravikanth V. Kothuri Paperwork: 824 pages (October 29, 2007) Apress Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in todays mobile and highly connected world. |
|
Oracle 9i Database Administration in 10 Minutes
By: Asim Abbasi Paperback: 138 pages (April 28, 2007) Takveen
|
|
Oracle 11i E-Business Suite from the Front Lines [Kindle Edition]
By: April J. Wells Electronic: 504 pages (April 16, 2007) Taylor & Francis Oracle 11i E-Business Suite from the Front Lines is the first book to compile the tips, techniques, and practical advice for administering Oracle E-Business Suite 11i. The author examines Active Directory Utilities, patching, cloning, and the new features that 11i brings to the market. The book benefits those with limited experience with Oracle Application but with more extensive background in Oracle Database Administration. This volume is valuable to systems administrators or DBAs who have expe rience with older versions of Oracle Financials and want to expand their knowledge to include the changes inherent in 11i. |
|
Oracle Internals Tips, Tricks, and Techniques for DBAs [Kindle Edition]
By: Donald K. Burleson Electronic: 896 pages (April 16, 2007) Taylor & Francis This book is a collection of the best most relevant articles published in Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information only available from peers and consultants. Unlike existing tutorials, this book focuses on the truly tough stuff - techniques learned and used in the trenches. |
|
Oracle Internals Tips, Tricks, and Techniques for DBAs
By: Donald K. Burleson Paperback: 896 pages (April 16, 2007) Auerbach This book is a collection of the best most relevant articles published in Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information only available from peers and consultants. Unlike existing tutorials, this book focuses on the truly tough stuff - techniques learned and used in the trenches. |
|
To Become an Oracle DBA in Eighty Days
By: Fly Balloon Paperback: 51 pages (February 16, 2007) Infinity Publishing The book To Become an Oracle DBA in Eighty Days explains the concepts of oracle database using the stories from Jules Verne's novel Around the World in 80 Days: One Oracle Database Architecture Two Oracle Network Configuration 2.1. Client Request 2.2. Network Configuration Files 2.3. Listener Static and Dynamic Register 2.4. Listener Failover and Load Balance Three Database Grid Control 3.1. Grid Control Structure 3.2. Event and Notification 3.3. Scheduled Job Four Backup, Recovery and RMAN 4.1. System Change Number (SCN) 4.2. Online Backup 4.3. Recovery 4.4. Oracle Recovery Manager (RMAN) Five Oracle Real Application Cluster (RAC) 5.1. Physical Structure 5.2. Resource Coordination 5.3. Cache Fusion Six Performance Tuning. |
|
Oracle Database 10g Backup & Recovery
By: Matthew Hart, Robert G. Freeman Paperback: 688 pages (November 1, 2006) McGraw-Hill Osborne Media (Oracle Press) This Oracle Press guide shows you how to take full advantage of RMAN--the robust backup and recovery technology built into Oracle 10g. Oracle Database 10g RMAN Backup & Recovery will serve both as a step-by-step tutorial and an indispensable on-the-job reference that you will refer to again and again. All the latest RMAN features introduced in Oracle Database 10g are covered, including incremental backups, flash recovery area, resetlogs, and much more. |
|
Pro Oracle Collaboration Suite 10g
By: John Watson Paperback: 400 pages (September 25, 2006) Apress OCS is becoming the dominant product for large-scale collaboration--blending core functions of e-mail, file serving, and diary management with the additional functionality of web conferencing, instant messaging, and wireless access. Pro Oracle Collaboration Suite 10g provides all you need to know to install and configure OCS for use, but this book is much more than a to-do list. It covers the architecture of the server processes and the applications, giving you the theoretical background to tak e OCS beyond the basics. There's no need to worry if you're new to the Oracle database, Oracle Components for Java environment (OC4J), HTTP web servers, or LDAP Internet directories--everything is explained carefully. But if you are already familiar with these topics, you'll learn how to fully exploit them in order to optimize your OCS installation. |
|
OCA: Oracle Application Server 10g Administration I Study Guide (Exam# 1Z0-311)
By: Robert J. Bryla, April Wells Paperback: 600 pages (September 12, 2006) Sybex Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam. Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal. The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book |
|
Pro Oracle RAC on Linux: Installation, Administration, and Performance
By: Julian Dyke, Steve Shaw Paperback: 700 pages (August 7, 2006) Apress Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many ot her topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster. |
|
Enterprise Grid Computing with Oracle (10g)
By: Brajesh Goyal, Shilpa Lawande Paperback: 408 pages (August 1, 2006) McGraw-Hill Osborne Media (Oracle Press) Written by the former principal product manager for Grid Computing at Oracle, this is the only book on the market that explains how to take full advantage of the agility, reliability, and low cost of Enterprise Grid Computing in the Oracle environment. The book discusses the technologies and processes involved in moving towards the grid model at every layer of the IT stack, including storage, servers, databases and applications. |
|
Hands-On Oracle Database 10g Express Edition for Linux
By: Steve Bobrowski Paperback: 512 pages (July 10, 2006) McGraw-Hill Osborne Media (Oracle Press) These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Linux and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away. |
|
Hands-On Oracle Database 10g Express Edition for Windows
By: Steve Bobrowski Paperback: 512 pages (July 10, 2006) McGraw-Hill Osborne Media (Oracle Press) These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Windows and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away. |
|
Oracle 10g RAC Grid, Services & Clustering
By: Murali Vallath Paperback: 704 pages (May 25, 2006) Digital Press 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 dist ribution 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 net work 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. |
|
Oracle 10g Database Administrator II: Backup/Recovery and Network Administration
By: Claire Rajan Paperback: 648 pages (May 11, 2006) Course Technology Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. |
|
Easy Oracle Jumpstart: Oracle Database Management Concepts and Administration
By: Robert G. Freeman, Don Burleson Paperback: 200 pages (May 1, 2006) Rampant Techpress Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site. |
|
Personal Oracle Real Application Clusters: Create Oracle 10g Grid Computing at-home
By: Edward Stoever, Donald K. Burleson Paperback: 200 pages (May 1, 2006) Rampant Techpress A guide for Oracle DBAs who are too busy to build a clustered server environment to learn about Oracle's Real Application Cluster technology, this book allows DBAs to build and configure a Real Application Cluster quickly and inexpensively. Covers how to find the right hardware to build an at-home RAC, where to get Linux and how to set it up, how to install the Oracle Cluster Manager, and how to create the RAC database. |
|
Oracle Tuning: Oracle 10g Time-series Optimization With The Automatic Workload Repository
By: Alexey B. Danchenkov, Donald Burleson Hardcover: 640 pages (April 15, 2006) Rampant Techpress Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site. |
|
Oracle Best Practices: Practical Standards for Success
By: Kent Crotty, Donald K. Burleson Paperback: 230 pages (April 1, 2006) Rampant Techpress Describing the successful techniques employed by large Oracle database shops to ensure quality and uniformity, this guide contains real-world examples and a code depot. All areas of Oracle best practices management, including the Oracle Optimal Flexible Architecture and testing and quality assurance best practices, are covered in detail. |
|
Oracle PL/SQL for DBAs
By: Arup Nanda, Steven Feuerstein Paperback: 429 pages (November 1, 2005) O'Reilly & Associates PL/SQL, Oracle's powerful procedural language, has been the cornerstone of Oracle application development for nearly 15 years. Although primarily a tool for developers, PL/SQL has also become an essential tool for database administration, as DBAs take increasing responsibility for site performance and as the lines between developers and DBAs blur. Until now, there has not been a book focused squarely on the language topics of special concern to DBAs Oracle PL/SQL for DBAs fills the gap. Coverin g the latest Oracle version, Oracle Database 10g Release 2 and packed with code and usage examples. Using Oracle's built-in packages (DBMS_CRYPTO, DBMS_RLS, DBMS_FGA, DBMS_RANDOM, DBMS_SCHEDULING) as a base, the book describes ways of building on top of these packages to suit particular organizational needs. Authors are Arup Nanda, Oracle Magazine 2003 DBA of the Year, and Steven Feuerstein, the world's foremost PL/SQL expert and coauthor of the classic reference, Oracle PL/SQL Programming. DB As who have not yet discovered how helpful PL/SQL can be will find this book a superb introduction to the language and its special database administration features. Even if you have used PL/SQL for years, you'll find the detailed coverage in this book to be an invaluable resource. |
|
Oracle Database 10g Linux Administration
By: Edward Whalen Paperback: 560 pages (October 31, 2005) McGraw-Hill Osborne Media (Oracle Press) Install and configure Oracle Database 10g on a Linux enterprise platform. This book explains how to set up, administer, monitor, and tune Oracle Database 10g on Linux. You will also learn how to implement High Availability solutions as well as handle backup, recovery, and replication. This exclusive Oracle Press guide is the ideal resource for all Oracle DBAs working in a Linux environment. |
|
Expert Oracle Database 10g Administration
By: Sam R. Alapati Paperback: 1304 pages (September 16, 2005) Apress 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 O racle DBA needs to build and admisiter complex Oracle 10g databases. |
|
Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions
By: Thomas Kyte Paperback: 768 pages (September 15, 2005) Apress 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. Each feature is taught in a proof-by-example manner, n ot 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 focus es 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. |
|
Grid Revolution: An Introduction to Enterprise Grid Computing
By: Brajesh Goyal, Shilpa Lawande Paperback: 72 pages (September 6, 2005) McGraw-Hill Osborne Media (Oracle Press) Flexible, reliable, and inexpensive, enterprise grid computing is the ideal solution to today's changing business needs. Perfect for business decision-makers, Grid Revolution provides an accessible overview of this technology. The book covers current grid standards activities and outlines the strategic steps required to phase grid computing into an existing infrastructure. |
|
Oracle Database 10g Insider Solutions
By: Arun Kumar, John Kanagaraj, Richard Stroupe Paperback: 528 pages (August 23, 2005) Sams Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tun ing. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else. |
|
Oracle DBA Pocket Guide
By: David C Kreines Paperback: 145 pages (August 8, 2005) O'Reilly & Associates The Oracle database is one of the most popular in the world, and for good reason. It's compatible, scalable, portable, and capable of performing incredibly fast. The advantages Oracle holds over its competition come with a price, however--it's a highly complex database that's becoming more complex with every release. And this level of detail, of course, can begin to weigh on database administrators (DBAs). Fortunately, the Oracle DBA Pocket Guide from O'Reilly is on the case. This handy referen ce is designed to help administrators make more effective use of their time by presenting a compact summary of DBA tasks in an easy-to-use form. With this book by your side, you'll have instant access to the most important concepts, best practices, tips, and checklists. Key topics include architecture, installation, configuration, tuning, and backup/recovery. Everything that you absolutely must know to do your job well is right there at your fingertips. |
|
Oracle Database Administration Concepts & Implementation Made Simple
By: Asim Abbasi Paperback: 400 pages (July 15, 2005) Takveen
|
|
Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7
By: Thomas Kyte Hardcover: 1328 pages (April 25, 2005) Apress Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte--it's very tempting to call him an Oracle oracle--seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is emin ently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment--and alternative ways of looking at the more familiar ones--solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Oracle d atabases. |
|
Oracle Database 10g DBA Handbook
By: Kevin Loney, Bob Bryla Paperback: 736 pages (March 24, 2005) McGraw-Hill Osborne Media (Oracle Press) 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. Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advan tage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more. |
|
Easy Oracle Automation: Oracle10g Automatic Storage, Memory and Diagnostic Features (10g)
By: Dr. Arun Kumar, Don Burleson Paperback: 200 pages (January 28, 2005) Rampant Techpress Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracl e10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics. |
|
Everyday Oracle DBA
By: April J. Wells Paperback: 368 pages (December 23, 2005) McGraw-Hill Osborne Media (Oracle Press) McGraw-Hill is the exclusive publisher of Oracle Press, working closely for more than ten years with Oracle experts and the user community to develop the most authoritative, comprehensive, and current references for Oracle products and technologies. Written in an accessible, engaging, and logical way this book will quickly become the fingertip quick reference for Oracle database administrators who want to get more done faster. Filled with shortcuts, this handy reference is divided into logical s ections: Administration, Tuning, backup and recovery, SQL and Pl/SQL, troubleshooting, and a general section on interesting ways to get everything done that has to be done. From the exclusive Oracle Press, this will be a well-thumbed reference that will have to be on every DBA's bookshelf. |
|
Pro Oracle Spatial
By: Euro Beinat, Albert Godfrind, Ravikanth V. Kothuri Hardcover: 712 pages (November 15, 2004) Apress Oracle Spatial is changing the way spatial information is used in organizations. This book addresses: (1) the special nature of spatial data and its role in professional and consumer applications, (2) the issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data; (3) the Oracle Spatial solution and the integration of spatial data into enterprise databases; and (4) how spatial information is used to understand business and support decisions, to manage cust omer relations, and to better serve private and corporate users. Pro Oracle Spatial shows how any Oracle application that has a spatial element (e.g. postcode) can take advantage of Spatial functionality. Thoroughly tech reviewed, this book contains case studies of more advanced applications of spatial in healthcare, telecom, retail, and distribution industries. Pro Oracle Spatial is based on extensive feedback from training courses, discussion lists, and customers. It recommends best practice approaches to the most common problems with which developers struggle. |
|
Oracle Utilities Pocket Reference
By: Sanjay Mishra Paperback: 117 pages (November 12, 2004) O'Reilly & Associates The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day. As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. Packed with information in an easy-to-read format, this valuable resourc e is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the Oracle Utilities Pocket Reference close at hand. Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "pocket reference" books. |
|
Oracle Database Foundations: Technology Fundamentals for IT Succes
By: Bob Bryla Paperback: 349 pages (October 12, 2004) Sybex 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 Or acle 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. |
|
Oracle Initialization Parameters Pocket Reference (Pocket Reference)
By: David C Kreines Paperback: 112 pages (August 1, 2004) O'Reilly & Associates Oracle designed its database products to be flexible and configurable so they would operate on a variety of hardware platforms, and they succeeded--Oracle software runs on more than seventy computer platforms, from mainframes to PC networks to handheld PDAs. The secret to this flexibility lies in the software's initialization parameters, whose numerous settings can be configured for top performance in countless environments. On the downside, however, improper settings can slow a system down; eve n grind it to a halt. And with so many parameters--which change from version to version of Oracle software--it's challenging for Oracle administrators to keep in mind the characteristics and optimal settings for each parameter. The Oracle Initialization Parameters Pocket Reference provides the crucial information you need to make key adjustments to your Oracle database. This concise guide is a mix of invaluable performance tips and a quick reference to Oracle's initialization parameters. The boo k describes each initialization parameter, indicates what category it's in--from auditing to multi-threaded server MTS--and whether it can be modified dynamically via the ALTER SESSION or ALTER SYSTEM command. In addition to the details about parameter characteristics and settings, you'll find performance tips, such as how the various parameters interact, and what the most advantageous settings are for different configurations. No other reference focuses exclusively on these initialization param eters--an absolute must for anyone working with an Oracle database. Presented in a handy, easy-to-use format, the Oracle Initialization Parameters Pocket Reference is a welcome alternative for anyone who's struggled to memorize the best configuration settings or gone back and forth to online resources, trying to figure out what works. O'Reilly's Pocket References put the information you need close at hand where you need it most. This guide will keep your Oracle databases operating at peak perfor mance. |
|
Oracle Insights: Tales of the Oak Table
By: Dave Ensor, Tim Gorman, Kyle Hailey, Anjo Kolk, Jonathan Lewis, Connor McDonald, Cary Millsap, James Morle, Mogens Norgaard, David Ruthven Paperback: 456 pages (July 23, 2004) Apress Apress has gathered 12 of the most talented and famous Oracle experts in the world to bring you Oracle Insights, Tales of the Oak Table. Eleven of the talented 12-author team are members of the prestigious Oak Table society and, each author has contributed by writing a single chapter. With a combined 90 years of Oracle experience, this impressive team has worked on some of the very largest and most complex (and in some cases, most infamous) Oracle projects in the world. Oracle Insights, Tales of the Oak Table is the collected experiences of the Oak Table team, placed against the backdrop of Oracle's evolution, and highlights some of the groundbreaking software and techniques that the authors invented in response to the challenges facing them, and how these techniques are relevant today. Each chapter of Oracle Insights, Tales of the Oak Table, is based on the author's real life experiences working with Oracle on various significant projects. The chapters are written in an anecdotal, hu morous manner, with the underlying intent to teach readers the general lessons learned from these projects and, more specifically, the techniques that emerged or evolved as a result of these projects. As described in Oracle Insights, Tales of the Oak Table, some of the authors will have crossed paths during certain projects described in the book. The book will provide a foldout color map, which attempts to show the time, and project where the authors met which, helps the readers to understand t he incredible relationship, both professional and personal, that the Oak Table experts have. |
|
Portable DBA: Oracle
By: Robert G. Freeman Paperback: 400 pages (July 21, 2004) McGraw-Hill Osborne Media (Oracle Press) This handy, affordable reference is ideal for on-the-job DBAs in need of quick access to administrative commands, error resolutions, and best practices. Covering the most commonly used Oracle database versions, the book contains invaluable tables so problems can be diagnosed quickly and includes examples and syntax diagrams for each command. |
|
Oracle Database 10g: The Complete Reference
By: Kevin Loney, Lisa McClain Paperback: 1200 pages (May 5, 2004) McGraw-Hill Osborne Media (Oracle Press) Refined to focus on the newest and most important practical features in Oracle Database 10g, this new edition of the most popular Oracle book of all time will thoroughly cover the most meaningful aspects with a straightforward combination of prose, conceptual diagrams, and code listings. |
|
Oracle Database 10g: Enterprise Grid Computing with Oracle
By: Benny Souder, Wendy Rinaldi Paperback: 400 pages (May 5, 2004) McGraw-Hill Osborne Media (Oracle Press)
|
|
Oracle 10g Grid & Real Application Clusters
By: Mike Ault, Madhu Tumma, Ranko Mosic Paperback: 680 pages (May 1, 2004) Rampant Techpress Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RA C, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications. |
|
Oracle Database 10g High Availability with RAC, Flashback, and Data Guard
By: Matthew Hart, Scott Jesse, Lisa McClain Paperback: 496 pages (April 21, 2004) McGraw-Hill Osborne Media (Oracle Press) Grid Computing has at its foundation the necessity that all computing components be readily available at all times, so they can be used when needed. Therefore, the ultimate success of any grid implementation must have at its core the resources to always be up. As such, the Oracle's High Availability offerings are a central component to its future strategy. This will be the first comprehensive book available on this core topic. |
|
OCP Instructors Guide for Oracle DBA Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration
By: Christopher T. Foot Paperback: 336 pages (April 1, 2004) Rampant Techpress An instructor's guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, desig n review meetings, software installation, database objects, backup and recovery, and tuning and performance. |
|
Oracle SQL Tuning & CBO Internals
By: Donald K. Burleson Paperback: 300 pages (April 1, 2004) Rampant Techpress As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book's timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the intern als of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database. |
|
Oracle Database 10g: A Beginner's Guide
By: Michael Abbey, Ian Abramson, Michael Corey (Publisher), Ian Abramson, Michael Abbey, Michael Corey Paperback: 448 pages (March 17, 2004) McGraw-Hill Osborne Media (Oracle Press) 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. |
|
Oracle DBA Scripting Quick Reference
By: Charlie Russel, Robert Cordingley Paperback: 256 pages (February 26, 2004) Prentice Hall
|
|
Oracle Essentials, 3e: Oracle Database 10g
By: Rick Greenwald, Robert Stackowiak, Jonathan Stern Paperback: 368 pages (February 1, 2004) O'Reilly & Associates The new edition of this classic book, Oracle Essentials 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracl e's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. More comprehensible than a large reference, and more detailed than mot primers, this book covers all the information you'll need to install and run the Oracle databases, as well as the conceptual background you'll want to understand how they work. If you're new to Oracle or upgrading to Oracle 10g, you'll find this all-in-one guide essential. |
|
Oracle Database 10g New Features
By: Robert G. Freeman Paperback: 272 pages (December 16, 2003) McGraw-Hill Osborne Media (Oracle Press) Here is an invaluable overview of all the cutting-edge features of Oracle's latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration. |
|
Oracle Replication: Snapshot, Multi-master & Materialized Views Scripts
By: John Garmany, Robert Freeman Paperback: 208 pages (December 1, 2003) Rampant Techpress With the advent of inexpensive and fast worldwide connectivity, many Oracle professionals recognize the benefits of distributing Oracle data. However, Oracle multi-master replication is extremely complex and time-consuming to implant. This book addresses the complexity of Oracle replication by providing working code examples and illustrations of working systems. Demonstrated is every aspect of Oracle snapshot replication including syntax for refresh intervals, managing snapshot logs, monitoring oracle replication, and refresh timings. Included is a description of the intricacies of Oracle multimaster replication tuning and monitoring. Also detailed are techniques for implementing conflict resolution in multi-master replication. |
|
Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration
By: Mike Ault, Madhu Tumma, Daniel Liu Paperback: 544 pages (December 1, 2003) Rampant Techpress 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 Utilities: Using Hidden Programs, Import/Export, SQL*Loader, oradebug, tkprof, & More
By: Dave Moore, Donald K. Burleson Paperback: 288 pages (August 1, 2003) Rampant Techpress Targeted at seasoned Oracle professionals who need to perform powerful system-wide operating system internal operations on their Oracle databases, this book provides help on how to use the utilities provided with the Oracle database. Explained are secrets for database migration with export/import and SQL*Loader utilities as well as OS utilities such as dbverify, orastack, and orakill. Tuning utilities including tkprof and dbms_debug are described in detail in addition to monitoring utilities inc luding dbms_alert and dbms_xplan. Also covered in the book are network and developer utilities. |
|
Expert Oracle9i Database Administration
By: Sam R. Alapati Paperback: 1248 pages (April 15, 2003) Apress This is the only real Oracle 9i Database Administration book on the market! This 1,000 page book enables a beginner or intermediate level Oracle DBA of Oracle Developer/Manager to master the art of building and managing complex Oracle 9i databases. "Expert Oracle9i Database Administration" is thorough in covering all aspects of the 9i database and also includes a UNIX primer, as well as an introduction to SQL and PL/SQL. Sam R. Alapati covers the entire spectrum of the new Oracle 9i RDBMS softwa re and clearly explains how to use all of its powerful features. Currently, there is no one book that combines the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. Sam R. Alapati's book fills that gap well, by providing all the necessary material in one comprehensive volume. "Expert Oracle9i Database Administration" is designed as the most complete Oracle 9i database text available today. It takes several courses, as well as mastery of several Oracle manuals, to become a proficient DBA. A major focus of this book is on the most important features of the Oracle 9i database. Readers will be able to become expert Oracle DBAs by using this book. |
|
Oracle in a Nutshell
By: Rick Greenwald, David C. Kreines (Editor) Paperback: 912 pages 1st Edition edition (December 1, 2002) O'Reilly & Associates Introduced a quarter-century ago, the Oracle database remains the leading enterprise relational database management system (RDBMS) in the world. Oracle is a complex system, offering a myriad of products, languages, and tools. Frequent updates, releases, and editions complicate the ability of Oracle users to keep up with the huge amounts of frequently changing information about the database and its capabilities. The goal of Oracle in a Nutshell is to bring order to the chaos of Oracle informatio n -- to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this book, an admirable addition to O'Reilly's respected In-a-Nutshell line, combine to boil down vital Oracle commands, language constructs, parameters, and file formats in a succinct and highly accessible desktop reference. Oracle in a Nutshell covers the information that database administrators PL/SQL and Java developers, and system, network, and security admini strators need as they manage Oracle databases and write code for these databases. |
|
Oracle9i Performance Tuning Tips & Techniques
By: Rich Niemiec, Richard J. Niemiec, Bradley D. Brown, Raymond J. Lane Paperback: 816 pages (December 2002) McGraw-Hill Osborne Media (Oracle Press) From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world! |
|
Oracle9i RMAN Backup & Recovery
By: Robert G. Freeman, Matthew Hart Paperback: 608 pages (October 18, 2002) McGraw-Hill Osborne Media (Oracle Press) From the exclusive publishers of Oracle Press Books, here is the only book available offering complete coverage of RMAN (Recovery Manager), Oracle's free backup and recovery technology. An indispensable resource for new Oracle users, database administrators, and system administrators. |
|
Oracle9i: The Complete Reference
By: Kevin Loney, George Koch Paperback: 1256 pages Book & Cd edition (August 16, 2002) McGraw-Hill Osborne Media (Oracle Press) The latest version of this popular guide introduces the fundamental commands and techniques used in Oracle 9i database systems, and how to develop applications using Oracle and SQL. The authors also review PL/SQL structures, object-oriented and Java features in the Oracle database, the data dictionary, database optimizers, and the application server. The CD-ROM contains an electronic version of the book and tables. Master all the powerful features of Oracle9i using the exclusive information ins ide 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. |
|
Perl for Oracle DBAs
By: Andy Duncan, Jared Still Paperback: 600 pages 1st edition (August 15, 2002) O'Reilly & Associates Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal. You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers: The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities. The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate wi th Oracle databases. Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason. The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tas ks: monitoring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more. |
|
Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts
By: John Adolph Palinski Paperback: 528 pages 1st edition (August 8, 2002) Addison-Wesley Publishing Introduces the basic relational database terminology and techniques for extracting information from Oracle databases. Written for beginners, the book focuses on the SQL*Plus query language and the SELECT command for querying a database. Business objects and data warehouses are briefly covered. The final three chapters overview the PL/SQL programming language. The CD-ROM contains a practice database and sample scripts |
|
Oracle9i DBA 101
By: Marlene Theriault, Rachel Carmichael, James Viscusi, Jim Viscusi Paperback: 576 pages 1st edition (July 15, 2002) McGraw-Hill Osborne Media (Oracle Press) Your Oracle career starts here! Ideal for those new to Oracle technology, this introductory guide explains in easy-to-follow detail the day-to-day duties of a database administrator (DBA), as well as essential database installation, monitoring, and managing techniques. |
|
Oracle9i for Windows Handbook
By: Rama Velpuri, Anand Adkoli Paperback: 528 pages 2 edition (April 19, 2002) McGraw-Hill Osborne Media (Oracle Press) This authorized guide from Oracle Press explains how to implement the Oracle9i Server on Windows NT/2000. You'll get details on operating system fundamentals, installation, and configuration, plus intermediate and advanced topics such as architecture, migration, clustering, parallel server |
|
Oracle Performance Tuning
By: Edward Whalen, Mitchell Schroeter Paperback: 432 pages 1st edition (April 16, 2002) Addison-Wesley Publishing Edward Whalen is vice president and founder of Performance Tuning Corporation (perftuning), a consulting company that specializes in database performance, administration, and backup/recovery solutions. He has extensive experience in database system design and tuning for optimal performance. His career has consisted of hardware, operating system, and database development projects for many different companies. Edward has published two other books on the Oracle RDBMS. He has also written four books on Microsoft SQL Server. In addition to writing, Edward has worked on numerous benchmarks and performance-tuning projects with both Oracle and MS SQL Server. Mitchell Schroeter is a senior consultant with Performance Tuning Corporation (perftuning) and has worked in the field of database performance tuning for five years. Prior to Performance Tuning Corporation, Mitchell worked at Dell Computer Corporation as a systems analyst in the systems performance analysis group, specializing in database technologies and high-performance storage systems. He has extensive experience with developing client-server and multitiered applications on both Oracle and Microsoft SQL Server in a variety of programming languages. Mitchell specializes in tuning database systems and application code, storage area networks, and Oracle 9i Real Application Clusters. |
|
Oracle DBA Automation Scripts
By: Rajendra Gutta Paperback: 408 pages 1st edition (April 11, 2002) Sams Provides and explains powerful scripts that automate common database administration tasks, empowering the DBA to spend more time focusing on the critical aspects of their job. |
|
Tru64 UNIX-Oracle9i Cluster Quick Reference
By: Tim Donar Paperback: 285 pages 1st edition (March 31, 2002) Butterworth-Heinemann Step-by-step configuration guide for Tru64 UNIX 5.1 TruCluster and Oracle9i RAC. Oracle9i RAC installation and configuration tips. Command summary included in each chapter. This quick reference provides step-by-step instructions on setting up Oracle9i RAC to run on a Tru64 UNIX cluster. Configuration information is included from start to finish. Command summary guides are built into each chapter for quick information retrieval. Examples and step-by-step instructions assist in the complete inst allation of a Tru64 UNIX 5.1A and Oracle9i. Designed as an introduction to Tru64 UNIX and Oracle9i RAC, Tru64 UNIX-Oracle9i Cluster Quick Reference will give intermediate and advanced administrators an invaluable resource for quickly locating vital information. |
|
Beginning Oracle Programming
By: Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman (Contributor), Howard Rogers Paperback: 1000 pages 1st edition (March 2002) Wrox Press Oracle is the world's leading relational database. It provides a rich environment to store, handle, and extract data. When used properly, Oracle provides a solid foundation upon which to build enterprise scale applications. Mastering the Oracle database is not an overnight job. It takes time, practice, and a lot of real world experience. This book teaches you the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of p rogramming Oracle. By the time you have completed this book, you will have all the knowledge you need to use Oracle databases with confidence. You are setting out on the same journey we travelled some years ago. We know the things you are going to run into time and time again. We understand the challenges you are going to meet when you have to develop an application or administer your database. We can guarantee you that the techniques you'll learn in this book are proven and have led us through many successful implementations. |
|
Oracle9i UNIX Administration Handbook
By: Donald K. Burleson, Don Burleson Paperback: 560 pages (January 16, 2002) McGraw-Hill Osborne Media (Oracle Press) This is a very interesting read for any Unix DBA, full of comprehensive explanations and diagrams on the way in which Oracle interacts with the Unix server. There are many detailed Unix Scripts to help you monitor your instances, which can be run via Statspack (dbms_job) and/or via the Unix cron. There is additional information on some more complicated UNIX commands, and copious small tips and tricks that will help in everyday Database Administration tasks. The book also covers commands for all different Unix environments Solaris, HP-UX, Tru64, AIX etc and help you interpret results from vmstat, sar and other Unix admin utilities. |
|
Oracle 9i New Features
By: Robert G. Freeman Paperback: 244 pages (January 4, 2002) McGraw-Hill Osborne Media (Oracle Press) Maximize all of the enhanced capabilities of Oracle9i using the precise information presented in this convenient resource, officially authorized by Oracle Corporation. Inside, you'll find full details on all the new Oracle9i features, including database administration and management improvements, architecture changes, performance enhancements, security advancements, and high-availability innovations. |
|
Mastering Oracle8i
By: Robert G. Freeman, Mark D. Blomber, Mark D. Blomberg Paperback: 1200 pages Bk & Cd-Rom edition (December 13, 2001) Sybex Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you're working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you'd want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialized views, advanced user management, and performance-tuning techniques. There's some discussion of hooks for software developers, as well. The authors' approach is to take a feature of the Oracle 8i environment--locks, say--and explain what purpose it serves, then break it down into component types with more detailed explanations. From there, the authors provide the commands and codes for view ing and manipulation of the feature, often with extensive tables. The really useful information comes next, in the form of sections on how to deal with related problems. The section on locks, for example, shows how to zero in on blocking locks. Other excellent coverage deals with how to dimension hardware, while a commendable section explains the object-oriented features of Oracle 8i. |
|
Oracle9i Development By Example
By: Dan Hotka Paperback: 640 pages 1st edition (December 12, 2001) Que Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format. |
|
Oracle9i for Windows(R) 2000 Tips & Techniques
By: Scott Jesse, Matthew Hart, Mike Sale Paperback: 612 pages 1st edition (December 7, 2001) McGraw-Hill Osborne Media (Oracle Press) From the authorized Oracle Press comes a unique volume, packed with undocumented tips ; techniques from Oracle experts, for maximizing Oracle9i on the Windows 2000 platform. You'll get full coverage of critical high-end features such as clustering and standbys and methods for ensuring high availability. You'll also get full details on all the features new to Oracle9i. Take full advantage of the strength and reliability of Oracle9i and the management features of Windows 2000. Written by the expe rts and authorized by Oracle Corporation, Oracle9i for Windows 2000 Tips & Techniques presents insider best practices for installation, upgrades, migration, tuning, backup and recovery, clustering, and high availability. You'll also get in-depth details on the new features of Oracle9i. |
|
Oracle E-Business Suite Financials Administration
By: Shankaran Iyer Paperback - 704 pages 1st edition (December 4, 2001) McGraw-Hill Osborne Media (Oracle Press) From the official Oracle Press comes a comprehensive guide managing, customizing, and tuning this key component of the Oracle Applications Suite. You'll learn to install and update Oracle Financials, apply various patches, and much more using this essential resource. |
|
Oracle DBA on Unix and Linux
By: Michael Wessler Paperback - 600 pages 1st edition (October 29, 2001) Sams Oracle DBA on Unix and Linux provides all the information needed to install, support, tune, and upgrade Oracle databases on the UNIX and Linux platforms. Maintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management products; use Backup and Recovery; tune, monitor, and troubleshoot servers; Web DB and the Oracle Portal, 8i, iFS, Java, and 9i coverage; and iAS - Internet Application Server. |
|
Expert One on One: Oracle
By: Thomas Kyte Perfect Paperback - 1265 pages (June 2001) Wrox Press Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: s cope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book. Kyte - it's very tempting to call him an Oracle oracle - seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is em inently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment - and alternative ways of looking at the more familiar ones - solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Orac le databases. |
|
Unix for Oracle DBAs Pocket Reference
By: Donald K. Burleson Paperback - 109 pages (May 2001) O'Reilly & Associates The Unix for Oracle DBAs Pocket Reference has a remarkably tight focus. It's about making Oracle database management systems run optimally under various Unix operating systems, including HP-UX, Sun Solaris, and IBM AIX (there's also some specialized coverage of IRIX and DEC Unix). Author Donald Burleson assumes readers know how to get around the Unix command shell, and that they're quite familiar with Oracle database administration. To put it simply, to get the most out of this book, you should already know what you want to do, and need only to be told concisely how to do it. This book is ideal for people moving from Oracle administration under Windows to the same job under Unix. |
|
Oracle & Open Source
By: Andy Duncan, Sean Hull Paperback - 400 pages (April 15, 2001) O'Reilly & Associates Oracle & Open Source is the first book to tie together the commercial world of Oracle and the free-wheeling world of open source software. As this book reveals, these two worlds are not as far apart as they may seem. Today, there are many excellent and freely available software tools that Oracle developers and database administrators can use, at no cost, to improve their own coding productivity and their system's performance. Moreover, many of the finest Oracle developers are now making thei r source code freely available so their peers can build upon this code base. Oracle Corporation is even porting its RDBMS to Linux and starting to incorporate a growing number of open source tools in the company's own software. Oracle & Open Source describes close to 100 open source tools you can use for Oracle development and database administration, from large and widely known open source systems (like Linux, Perl, Apache, TCL/Tk and Python) to more Oracle-specific tools (like Orasoft, Ora c, OracleTool, and OraSnap). You'll learn how to obtain the software and how to adapt it to best advantage. The book abounds with code examples, download and installation instructions, and helpful usage hints. Not only does it tell you how to find and use existing open source code; Oracle & Open Source gives you the details and the motivation to build your own open source contributions and release them to the Oracle community. You'll lear n all about tools like the Oracle Call Interface (OCI) and Perl-DBI (Database Interface), which provide the glue allowing new open source tools to link into commercial Oracle software. With Oracle & Open Source as a guide, you'll discover an enormous number of highly effective open source tools, while getting involved with the thriving community of open source development. |
|
Oracle DBA Checklists Pocket Reference
By: Revealnet Staff (Editor) Paperback - 80 pages (April 15, 2001) O'Reilly & Associates Oracle database administration is a complex and stressful job. Pocket guide and quick reference to Oracle DBA, containing easy-to-use checklists for common database administration tasks. Includes coverage of database management, installation and configuration, and network management. Also includes step-by-step quick reference material. In a series of easy-to-use checklists, this concise pocket reference summarizes the enormous number of tasks you must perform as an Oracle DBA. Each section takes a step-by-step "cookbook" approach to presenting DBA quick-reference material. This book's quick-reference, step-by-step approach takes the stress out of DBA problem solving by making it easy to find the information you need - and find it fast. |
|
Oracle SQL Loader: The Definitive Guide
By: Jonathan Gennick, Sanjay Mishra Paperback - 251 pages 1st edition (April 15, 2001) O'Reilly & Associates SQL*Loader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQL*Loader is to load data from flat files into an Oracle database. It's optimized for loading large volumes of data, and is flexible enough to handle virtually any input format. Almost every Oracle user has to use SQL*Loader at one time or another, and DBAs are frequent ly called upon to load data for the users in their organization. Despite SQL*Loader's wide availability and usage, few DBAs and developers know how to get the most out of it. Oracle SQL*Loader: The Definitive Guide has everything you need to know to put SQL*Loader to its best use: an introduction to SQL*Loader, a reference to all of its syntax options, and most importantly, step-by-step instructions for all the SQL*Loader tasks you'd want to perform - and maybe some you didn't realize you COULD perform. |
|
Implementing and Managing Oracle Databases
By: Steve Lemme, John R. Colby Paperback - 418 pages (February 2001) Premier Press Oracle database administration goes far beyond installation and tuning of the database - topics covered by the majority of books on the market. As DBAs become more involved in the business process, architecture, and planning, there may be more to do up front, but the end result is less chaotic. To better prepare those who are up to the new eBusiness challenges, the chapters in this book have been organized with information to not only provide IT professionals with information that can be applied for a more challenging and successful career, but also for those companies who are trying to attract and retain them. |
|
Practical Oracle 8i: Building Efficient Databases
By: Jonathan Lewis Paperback - 640 pages 1st edition (January 15, 2001) Addison-Wesley Publishing A lot of books seem to give canned explanations of how oracle works - geared towards rote memorization as opposed to understanding. This book does a great job of taking the next step. For example, The detail with which the author goes through the process of how updating a row actually works in an Oracle database was tremendous. His explanation of how a select statement could actually cause a row to be marked as committed ( i.e. a read causes a write ) was great. I've only been a DBA (or pseudo-D BA) for about 6 months now, so I'm certainly no expert in this area. Yet I found all of his explanations very clear and easy to understand. If you're looking for a new Oracle book, get this one. |
|
Oracle SQL High-Performance Tuning
By: Guy Harrison Paperback - 656 pages 2nd edition (December 29, 2000) Prentice Hall A guide for Oracle developers and database administrators, covering every aspect of Oracle 8/8i SQL and PL/SQL tuning, with specific recommendations, detailed case studies, and real benchmarks. Coverage includes designing applications to maximize efficiency, building indexes, identifying and resolving Oracle Server bottlenecks, fixing poorly performed SQL code, and leveraging Oracle's parallel query facility. |
|
Oracle DBA Interactive Workbook
By: Melanie Caffrey, Douglas Scherer Paperback - 457 pages 1st edition (December 15, 2000) Prentice Hall The Oracle DBA Interactive Workbook presents an introduction to Oracle database administration in a unique and highly effective format. It is organized more like a teaching aid than a reference manual in that to learn basic administration techniques, you are challenged to work through a set of guided tasks rather than to read through descriptions. There is a list of additional reading material in Appendix B that you can reference if you wish to delve deeper into any of the topics covered in this book. This book is intended for beginners in the world of Oracle database administration. It will take you through a set of tasks, starting with creating a database to using some of the Oracle database tuning, and backup and recovery utilities. Those experienced with Oracle databases will recognize that a workbook covering the topic of database administration will be an extremely useful introduction for the beginner, but it cannot be used as a deep study of the Oracle database environment. Aft er working through this book, you will have been launched into the exciting and interesting (sometimes nerve-racking) world of database administration, but it will take years of experience to become a senior database administrator. This book is intended for anyone who needs a quick and detailed introduction to Oracle database administration tasks. It is not the intention of this book to provide an in-depth study of the Oracle database server. The foundation for this book was developed to supplem ent the Introduction to Oracle Database Administration class in the Database Track at Columbia University's Computer Technology and Applications (CTA) program in New York City. The book's sidebars and answers often reflect questions that students have asked in class. |
|
Oracle Database Administration: The Complete Video Course
By: Melanie Caffrey, Douglas Scherer Paperback Video and Book edition (December 2000) Prentice Hall This video course contains three-and-a-half hours of QuickTime video instruction plus the Oracle Interactive Workbook e-Book. Caffrey and Scherer (database development and management, Columbia U. School of Continuing Education) present 17 video lectures that cover all key aspects of day-to-day Oracle database administration including creating new datasets; managing physical database layouts; administering users, privileges, and resource groups; tuning Oracle and SQL code for maximum performance; security, auditing, and data integrity; logical and practical backup and recovery; auditing; rollback segments; and other topics. |
|
Oracle8i: The Complete Reference
By: Kevin Loney, George K. Koch Hardcover - 1308 pages (May 23, 2000) McGraw-Hill Osborne Media (Oracle Press) Provides a comprehensive understanding of database development on the Internet. DBAs will benefit from coverage on the Web Development environment usage and the Internet File System (IFS) feature. Describes the scalable, integrated and robust Java Virtual Machine (JVM) which allows DBAs to write, store, and execute Java code. CD-ROM offers scripts and codes from the book. |
|
Oracle DBA Tips and Techniques
By: Sumit Sarin Paperback - 737 pages 1st edition (April 15, 2000) McGraw-Hill Osborne Media (Oracle Press) Oracle DBA Tips & Techniques is the perfect complement to Oracle Press DBA Handbooks and soon-to-be published Starter Kit. The book is organized and structured to provide time-saving, undocumented methods for the DBAs comprehensive job. The Oracle Tips & Techniques Series is a response to the many requests for this type of material from the readers of Oracle Press. Important features include: "Tips Covered" and "Tips Reviewed" section at the beginning and end of each chapter; easy-refere nce bleed tabs. |
|
Oracle8i DBA Bible
By: Jonathan Gennick, Carol McCullough-Dieter, Gerrit-Jan Linker Paperback - 1113 pages Bk & Cd Rom edition (April 2000) Hungry Minds Oracle 8i is packed with new features, including an embedded Java Virtual Machine, expanded data warehousing capabilities, and enhanced DBA tools. This comprehensive guide shows you step-by-step how to make the most of this improved functionality - and master the day-to-day tools and challenges of Oracle database administration. From SQL Plus basics and performance-tuning options to recovery tips and WebDB strategies, Oracle 8i DBA Bible is all you need to optimize a database and keep it running smoothly. |
|
Oracle 24x7 Tips & Techniques
By: Venkat S. Devraj Paperback - 1008 pages (November 1999) McGraw-Hill Osborne Media (Oracle Press) Time-tested information--Strategies come straight from an Oracle DBA who's worked in the trenches for the Quatar Government keeping systems online 24x7. 8i Coverage--Version 8i's web functionality makes working in 24x7 mode available to a wider spectrum of corporations. Specific discussions--Covers areas of database installation, configuration, and management of security, performance, and recoverability. Diagnostic and database monitoring scripts--Scripts can be deployed immediately to help DBAs achieve high-availability databases. |
|
Oracle Essentials: Oracle8 and Oracle8i
By: Rick Greenwald, Jonathan Stern, Robert Stackowiak Paperback - 355 pages (November 1999) O'Reilly & Associates The Oracle relational database management system (RDBMS) is an enormous system, with myriad technologies, options, and releases. Most users -- even experienced developers and database administrators -- find it difficult to get a handle on the full scope of the Oracle system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies. This book distills the enormous amount of information about what Oracle i s, where it came from, and what the latest releases (Oracle8 and Oracle8i) do -- and packages it into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints for DBAs and developers. It explains what is new and important about Oracle's revolutionary releases, Oracle8 (the "object-relational database") and Oracle8i (the "Internet database"). It covers such topics as overall system products, architecture, and data structures; installation, management, security, ba ckup and recovery, and tuning issues; and specific Oracle technologies such as data warehouses, online transaction processing (OLTP), and the system's interfaces to the Web. |
|
Oracle 8i Administration and Management
By: Michael R. Ault Paperback - 1024 pages Bk & CD-ROM edition (October 20, 1999) John Wiley & Sons Oracle database administrators always have plenty on their plate. Oracle8i Administration and Management comes to the rescue with lots of guidance in creating and maintaining Oracle databases and keeping them running at top performance. This is the latest revision of the DBA guide that has previously covered Oracle7 and, more recently, Oracle8. This update adds full coverage of Oracle 8i and includes an integrated discussion of the new version's object-oriented additions to the popular SQL data base product. Author Michael R. Ault meticulously goes through the topics administrators care about most, presenting a detailed discussion of the underlying architectural details. By organizing chapters according to administrative functions, such as "Tuning Oracle Applications" and "Database Internals Tuning," Ault has created a text that is quite handy for on-the-spot reference. A number of useful appendices on the companion CD-ROM offer plenty of useful management tidbits, as well as all of t he code scripts used in the book and demonstration versions of management utilities. |
|
Oracle8i DBA Handbook
By: Kevin Loney, Marlene L. Theriault Paperback - 979 pages (October 12, 1999) McGraw-Hill Osborne Media (Oracle Press) A thorough overhaul of the previous edition - widely considered the Oracle DBA "bible" - wth full coverage of all the new Oracle8i features. Covers everything the administrator needs to know to effectively manage a robust, peak-performance Oracle8i database. Explains how to configure Oracle to be accessed through a firewall from a DBA's perspective. "Solutions" sections illustrates - with annotations - how to implement the techniques described in each chapter. Maintain a robust, mission-critical Oracle8i database - the most manageable Web-enabled enterprise database system available. Oracle8i DBA Handbook provides high-end administrative solutions for the day-to-day DBA. Inside, you'll learn to set up a database for maximum efficiency, monitor it, tune it, and maintain its security. |
|
Oracle Distributed Systems
By: Charles Dye, Deorah Russell (Editor), Deborah Russell (Editor) Paperback - 530 pages Bk & Disk edition (April 1999) O'Reilly & Associates Most organizations that use the Oracle relational database management system (RDBMS) these days need to use multiple databases. There are many reasons to use more than a single database in a distributed database system: Different databases may be associated with particular business functions, such as manufacturing or human resources. Databases may be aligned with geographical boundaries, such as a behemoth database at a headquarters site and smaller databases at regional offices. Two different d atabases may be required to access the same data in different ways, such as an order entry database whose transactions are aggregated and analyzed in a data warehouse. A busy Internet commerce site may create multiple copies of the same database to attain horizontal scalability. A copy of a production database may be created to serve as a development test bed. |
|
Oracle8 Advanced Tuning & Administration
By: Eyal Aronoff, Kevin Loney, Noorali Sonawalla Paperback - 660 pages (June 9, 1998) McGraw-Hill Osborne Media (Oracle Press) Picks up teaching Oracle skills where Oracle8 DBA Handbook and Tuning Oracle leave off. Gives Oracle8 DBAs the advanced tools necessary to manage and tune their databases regardless of the rate of growth in the environment--a very important scalability skill. Revised to cover all new aspects of Oracle8, including: Partitioned tables, abstract datatypes, index-only tables, objects, and more. CD-ROM includes code from the book, plus a new version of SQLab--a valuable application tool that help rea ders practice advanced optimization techniques. The previous edition sold over 25,000 copies, and this new version gives Oracle8 DBAs the advanced tools necessary to manage and tune their databases regardless of the rate of growth in the environment. The CD-ROM includes code from the book plus a new version of SQLab. |
|
Oracle Built-In Packages
By: Steven Feuerstein, Charles Dye, John Beresniewicz Paperback - 956 pages (May 1998) O'Reilly & Associates Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of Oracle development tools. Originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. Now, with the introduction of Oracle8, PL/SQL has taken the next ste p towards becoming a fully realized programming language providing sophisticated object-oriented capabilities. Steven Feuerstein's Oracle PL/SQL Programming is a comprehensive guide to building applications with PL/SQL. That book has become the bible for PL/SQL developers who have raved about its completeness, readability, and practicality. Built-in packages are collections of PL/SQL objects built by Oracle Corporation and stored directly in the Oracle database. The functionality of these packag es is available from any programming environment that can call PL/SQL stored procedures, including Visual Basic, Oracle Developer/2000, Oracle Application Server (for Web-based development), and, of course, the Oracle database itself. Built-in packages extend the capabilities and power of PL/SQL in many significant ways. |
|
Oracle Scripts
By: Brian Lomasky, David C. Kreines Paperback - 204 pages (May 1998) O'Reilly & Associates This book provides a powerful set of tools for Oracle database administrators and developers. During their many years of administering, tuning, and troubleshooting Oracle databases, the authors have developed hundreds of useful scripts. Now you can instantly take advantage of their experience by putting these scripts to work at your own site. DBAs and developers are constantly reinventing the wheel. Most Oracle sites have similar requirements, problems, and crises, and at most of these sites DBA s and developers find themselves reinventing the wheel by writing the same kinds of scripts -- and too often they're writing them under pressure, in hit-or-miss and error-prone fashion. The scripts in this book are tried-and-true. They've been thoroughly tested in many different environments. You can use them right now to simplify the tasks you perform each day -- monitoring databases for reliability, protecting your database against data loss, improving performance, increasing security, and bui lding reports that provide insight into the inner workings of Oracle databases. You can also turn to these scripts in emergencies to diagnose system problems and repair databases when the pressure is on. |
|
Oracle8 Architecture
By: Steve Bobrowski Paperback - 356 pages authorized edition (October 1997) McGraw-Hill Osborne Media (Oracle Press) The book design has two primary goals. First, the book is a basic/intermediate level presentation of the primary concepts and software architecture of Oracle8. After reading this book, any type of Oracle8 user will have a solid, big-picture understanding of how Oracle8 fits into the world of serious data management applications. Second, the book is an excellent planning guide that will help a current Oracle user server to migrate Oracle7 databases and corresponding database server administrators and application developers need to understand to work with Oracle8. |
|
Oracle8: The Complete Reference
By: Kevin Loney, George K. Koch Hardcover - 1300 pages (September 1997) McGraw-Hill Osborne Media (Oracle Press) Oracle8: The Complete Reference is completely updated to cover versions 7.0 through 8. The book is organized in 6 parts. Part I introduces database concepts. Part II discusses SQL, the Structured Query Language which allows programmers to process information to and from a database. Part III is the Hitchhiker's Guide to the Data Dictionary. Part IV discusses database design consideration. Part V is a big, alphabetical reference for virtually every Oracle command. Part VI lists the tables used in the book. The book offers both terrific coverage of using Oracle and a substantial command reference listing the syntax and sample usage for every major command. It also includes a new chapter called "The Hitchhiker's Guide to the Oracle Optimizer." This presents the SQL operations and tuning issues directed towards a beginner user audience. As with its predecessor, this book will include a CD-ROM. This is particularly valuable for readers for two reasons. First, since the book is large, having quick referencing capability on CD will be attractive to end-users. The sizeable reference section is perfect for electronic access. Secondly, the tables in the book will be accessible on the CD, so users will save both time and money. |
|
Oracle DBA Reference Library
By: Guy Harrison (Contributor), Lynnwood Brown (Contributor), Ahmed Alomari Paperback Bk & CD-ROM edition (September 1997) Prentice Hall This kit includes three books: Oracle SQL highperformance tuning, Oracle database administration on UNIX systems, and Oracle and UNIX performance tuning. Three CD ROMs included. The complete professional's resource for building, managing, and optimizing Oracle databases! Oracle DBA Reference Library is an unparalleled practical resource for DBAs, database programmers, IT managers, and anyone who needs to make the most of Oracle database technology. It's three comprehensive, up-to-date books by w orld-class Oracle professionals, plus three CD-ROMs packed with tools and information, all for one great price! |
|
2001-2011 Oracle-Books.com |