1 / 20

Oracle and DBA Management: New Roles, Features & Challenges

Understand the evolving DBA role, new Oracle features, performance issues, and managing high availability, security, and compliance. Learn to adapt to changing business needs and leverage automation for efficient database management. Stay informed on critical patch updates and software maintenance. Enhance communication with stakeholders and align DBA operations with organizational goals. Get insights from expert Michelle Malcher on effective DBA management strategies.

zeph-flowers
Download Presentation

Oracle and DBA Management: New Roles, Features & Challenges

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related