Transcript Presentation Guidelines

For the DBA Manager –
Understanding Oracle and DBAs
Michelle Malcher
PepsiCo
Session #
Speaker Qualifications
• Michelle Malcher, Senior Database Administrator
• Enterprise Best Practices SIG
• Contributing author for IOUG Best Practices Tip
Guide and Select Journal
• Over 10 years experience in database administration,
architecture and development.
Agenda
Managers of DBAs
• New DBAs Roles
• New Database Features
• Performance Issues
• Oracle Software including patches and
CPUs
Experience
Technical Background?
New to Oracle?
New features?
Coming from other platforms?
New DBA Roles
Why is the DBA role changing?
• SOX and Governance
• More complex business process
• Demand for highly available systems
• “Easier” to manage databases
• Sensitive data and data classification
New DBA Roles
What access is needed for DBAs to do
their jobs?
• Access to sensitive data
• Logging in as SYS or SYSTEM
• Other available roles
• Need to audit this type of access
• Migrations from development to
production
New DBA Role
• How to separate roles?
• Defining roles
–
–
–
–
Production Support
Systems
Application
Auditing
• Advantages
• Disadvantages
New Features
•
•
New features are not just a new cool toy for
DBAs
Solutions for new business needs
–
–
–
High Availabilty
Security
Performance
New Features
•
High Availability
–
Real Application Cluster (RAC)
•
•
•
–
Data Guard
•
•
–
Workload balance
Manageability
Rolling patches
Active Standby
Failover / DR
Automatic Storage Management (ASM)
•
•
Manage Oracle files
Rolling patches
New Features
•
High Availability
–
Flashback
•
•
•
Flashback queries
Flashback database
HA solutions include Business Continutity
–
–
–
Failover options
Provides DR solutions
Different options for backups
New Features
•
Security
–
Secure configuration of database
•
•
–
Database auditing
•
–
Default more secure
Least privileges
11g turned on by default
Tools
•
•
•
Database Vault
Database Audit Vault
Secure Backup
New Features
•
Performance
–
–
Still no run fast button
Reports
•
•
–
Statspack now AWR and ADDM
Automatically collecting information
Tools
•
•
OEM – Enterprise Manager
Grid Computing
–
–
•
Repeatable configurations
View across systems
Add-ons
–
From tuning to compliance
Working with Oracle
•
Software Support
–
Cases with Oracle
•
•
–
Need to gather several pieces of information
Need to be on recent releases and patches
Patch information
•
Critical Patch Update (CPU)
–
–
–
•
Just security patches
Released quarterly
Important for compliance
One off patches
–
Bug fixes
Working with Oracle
•
Software Ownership and Maintenance
–
–
What pieces are owned?
What add-ons are available?
•
•
–
Ensure the correct pieces are installed
Ensure that tools are being used that are available
When is maintenance paid?
•
•
Review environment
New requirements
Working with Oracle
•
Basic software
–
–
–
Easier? Easier to manage?
More complex because of the different available
components
Database parameters and dictionary views
•
•
–
Increase with each release
Options available
Tools becoming more valuable
•
•
Standardizing processes
Automate basic task
DBA
•
Roles changing
–
–
•
With easier to manage software, basic tasks can
be automated
Database still getting more complex
Business needs changing
–
–
Need to develop HA environments
Compliance and security
DBA Manager
•
Manage solutions with business needs
–
–
–
•
Understand some of the new features
Security and compliance
High availability and support
Manage DBA roles
–
–
Provide opportunities
Communication of business needs
Summary
•
•
•
•
Overview of new features
New DBA roles
Performance
Oracle software
Questions?
Thank You
• Please fill out evaluation forms
• Michelle Malcher
– For the DBA Manager – Understanding Oracle
and DBAs, #
– [email protected]