Read Oracle Essentials Oracle Database 11g Online
Authors: Rick Greenwald
Standalone Management Packs, 126
potential data losses with site failure, 284
access facts along “look-up” values, 223
cost-based query optimization, 230
transaction
storage area networks (SANs), 165
stored procedures
striping
granting security privileges directly, 146
Structured Query Language (see SQL)
variables, datatype attribute, 82
support services available through Oracle
AQ (Advanced Queuing), 19, 218
Symmetric Multiprocessing (SMP) systems
change data capture, enabling, 218
384
|
Index
synchronous replication, 286, 287
three-dimensional geometry objects, 329
SYS and SYSTEM user accounts, 140
System Change Number (SCN), 78, 192, 280
TNS_ADMIN environment variable and
system memory, types, 291, 301, 303
System Monitoring plug-ins, 126
TP (transaction processing) monitors, 208,
T
Transaction Processing, Concepts and
tables
transaction processing (TP) monitors, 208,
index-organized tables (IOTs), 93
parent-child relationship, 106
locks, and FOR UPDATE clause, 189
routing, three-tier systems, 209
transient failure recovery, 266
TAF (Transparent Application Failover), 217
Transparent Application Failover (see TAF)
Transparent Data Encryption (TDE), 149
failover-aware applications, for
Transparent Gateways, 18, 239, 306
high availability benefits, 272
transportable tablespaces, 18, 239, 317
triggers
TARs (Technical Assistance Requests), 137
TDE (Transparent Data Encryption), 149
Technical Assistance Requests (TARs), 137
technical requirement solutions, 222
procedural languages for writing, 108
row and statement level activation, 107
third-generation languages (3GLs), 10, 11
third-party naming services, 65
Index
|
385
VLDB (Very Large Database) and
two-tier client/server system, 207
volume-management software, 164
VPD (virtual private database), 137
U
VTL (Virtual Tape Library), 136
UCM (Universal Content Management), 327
W
web services
UNIQUE constraint and IOTs, 93
Universal Content Management (UCM), 327
Universal Records Management (URM), 327
web sites
Unix
Oracle database administration, 357
Oracle Net configuration files, default
wildcards format parameters, 47
Windows
user accounts, auditing, 138, 150
Oracle Net configuration files, default
V
X
XA-compliant resource managers, 309
XML (eXtensible Markup Language)
CWMI (Common Warehouse Metadata
Very Large Database (VLDB), 169
access control, using for, 144
iDAP (Internet Document Access
Oracle Wireless Edition and, 16
performance evaluation, used in, 156
virtual private database (VPD), 137, 145
Virtual Tape Library (VTL), 136
386
|
Index
About the Authors
Rick Greenwald
has been active in the world of computer software for more than
two decades, including stints with Data General, Cognos, Gupta Technologies, and
Oracle. He is currently a developer evangelist with
Salesforce.com
. He has published 15 books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents. Rick’s other books include coauthoring
Oracle in a Nutshell
(O’Reilly) and
Professional Oracle Programming
(WROX). Rick lives in Arizona with his wife and three daughters.
Robert Stackowiak
has worked for more than 20 years in business intelligence and IT-related roles that have included sales and sales consulting, business development, management of software development, and systems engineering. As vice president of Business Intelligence in Oracle’s Technology Business Unit, he is recognized world-wide for his work in business intelligence and data warehousing. His papers regarding business intelligence and computer and software technology have appeared in publications such as
President & CEO Magazine
,
Database Trends and
Applications
, and The Data Warehousing Institute’s publications. He has also coauthored the books
Oracle Application Server 10g Essentials
(O’Reilly),
Professional
Oracle Programming
(WROX), and
Oracle Data Warehousing and Business Intelligence Solutions
(Wiley).
Jonathan Stern
used more than 13 years of IT experience in contributing to the original edition of this book. His background included senior positions in consulting, systems architecture, and technical sales. Especially useful in his early work on this book was his in-depth experience with the Oracle database across all major open systems’ hardware and operating systems, covering tuning, scaling, parallelism, Oracle Parallel Server, high availability, data warehousing, and OLTP. He authored numerous papers and presented at internal and external conferences on topics such as scaling with Oracle’s dynamic parallelism and the role of reorganizing segments in an Oracle database.
Colophon
The animals on the cover of
Oracle Essentials: Oracle Database 11g
are cicadas.
There are about 1,500 species of cicada. In general, cicadas are large insects with long thin wings that are perched above an inch-long abdomen. Their heads are also large and contain three eyes and a piercing and sucking mechanism with which to extrude sap from trees. Cicadas are known for their characteristic shrill buzz, which is actually the male’s mating song, one of the loudest known insect noises.
Cicadas emerge from the ground in the spring or summer, molt, then shed their skin in the form of a shell. They stay near trees and plants, where they live for four to six weeks with the sole purpose of mating. The adult insects then die, and their young hatch and burrow into the ground. They attach to tree roots and feed off the sap for 4 to 17 years, after which time they emerge and continue the mating cycle. Cicadas have one of the longest life spans of any insect; the most common species is the periodical cicada, which lives underground for 13 to 17 years.
The cover image is an original 19th-century engraving from
Cuvier’s Animals
. The cover font is Adobe ITC Garamond. The text font is Linotype Birka; the heading font is Adobe Myriad Condensed; and the code font is LucasFont’s TheSans Mono Condensed.