PDF about oracle: 1 to 10 of 100 results fetched - page 1 [an]

Oracle - Sunken Earth (Volume 1)

Oracle - Sunken Earth (Volume 1)

https://www.amazon.com/Oracle-Sunken-Earth-C-W-Trisef-ebook/...
Fall, current day, Atlantic Ocean. Another hurricane tears through the Bahamas, headed for Florida. Among the wreckage: a U.S. Coast Guard rescue boat, one survivor (Ret Cooper), and a spherical object of curious design (the Oracle).Ret Cooper is a simple young man with mysterious origins, unique physical features, and no memory of his past. His new family and friends discover he is truly extraordinary, with supernatural powers and strange scars on the palms of his hands. But what is his destiny?The Oracle is the key to Earth's unity and full potential, too perfect to be man-made. Legend claims it can unleash limitless power when filled with Mother Nature's six, pure, original elements. But where are these elements? And which of our planet’s ancient secrets will be explained in the process of locating them?The first book from new author C.W. Trisef will have you cheering for Ret as he travels a submerged road, discovers a lost city, climbs an electrifying mountain, and begins to unravel the mystery of the Oracle...all during his first year of high school.
Author: C.W. Trisef
Published by: BookBaby | Publication date: 06/01/2011
Kindle book details: Kindle Edition, 348 pages
Oracle SQL Performance Tuning and Optimization: Its all about the Cardinalities

Oracle SQL Performance Tuning and Optimization: Its all about the Cardinalities

