Exadata X10M HC Storage machines comes with 10 cell servers with up to 2 Petabytes (PB) of raw disk capacity which translates to 960 TB of usable space with high redundancy disk groups
Exadata placement should be performed based on the database utilization on the respective frames such that databases running can utilize Exadata resources to its optimal keeping the resource capping for CPU - Upto 60%, Memory - 50 - 60% and Storage - 60% + buffer 20% Upto 80%
Collect the metrices of the target database in terms of storage usage, CPU usage and Memory usage
SQL> with TS_GROUP as (
select /*+ materialize parallel(t,2) ordered */
to_char(c.begin_interval_time,'yyyy-mm-dd') report_date,
b.name ts_name,
(round(max((a.tablespace_size*8192))/1024/1024/1024,2)) size_gb,
(round(max((tablespace_usedsize*8192))/1024/1024/1024,2)) used_gb
from
dba_hist_tbspc_space_usage a,
v$tablespace b,
dba_hist_snapshot c
where
a.tablespace_id=b.ts#
and a.snap_id=c.snap_id
group by to_char(c.begin_interval_time,'yyyy-mm-dd'), b.name)
select
report_date,
sum(size_gb) total_size_GB,
sum(used_gb) used_size_GB
from
TS_GROUP
group by report_date
order by report_date;
The cluster will Handle different type of workloads with fair Access to resources for databases.
Constrain or limit usage of resources to ensure predictable performance.
IORM plan with basic should be considered to use IORM shares based on cpu_count setting at the PDB level.