Transcript Top Five Tips and Tricks for DBAs and Storage

Top Five Tips and Tricks for DBAs
and Storage Admins Deploying
Oracle Database 12c
1
Gagan Singh
Sr. Database Architect
Technology and Manufacturing Group
Intel Corporation
Agenda
• Company Overview
• Architecture Layout
• ZS3-4 Configuration Snapshot
• Value
• Key Learnings
2
Intel Corporation
The World’s Largest Semiconductor Manufacturer
Leading Manufacturer of Computer, Networking & Communications Products
Headquartered in Santa Clara, California
$55.9B in Annual Revenues - 25+ Consecutive Years of Positive Net Income
Over 107,000 Employees, 170 Sites in +70 Countries
Ranked #12 on Forbes World’s Most Reputable Companies
3
3
Architecture Layout
Platinum Gateway
Data Transfer from ONLINE DB
InfiniBand
Network
10Gbe
RHEL-11.2.0.4 RAC
Historical Data
Applications
Historical / Analytics
Exadata
X4-8
4
Oracle ZS3-4
RHEL-11.2.0.4 RAC
Tier 1 Storage
Applications
Transactional
Oracle ZS3-4 Configuration Snapshot
Backups
•
•
•
•
•
•
5
RAID Z1
Oracle Direct NFS Client
Record size-1Mb
Logbias- Throughput
MTU 65520
8 channels/compute
node
Database
•
•
•
•
Mirrored
Oracle Direct NFS Client
Record Size 128K
Logbias –Latency(DATA
drives)
• MTU 9000
• No ASM
Performance
Simplicity
• 22Tb/hr backup throughput –for VLDB
• Sql queries meeting SLA for historical data.
• Improved Recovery Point and Recovery Time
Objectives
• Flexibility to thin clone databases
• Seamless data movement between OLTP
and historical DB
• Manageability through Enterprise Manager
• Easy management of underlying disks
Value
6
Savings
Support
• Lower TCO than competitive product
• Storage for Offline database ~100TB
• ILM – HCC Compression through
partitioning.
• Single vendor escalation and support
• Interactive admin GUI
• Platinum Gateway Monitoring(S/W+H/W)
Lessons Learnt
•
Direct NFS enabled for database and Exadata backups
--Check Direct NFS related patches (18159793,19788303)
•
Define logical space within ZFS, if it is being shared
•
Leverage the ZFS GUI for real time Monitoring and Operations
--Analytics to monitor metrics , integrated with EM12c
•
No ASM for hosting Database
•
Check db_file_multiblock_readcount,_ldr_io_size,_max_io_size
•
Define share properties according to I/O type (Read vs Write)
http://www.oracle.com/technetwork/server-storage/sun-unifiedstorage/documentation/oracle11gr2-zfssa-bestprac-2255303.pdf
7
Thank You