In this video, we list the additional components that exist in the Oracle SGA: The Large Pool, The JAVA Pool and the Streams POOL as we all discuss the function of the Oracle PGA and how it is used by connected users
- [Narrator] Woof.…That was a long explanation for such a small component…of the Oracle Instance, literally.…The largest component of the SGA is usually the…buffer cache.…As it caches actual data read from disk.…In rows, lots of rows from, you know, tables,…lots and lots of tables.…The second largest cache in the SGA is usually…the shared pool.…It stores the past presentation of single statements…as well as metadata.…This leaves us with the RedoLog Buffer.…
Usually making it the smallest of the major components…in the SGA.…But alas we are not done just yet.…Bare with me for a few more minutes as we briefly go over…several other SGA components.…Some of them are not nearly as important for our…daily administration of the oracle database as the…shared pool, buffer cache and redolog buffer.…But we still need to know about their functions in the SGA.…Next on our list of SGA components galore is the large pool.…
We won't go into a lot of details as the large pool…isn't nearly as important as the buffer cache, shared pool…
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
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 55s
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.