Exercise files - Oracle Database Tutorial

Contents

• Introduction Introduction

  • Welcome

    1m 34s
  • Target audience

    1m 13s
  • Exercise files

    19s
  • Learning supports

    25s
• 1. Architecture 1. Architecture

  • Database instance

    3m 26s
  • Database storage

    4m 14s
  • Server processes

    5m 56s
• 2. Instance Memory Pools 2. Instance Memory Pools

  • System global area

    2m 19s
  • Shared pool

    5m 37s
  • Buffer cache

    3m 37s
  • Redo log buffer

    4m 46s
  • Other SGA pools and the PGA

    3m 51s
  • SGA and PGA sizing

    4m 24s
• 3. Instance Background Processes 3. Instance Background Processes

  • Database writer

    4m 58s
  • Log writer

    6m 2s
  • Checkpoint process

    2m 30s
  • SMON process

    44s
  • PMON process

    38s
  • RECO process

    1m 35s
  • LREG process

    2m 27s
  • Archiver process

    2m 15s
• 4. Client Connections 4. Client Connections

  • Oracle listener

    5m 22s
  • TNSNAMES.ORA config files

    5m 30s
  • How client connections work

    2m 55s
• 5. Physical Database Structures 5. Physical Database Structures

  • Database storage file types

    2m 26s
  • Datafiles and tablespaces

    8m 39s
  • Special Oracle tablespaces

    3m 2s
  • Redo log files

    4m 5s
  • Control files

    2m 4s
  • Backup files

    4m 49s
  • Additional storage files

    3m 19s
• 6. Multitenant Database 6. Multitenant Database

  • Benefits of the 12c architecture

    2m 47s
  • New vs. old

    2m 22s
  • Backward compatibility

    1m 19s
• 7. Start and Stop the Database 7. Start and Stop the Database

  • Startup

    3m 35s
  • Shutdown

    3m 46s
• 8. Install Oracle 12c software 8. Install Oracle 12c software

  • Prerequisites for installation

    14m 10s
  • O/S configuration

    6m 43s
  • Download the software

    4m 3s
  • Install software

    6m 36s
• 9. Create a Database Instance 9. Create a Database Instance

  • Use NETCA to create a listener

    3m 36s
  • Use DBCA to create a database

    14m 55s
• 10. Tools for Developers and DBAs 10. Tools for Developers and DBAs

  • SQL *Plus for administration

    4m 16s
  • SQL Developer for development

    13m 57s
  • Oracle Enterprise Manager

    8m 14s
• 11. Management 11. Management

  • Start and stop the instance

    3m 20s
  • Start and stop the listener

    3m 4s
  • View and set parameters

    5m 27s
  • Create users and assign permissions

    9m
  • Data dictionary

    8m 20s
  • Troubleshoot using the Alert Log

    5m 13s
  • Storage: Tablespaces and datafiles

    7m 24s
• Conclusion Conclusion

  • Next steps

    1m 17s