Product Documentation

Appearance

All platforms

sys.wlm_active_profile ​

This view returns the currently active WLM profile for each compute cluster, identified by its cluster ID (UUID).

For example:

premdb=> select * from sys.wlm_active_profile;
  profile_name  |              cluster_id              
----------------+--------------------------------------
 default        | 96842a0a-4627-4e39-aaf0-94968d6b22b4
 instance_small | 56ec98dd-b475-4a33-a499-90b29cef87e8
(2 rows)

Join this view to sys.cluster for more information:

premdb=> select sw.*, sc.cluster_name from sys.wlm_active_profile sw join sys.cluster sc on sw.cluster_id=sc.cluster_id;
  profile_name  |              cluster_id              |     cluster_name      
----------------+--------------------------------------+-----------------------
 default        | 96842a0a-4627-4e39-aaf0-94968d6b22b4 | large-default-cluster
 instance_small | 56ec98dd-b475-4a33-a499-90b29cef87e8 | small-2node-cluster
(2 rows)