Author : David C. Kreines
Publisher : "O'Reilly Media, Inc."
Page : 428 pages
File Size : 10,48 MB
Release : 2000
Category : Computers
ISBN : 9781565926974
SQL (Structured Query Language), the heart of a relational database management system, is the language used to query the database, to create new tables in the database, to update and delete fields, and to set access privileges. Aimed at everyone who needs to access an Oracle database using SQL, including developers, DBAs, designers, and managers, this book delivers all the information they need to know about standard SQL, and Oracle's extensions to it.
Author : David Kreines
Publisher : O'Reilly Media, Incorporated
Page : 586 pages
File Size : 24,21 MB
Release : 1999-04-14
Category : Computers
ISBN : 9781565925168
Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.
Author : David Kreines
Publisher : "O'Reilly Media, Inc."
Page : 153 pages
File Size : 36,61 MB
Release : 2005-08-08
Category : Computers
ISBN : 0596100493
A pocket guide that provides useful information about Oracle database administration including software options, installation and initialization, key concepts, and commands.
Author : David C. Kreines
Publisher :
Page : pages
File Size : 38,54 MB
Release : 1999
Category :
ISBN :
Author : Arun Kumar
Publisher :
Page : 354 pages
File Size : 22,49 MB
Release : 2018-12-17
Category :
ISBN : 9781791856007
Learn the RDBMS concepts, database installation, and oracle database administration using different tools and utilities that will help you to administer, monitor any production database.Build strong foundation in database administration with this tutorial for absolute beginners- Oracle database installation- User connectivity and SQL execution- Oracle database architecture- Manual database creation- Tablespace and user administration- Oracle networking and utitlities- Oracle DBA is one of the highly stable jobs!Database Administrator is one of the highly sought after jobs in the IT industry. It is also one of the highly stable jobs as DATA is a vital part of every organization and they need that to be in the capable hands of a good DBA!Starting with the database architecture, this eBook will take you through database installation, basic administration, user administration, tablespace administration and more. By working on lab activities, you will establish a strong database administration skill.With the basic database administration knowledge, the eBook will take you through Oracle networking by teaching you how Oracle client and server connectivity is done, installation of Oracle client on windows, configuring tns entries and configuration of database listener.By completing Lab Activities, you will be able to work along with the author and learn database administration.
Author : Craig Mullins
Publisher : Addison-Wesley Professional
Page : 736 pages
File Size : 40,10 MB
Release : 2002
Category : Computers
ISBN : 9780201741292
Giving comprehensive, soup-to-nuts coverage of database administration, this guide is written from a platform-independent viewpoint, emphasizing best practices.
Author : Iggy Fernandez
Publisher : Dreamtech Press
Page : 466 pages
File Size : 14,70 MB
Release : 2009-03-06
Category :
ISBN : 9788184892161
Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.Part 1: Database ConceptsChapter 1: Relational Database Management SystemsChapter 2: SQL and PL/SQLChapter 3: Oracle ArchitecturePart II: Database ImplementationChapter 4: PlanningChapter 5: Software InstallationChapter 6: Database CreationChapter 7: Physical Database DesignChapter 8: User Management and Data LoadingPart III: Database SupportChapter 9: Taking ControlChapter 10: MonitoringChapter 11: Fixing ProblemsChapter 12: BackUpsChapter 13: RecoveryChapter 14: Database MaintenanceChapter 15: The Big Picture and the Ten DeliverablesPart IV: Database TuningChapter 16: Instance TuningChapter 17: SQL Tuning
Author : David C. Kreines
Publisher : "O'Reilly Media, Inc."
Page : 147 pages
File Size : 26,29 MB
Release : 2003-04-28
Category : Computers
ISBN : 1449366805
If you work with Oracle, then you don't need to be told that the data dictionary is large and complex, and grows larger with each new Oracle release. It's one of the basic elements of the Oracle database you interact with regularly, but the sheer number of tables and views makes it difficult to remember which view you need, much less the name of the specific column. Want to make it simpler? The Oracle Data Dictionary Pocket Reference puts all the information you need right at your fingertips. Its handy and compact format lets you locate the table and view you need effortlessly without stopping to interrupt your workOracle 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.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. 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.
Author : Sam Alapati
Publisher : Apress
Page : 1376 pages
File Size : 18,99 MB
Release : 2009-01-10
Category : Computers
ISBN : 1430210168
Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration. Tests and explains in detail key DBA commands. Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.
Author : Heidi Thorpe
Publisher : Addison-Wesley Professional
Page : 0 pages
File Size : 34,38 MB
Release : 2001
Category : Oracle (Computer file).
ISBN : 9780201704365
Poring over the 30 volumes of official Oracle documentation is a daunting task for any Oracle database administrator (DBA). "Oracle8iTM Tuning and Administration: The Essential Reference" distills the essentials of what you need to know to perform your job intelligently and skillfully. Bypassing obscure technical details, this book answers three essential questions for each topic listed below: What is it? Why is it important? How do I use it? Less experienced DBAs can now acquire the framework they need to understand important details in the Oracle documentation. Advanced DBAs will find this book a practical reference to effective configuration and troubleshooting. "Oracle8iTM Tuning and Administration" covers the major areas for which DBAs are typically responsible: administration, sizing and configuration, monitoring, and application and database tuning for better performance. In addition, the book reviews fundamental Oracle concepts and summarizes the newest features of Oracle8iTM. Specific topics covered include: Security and auditing Administering tables, views, constraints, indexes, data files, log files, and more Free space search algorithm Using database blocks efficiently Optimizing space management Partitioning Database, process, and object limits Monitoring events, usage, waits, and log files Query optimization hints SQL statement tuning Diagnosing performance problems and detecting runaway processes Tuning the operating system, CPU, memory, and disk I/O Tuning Private SQL and PL/SQL areas Tuning and initialization parameters New features for bitmapped indexes The new SAMPLE function Advanced queuing and sort improvements Online index creation, rebuild, and defragmentation Statistics generation for long-running operations Concise and thorough, with an easy-access format, "Oracle8iTM Tuning and Administration: The Essential Reference" is the Oracle resource you will keep close at hand.
