Share

Oracle DBA Pocket Guide

2005-08-08 Computers
Download Oracle DBA Pocket Guide PDF Online Free

Author :
Release : 2005-08-08
Genre : Computers
Kind : eBook
Book Rating : 493/5 ( reviews)

GET EBOOK


Book Synopsis Oracle DBA Pocket Guide by : David Kreines

Download or read book Oracle DBA Pocket Guide written by David Kreines. This book was released on 2005-08-08. Available in PDF, EPUB and Kindle. Book excerpt: A pocket guide that provides useful information about Oracle database administration including software options, installation and initialization, key concepts, and commands.

Oracle DBA Checklists Pocket Reference

2001-04-06 Computers
Download Oracle DBA Checklists Pocket Reference PDF Online Free

Author :
Release : 2001-04-06
Genre : Computers
Kind : eBook
Book Rating : 833/5 ( reviews)

GET EBOOK


Book Synopsis Oracle DBA Checklists Pocket Reference by : Quest Software

Download or read book Oracle DBA Checklists Pocket Reference written by Quest Software. This book was released on 2001-04-06. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Unix for Oracle DBAs Pocket Reference

2001-02 Computers
Download Unix for Oracle DBAs Pocket Reference PDF Online Free

Author :
Release : 2001-02
Genre : Computers
Kind : eBook
Book Rating : 090/5 ( reviews)

GET EBOOK


Book Synopsis Unix for Oracle DBAs Pocket Reference by : Donald K. Burleson

Download or read book Unix for Oracle DBAs Pocket Reference written by Donald K. Burleson. This book was released on 2001-02. Available in PDF, EPUB and Kindle. Book excerpt: 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.

SQL Pocket Guide

2004 Database management
Download SQL Pocket Guide PDF Online Free

Author :
Release : 2004
Genre : Database management
Kind : eBook
Book Rating : 122/5 ( reviews)

GET EBOOK


Book Synopsis SQL Pocket Guide by : Jonathan Gennick

Download or read book SQL Pocket Guide written by Jonathan Gennick. This book was released on 2004. Available in PDF, EPUB and Kindle. Book excerpt: 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

Oracle SQL Tuning Pocket Reference

2002-01-01 Computers
Download Oracle SQL Tuning Pocket Reference PDF Online Free

Author :
Release : 2002-01-01
Genre : Computers
Kind : eBook
Book Rating : 130/5 ( reviews)

GET EBOOK


Book Synopsis Oracle SQL Tuning Pocket Reference by : Mark Gurry

Download or read book Oracle SQL Tuning Pocket Reference written by Mark Gurry. This book was released on 2002-01-01. Available in PDF, EPUB and Kindle. Book excerpt: 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.

You may also like...