资源管理器最新分析和总结.pptx

资源管理器;Program Agenda;Program Agenda;Why Consolidate?;Managing Resources;How to Guarantee Resources?;How to Guarantee Resources?;How to Limit Resources?;Program Agenda;For PDBs or Consumer Groups (Workloads);Managing CPU;Managing CPU Instance Caging Approach #1: Partition CPUs;Managing CPU;Exadata Storage;Exadata Storage;;Exadata Storage;Exadata Storage Managing Flash and Disk I/Os;Exadata Storage;Exadata Storage;Non-Exadata I/Os PDB Rate Limits Rate limit parameters prevent PDBs from swamping the storage system MAX_IOPS: maximum I/O requests per second MAX_MBPS: maximum megabytes per second of I/O For non-Exadata storage only! On Exadata, use IORM - much more powerful! What about background I/Os? DBWR I/Os are counted, but not throttled LGWR and Root I/Os aren’t counted, nor throttled;Managing Physical Memory Preventing Swapping;Managing Physical Memory Linux Huge Pages;Managing Physical Memory SGA;Managing PGA How Does PGA Work?;Managing Physical Memory PGA;Managing Memory in a CDB;;Queue!;Managing Parallel Execution;;Program Agenda;Managing a Cloud;;Automatic Management Reduce CPU and Exadata I/O Impact;Automatic Management;Enterprise Manager Express UI Configure and Monitor PDB Resource Manager;Exadata Storage;Program Agenda;;And a few extra slides for content we didn’t have time to cover…;Mixed Workloads and Resource Manager;Mixed Workloads and Resource Management;Configuring Workloads with Consumer Groups;Configuring Workloads with Consumer Groups;Configuring Workloads with Consumer Groups;Configuring Workloads with Consumer Groups;Managing CPU within a Database;Configuring CPU Resource Manager;Configuring CPU Resource Manager;Configuring CPU Resource Manager Enterprise Manager UI;Monitoring and Tuning CPU Resource Manager;Monitoring and Tuning CPU Resource Manager;Monitor using v$rsrcmgrmetric_history, v$rsrcpdbmetric_history or Enterprise Manager;Managing Runaway Queries;Managing Runaway Queries;Managing Runaway Queries;