1 / 30

Oracle Database Administrator

GangBoard, provide you with a specialized Oracle DBA Online Training, from beginner to advanced level. We have experienced Oracle DBA experts will guide and help you understand how to administering standalone Oracle databases. In addition, our team has customized this Oracle DBA Online Course curriculum to meet the standards of current industry.<br>https://www.gangboard.com/database-training/oracle-dba-training?utm_content=kiruthika

prabhavenkat
Télécharger la présentation

Oracle Database Administrator

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. Oracle Database Administrator An overview of oracle dba

  2. CONTENT • What is Oracle DBA • Features of Oracle DBA • Responsibilities of Oracle DBA • Challenges that Oracle DBA Faced • Tools for DBA • Roles Of DBA • Scope of Oracle DBA

  3. WHAT IS ORACLE DBA • Oracle DBA is an expert in all aspects of Oracle software. They understand the theories and the components that make the system work. • They also need to know the structured query language (SQL) to create and change the structures of the database. • They designed the databases using Oracle software and SQL knowledge.

  4. FEATURES OF ORACLE DBA • The installation of information is not a single-parent task, but is managed by a group of specialists • The first is data related to the use of hardware • Work on standard graphics.

  5. RESPONSIBILITIES OF ORACLE DBA • Data collection • planning • Data migration • Database designing • installations • configuration • performance monitoring • security mechanisms • data recovery techniques

  6. CHALLENGES THAT ORACLE DBA FACED • Meeting recovery SLA’s. • Impact of backups on production performance. • Dealing with Long-term Storage Complexity • Management Complexity • Budget

  7. TOOL FOR DBA • Oracle Enterprise Manager • SQL *plus • Tools for Database Installation and Configuration • Tools for Oracle Net Configuration and Administration • Tools for Data Movement and Analysis

  8. ORACLE ENTERPRISE MANAGER • Oracle Enterprise Manager is a management tool for the program that provides organization of the database organization. • Along with convenience, Oracle Management servers, Oracle Intelligent agents, extended services, and specialized equipment, Enterprise Manager directs the best management of the Oracle product program.

  9. FUNCTION OF ORACLE ENTERPRISE MANAGER

  10. SQL *PLUS • SQL * More is linked to the Oracle Database installation content. There is a development that uses the codec to work as a client when you connect to the database. • SQL*Plus has its own commands and environment.  • It enables you to enter and execute SQL, PL/SQL, SQL*Plus and operating system commands

  11. SQL AND SQL *PLUS INTERACTION

  12. TASKS OF SQL *PLUS • Formatting, performing calculations on, storing, and printing from query results • Examining table and object definitions • Developing and running batch scripts • Administering a database

  13. TOOLS FOR DATABASE INSTALLATION AND CONFIGURATION • Database Upgrade Assistant • Database Configuration Assistant • Oracle Universal Installer

  14. Fig 1.1 Upgrade Assistant Fig 1.2 Config. Assistant Fig 1.3 Oracle Universal Manager

  15. TOOLS FOR ORACLE NET CONGFIGURATION AND ADMINISTRATION • Oracle Data Services provides comprehensive solutions for distribution services and the Internet environment for the communications industry. • Oracle Net Manager • Oracle Net Configuration Assistant • Listener Control Utility • Oracle Connection Manager Control Utility

  16. ORACLE NET SERVICE

  17. Tools for Data Movement and Analysis • There are several utilities included in Oralce Database to assist the database movement and analysis.  • Load data into Oracle Database tables from operating system files • Move data and metadata from one database to another database • Query redo log files through a SQL interface • Manage Oracle Database diagnostic data

  18. ANALYSIS OF MOVEMENT BEHAVIOR

  19. ROLES OF DBA • Backup and Recovery • Memory management • Resource Management and Task Scheduling • Performance Diagnostics and Tuning

  20. BACKUP AND RECOVERY • Backup and recovery is the arrangement of ideas, methods, and methodologies associated with securing the database against information misfortune brought about by media disappointment or clients mistakes. • By and large, the reason for a reinforcement and recuperation methodology is to secure the database against information misfortune and recreate lost information. • A backup is a duplicate of information. A backup can incorporate essential pieces of the database, for example, information documents, the server parameter record, and control record.

  21. MEMORY MANAGEMENT • Memory management includes keeping up ideal sizes for the Oracle case memory structures as requests on the database change. Introduction parameter settings decide how SGA and example PGA memory is overseen.

  22. Memory Management Methods • Automatic Memory Management • Shared Memory Management • Automatic Shared Memory Management • Manual Shared Memory Management

  23. AUTOMATIC MEMORY MANAGEMENT

  24. RESOURCE MANAGEMENT AND TASK SCHEDULING • In a database with numerous dynamic clients, asset the executives is a significant piece of database organization. • A related issue is the way to timetable undertakings so they keep running at the best time. Prophet Database gives apparatuses to help take care of these issues. • Database Resource Manager • Oracle Scheduler

  25. DATABASE RESOURCE MANAGER • Oracle Database Resource Manager (the Resource Manager) is a foundation that gives granular control of database assets assigned to clients, applications, and administrations. • The Resource Manager tackles numerous asset portion issues that a working framework does not oversee well, including: • Excessive overhead • Inefficient scheduling • Inappropriate allocation of resources • Inability to manage database-specific resources

  26. ORACLE SCHEDULER • Oracle Scheduler enables database administrators and application developers to control when and where various tasks take place in the database environment. • The Scheduler provides complex enterprise scheduling functionality, which you can use to: • Schedule job execution based on time or events • Schedule job processing in a way that models your business requirements • Manage and monitor jobs • Execute and manage jobs in a clustered environment

  27. SCOPE OF ORACLE DBA • Oracle DBA will be in real life as long as the databases are there. Be that as it may, we have to continue improving our self and refreshed with the most recent advances. • Learning Oracle DBA from good institute is the essential thing and it is our duty to choose the right institute. Take Best Oracle Onine Training from best institute.

  28. THANK YOU https://www.gangboard.com/database-training/oracle-dba-training?utm_content=kiruthika

More Related