Oracle AI Database: Administration Workshop Live Class — Lesson 2: Storage, Memory, Resource Control, and Performance Evidence

Technical Scope

• tablespaces, temp, undo, and I/O
• SGA, PGA, sessions, and process limits
• Resource Manager and workload priority
• waits, SQL evidence, plans, and capacity

Instructor Demonstration

Demonstrate tablespaces, temp, undo, and I/O inside a mixed transactional and AI-assisted application with workload, access, and service-health challenges, then capture the exact configuration, command, transaction, report, or code evidence that proves the result.

Applied Workshop

Implement a controlled workshop covering SGA, PGA, sessions, and process limits and Resource Manager and workload priority, then test a failure or exception involving waits, SQL evidence, plans, and capacity.

1. Confirm environment, identity, data, dependencies, and expected result.
2. Complete the product-specific implementation or analysis.
3. Capture commands, configuration, output, logs, transactions, or reports.
4. Explain the operational, security, performance, or business trade-off.

Validation Standard

The Storage, Memory, Resource Control, and Performance Evidence result must be reproducible, traceable to approved inputs, and consistent with the expected Oracle product behavior.

• The intended target and ownership are verified.
• The result is supported by reproducible evidence.
• Security, performance, reliability, and support impact are reviewed.
• Unexpected behavior is investigated before acceptance.

Failure Analysis

Diagnose issues in tablespaces, temp, undo, and I/O, SGA, PGA, sessions, and process limits, Resource Manager and workload priority, or waits, SQL evidence, plans, and capacity without making an unverified production change.

Learners isolate the smallest proven cause, apply a reversible correction, rerun validation, and record the preventive action.