Oracle Performance Survival Guide

Oracle Performance Survival Guide

Author: Guy Harrison

Publisher: Pearson Education

Published: 2009-10-09

Total Pages: 934

ISBN-13: 0137000502

DOWNLOAD EBOOK

Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.” Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes • “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization • Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance • Highly efficient database logical and physical design, indexing, transaction design, and API use • SQL and PL/SQL tuning, including the use of parallel SQL techniques • Minimizing contention for locks, latches, shared memory, and other database resources • Optimizing memory and physical disk IO • Tuning Real Application Cluster (RAC) databases guyharrison.net informit.com/ph


Oracle Exadata Survival Guide

Oracle Exadata Survival Guide

Author: David Fitzjarrell

Publisher: Apress

Published: 2013-11-11

Total Pages: 273

ISBN-13: 1430260106

DOWNLOAD EBOOK

Describes what Exadata is and its available configurations for such features as smart scans, storage indexes, hybrid columnar compression, and Smart Flash Cache.


Next Generation Databases

Next Generation Databases

Author: Guy Harrison

Publisher: Apress

Published: 2015-12-30

Total Pages: 244

ISBN-13: 1484213297

DOWNLOAD EBOOK

"It’s not easy to find such a generous book on big data and databases. Fortunately, this book is the one." Feng Yu. Computing Reviews. June 28, 2016. This is a book for enterprise architects, database administrators, and developers who need to understand the latest developments in database technologies. It is the book to help you choose the correct database technology at a time when concepts such as Big Data, NoSQL and NewSQL are making what used to be an easy choice into a complex decision with significant implications. The relational database (RDBMS) model completely dominated database technology for over 20 years. Today this "one size fits all" stability has been disrupted by a relatively recent explosion of new database technologies. These paradigm-busting technologies are powering the "Big Data" and "NoSQL" revolutions, as well as forcing fundamental changes in databases across the board. Deciding to use a relational database was once truly a no-brainer, and the various commercial relational databases competed on price, performance, reliability, and ease of use rather than on fundamental architectures. Today we are faced with choices between radically different database technologies. Choosing the right database today is a complex undertaking, with serious economic and technological consequences. Next Generation Databases demystifies today’s new database technologies. The book describes what each technology was designed to solve. It shows how each technology can be used to solve real word application and business problems. Most importantly, this book highlights the architectural differences between technologies that are the critical factors to consider when choosing a database platform for new and upcoming projects. Introduces the new technologies that have revolutionized the database landscape Describes how each technology can be used to solve specific application or business challenges Reviews the most popular new wave databases and how they use these new database technologies


Oracle Database 12c Backup and Recovery Survival Guide

Oracle Database 12c Backup and Recovery Survival Guide

Author: Francisco Munoz Alvarez

Publisher:

Published: 2013

Total Pages: 0

ISBN-13: 9781782171201

DOWNLOAD EBOOK

The book follows a tutorial-based approach, covering all the best practices for backup and recovery. The book starts by introducing readers to the world of backup and recovery, then moves on to teach them the new features offered by Oracle 12c. The book is full of useful tips and best practices that are essential for any DBA to perform backup and recovery operations in an organization.This book is designed for Oracle DBAs and system administrators. The reader will have a basic working experience of administering Oracle databases. This book is designed for Oracle DBAs and system administrators.This book will become a reference guide and will also help you to learn some new skills, and give you some new ideas you never knew about, helping you to easily find the solution to some of the most well-known problems you could encounter as DBAs.


Oracle Database Performance and Scalability

Oracle Database Performance and Scalability

Author: Henry H. Liu

Publisher: John Wiley & Sons

Published: 2011-11-22

Total Pages: 728

ISBN-13: 111805699X

DOWNLOAD EBOOK

The innovative performance and scalability features with each newer edition of the Oracle database system can present challenges for users. This book teaches software developers and students how to effectively deal with Oracle performance and scalability issues throughout the entire life cycle of developing Oracle-based applications. Using real-world case studies to deliver key theories and concepts, the book introduces highly dependable and ready-to-apply performance and scalability optimization techniques, augmented with Top 10 Oracle Performance and Scalability Features as well as a supplementary support website.


PeopleSoft for the Oracle DBA

PeopleSoft for the Oracle DBA

Author: David Kurtz

Publisher: Apress

Published: 2012-01-27

Total Pages: 548

ISBN-13: 9781430237075

DOWNLOAD EBOOK

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. Explains PeopleSoft’s technical architecture as it relates to Oracle Database Demonstrates how to instrument and measure the performance of PeopleSoft Provides techniques to troubleshoot and resolve performance problems


The Computer User's Survival Guide

The Computer User's Survival Guide

Author: Joan Stigliani

Publisher: "O'Reilly Media, Inc."

Published: 1995-10-01

Total Pages: 310

ISBN-13: 1449399673

DOWNLOAD EBOOK

You probably suspect, on some level, that computers might be hazardous to your health. You might vaguely remember a study that you read years ago about miscarriages being more frequent for data entry operators. Or you might have run into a co-worker wearing splints and talking ominously about Workers' Comp insurance. Or you might notice that when you use a computer too long, you get stiff and your eyes get dry.But who wants to worry about such things? Surely, the people wearing splints must be malingerers who don't want to work? Surely, the people who design keyboards and terminals must be working to change their products if they are unsafe? Surely, so long as you're a good worker and keep your mind on your job, nothing bad will happen to you?The bad news is: You can be hurt by working at a computer. The good news is that many of the same factors that pose a risk to you are within your own control. You can take action on your own to promote your own health -- whether or not your terminal manufacturer, keyboard designer, medical provider, safety trainer, and boss are working diligently to protect you.The Computer User's Survival Guide looks squarely at all the factors that affect your health on the job, including positioning, equipment, work habits, lighting, stress, radiation, and general health.Through this guide you will learn: a continuum of neutral postures that you can at utilize at different work tasks how radiation drops off with distance and what electrical equipment is responsible for most exposure how modern office lighting is better suited to working on paper than on a screen, and what you can do to prevent glare simple breathing techniques and stretches to keep your body well oxygenated and relaxed, even when you sit all day how reading from a screen puts unique strains on your eyes and what kind of vision breaks will keep you most productive and rested what's going on "under the skin" when your hands and arms spend much of the day mousing and typing, and how you can apply that knowledge to prevent overuse injuries The Computer User's Survival Guide is not a book of gloom and doom. It is a guide to protecting yourself against health risks from your computer, while boosting your effectiveness and your enjoyment of work.