From bestselling comic-book franchise writer Charles Soule comes a clever and witty first novel of a twentysomething New Yorker who wakes up one morning with the power to predict the future—perfect for fans of Joe Hill and Brad Meltzer, or books like This Book Is Full of Spiders and Welcome to Night Vale.Knowledge is power. So when an unassuming Manhattan bassist named Will Dando awakens from a dream one morning with 108 predictions about the future in his head, he rapidly finds himself the most powerful man in the world. Protecting his anonymity by calling himself the Oracle, he sets up a heavily guarded Web site with the help of his friend Hamza to selectively announce his revelations. In no time, global corporations are offering him millions for exclusive access, eager to profit from his prophecies.He's also making a lot of high-powered enemies, from the President of the United States and a nationally prominent televangelist to a warlord with a nuclear missile and an assassin grandmother. Legions of cyber spies are unleashed to hack the Site—as it's come to be called—and the best manhunters money can buy are deployed not only to unmask the Oracle but to take him out of the game entirely. With only a handful of people he can trust—including a beautiful journalist—it's all Will can do to simply survive, elude exposure, and protect those he loves long enough to use his knowledge to save the world. Delivering fast-paced adventure on a global scale as well as sharp-witted satire on our concepts of power and faith, Marvel writer Charles Soule's audacious debut novel takes readers on a rollicking ride where it's impossible to predict what will happen next.
Published by: Harper Perennial | Publication date: 04/03/2018Kindle book details: Kindle Edition, 419 pages
The vast majority of Oracle SQL books discuss some syntax, provide the barest rudiments of using Oracle SQL, and perhaps include a few simple examples. It might be enough to pass a survey course, or give you some buzz words to drop in conversation with real Oracle DBAs. But if you use Oracle SQL on a regular basis, you want much more. You want to access the full power of SQL to write queries in an Oracle environment. You want a solid understanding of what's possible with Oracle SQL, creative techniques for writing effective and accurate queries, and the practical, hands-on information that leads to true mastery of the language. Simply put, you want useful, expert best practices that can be put to work immediately, not just non-vendor specific overview or theory.Updated to cover the latest version of Oracle, Oracle 10g, this edition of the highly regarded Mastering Oracle SQL has a stronger focus on technique and on Oracle's implementation of SQL than any other book on the market. It covers Oracle s vast library of built-in functions, the full range of Oracle SQL query-writing features, regular expression support, new aggregate and analytic functions, subqueries in the SELECT and WITH clauses, multiset union operators, enhanced support for hierarchical queries: leaf and loop detection, and the CONNECT_BY_ROOT operator, new partitioning methods (some introduced in Oracle9i Release 2), and the native XML datatype, XMLType.Mastering Oracle SQL, 2nd Edition fills the gap between the sometimes spotty vendor documentation, and other books on SQL that just don't explore the full depth of what is possible with Oracle-specific SQL. For those who want to harness the untapped (and often overlooked) power of Oracle SQL, this essential guide for putting Oracle SQL to work will prove invaluable.
Published by: O'Reilly Media | Publication date: 06/22/2004Kindle book details: Kindle Edition, 496 pages
Even psychics have their blind spots.What would you do if you could see the future?Diana Hawthorne can do just that. Every day she delves into personal prophecies, giving guidance to all the poor souls knocking at her door. There's a catch; while she helps others see where they've been, and to know where they're going…she has no recollection of her own beginnings. Nothing before the age of twenty-four holds residency in her mind.Then she meets a cocky, self-assured private investigator and takes an immediately disliking to him. But more than that, he’s the first person in all her existence who she can’t read—and she’s been around a long time. Everything about him is a complete void and she’s not sure if it’s blissful or completely annoying. Fate intervenes, putting Diana in his path as she helps him solve a missing girl case.As pieces begin to fall in and out of place, Diana is forced to make a decision that could unlock her memory but unravel her world.***Oracle can be read separately or in conjunction with The Final Five novelette found exclusively in the Angels & Magic Boxed Set available to download now!Diana Hawthorne is a breed of her own—a snarky protagonist who cares, but has been around too long to give a shit. If you're a reader who loves witty banter and ironic, sardonic humor—this is the book for you.Purchase Oracle today and be prepared for a uniquely funny, thought provoking kind of psychic mystery.
Publication date: 06/21/2018Kindle book details: Kindle Edition, 245 pages
Take the right steps when a breach of your Oracle Database environment becomes known or suspected. You will learn techniques for discerning how an attacker got in, what data they saw, and what else they might have done. This book helps you understand forensics in relation to Oracle Database, and the tools and techniques that should be used to investigate a database breach. You will learn the measures to put in place now to make it harder for an attack to be successful, and to aid in the detection and investigation of future attacks. You will know how to bring together tools and methods to create a holistic approach and investigation when an event occurs, helping you to be confident of your ability to react correctly and responsibly to threats against your organization’s data. What You'll LearnDetect when breaches have or may have occurredReact with confidence using an organized planDetermine whether a suspected breach is real Determine the scope of data that has been compromisedPreserve evidence for possible criminal prosecutionsPut in place measures to aid future investigationsWho This Book is ForDatabase administrators, system administrators, and other technology professionals who may be called upon to investigate breaches of security involving Oracle Database
Published by: Apress | Publication date: 11/28/2017Kindle book details: Kindle Edition, 199 pages
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.
Publication date: 01/04/2016Kindle book details: Kindle Edition, 199 pages
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/2014Kindle book details: Kindle Edition, 1392 pages
Master the Cutting-Edge Features of Oracle Database 12c Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions.
- Set up Oracle Database 12c or upgrade from an earlier version
- Design Oracle databases and plan for application implementation
- Construct SQL and SQL*Plus statements and execute powerful queries
- Secure data with roles, privileges, virtualization, and encryption
- Move data with SQL*Loader and Oracle Data Pump
- Restore databases using flashback and the Oracle Database Automatic Undo Management feature
- Build and deploy PL/SQL triggers, procedures, and packages
- Work with Oracle pluggable and container databases
- Develop database applications using Java, JDBC, and XML
- Optimize performance with Oracle Real Application Clusters
Published by: McGraw-Hill Education | Publication date: 08/05/2013Kindle book details: Kindle Edition, 1472 pages
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
Published by: For Dummies | Publication date: 10/24/2013Kindle book details: Kindle Edition, 435 pages
Master Oracle Database 12c Release 2 testing and tuning Seamlessly transition to Oracle Database 12c Release 2 and achieve peak performance using the step-by-step instruction and best practices contained in this Oracle Press guide. Written by a team of Oracle ACEs, Oracle Database 12c Release 2 Testing Tools and Techniques for Performance and Scalability clearly explains how to identify, investigate, and resolve performance issues. You will discover how to use troubleshooting tools and test rigs, optimize code and queries, evaluate database performance, perform realistic application testing, capture and replay actual production workloads, and employ Oracle Database In-Memory. •Establish benchmarks and evaluate application workload performance •Configure and deploy SQL Tuning Advisor and SQL Access Advisor •Maximize efficiency using Oracle Database In-Memory and In-Memory Advisor •Identify and repair poorly running code with SQL Monitor •Uncover database problems using Real-Time ADDM and Emergency Monitoring •Work with database workload capture and replay •Analyze third-party code with Workload Intelligence •Identify database objects that will benefit most from In-Memory Column Store (IMCS) •Monitor and manage IMCS objects with In-Memory Central
Published by: McGraw-Hill Education | Publication date: 10/05/2017Kindle book details: Kindle Edition, 432 pages
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/2013Kindle book details: Kindle Edition, 432 pages