Oracle Core: Essential Internals for DBAs and Developers

Author: Jonathan Lewis
Publisher: Apress
ISBN: 1430239557
Category : Computers
Languages : en
Pages : 276

Book Description
Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica

Unix for Oracle DBAs Pocket Reference

Author: Donald K. Burleson
Publisher: "O'Reilly Media, Inc."
ISBN: 0596529090
Category : Computers
Languages : en
Pages : 110

Book Description
The Unix for Oracle DBAs Pocket Reference puts within easy reach the commands that Oracle database administrators need most when operating in a Unix environment. If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that these commands are far different from those covered in most beginning Unix books. To jump start your learning process, Don Burleson has gathered together in this succinct book the Unix commands he most often uses when managing Oracle databases. You'll be able to reach into your pocket for the answer when you need to know how to: Display all Unix components related to Oracle, identify the top CPU consumers on your server, and even kill processes when necessary Stack Unix commands into powerful scripts that can perform vital DBA functions Monitor Unix filesystems, and automatically manage your trace files, dump files, and archived redo log files Use essential server monitoring commands such as top, sar, and vmstat And there's much more between these covers. If you need to get up to speed with Oracle on Unix, and quickly, this book is for you.

Cost-Based Oracle Fundamentals

Author: Jonathan Lewis
Publisher: Apress
ISBN: 1430200871
Category : Computers
Languages : en
Pages : 521

Book Description
Jonathan Lewis is one of the world's foremost authorities in this field (he is frequently quoted and reference by other leading experts, such as Tom Kyte – see for example http://asktom.oracle.com/pls/ask/download_file?p_file=3067171813508366601 Book will be strongly co-promoted with Tom Kyte's Expert Oracle Database Architecture (1-59059-530-0) Highlights traps for those migrating from Oracle 8i to 9i to 10g, potentially averting often disastrous performance issues and downtime (=lost revenue) The first comprehensive book written to investigate, describe, and demonstrate the methods used by the Cost Based Optimizer Jonathan is one of very few Oracle authors to maintain online enhancements, errata and addenda pages, so the reader will be supported long after the book is published

Troubleshooting Oracle Performance

Author: Christian Antognini
Publisher: Apress
ISBN: 1430204982
Category : Computers
Languages : en
Pages : 603

Book Description
When your database application isn’t running fast enough, troubleshooting is usually your first move. Finding the slow part of an application is often easy, but discovering a solution can prove much more difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance. Written for developers by an application developer who has learned by doing, this book shows you how to plan for performance as you would for any other application requirement.

Database Administration

Author: Craig Mullins
Publisher: Addison-Wesley Professional
ISBN: 9780201741292
Category : Computers
Languages : en
Pages : 736

Book Description
Giving comprehensive, soup-to-nuts coverage of database administration, this guide is written from a platform-independent viewpoint, emphasizing best practices.

Oracle Net8 Configuration and Troubleshooting

Author: Hugo Toledo
Publisher: IGI Global
ISBN: 9781565927537
Category : Computers
Languages : en
Pages : 412

Book Description
"This book also describes Oracle's various network management utilities, including Listener Control (Isnectl), Oracle Names Control (namesctl), Oracle Connection Manager Control (cmctl), tnsping, and Net8 Assistant. In addition, the book provides a variety of networking troubleshooting techniques, commonly encountered Net8 configuration problems, and a complete syntax summary for all networking files and commands."--BOOK JACKET.

Expert One-on-One Oracle

Author: Thomas Kyte
Publisher: Apress
ISBN: 9781430212799
Category : Computers
Languages : en
Pages : 1328

Book Description
* A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.

Oracle Performance Survival Guide: A Systematic Approach To Database Optimization

Author: Harrison Guy
Publisher: Pearson Education India
ISBN: 9788131734766
Category :
Languages : en
Pages : 762

Book Description

Oracle DBA Mentor

Author: Brian Peasland
Publisher: Apress
ISBN: 1484243218
Category : Computers
Languages : en
Pages : 454

Book Description
New Oracle database administrators can get off the ground running. This book helps you develop the ability to think on your feet and move focus in an instant from arcane syntax details to broad, corporate issues. Along the way, you will see how to create your first database and implement best practices to ensure a well-running database system. What makes Oracle DBA Mentor different is that it also teaches you how to obtain answers that are not found in this or other books. Focus is given to creating a test bed and running test cases to examine hypotheses and prove out solutions so you can be sure they work in production. Attention is given to navigating product documentation and networking in forums and social media to build your skills and a network to draw on when solving problems under pressure. There are chapters of step-by-step technical content as well as coverage of essential skills to succeed as a DBA no matter which database engine you administer. By the time you are done reading this book, you will have confidence to face many of the situations thrown in your direction. You will know where to go for the answers you don’t yet know that you need. You’ll be able to work and troubleshoot under pressure. You’ll know how to create a database, institute backup and recovery procedures, secure the database and its valuable corporate data, and acquire more knowledge as needed so you can run a database to meet the needs of your organization. What You'll LearnInstall Oracle Database with best practices Implement backup and recovery procedures Understand the fundamentals of databases and data security Find answers to technical problems using Oracle documentation, Oracle Support, and other resources Patch and upgrade an Oracle database Who This Book Is For The novice database administrator who wants help getting off the ground with their DBA career, and in building the skills to let that career flourish in the long term. Mid-level DBAs will also find the book helpful as they try to grow their career to the next level. While the book is geared toward the Oracle platform, database administrators from other platforms can benefit from the soft skills covered in this book.

Oracle Internals: An Introduction

Author: Steve Adams
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565925984
Category : Computers
Languages : en
Pages : 140

Book Description
Based on Oracle8i, release 8.1, this concise book contains detailed, hard-to-find information about Oracle internals (data structures, algorithms, hidden parameters, and undocumented system statistics). Main topics include waits, latches, locks (including instance locks used in parallel server environments) and memory use and management.