Oracle Initialization Parameters Pocket Reference

Oracle Initialization Parameters Pocket Reference
Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
Total Pages: 119
Release: 2004-08-25
Genre: Computers
ISBN: 0596007701
GET BOOK

Download Oracle Initialization Parameters Pocket Reference Book in PDF, Epub and Kindle

This quick reference covers database releases Oracle8i, Oracle 9i, and Oracle Database 10g. For each initialization parameter, the book includes a description, valid values, default, and whether it can be changed dynamically. It also describes the initialization file and server parameter file and provides hints for best performance. In addition to listing all parameters alphabetically, the book indicates the categories of parameters often set as a group to control different aspects of the database.

Oracle DBA Pocket Guide

Oracle DBA Pocket Guide
Author: David Kreines
Publisher: "O'Reilly Media, Inc."
Total Pages: 153
Release: 2005-08-08
Genre: Computers
ISBN: 0596100493
GET BOOK

Download Oracle DBA Pocket Guide Book in PDF, Epub and Kindle

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

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
GET BOOK

Download TOAD Pocket Reference for Oracle Book in PDF, Epub and Kindle

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.

Oracle DBA Checklists Pocket Reference

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

Download Oracle DBA Checklists Pocket Reference Book in PDF, Epub and Kindle

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

Oracle Data Dictionary Pocket Reference
Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
Total Pages: 147
Release: 2003-04-28
Genre: Computers
ISBN: 0596005172
GET BOOK

Download Oracle Data Dictionary Pocket Reference Book in PDF, Epub and Kindle

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).

Oracle DBA Automation Quick Reference

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

Download Oracle DBA Automation Quick Reference Book in PDF, Epub and Kindle

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 PL/SQL Language Pocket Reference

Oracle PL/SQL Language Pocket Reference
Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
Total Pages: 157
Release: 2004-04-06
Genre: Computers
ISBN: 0596006802
GET BOOK

Download Oracle PL/SQL Language Pocket Reference Book in PDF, Epub and Kindle

Provides quick-reference information that will help you use Oracle's PL/SQL languange, including the newest Oracle Database 10g features. This is a companion to Steven Feuerstein and Bill Pribyl's Oracle PL/SQL Programming.

Oracle PL/SQL Language

Oracle PL/SQL Language
Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
Total Pages: 132
Release: 2003
Genre: Computers
ISBN: 9780596004729
GET BOOK

Download Oracle PL/SQL Language Book in PDF, Epub and Kindle

This updated edition describes features available in Oracle9i, and provides a quick reference that summarizes PL/SQL syntax for every developer who uses PL/SQL for database programming.

Oracle Utilities Pocket Reference

Oracle Utilities Pocket Reference
Author: Sanjay Mishra
Publisher: "O'Reilly Media, Inc."
Total Pages: 125
Release: 2004-11-11
Genre: Computers
ISBN: 0596553056
GET BOOK

Download Oracle Utilities Pocket Reference Book in PDF, Epub and Kindle

The Oracle Utilities Pocket Reference is a handy, quick-reference guide to the multitude of Oracle utilities that database administrators (DBAs) use every hour of every day.As the undisputed leader among database products, Oracle is grasped conceptually by most DBAs. However, they understandably may not recall the specific utility to use for a given task, and, more commonly, won't in many cases remember the syntax to use. And that's exactly what the Oracle Utilities Pocket Reference supplies--the syntax and options for whatever utility a DBA needs to perform a given task.Some of the utilities documented in this guide include: SQL*Loader, for loading data expdp and exp for exporting data to another database oradebug for use in troubleshooting loadjava and dropjava for loading and unloading Java programs Packed with information in an easy-to-read format, this valuable resource is ideal for any experienced DBA. Even database programmers who deal with Oracle will truly appreciate having the Oracle Utilities Pocket Reference close at hand.Authored by Sanjay Mishra, a foremost authority on Oracle systems, this convenient and compact guide is focused and to-the-point, eliminating any potential guesswork or difficult memorization. The Oracle Utilities Pocket Reference is part of the strong-selling collection of O'Reilly "pocket reference" books.

Oracle SQL*Plus Pocket Reference

Oracle SQL*Plus Pocket Reference
Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
Total Pages: 154
Release: 2004-11-11
Genre: Computers
ISBN: 0596528906
GET BOOK

Download Oracle SQL*Plus Pocket Reference Book in PDF, Epub and Kindle

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQLPlus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQLPlus Specify SQLPlus commands and format elements Tune SQL queries The new third edition of this book has been updated for Oracle Database 10g to include information on both SQLPlus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQLPlus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.