Michelle Malcher PepsiCo Session #

1. For the DBA Manager – Understanding Oracle and DBAs Michelle MalcherPepsiCoSession #

2. 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.

3. Agenda Managers of DBAs • New DBAs Roles • New Database Features • Performance Issues • Oracle Software including patches and CPUs

4. Experience Technical Background? New to Oracle? New features? Coming from other platforms?

5. 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

6. 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

7. New DBA Role • How to separate roles? • Defining roles • Production Support • Systems • Application • Auditing • Advantages • Disadvantages

8. New Features • New features are not just a new cool toy for DBAs • Solutions for new business needs • High Availabilty • Security • Performance

9. New Features • High Availability • Real Application Cluster (RAC) • Workload balance • Manageability • Rolling patches • Data Guard • Active Standby • Failover / DR • Automatic Storage Management (ASM) • Manage Oracle files • Rolling patches

10. New Features • High Availability • Flashback • Flashback queries • Flashback database • HA solutions include Business Continutity • Failover options • Provides DR solutions • Different options for backups

11. New Features • Security • Secure configuration of database • Default more secure • Least privileges • Database auditing • 11g turned on by default • Tools • Database Vault • Database Audit Vault • Secure Backup

12. 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

13. 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

14. 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

15. 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

16. 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

17. 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

18. Summary • Overview of new features • New DBA roles • Performance • Oracle software

19. Questions?

20. Thank You • Please fill out evaluation forms • Michelle Malcher • For the DBA Manager – Understanding Oracle and DBAs, # • Michelle.a.malcher@pbsg.com