In this video, we will list the configuration parametes used for sizing the SGA and PGA
- [Narrator] Let's put some theory into practice.…Now that we know what's inside the Oracle SGA…and what is the role of the PGA…let's talk about how we can size both of them correctly.…This is super important.…As it's up to the database expert to decide how much…memory will be allocated to Oracle…and how much memory will be provided for the SGA…compared to the PGA.…We can control the size of the SGA using two parameters.…SGA Target and SGA Max Size.…
Based on these parameters…Oracle by itself will derive the sizing…for other individual SGA components.…Such as the Buffer Cache, the Shared Pool,…and the Radio Log Buffer.…As an example, we can configure an SGA Target…for 64 GB and the SGA Max Size for 128 GB…and have Oracle dynamically resize the SGA…between 64 GB and 128 GB of memory…depending on workload characteristics.…
On the other hand, when sizing the PGA…we set the PGA Aggregate Target parameter…to equal the total amount of memory.…We want available 40 PGA but across all server processes.…Each server process will allocate a subset…
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
Learning Relational Databases (2014)with Adam Wilbert2h 39m 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.