Oracle 11g

Author : Kevin Loney
Publisher : McGraw Hill Professional
Page : 1369 pages
File Size : 51,6 Mb
Release : 2008-10-15
Category : Computers
ISBN : 9780071598767

Get Book

Oracle Database 11g The Complete Reference by Kevin Loney Pdf

The Definitive Guide to Oracle Database 11g Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included. Install Oracle Database 11g or upgrade from an earlier version Create database tables, sequences, indexes, views, and user accounts Construct SQL statements, procedures, queries, and subqueries Optimize security using virtual private databases and transparent data encryption Import and export data using SQL*Loader and Oracle Data Pump Use SQL replay, change management, and result caching Avoid human errors using flashback and automatic undo management Build and tune PL/SQL triggers, functions, and packages Develop database applications using Java, JDBC, and XML Optimize availability and scalability with Oracle Real Application Clusters

Author : Joan Casteel
Publisher : Course Technology
Page : 608 pages
File Size : 53,6 Mb
Release : 2014-06-25
Category : Computers
ISBN : 1305268024

Get Book

Oracle 11G by Joan Casteel Pdf

ORACLE 11G: SQL is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.

Author : Ignatius Fernandez
Publisher : Apress
Page : 448 pages
File Size : 47,6 Mb
Release : 2009-03-25
Category : Computers
ISBN : 9781430206286

Get Book

Beginning Oracle Database 11g Administration by Ignatius Fernandez Pdf

This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible.

Author : Michael McLaughlin
Publisher : McGraw Hill Professional
Page : 865 pages
File Size : 53,5 Mb
Release : 2008-04-19
Category : Computers
ISBN : 9780071643566

Get Book

Oracle Database 11g PL/SQL Programming by Michael McLaughlin Pdf

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit

Author : Kevin Loney
Publisher : McGraw Hill Professional
Page : 1393 pages
File Size : 53,9 Mb
Release : 2004-09-28
Category : Computers
ISBN : 9780071770491

Get Book

Oracle Database 10g The Complete Reference by Kevin Loney Pdf

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.

Author : Brian Carr,John Garmany,Lutz Hartmann,V. J. Jain,Steve Karam
Publisher : Rampant TechPress
Page : 480 pages
File Size : 50,6 Mb
Release : 2008
Category : Database management
ISBN : 9780979795107

Get Book

Oracle 11g New Features by Brian Carr,John Garmany,Lutz Hartmann,V. J. Jain,Steve Karam Pdf

Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs and Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager.

Author : Ian Abramson,Michael Abbey,Michael J. Corey
Publisher : McGraw Hill Professional
Page : 417 pages
File Size : 51,7 Mb
Release : 2004-04-21
Category : Computers
ISBN : 9780071706773

Get Book

Oracle Database 10g: A Beginner's Guide by Ian Abramson,Michael Abbey,Michael J. Corey Pdf

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

Author : Emre Baransel
Publisher : Packt Publishing Ltd
Page : 695 pages
File Size : 52,6 Mb
Release : 2013-01-01
Category : Computers
ISBN : 9781849687911

Get Book

Oracle Data Guard 11gR2 Administration Beginner's Guide by Emre Baransel Pdf

Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you'll be able to easily follow the book.

Author : Chris Zeis,Chris Ruel,Michael Wessler
Publisher : John Wiley & Sons
Page : 410 pages
File Size : 44,8 Mb
Release : 2009-02-10
Category : Computers
ISBN : 9780470465073

Get Book

Oracle 11g For Dummies by Chris Zeis,Chris Ruel,Michael Wessler Pdf

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Author : April C. Sims
Publisher : Packt Publishing Ltd
Page : 454 pages
File Size : 49,6 Mb
Release : 2010-04-08
Category : Computers
ISBN : 9781849680011

Get Book

Oracle Database 11G - Underground Advice for Database Administrators by April C. Sims Pdf

A real-world DBA survival guide for Oracle 11g database implementations with this book and eBook.

Author : Sam Alapati,Darl Kuhn,Bill Padfield
Publisher : Apress
Page : 584 pages
File Size : 46,5 Mb
Release : 2011-10-18
Category : Computers
ISBN : 9781430236634

Get Book

Oracle Database 11g Performance Tuning Recipes by Sam Alapati,Darl Kuhn,Bill Padfield Pdf

Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 11g Performance Tuning Recipes delivers. Oracle Database 11g Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book. Provides proven solutions to real-life Oracle performance problems Offers relevant background and theory to support each solution Written by a team of experienced database administrators successful in their careers

Author : Richard Niemiec
Publisher : McGraw Hill Professional
Page : 1010 pages
File Size : 55,7 Mb
Release : 2007-07-16
Category : Computers
ISBN : 9780071596435

Get Book

Oracle Database 10g Performance Tuning Tips & Techniques by Richard Niemiec Pdf

"Offers hundreds of hints, tips, and tricks of the trade that can be useful to any DBA wanting to achieve maximum performance of Oracle applications. No Oracle library would be complete without this book." --Ken (Dr. DBA) Jacobs, Vice President of Product Strategy for Server Technologies, Oracle Corporation "Rich is the first and last stop for Oracle Database technology and performance tuning. His knowledge is a vital tool that you need to successfully negotiate the waters of Oracle database development." --Mike Frey, Principal Architect, Navteq

Author : Technologies Cadcim
Publisher : Pearson Education India
Page : 512 pages
File Size : 50,9 Mb
Release : 2010-09
Category : Electronic
ISBN : 8131732142

Get Book

Oracle 11G: With Pl/Sql Approach by Technologies Cadcim Pdf

Author : Darl Kuhn,Sam Alapati,Bill Padfield
Publisher : Apress
Page : 264 pages
File Size : 51,5 Mb
Release : 2012-03-23
Category : Computers
ISBN : 9781430237365

Get Book

Expert Indexing in Oracle Database 11g by Darl Kuhn,Sam Alapati,Bill Padfield Pdf

Expert Indexing in Oracle Database 11g is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer. Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Indexing in Oracle Database 11g helps by bringing together information indexing and how to use it into one, convenient and blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indices available and when each is best applied. Recognize when queries aren’t using indices as you intend. Manage your indexing for maximum performance. Let Expert Indexing in Oracle Database 11g be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database. Explains how indices work, how they help, and how they hinder Demystifies the various index choices Describes the database administration chores associated with indices

Author : Kogent Solutions Inc.
Publisher : Dreamtech Press
Page : 268 pages
File Size : 55,7 Mb
Release : 2008-06
Category : Electronic
ISBN : 8177228544

Get Book

Oracle 11G Administration In Simple Steps by Kogent Solutions Inc. Pdf

This book contains the step by step information about the Oracle 11g database Administration. This book is for you if you are familiar with SQL and are looking for a book that effectively explains the concepts of the Oracle 11g database Administration. It gives the core information about administrating the Oracle 11g database using the new and improved Enterprise Manager GUI. The book contains lots of examples and helps you to perform the Oracle 11g administration in an easier way. You will also find information about the Grid Architecture in this book.