Oracle Initialization Parameters Pocket Reference

Oracle Initialization Parameters Pocket Reference PDF Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596007701
Category : Computers
Languages : en
Pages : 119

Get Book Here

Book Description
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 Initialization Parameters Pocket Reference

Oracle Initialization Parameters Pocket Reference PDF Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596007701
Category : Computers
Languages : en
Pages : 119

Get Book Here

Book Description
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 PDF Author: David Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596100493
Category : Computers
Languages : en
Pages : 153

Get Book Here

Book Description
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 PDF Author: Jim McDaniel
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003371
Category : Computers
Languages : en
Pages : 130

Get Book Here

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

Oracle Data Dictionary Pocket Reference PDF Author: David C. Kreines
Publisher: "O'Reilly Media, Inc."
ISBN: 0596005172
Category : Computers
Languages : en
Pages : 147

Get Book Here

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

Oracle DBA Automation Quick Reference

Oracle DBA Automation Quick Reference PDF Author: Charlie Russel
Publisher: Prentice Hall Professional
ISBN: 9780131403017
Category : Database management
Languages : en
Pages : 296

Get Book Here

Book Description
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 PDF Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 0596006802
Category : Computers
Languages : en
Pages : 157

Get Book Here

Book Description
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 PDF Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596004729
Category : Computers
Languages : en
Pages : 132

Get Book Here

Book Description
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 PDF Author: Sanjay Mishra
Publisher: "O'Reilly Media, Inc."
ISBN: 0596553056
Category : Computers
Languages : en
Pages : 125

Get Book Here

Book Description
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 PDF Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 0596528906
Category : Computers
Languages : en
Pages : 154

Get Book Here

Book Description
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.

Oracle RMAN Pocket Reference

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

Get Book Here

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.