Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you ll get the fundamentals applicable to all Oracle database releases.
Oracle Database 10g marks the latest release by a company that has experienced a meteoric rise to success over the past 25-plus years. They have been grossing many billions of dollars annually for many years, vending a suite of solutions powered by their flagship product—the Oracle database. It has gone through many changes in names—v6, Oracle7, Oracle8i, Oracle9i, and now Oracle 10g. Regardless of what it is called, the Oracle server has been catapulted to the forefront of our Internet-savvy society, playing a role as the primary data server on a web site in your neighborhood. This book is your introduction to the Oracle Database 10g technology. It is the start of your journey—a quick start to a complex and popular technology.
Oracle Database 10g is the culmination of thousands upon thousands of person hours building an infrastructure to deliver data to a hungry, worldwide community, just as electricity is delivered to a three-prong outlet near you. Larry Ellison, CEO of Oracle Corporation, is a visionary steering Oracle s product set in directions unheard of before. You cannot read any public relations or technical material from Oracle Corporation without hearing that four letter word—grid. With grid computing, the industry envisions a computational grid where machines all the way from the Intel-based server to the high-end servers from HP, IBM, and Sun are interlaced with one another is a massively scalable and sharable environment.
There have been many advances in the processing power of computer chips over the past few decades, and grid computing is seen as allowing applications to harness that power. Idle processor time is deliberately consumed by shared applications. The analogy to the electricity grid is an interesting one. When you plug your iron into a socket in your basement, you neither know nor care where the electricity is coming from—it s just there and taken for granted. With Oracle Database 10g grid computing, transparent access is provided to a wide network of remote computers. Unbeknownst to application users, processing is shared between widely disparate sites, where the location of nodes responsible for data delivery is dynamic—hence the likeness to the
1 Database Fundamentals 1
Critical Skill 1.1 Define a Database 2
Critical Skill 1.2 Learn the Oracle Database 10g Architecture 3
The Control Files 4
The Online Redo Logs 4
The SYSTEM Tablespace 5
The SYSAUX Tablespace 5
Default Temporary Tablespace 5
Undo Tablespace 5
The System Parameter File 6
Background Processes 6
Project 1-1 Reviewing the Oracle Database 10g Architecture 8
The Database Administrator 9
Critical Skill 1.3 Learn the Basic Oracle Database 10g Data Types 10
Critical Skill 1.4 Work with Tables 12
Tables Related to part_master 13
Critical Skill 1.5 Work with Stored Objects 14