In this video, learn the role of the shared pool in processing user SQL statements and storing Oracle metadata.
- [Narrator] Now it's time to peek inside the SGA…and get on a first name basis with…all of those individual caches.…Starting off with The Shared Pool,…and no, I don't mean the same kind of pool…you share with your fellow vacationers while staying…at your favorite beach resort.…In an Oracle context,…the Shared Pool is the most important area inside the SGA…that is used to cache non-user data.…That is, stuff other than the actual database rows…from our actual tables.…
So, what is there to cache other than rows, you may ask?…Well, there are various other database construct that,…if shared among users,…would speed up the performance…of various database activities.…In order to do that,…the Shared Pool, in itself,…is divided into yet another subset of caches.…Please bear with me. I don't want you to be scared.…Remember the hierarchy.…We have the Oracle Instance.…Inside we have a logical component known as the SGA.…
Upon database setup, we define the size for the SGA.…Such as, I want my SGA, as a whole,…to take up 64 gigabytes of RAM.…
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 Fundamentals: Core Conceptswith Adam Wilbert2h 14m Beginner
Relational Database Fundamentalswith Adam Wilbert2h 40m 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.