Have one to sell?

Flip to back Flip to front

Listen Playing... Paused You're listening to a sample of the Audible audio edition.
Learn more

See this image

Oracle Database 11g R2: Architecture & Internals

by Sideris (Author)

1.0 1 rating

See all formats and editions

Price

New from

Used from

Paperback, April 15, 2011

"Please retry"

—

Paperback
—

Success in database administration and tuning, or in the development of database applications, depends upon having a sufficient understanding of the architecture and internal mechanisms which operate within the database. Without such an understanding, one could implement such things as structural changes, performance tuning adjustments and other modifications to the environment which could actually be counterproductive. The purpose of this unique and popular Oracle 11g training course is to reveal the underlying architecture of the Oracle database environment. This course is also intended to be of help to information technology (IT) managers and executives who require an understanding of the technology upon which they and their staff rely. This course is often used in combination with other advanced Oracle database administration or database developer courses to provide the prerequisite foundation in the architecture of the database. Major objectives covered within this training guide include: - Understanding the broader Oracle enterprise architecture, including the client, middleware and database tiers found within a multi-tiered enterprise environment; - Understand key computing concepts such as parallelization, grid-based resource acquisition and clusters; - Understanding the role of database machines, such as the Exadata database computing machines and storage machines; - An in-depth exploration of the database architecture, including memory, process and data structures, and the composition of an Oracle database instance; - Alternative modes of database operation, including dedicated server mode, shared servers mode, parallel execution and how one selects the appropriate mode for each environment; - Consider the role of the Shared Global Area (SGA) and the various memory caches and subcaches which can be optionally configured within that space; - Consider the complimentary role of the Program Global Area (PGA), also known as the Process Global Area; - Discuss the role of the instance background processes, including those which are optional and those which can have additional instances optionally launched; - Consider physical database storage structures such as tablespaces, data files, blocks and the internal format of rows; - Consider the alternative row-level storage option of hybrid columnar compression; - Compare and contrast internal storage of data segments, B-tree and bitmap index segments; - Review all of the possible database object types which one may find within the logical application database; - The schema and ownership context in which logical database objects reside; - The editions context in which database objects can exist in different forms and how hot application upgrades are supported by database editions; - This architectural discussion will be much more than just a presentation of theoretical concepts; - After explaining in logical terms the architectural component under consideration, this course module will frequently show the component as it is actually rendered by the Enterprise Manager graphical interface for database administrators. At other times this course will use the SQL command-line interface to explain the characteristics of the architectural component being discussed; - Furthermore, while other modules within this curriculum are focused on the actual administration of these database components, in some cases we will demonstrate within this course how one creates or configures some of these elements under discussion.

Product details

Publisher ‏ : ‎ Sideris Courseware Corp. (April 15, 2011)
Language ‏ : ‎ English
Paperback ‏ : ‎ 260 pages
ISBN-10 ‏ : ‎ 193693017X
ISBN-13 ‏ : ‎ 978-1936930173
Item Weight ‏ : ‎ 1.3 pounds
Dimensions ‏ : ‎ 8.27 x 0.55 x 11.02 inches

Customer Reviews:
1.0 1 rating

Brief content visible, double tap to read full content.

Full content visible, double tap to read brief content.

Videos

Help others learn more about this product by uploading a video!

Upload your video

Customer reviews

1 out of 5

1 global rating

5 star 0% (0%)		0%
4 star 0% (0%)		0%
3 star 0% (0%)		0%
2 star 0% (0%)		0%
1 star		100%

How customer reviews and ratings work

Top review from the United States

There was a problem filtering reviews right now. Please try again later.

Richard L. Rankin

Not what I thought

Reviewed in the United States 🇺🇸 on March 5, 2012

Verified Purchase

Read Jonathan Lewis' internals book - it's the best. Unless you're a rookie, in which case this might be useful.

Amazon Music Stream millions of songs	Amazon Advertising Find, attract, and engage customers	6pm Score deals on fashion brands	AbeBooks Books, art & collectibles	ACX Audiobook Publishing Made Easy	Sell on Amazon Start a Selling Account

Amazon Business Everything For Your Business	Amazon Fresh Groceries & More Right To Your Door	AmazonGlobal Ship Orders Internationally	Home Services Experienced Pros Happiness Guarantee	Amazon Ignite Sell your original Digital Educational Resources	Amazon Web Services Scalable Cloud Computing Services

Audible Listen to Books & Original Audio Performances	Book Depository Books With Free Delivery Worldwide	Box Office Mojo Find Movie Box Office Data	ComiXology Thousands of Digital Comics	DPReview Digital Photography	Fabric Sewing, Quilting & Knitting

Goodreads Book reviews & recommendations	IMDb Movies, TV & Celebrities	IMDbPro Get Info Entertainment Professionals Need	Kindle Direct Publishing Indie Digital & Print Publishing Made Easy	Amazon Photos Unlimited Photo Storage Free With Prime	Prime Video Direct Video Distribution Made Easy

Shopbop Designer Fashion Brands	Amazon Warehouse Great Deals on Quality Used Products	Whole Foods Market America’s Healthiest Grocery Store	Woot! Deals and Shenanigans	Zappos Shoes & Clothing	Ring Smart Home Security Systems

eero WiFi Stream 4K Video in Every Room	Blink Smart Security for Every Home	Neighbors App Real-Time Crime & Safety Alerts	Amazon Subscription Boxes Top subscription boxes – right to your door	PillPack Pharmacy Simplified	Amazon Renewed Like-new products you can trust