https://www.amazon.com/Oracle-Performance-Tuning-Optimizatio...
After 30 years of working with the Oracle Database, this Expert teaches SQL Tuning to the masses. Not a book of quick tips or rare oddities, these pages teach real knowledge. They present a practical process for tuning badly performing SQL that works reliably in the real world of the Oracle Professional. Refined and Distilled to save you years of the hard grinding everyone else had to go through to learn how to do it, these pages will teach you:- The Power of Cardinalities (Estimated Cardinality, Actual Cardinality, Table Cardinality, Cardinality Feedback)- The Importance of Driving Table and Join Order (Join Sentence, Join Tree, Query Diagram, Query Data Model)- The use of Query Decomposition and Reconstruction in localizing the problem component of a query- How to construct a Filtered Rows Percentage Spreadsheet to learn if a query got off to a good start- How to extract useful information from Oracle Query Execution Plans (Query Modification, Cardinality Estimation, Fetch Efficiency, Join Efficiency)- How to build indexes and evaluate their value to a specific problem query (DUNSEL Columns, Inequality Predicates, Column Modification, Column Order, Predicate Selectivity)- How to build the proper set of indexes for specific problem queries when necessary using a formal process (ACCESS, FILTER, COVERAGE, POST-TABLE FILTERING, Indexing for a Driving Table, Indexing for an Inner Table in a Join)- How to make joins go faster, particularly Hash Join (2% Rule, Precision Query vs. Warehouse Query, Most Common Join Failures Scenarios, Tuning the Hash Join)- How to use hints as a discovery tool instead of a club- The Absolute Necessity of Good Database Design in Assuring top Performance (Modeling Paradigm, 3rd Normal Form, SQL Workload Types (OLTP, DSS, Analytic), Fundamentals of Statistics (NDV, Uniform Distribution, Dependence, Dynamic Sampling), Addressing Statistics Problems (Staleness, Skew, Dependence, Defaulting, Out-of-Bounds, Transiency, Bloat)- Opening Moves used in the trenches for quick diagnosis under pressure (The Typical Crisis Meeting, Query Analysis Breakdown, Three Kinds of Row Counts, Types of QEP Plan Steps, Questions used to Guide the Analysis)- As a bonus, a special chapter offers unique perspective on EXADATA and how to position yourself to exploit its opportunities as a Developer or DBA (Sales Pitch vs. Reality, How much faster will your Apps go?, 40X Speed Up?, SMARTSCAN, Column Projection, Row Filtering, iDB Messaging, Storage Indexes, Bloom Filters, What sours the Secret Sauce, EXADATA's effect on your Applications, NON-EXADATA query costs, Reality of Hybrid Columnar Compression, The Three Compression Strategies, Where you the Oracle Professional can be Unique)- How to document your work in a ways that let you show others how good you are and teach them how to tune tooSupported by a dozen of Kevin's powerful SQL scripts that make it much easier for you to succeed, you will learn and apply the knowledge and processes found in this book and soon be recognized as one of your company's top SQL Tuning Technicians.
Author: Kevin Meade
Publication date: 01/04/2016
Kindle book details: Kindle Edition, 348 pages
Oracle PL/SQL: Programming Fundamentals

Oracle PL/SQL: Programming Fundamentals

https://www.amazon.com/Oracle-PL-SQL-Programming-Fundamental...
PL/SQL, integrated with the Oracle database, is the procedural extension of SQL. This book is for PL/SQL beginners. When they finish reading the book and trying its examples, they would have equipped themselves with basic PL/SQL skills to start writing PL/SQL programs in a real-world development project.
Publication date: 04/06/2014
Kindle book details: Kindle Edition, 131 pages
Oracle Essentials: Oracle Database 12c

Oracle Essentials: Oracle Database 12c

https://www.amazon.com/Oracle-Essentials-Database-12c-ebook/...
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning.Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works.Topics include:
  • A complete overview of Oracle databases and data stores, and Fusion Middleware products and features
  • Core concepts and structures in Oracle’s architecture, including pluggable databases
  • Oracle objects and the various datatypes Oracle supports
  • System and database management, including Oracle Enterprise Manager 12c
  • Security options, basic auditing capabilities, and options for meeting compliance needs
  • Performance characteristics of disk, memory, and CPU tuning
  • Basic principles of multiuser concurrency
  • Oracle’s online transaction processing (OLTP)
  • Data warehouses, Big Data, and Oracle’s business intelligence tools
  • Backup and recovery, and high availability and failover solutions
Published by: O'Reilly Media | Publication date: 09/06/2013
Kindle book details: Kindle Edition, 432 pages
Oracle 12c For Dummies

Oracle 12c For Dummies

https://www.amazon.com/Oracle-12c-Dummies-Chris-Ruel-ebook/d...
Demystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world’s largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world.
  • Highlights the important features of Oracle 12c
  • Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database
  • Covers advanced Oracle 12c technologies including Oracle Multitenant—the "pluggable database" concept—as well as several other key changes in this release
Make the most of Oracle 12c's improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.
Author: Chris Ruel
Published by: For Dummies | Publication date: 10/24/2013
Kindle book details: Kindle Edition, 435 pages
Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c

Oracle PL/SQL Programming: Covers Versions Through Oracle Database 12c

https://www.amazon.com/Oracle-PL-SQL-Programming-Versions-eb...
Considered the best Oracle PL/SQL programming guide by the Oracle community, this definitive guide is precisely what you need to make the most of Oracle’s powerful procedural language. The sixth edition describes the features and capabilities of PL/SQL up through Oracle Database 12c Release 1.Hundreds of thousands of PL/SQL developers have benefited from this book over the last twenty years; this edition continues that tradition. With extensive code examples and a lively sense of humor, this book explains language fundamentals, explores advanced coding techniques, and offers best practices to help you solve real-world problems.
  • Get PL/SQL programs up and running quickly, with clear instructions for executing, tracing, testing, debugging, and managing code
  • Understand new 12.1 features, including the ACCESSIBLE_BY clause, WITH FUNCTION and UDF pragma, BEQUEATH CURRENT_USER for views, and new conditional compilation directives
  • Take advantage of extensive code samples, from easy-to-follow examples to reusable packaged utilities
  • Optimize PL/SQL performance with features like the function result cache and Oracle utilities such as PL/Scope and the PL/SQL hierarchical profiler
  • Build modular, easy-to-maintain PL/SQL applications using packages, procedures, functions, and triggers
Published by: O'Reilly Media | Publication date: 01/23/2014
Kindle book details: Kindle Edition, 1392 pages
Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2

Oracle Database Upgrade and Migration Methods: Including Oracle 12c Release 2

https://www.amazon.com/Oracle-Database-Upgrade-Migration-Met...
Learn all of the available upgrade and migration methods in detail to move to Oracle Database version 12c. You will become familiar with database upgrade best practices to complete the upgrade in an effective manner and understand the Oracle Database 12c patching process.So it’s time to upgrade Oracle Database to version 12c and you need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. You will be aware of the practical issues and proactive measures to take to upgrade successfully and reduce unexpected issues. With every release of Oracle Database there are new features and fixes to bugs identified in previous versions. As each release becomes obsolete, existing databases need to be upgraded. Oracle Database Upgrade and Migration Methods explains each method along with its strategy, requirements, steps, and known issues that have been seen so far. This book also compares the methods to help you choose the proper method according to your constraints.Also included in this book:
  • Pre-requisite patches and pre-upgrade steps
  • Patching to perform changes at the binary and database level to apply bug fixes
What You Will Learn:
  • Understand the need and importance of database upgrading and migration
  • Be aware of the challenges associated with database upgrade decision making
  • Compare all upgrade/migration methods
  • Become familiar with database upgrade best practices and recommendations
  • Understand database upgrade concepts in high availability and multi-tenant environments
  • Know the database downgrade steps in case the upgraded database isn’t compatible with the environment
  • Discover the features and benefits to the organization when it moves from the old database version to the latest database version
  • Understand Oracle 12c patching concepts
Who This Book Is For:Core database administrators, solution architects, business consultants, and database architects
Published by: Apress | Publication date: 03/01/2017
Kindle book details: Kindle Edition, 610 pages
Oracle Cheat Sheet

Oracle Cheat Sheet

https://www.amazon.com/Oracle-Cheat-Sheet-Cobin-Rox-ebook/dp...
Commonly used but easily forgotten Oracle commands in an easy cheat sheet format.
Author: Cobin Rox
Publication date: 10/17/2012
Kindle book details: Kindle Edition, 60 pages
Oracle Database 12c PL/SQL Programming

Oracle Database 12c PL/SQL Programming

https://www.amazon.com/Oracle-Database-12c-SQL-Programming-e...
Master Oracle Database 12c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.
  • Explore new SQL and PL/SQL features in Oracle Database 12c
  • Build control structures, cursors, and loop statements
  • Work with collections, varrays, tables, and associative array collections
  • Locate and repair errors and employ exception handlers
  • Execute black box, white box, and integration tests
  • Configure and manage stored packages and libraries
  • Handle security with authentication and encryption
  • Use LOBs to store text and multimedia content
  • Write and implement PL/SQL and Java triggers
  • Extend functionality using dynamic SQL statements
  • Understand object types, nested tables, and unnesting queries
Published by: McGraw-Hill Education | Publication date: 02/07/2014
Kindle book details: Kindle Edition, 1192 pages
Oracle Database 12c Release 2 Multitenant (Oracle Press)

Oracle Database 12c Release 2 Multitenant (Oracle Press)

https://www.amazon.com/Oracle-Database-Release-Multitenant-P...
Master the Powerful Multitenant Features of Oracle Database 12c Govern a scalable, extensible, and highly available enterprise database environment using the practical information contained in this Oracle Press guide. Written by a team of Oracle Masters, Oracle Database 12c Release 2 Multitenant shows, step-by-step, how to deploy and manage multitenant configurations across IT frameworks of all types and sizes. Find out how to create databases, work with PDBs and CDBs, administer Oracle Net Services, and automate administrative tasks. Backup and recovery, security, and advanced multitenant options are covered in complete detail. Learn how to: • Build high-performance multitenant Oracle databases• Create single-tenant, multitenant, and application containers• Establish network connections and manage services• Handle security using authentication, authorization, and encryption• Back up and restore your mission-critical data• Work with point-in-time recovery and Oracle Flashback• Move data and replicate and clone databases• Work with Oracle’s Resource Manager and Data Guard
Published by: McGraw-Hill Education | Publication date: 09/30/2016
Kindle book details: Kindle Edition, 416 pages
[1] 2345Next
PDFfetch