
Expert Oracle Database 11g Administration
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day-to-day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done.
- Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration.
- Tests and explains in detail key DBA commands.
- Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.
More details
Other editions
Additional editions

Person
Content
¦ ¦ ¦
In the first four chapters, I set the stage for working with Oracle. It's time now to learn about the fundamental structures of Oracle Database 11g. Oracle uses a set of logical structures called data blocks, extents, segments, and tablespaces as its building blocks. Oracle's physical database structure consists of datafiles and related files. Oracle memory structures and a set of database processes constitute the Oracle instance, and are responsible for actually performing all the work for you in the database.
To understand how the Oracle database works, you need to understand several concepts, including transaction processing, backup and recovery, undo and redo data, the optimization of SQL queries, and the importance of the data dictionary. This chapter provides an outline of the important Oracle automatic management features, as well as the sophisticated built-in performance tuning features, including the Automatic Workload Repository (AWR) and the Automatic Database Diagnostic Monitor (ADDM), a brand new diagnostic framework introduced in this release, and the new Data Recovery Advisor, which helps you easily recover from several types of data disasters and errors. I also outline Oracle's advisor-based Management Framework.
Oracle Database Structures
In discussing the Oracle database architecture, you can make a distinction between the physical and logical structures. You don't take all the data from the tables of an Oracle database and just put it on disk somewhere on the operating system storage system. Oracle uses a sophisticated logical view of the internal database structures that helps in storing and managing data properly in the physical datafiles.
By organizing space into logical structures and assigning these logical entities to users of the database, Oracle databases logically separate the database users (who own the database objects, such as tables) from the physical manifestations of the database (datafiles and so forth). The following sections discuss the various logical and physical data structures.
Logical Database Structures
Oracle databases use a set of logical database storage structures in order to manage the physical storage that is allocated in the form of operating system files. These logical structures, which primarily include tablespaces, segments, extents, and blocks, allow Oracle to control the use of the physical space allocated to the Oracle database.
Taken together, a set of related logical objects in a database is called a schema. Remember that Oracle database objects, such as tables, indexes, and packaged SQL code, are actually logical entities. Dividing a database's objects among various schemas promotes ease of management and a higher level of security. Let's look at the logical composition of an Oracle database from the bottom up, starting with the smallest logical components and moving up to the largest entities:
Data blocks: A data block is the smallest building block of the Oracle database and consists of a specific number of bytes on the disk.
Extents: An extent is two or more consecutive Oracle data blocks, and this is the unit of space allocation.
Segments: A segment is a set of extents that you allocate to a logical structure like a table or an index (or some other object).
Tablespaces: A tablespace is a set of one or more datafiles, and usually consists of related segments.
The datafiles contain the data of all the logical structures that are part of a tablespace, like tables and indexes. The following sections explore each of these logical database structures in detail.
System requirements
File format: PDF
Copy protection: Watermark-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Use the free software Adobe Reader, Adobe Digital Editions, or any other PDF viewer of your choice (see eBook Help).
- Tablet/Smartphone (Android; iOS): Install the free app Adobe Digital Editions or another reading app for eBooks, e.g., PocketBook (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Watermark-DRM, a „soft” copy protection. This means that there are no technical restrictions to prevent illegal distribution. However, there is a personalised watermark embedded in the eBook that can be used to identify the purchaser of the eBook in the event of misuse and to provide evidence for legal purposes.
For more information, see our eBook Help page.