Oracle Essentials: Oracle Database 12c

By Robert Stackowiak, Jonathan Stern

Written via Oracle insiders, this fundamental advisor distills an immense quantity of data concerning the Oracle Database into one compact quantity. excellent for beginner and skilled DBAs, builders, managers, and clients, Oracle Essentials walks you thru applied sciences and lines in Oracle’s product line, together with its structure, info constructions, networking, concurrency, and tuning.

Complete with illustrations and invaluable tricks, this 5th version presents a worthy one-stop evaluate of Oracle Database 12c, together with an creation to Oracle and cloud computing. Oracle Essentials offers the conceptual history you want to know how Oracle really works.

Topics include:

  • A whole evaluate of Oracle databases and knowledge shops, and Fusion Middleware items and features
  • Core innovations and buildings in Oracle’s structure, together with pluggable databases
  • Oracle items and a number of the datatypes Oracle supports
  • System and database administration, together with Oracle firm supervisor 12c
  • Security strategies, uncomplicated auditing services, and techniques for assembly compliance needs
  • Performance features of disk, reminiscence, and CPU tuning
  • Basic ideas of multiuser concurrency
  • Oracle’s on-line transaction processing (OLTP)
  • Data warehouses, colossal information, and Oracle’s enterprise intelligence tools
  • Backup and restoration, and excessive availability and failover solutions

Show description

Quick preview of Oracle Essentials: Oracle Database 12c PDF

Show sample text content

Either that set up and the install of Oracle Database 12c may be entire in lower than 20 mins. the present model of the Oracle common Installer starts the method by means of checking the objective atmosphere to ensure there are adequate assets for the Oracle Database. If the objective is a section mild, you can be knowledgeable with a caution and given the choice to proceed. sixty five As a part of the deploy procedure, the Installer additionally runs the web Configuration Assistant and the Database Configuration Assistant so you will prove with a operating Oracle example whilst the method is entire.

A thread of redo consists of redo log teams, that are composed of 1 or extra redo log contributors. Logically, you could examine a redo log staff as a unmarried redo logfile. besides the fact that, Oracle permits you to specify a number of copies of a redo log to guard the all-important integrity of the redo log. via developing a number of copies of every redo logfile, you shield the redo logfile from disk failure and different different types of failures. determine 2-5 illustrates a thread of redo with teams and individuals. The determine exhibits individuals in step with crew, with every one redo log reflected.

Bankruptcy 15 describes cloud definitions, the Oracle Database within the cloud, and the position of APEX. Appendix A lists the Oracle Database 12c adjustments defined during this publication. Appendix B lists numerous extra resources—both on-line and offline—so you are able to do extra distinct analyzing. Conventions utilized in This e-book the subsequent typographical conventions are utilized in this e-book: Italic Used for dossier and listing names, emphasis, and the 1st incidence of phrases consistent width Used for code examples and literals consistent width italic In code examples, exhibits a component (for instance, a parameter) that you just offer UPPERCASE as a rule shows Oracle key terms lowercase In code examples, usually exhibits user-defined goods equivalent to variables Preface | xvii This icon shows a tip, recommendation, or common notice.

With the discharge of Oracle Database 11g, Oracle recommended that you simply stream your saved outlines to SQL plan baselines. Now, as well as manually loading plans, Oracle could be set to instantly seize plan histories into those SQL plan baselines. incorporated during this accumulated background is the SQL textual content, define, bind variables, and compilation environ‐ ment. while a SQL assertion is compiled, Oracle will first use the cost-based optimizer to generate a plan and should review any matching SQL plan baselines for relative rate, selecting the plan with the bottom fee.

389 desk of Contents | xi Preface We devote this publication to the reminiscence of 1 of our unique coauthors, Jonathan Stern. Jonathan all at once passed on to the great beyond in March of 2007. but his reminiscence lives on for these folks who knew him and, in lots of methods, should you will learn this e-book. allow us to clarify. the unique define for this booklet used to be first assembled on the ubiquitous espresso store positioned within the Sears Tower in Chicago. It was once 1998 and the authors had accumulated there with a typical target. We have been all Oracle staff operating in technical revenues roles and had visited many businesses and firms.

Download PDF sample

Rated 4.07 of 5 – based on 24 votes