Programming Oracle® Triggers and Stored Procedures, Third Edition

2.3. Connecting to an Infrastructure

This section illustrates the Oracle infrastructure to which you connect. The first part, illustrated in Figure 2-4, discusses the point-to-point connection you have with Oracle in a dedicated-server environment. Second, we discuss the instance infrastructure, illustrated in Figure 2-5. This is all tied together with a discussion surrounding Figure 2-6.

Figure 2-4. Oracle Dedicated-Server Mode.

Figure 2-5. Database Instance.

Figure 2-6. Database Instance with Connections.

When you invoke SQL*Plus you start an ...