kiruthiprabha

1
Oracle Database Administrator

• An overview of oracle dba

2
(No Transcript)
3
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

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

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

6
RESPONSIBILITIES OF ORACLE DBA

• Data collection
• planning
• Data migration
• Database designing
• installations
• configuration
• performance monitoring
• security mechanisms
• data recovery techniques

7
(No Transcript)
8
CHALLENGES THAT ORACLE DBA FACED

• Meeting recovery SLAs.
• Impact of backups on production performance.
• Dealing with Long-term Storage Complexity
• Management Complexity
• Budget

9
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

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

11
FUNCTION OF ORACLE ENTERPRISE MANAGER
12
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.
• SQLPlus has its own commands and environment. 
• It enables you to enter and execute SQL, PL/SQL,
  SQLPlus and operating system commands

13
SQL AND SQL PLUS INTERACTION
14
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

15
TOOLS FOR DATABASE INSTALLATION AND CONFIGURATION

• Database Upgrade Assistant
• Database Configuration Assistant
• Oracle Universal Installer

16
Fig 1.1 Upgrade Assistant
Fig 1.2 Config. Assistant
Fig 1.3 Oracle Universal Manager
17
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

18
ORACLE NET SERVICE
19
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

20
ANALYSIS OF MOVEMENT BEHAVIOR
21
ROLES OF DBA

• Backup and Recovery
• Memory management
• Resource Management and Task Scheduling
• Performance Diagnostics and Tuning

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

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

24
Memory Management Methods

• Automatic Memory Management
• Shared Memory Management
• Automatic Shared Memory Management
• Manual Shared Memory Management

25
AUTOMATIC MEMORY MANAGEMENT
26
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

27
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

28
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

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

30
THANK YOU
https//www.gangboard.com/database-training/oracle
-dba-training?utm_contentkiruthika