In this video, explore the Oracle database architecture and focus on the Oracle instance and its functions for caching data and processing user transactions.
- [Instructor] Behold, the magnificent…Oracle database architecture, a multitude of individual…components working in tandem to allow…an Oracle database to be, well, a database,…allowing you to read and write data from tables…in a way that's safe, speedy, scalable, and secure.…The Oracle database architecture can be divided…into three major components.…Let's start by taking a bird's eye's view…of the Oracle architecture and list the three…major components making up our Oracle database.…
Our first component is the Oracle instance.…Our second component is the Oracle database storage.…And our third component are the Oracle…server processes, or SPs.…Let's start by talking a little more…about the Oracle instance, which is basically…the Oracle program, or binary, loaded into the server RAM.…It exists only in memory, and created by Oracle…every time you start up your database.…Created, you say?…Yep, it's non-persistent and disappears…each time the database re-starts.…
What does it do?…Well, it contains special areas…used to cache really important data…
After completing this course, you'll have fundamentals required for installation, configuration, and administration of an Oracle 12c database.
- Database instance and storage
- Instance memory pools
- Instance background processes
- Client connections
- Database storage file types
- Control files and backup files
- Multitenant databases
- Starting and stopping the database
- Installing Oracle 12c software
- Using the developer tools
- Database management
Skill Level Beginner
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Database Foundations: Administrationwith Adam Wilbert1h 14m Beginner
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
2. Instance Memory Pools
3. Instance Background Processes
4. Client Connections
5. Physical Database Structures
6. Mulitenant Database
7. Start and Stop the Database
8. Install Oracle 12c software
9. Create a Database Instance
Use DBCA to create a database14m 58s
10. Tools for Developers and DBAs
Next steps1m 17s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.