Lesson 1

SQL*Plus is a command-line tool that provides access to the Oracle RDBMS. SQL*Plus enables you to:

1. Enter SQL*Plus commands to configure the SQL*Plus environment.
2. Startup and shutdown an Oracle database.
3. Connect to an Oracle database.

• Oracle's Shared Server Database Architecture This module teaches you about Oracle's Shared Server Database Architecture, which was the successor to Oracle Server Manager, a utility that was formally used to manage Oracle databases. When you are finished with this module, you will understand how SQL*Plus allows you to interact with Oracle tables.
  
  1. Start SQL*Plus and connect to a database
  2. Get help for Shared Server commands
  3. List the columns in a table or a view
  4. Use SQL *Plus to select data from a database
  5. Write output to a file

• The latest release of Oracle Enterprise Manager (EM) Cloud Control as of August 2024 is indeed version 13.5, specifically 13.5.0.22.
• This version does come with various enhancements.

Oracle database versions and EM Cloud Control versions use different numbering schemes.
"22c" refers to an Oracle Database version, not an EM Cloud Control version. You cannot directly compare them to determine which is "higher".
Multiple studies have proven that, while the business demand for databases grows, operational teams are constrained by traditional, reactive processes. Combined with budgetary pressures, this causes them to fall short in meeting the demand in a timely fashion. In addition, as companies adopt cloud paradigms, operational teams must manage across on-premises and cloud environments with the same resources. To be effective, companies need to shift from a reactive posture to one of standardization and proactive analysis and planning by leveraging intuitive tooling to automate manually intensive and non-value, adding activities and to deliver real-time insights. Customers we talked with reported that they use Oracle Enterprise Manager to address their most critical business needs, which can span both on-premises and cloud environments in a progressive manner. The Enterprise Manager features that ensure their success are the foundational Diagnostics and Tuning Packs for performance monitoring and management; Database Lifecycle Management Pack for automated patching, provisioning, and compliance; Real Application Testing for validating performance for environment or SQL changes; and finally Cloud Management Pack for private-cloud self-service provisioning, charge-back, and cloning.