Oracle Database 10g DBA Handbook

Oracle Database 10g DBA Handbook
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 737
Release: 2005-04-14
Genre: Computers
ISBN: 0071770437

Download Oracle Database 10g DBA Handbook Book in PDF, Epub and Kindle

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Oracle Database 12c DBA Handbook

Oracle Database 12c DBA Handbook
Author: Bob Bryla
Publisher: McGraw Hill Professional
Total Pages: 745
Release: 2015-07-03
Genre: Computers
ISBN: 007179879X

Download Oracle Database 12c DBA Handbook Book in PDF, Epub and Kindle

The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online

Oracle DBA Guide to Data Warehousing and Star Schemas

Oracle DBA Guide to Data Warehousing and Star Schemas
Author: Bert Scalzo
Publisher: Prentice Hall Professional
Total Pages: 236
Release: 2003
Genre: Computers
ISBN: 9780130325846

Download Oracle DBA Guide to Data Warehousing and Star Schemas Book in PDF, Epub and Kindle

The ultimate reference guide to successful implementation of star schemas within Oracle data warehouses, this edition also covers Oracle 8i and Oracle 9i with real-world examples, sample code and benchmarks to illustrate key concepts.

Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs
Author: Michelle Malcher
Publisher: McGraw Hill Professional
Total Pages: 353
Release: 2010-10-06
Genre: Computers
ISBN: 0071744304

Download Oracle Database Administration for Microsoft SQL Server DBAs Book in PDF, Epub and Kindle

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 DBA Handbook

Oracle DBA Handbook
Author: Kevin Loney
Publisher: McGraw-Hill Companies
Total Pages: 714
Release: 1994
Genre: Computers
ISBN:

Download Oracle DBA Handbook Book in PDF, Epub and Kindle

This handbook is ideal for all new and experienced database administrators who need to learn to manage a networked Orcale database system efficiently and effectively. The book opens with database architecture and setting up a database, before covering management and supporting packages. Readers will find a command reference, configuration guidelines, plus scripts and tips to help them set up a database. (Database Management)

Oracle Database 11g DBA Handbook

Oracle Database 11g DBA Handbook
Author: Bob Bryla
Publisher: McGraw Hill Professional
Total Pages: 698
Release: 2007-12-27
Genre: Computers
ISBN: 0071595791

Download Oracle Database 11g DBA Handbook Book in PDF, Epub and Kindle

The Essential Resource for Oracle DBAs--Fully Updated and Expanded Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces Optimize disk allocation, CPU usage, I/O throughput, and SQL queries Develop powerful database management applications Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import Work with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

Oracle Database 11g & MySQL 5.6 Developer Handbook

Oracle Database 11g & MySQL 5.6 Developer Handbook
Author: Michael McLaughlin
Publisher: McGraw-Hill Prof Med/Tech
Total Pages: 610
Release: 2011-09-30
Genre: Computers
ISBN: 0071768858

Download Oracle Database 11g & MySQL 5.6 Developer Handbook Book in PDF, Epub and Kindle

Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories

PeopleSoft for the Oracle DBA

PeopleSoft for the Oracle DBA
Author: David Kurtz
Publisher: Apress
Total Pages: 540
Release: 2012-03-02
Genre: Computers
ISBN: 1430237082

Download PeopleSoft for the Oracle DBA Book in PDF, Epub and Kindle

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. Explains PeopleSoft’s technical architecture as it relates to Oracle Database Demonstrates how to instrument and measure the performance of PeopleSoft Provides techniques to troubleshoot and resolve performance problems

Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition

Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition
Author: K Gopalakrishnan
Publisher: McGraw Hill Professional
Total Pages: 546
Release: 2011-08-10
Genre: Computers
ISBN: 0071752625

Download Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition Book in PDF, Epub and Kindle

Master Oracle Real Application Clusters Maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition has been fully revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, optimize data integrity, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide. Install and configure Oracle Real Application Clusters Configure and manage diskgroups using Oracle Automatic Storage Management Work with services, voting disks, and Oracle Clusterware Repository Look under the hood of the Cache Fusion and Global Resource Directory operations in Oracle Real Applications Clusters Explore the internal workings of backup and recovery in Oracle Real Application Clusters Employ workload balancing and the Transparent Application Failover feature of an Oracle database Get complete coverage of Stretch Clusters, also known as Metro Clusters Troubleshoot Oracle Clusterware using the most advanced diagnostics available Develop custom Oracle Real Application Clusters applications

Oracle Database 10g The Complete Reference

Oracle Database 10g The Complete Reference
Author: Kevin Loney
Publisher: McGraw Hill Professional
Total Pages: 1393
Release: 2004-09-28
Genre: Computers
ISBN: 0071770496

Download Oracle Database 10g The Complete Reference Book in PDF, Epub and Kindle

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.