 |
|
The Architecture of the
Oracle Database, SQL and PL/SQL
Oracle Tips by
Burleson
|
The Oracle database is not a simple piece of software. Fortunately,
becoming a good PL/SQL developer doesn’t require that you know
everything about the internal structures of the database.
Unfortunately, becoming a good PL/SQL developer requires that you
understand a large part of the database architecture. This chapter is
intended to provide you with a very high level perspective on what you
need to know.
If you are already experienced with Oracle, SQL, and PL/SQL, you’ll
probably want to browse this chapter and move on to Chapter 3. If
you’re completely new to Oracle (either with or without previous
development experience), make sure that you read this chapter before
proceeding.
The Architecture Of The Oracle Database
Your knowledge of the database needs to cover the following basics:
-
Constraints
-
Indexing
-
Locking
-
Roles and privileges
-
Schemas
-
Sequences
-
SGA (system global area)
-
Snapshots
-
Synonyms
-
Tables and columns
-
Views
This list is by no means comprehensive. Your work as an application
developer using Oracle and PL/SQL will continually expose you to new
challenges; with hard work and dedication, you’ll meet those
challenges head on.
This is an excerpt from the book "High Performance Oracle
Database Automation" by Jonathan Ingram and Donald K.
Burleson, Series Editor.
|
