Unix for Oracle DBAs Pocket Reference

Unix for Oracle DBAs Pocket Reference
Author: Donald K. Burleson
Publisher: "O'Reilly Media, Inc."
Total Pages: 111
Release: 2001-02-01
Genre: Computers
ISBN: 0596550545

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.

Unix for Oracle DBAs Pocket Reference

Unix for Oracle DBAs Pocket Reference
Author: Donald K. Burleson
Publisher: "O'Reilly Media, Inc."
Total Pages: 110
Release: 2001-02
Genre: Computers
ISBN: 0596529090

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.

Oracle DBA Checklists Pocket Reference

Oracle DBA Checklists Pocket Reference
Author: Quest Software
Publisher: "O'Reilly Media, Inc."
Total Pages: 82
Release: 2001-04-06
Genre: Computers
ISBN: 0596528833

Oracle database administration is a complex and stressful job. 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.The Oracle DBA Checklists Pocket Reference is divided into three major sections covering the main areas of an Oracle DBA's responsibilities: Database management. Describes how to maintain existing databases (with a checklist of daily, weekly, and monthly activities), prepare new databases for production, and back up and recover databases (with checklists for how to recover tables, data files, index files, control files, rollback segments, and active and inactive redo logs). Installation and configuration. Contains a summary of key procedures for installation on Unix, Windows NT, and VMS platforms. Also includes special steps for configuring a parallel database. Network management. Helps with installing, configuring, and testing Net8 software on server and client machines. Tasks include confirming network availability and Net8 connectivity, verifying Net8 name resolution, configuring Net8 clients (with LDAP or Oracle Names), configuring Net8 on the server, configuring the Multi-Threaded Server (MTS), tracing client connections, and tracing the Net8 listener. 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 DBA Automation Quick Reference

Oracle DBA Automation Quick Reference
Author: Charlie Russel
Publisher: Prentice Hall Professional
Total Pages: 296
Release: 2004
Genre: Computers
ISBN: 9780131403017

With concise coverage of both Oracle 9i and Oracle 10g, this is the ideal reference for the professional DBA on how to use Perl to automate database tasks. The book covers language selection and concepts, including basic scripting concepts.

Oracle Applications DBA Field Guide

Oracle Applications DBA Field Guide
Author: Paul Jackson
Publisher: Apress
Total Pages: 256
Release: 2006-11-22
Genre: Computers
ISBN: 1430201487

Expert guidance on administering the highly complex Oracle E-Business Suite Time-proven best practices Tried and tested scripts, notes, and references Covers all vital admin tasks, including configuration, monitoring, performance tuning, troubleshooting, and patching

Oracle Application Server 10g Essentials

Oracle Application Server 10g Essentials
Author: Rick Greenwald
Publisher: "O'Reilly Media, Inc."
Total Pages: 292
Release: 2004
Genre: Computers
ISBN: 9780596006211

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server.This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms and Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software.Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web caching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, the authors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server.More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, Oracle Application Server 10g Essentials offers Oracle application developers and administrators everything they need to know about this powerful server.

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference
Author: Mark Gurry
Publisher: "O'Reilly Media, Inc."
Total Pages: 113
Release: 2002-01-01
Genre: Computers
ISBN: 0596552130

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. Mark also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, Mark provides a number of handy SQL tuning tips. He discusses the various optimizer hints, telling you when they can be used to good effect. Finally, Mark discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.

Oracle DBA SQL Quick Reference

Oracle DBA SQL Quick Reference
Author: Charlie Russel
Publisher: Prentice Hall Professional
Total Pages: 566
Release: 2003
Genre: Computers
ISBN: 9780131403031

Covering the core of the day-to-day tasks most DBA's are responsible for, this is the perfect complement to all SQL tutorials available. The book also provides syntax diagrams and SQL commands in alphabetical order.

Tru64 UNIX-Oracle9i Cluster Quick Reference

Tru64 UNIX-Oracle9i Cluster Quick Reference
Author: Tim Donar
Publisher: Digital Press
Total Pages: 318
Release: 2002
Genre: Computers
ISBN: 9781555582722

The Tru64 UNIX-Oracle9i Cluster Quick Reference meets the needs of Tru64 UNIX system administrators everywhere. When a new UNIX server arrives, the sys adim installs and configures everything, using a wide variety of available books. The required information is not available in just one handy reference source. The relevant commands are now documented with clear examples without including every single option for every single command and it contains specifics on Oracle. The Oracle documentation has minimal information on specific platforms and most of the current documentation is not platform specific at all. This text covers only the most common practices and examples, so the task is greatly simplified.

TOAD Pocket Reference for Oracle

TOAD Pocket Reference for Oracle
Author: Jim McDaniel
Publisher: "O'Reilly Media, Inc."
Total Pages: 130
Release: 2002
Genre: Computers
ISBN: 9780596003371

TOAD -- the Tool for Oracle Application Developers -- is an enormously popular interactive environment for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. TOAD makes developers far more productive; using TOAD, you'll find that program changes that once took hours can now be completed in minutes. In addition to its development features, TOAD also provides extensive facilities for Oracle database administration. Coauthored by the TOADman and TOAD team, and Patrick McGrath of Quest Software, Inc., this pocket reference is a helpful companion for Oracle developers and DBAs. It's packed with quick-reference material: TOAD feature and menu summaries, shortcut keys, suggested changes to TOAD defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic TOAD components: the SQL Editor, Procedure Editor, Text Editor, SQL Modeler, Schema Browser, and Debugger. It also provides helpful hints on using TOAD to perform database administration and SQL tuning. Whether you're a new or experienced TOAD user, you'll find this quick reference an indispensable companion to the product and its online help files. Book jacket.