Release Notes

Optimize an SC Series array for an Oracle data warehouse
15 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
For LVM, the three main data types are:
• Oracle software binaries
• Log files generated by various Oracle processes
• Dump files generated by Oracle Data Pump utility
The binaries are read into the system memory during the startup of the environment. They do not get
accessed on storage or changed frequently. For the log files, they are continuously written to the file system
but only get read when administrators need to review and troubleshoot an issue. Therefore storing these data
types on tier 3 storage would seem reasonably adequate.
LVM data types and storage profiles
High Priority
(Tier 1)
T1/
all RAID
levels
• Pin data in T1 only if it is deemed highly
critical and requires the best
performance
• New data writes to the fastest write
layer T1 R10
• Aged data can still move to T1 R5 or R6
to free up space
+SYSTEMDG
Metadata
Redo logs
System data
Recommended
All tiers/
all RAID
levels
• Metadata changes infrequently; mostly
read I/Os
• Redo logs are circular logs; mostly write
I/Os
• New data/logs writes to the fastest layer
T1 R10
• Aged data moves to T3 R5 or R6
+FRADG
Archived logs
Low Priority
(Tier 3)
T3/
all RAID
levels
• New logs writes to T3 R10
• Aged logs moves to T3 R5 or R6 to free
up space
LVM disk
group
Data type
Storage
profiles
Storage
tiers/RAID
levels
Description
vgoracle
• Oracle software
• Oracle logs
• Oracle data
pump files
Low Priority
(Tier 3)
T3/All RAID
levels
• New files writes to T3 R10
• Aged files move to T3 R5 or R6 to free
up space
• T3 R5/R6 offers good read performance
for logs and dump files