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.

Oracle DBA Pocket Guide

Author: David Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596100493
Category : Computers
Languages : en
Pages : 153

Book Description
A pocket guide that provides useful information about Oracle database administration including software options, installation and initialization, key concepts, and commands.

Oracle Regular Expressions Pocket Reference

Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 0596552491
Category : Computers
Languages : en
Pages : 67

Book Description
Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data.This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.

Oracle RMAN Pocket Reference

Author: Darl Kuhn
Publisher: "O'Reilly Media, Inc."
ISBN: 0596551991
Category : Computers
Languages : en
Pages : 121

Book Description
Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital.The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as: Implementing a recovery catalog Creating and running RMAN scripts Configuring input/output channels Taking a full database backup Backing up tablespaces and datafiles Taking incremental backups Recovering lost datafiles The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.

Oracle Database Administration for Microsoft SQL Server DBAs

Author: Michelle Malcher
Publisher: McGraw Hill Professional
ISBN: 0071744304
Category : Computers
Languages : en
Pages : 353

Book Description
Apply Your SQL Server DBA Skills to Oracle Database Administration 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. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard

Oracle SQL Tuning Pocket Reference

Author: Mark Gurry
Publisher: "O'Reilly Media, Inc."
ISBN: 0596552130
Category : Computers
Languages : en
Pages : 113

Book Description
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 Data Dictionary Pocket Reference

Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596005172
Category : Computers
Languages : en
Pages : 147

Book Description
Oracle Data Dictionary Pocket Reference gives DBAs and developers at any level quick and easy access to the data dictionary in Oracle's latest database, Oracle9i. This pocket-sized book provides a complete list of the most commonly used tables and views in the Oracle9i data dictionary, intelligently arranged for quick reference. It also includes column names and descriptions for each of the tables and views, as well as helpful tips, warnings, and usage examples. When you've reached a sticking point in your work and want to check your facts quickly, the Oracle Data Dictionary Pocket Reference is the book to have close by. (Midwest).

SQL Pocket Guide

Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596005122
Category : Database management
Languages : en
Pages : 164

Book Description
This pocket guide presents the most crucial information about SQL in a compact and easily accessible format, covering the four commonly used SQL variants--Oracle, IBM DB2, Microsoft SQL Server, and MySQL. Topics include: Data manipulation statements (SELECT, DELETE, INSERT, UPDATE, MERGE) and transaction control statements (START TRANSACTION, SAVEPOINT, COMMIT, ROLLBACK). Common SQL functions (date, numeric, math, trigonometric, string, conversion, aggregate) Such topics as literals, NULLs, CASE expressions, datatype conversion, regular expressions, grouping and summarizing data, joining tables, and writing queries (hierarchical, recursive, union, flashback) and subqueries. Instead of presenting complex and confusing syntax diagrams, the book teaches by example, showing the SQL statements and options that readers are most like to use. All example data is available on the O'Reilly web site. "If you need fast, accurate SQL information, with examples for multiple database engines, be sure to check out this book."--Chris Kempster, Senior DBA and author of SQL Server 2000 for the Oracle DBA, www.chriskempster.com

Linux Recipes for Oracle DBAs

Author: Darl Kuhn
Publisher: Apress
ISBN: 1430215755
Category : Computers
Languages : en
Pages : 521

Book Description
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 real application clusters on Linux. Implement Oracle automatic storage management on Linux. Remotely (and securely!) manage Oracle on Linux. Who this book is 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.

Oracle SQL*Plus

Author: Jonathan Gennick
Publisher: O'Reilly Media
ISBN:
Category : Computers
Languages : en
Pages : 104

Book Description
Despite the wide use of SQL *Plus, few developers and database administrators know how powerful it really is. And the syntax can sometimes be tricky. This portable guide provides a quick reference to subjects such as interacting with SQL *Plus, selecting data, formatting reports, writing scripting, and tuning SQL. There's also a command reference.