About this product: Oracle Applications DBA covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and troubleshooting of the application system. Embellished with over 350 screenshots and illustrations, it helps in administrating complex Oracle Database in an easy-to-navigate format. To help readers manage Oracle Applications without much difficulty, a comprehensive discussion on upgrading Oracle Applications in Unix environment has been provided. Further the book includes a balanced coverage of Oracle 11i and R12 – making it a must-have for experienced Oracle Applications DBAs. Professionals who are keen to migrate from DBA to Apps DBA profile would also find the book useful.
Administrators and managers as well as more advanced users will find plenty of hard facts for administering Oracle Applications in a work environment, but it's also quite portable and not the weighty tome you'd expect from such a survey.
— Midwest Book Review, California Bookwatch
Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux serversall in an easy reading and quick-to-navigate format.
Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Applications Release 12 and Fusion.
About this product: 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 recovery 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 SQL 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 networked databases, data warehouses, and VLDBs
Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more
SQL Server 2008 Administration isn't a standard SQL Server tutorial-there are dozens of those to choose from. Instead, this book breaks down the role of "SQL Server Administrator" into its key focus areas and tasks and details the techniques and best practices that make an administrator effective. In this book, a reader can quickly identify a task and find the best practice associated with it. For example, a reader looking for information about indexing would find step-by-step procedures for identifying and dropping unused indexes, creating missing indexes, selecting the appropriate clustered index, and so forth.
Each technique is presented in a clear, straightforward style and in the order of the typical lifecycle of a SQL Server system. This allows a reader to easily open the book at the appropriate page and focus on what you need to know for each specific situation.
While most techniques will work for all versions of SQL Server, this book is current for the recent final release of SQL Server 2008.
For power users, developers, IT pros, and anyone who manages SQL Server without formal DBA training.
Eric Johnson shows you how to perform every essential DBA task with SQL Server 2005 and SQL Server 2008, even if you’ve never had any DBA training. Learn at your own pace through realistic hands-on examples that walk you through every step!
SQL Server MVP and expert Eric Johnson is a database analyst who has spent many years working with Microsoft SQL Server. He is author of A Developer’s Guide to Data Modeling for SQL Server (Addison-Wesley, 2008) and the forthcoming Windows Essential Business Server 2008 Unleashed (Sams). Eric is currently the President of the Colorado Springs SQL Server Users Group.
“Are you an accidental DBA–out of the blue expected to run Microsoft SQL Server efficiently, reliably, and securely–when nobody ever taught you how? From installation to backup/restore, indexing to scheduling to memory management, expert Eric Johnson will give you all the personal, practical DBA training you’ll ever need!”
Looking for a better way to master today’s rapidly changing technologies? Want expert help, but don’t have the time or energy to read a book? Can’t find classroom training worth the money? Discover LiveLessons: self-paced, personal video instruction from the world’s leading technology experts.
LiveLessons are video courses, on DVD with a book supplement, that are organized into bite-sized, self-contained sessions–you’ll learn key skills in as little as fifteen minutes!
Each lesson begins with well-defined learning objectives and ends with comprehensive summaries, which help you track your progress.
Follow along as your trainer shows how to perform all the critical tasks needed to manage either SQL Server 2005 or SQL Server 2008
Eric Johnson, MCSE, MCDBA, MCSD, a database analyst for a Fortune 500 company, has spent many years working with Microsoft SQL Server. Honored by Microsoft as a SQL Server MVP, he has taught many SQL Server training classes, and is the President of the Colorado Springs SQL Server Users Group.
System Requirements
Operating System: Windows 98, 2000, XP, or Vista; Mac OS X; versions of Linux with the Flash 8 Player or later.
Multimedia: DVD drive, an 800x600 or higher display, and a sound card with speakers.
About this product: 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.
As a byproduct of its careful focus, the book is tiny. It almost fits in a shirt pocket, and is about as thick as a standard pencil. A typical entry documents a single command (there are separate entries for different operating systems when commands differ), and includes a bit of text followed by the relevant command and a listing of typical output. Utility scripts with Oracle relevance are listed with minimal comments. This isn't traditional man-page-style Unix documentation, but rather advice on how to accomplish various Oracle goals inside Unix. Most readers will likely turn first to the index to find the entries that they need. --David Wall
Topics covered: Making Oracle database management systems run well under HP-UX, Sun Solaris, IBM AIX, IRIX, and DEC Unix. Ways of examining and adjusting Oracle's use of processes, memory, processor cycles, files, disk resources, and other aspects of the Unix system. Information is presented in recipes, in type-this-to-do-that format.
About this product: Oracle DBA 101 offers a friendly place for budding Oracle professionals to learn critical database management skills. Refreshingly, the book's entertaining style doesn't preclude the authors from discussing advanced concepts.
The text opens with a discussion of everything an Oracle DBA is expected to do. It moves quickly into the particulars of the Oracle architecture, all the while maintaining a comfortable writing style that makes easy reading of material that is, because of its technical nature, very dry. It also includes excellent discussions of the valuable inner workings of Oracle such as the V$ views and tools such as the Optimizer and Explain Plan. This section, along with a later chapter on performance, provides techniques for diagnosing the causes of even mysterious performance symptoms. A chapter on backup and recovery is included, but it is fairly brief.
Oracle is a very complex product, and this book doesn't attempt to make a seasoned pro out of the reader. But it does provide a fine balance of big picture perspective and internal details to enable new DBAs to hit the ground running. --Stephen W. Plain
Topics covered: Database layout, installation and configuration, tablespaces, System Global Area, monitoring, DBA and V$ views, SQL*Plus overview, Optimizer, Explain Plan, TKPROF, Autotrace, performance tuning, backup and recovery.
Linux Recipes for Oracle DBAs is an example–based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task–oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done.
Takes you directly from problem to solution
Covers the “right” mix of Linux user and administration tasks for database administrators
Respects your time by being succinct and to–the–point
What you’ll learn
Execute Linux commands applicable to Oracle Database administration.
Write shell scripts to automate critical DBA tasks.
Monitor, tune, and optimize a Linux server to run Oracle Database.
Perform Linux system administration tasks relevant to Oracle Database.
Implement Oracle RAC on Linux.
Implement Oracle ASM on Linux.
Remotely (and securely!) manage Oracle on Linux.
Who is this book for?
Linux Recipes for Oracle DBAs is a book for Oracle database administrators who want to expertly operate Oracle databases on the Linux operating system. If you’re new to Linux, or are migrating from a Unix platform, or just want detailed solutions for tasks that Oracle DBAs perform on Linux servers, this book is for you.
About this product: 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.
About this product: Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.