Join David Yahalom for an in-depth discussion in this video PDB I/O resource management demo, part of Oracle 12c Release 2 New Features & The Oracle Cloud.
- [Instructor] Let's start our demo of PDB resource management by connecting to our Oracle instance with the sysdba user. So, we'll type: sqlplus as sysdba. We'll also set our session to the PDB1 pluggable database. So: alter session set container=pdb1. Remember that PDB1 is the pluggable database we chose to automatically create via the Oracle Cloud web interface when we created our ORCL database instance.
PDB resource management in Oracle 12C, release two is controlled via the max_iops and max_mbps parameters. By default, these parameters are not set to any specific values. We can see that by typing: show parameter max_mbps and show parameter max_iops. A value of zero means that we are not restricting the amount of io this pluggable database can generate.
We can enable either or both parameters and limit the maximum potential io that can be generated by PDB number one using alter system commands. Let's give it a try: alter system set max_iops and let's limit it to 500. So that PDB1 cannot generate more than 500 individual io operations every second. We'll also type: scope=both, so that the setting will be stored both in the Oracle configuration file, the SP file, and also applied in memory.
Similarly, we can set our max_mbps or megabytes per second, to control the amount of sequential io our pluggable database can generate. We'll do that by typing: alter system set max_mbps=, and let's give it a value of say, 200. So, a maximum number of 200 megabytes per second. Scope both. By having two individual parameters for PDB resource management, we can specify individual value for max iops which will impact mostly random reads and max mbps which will effect the throughput done via a sequential read such as full table scan.
We can now see that both parameters have taken effect. Show parameter max_mbps and show parameter max_iops. We can see the new values for both parameters. So, now PDB1 cannot generate more than 500 iops or 200 megabytes per second of sequential io. Super simple and super cool feature that can provide us with an even finer grained level of control over our utilization for individual PDBs in a multi tenant Oracle 12C instance.
We can now quit out SQL plus window.
- Registering for a new Oracle Cloud free trial account
- Creating an Oracle 12c R2 database in the Oracle Cloud
- Configuring SSH access to the database
- Advanced database configuration
- Connecting to your Oracle Cloud database
- PDB resource management
- PDB cloning
- PDB flashback
- Read-only partitions
- Transforming non-partitioned tables to partitioned tables automatically
- Creating a table for Exchange automatically
- Automatic list partitioning