01_001 Introduction

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

02_002 - Database installation

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

03_003 - Database health checks

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

04_004 - Identify the alertlog and tracefiles

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

05_005 - Create sample table

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

05_005 - sampletable.sql

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

06_006 - Monitor a session

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

06_007 - Identify Long sessions

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

06_008 - Map OS process to database

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

06_009 - Identify session that i am connected to

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

06_010 - Project scenario Kill sessions

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

06_011 - Who has blocked my session

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

07_012 - FRA space issues

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

08_013 - Calculate optimal processes sessions and transactions

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

08_014 - Simulate processes exceed error

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

09_015 - Undo management demonstration

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

09_016 - Undo errors and face them

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

10_017 - DBA coordination for OS patching

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

11_018 - Ensure backups

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

12_019 - Database mount point full scenario

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

13_020 - Optimizer statistics for table

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

13_021 - Statistics issues scenario

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

14_022 - Grant access for existing user

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

15_023 - Temp tablespace growth

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

16_024 - Tablespace issues when disk is full

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

17_025 - Decommission a database

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

18_026 - PDB connection scenario

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

18_027 - Connect to PDB and identify current connected container

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

18_028 - Application connectivity issues to PDB after activity

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

18_029 - Save PDB states

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

19_030 - Oracle internal error scenario

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

19_030 - ora600simulate.sql

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

20_031 - Simulate logical corruption

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

20_031 - corrupt.sql

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

21_032 - Table refresh 1

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA

21_033 - Table refresh 2

Oracle Dba 19c -learn Real Time Scenarios Using Simulation

Oracle administration

What you'll learn
Learners can be able to get hands on experience on Oracle database administration
Learners get confidence to face real time scenarios
Learners can apply the techniques in their workplace
Learners can get a broader understanding of Oracle Administration
Requirements
A laptop with good specifications and Internet connection
Description
Objective:Title - Administration in standalone database********Course will be updated dynamically ********!Practice makes perfect ! Are you new to Oracle database? Do you want to become a DBA? Are you obsessed to get a real world knowledge on the DBA tasks? Are you ready to learn by simulating the issues faced by a day to day DBA in his jobMajority of lab scenarios are presented in this courseDo you want to pretend you as a DBA in a project or account?This course is for oracle learners who want to pretend doing a DBA job by simulations and scenariosIn this course, learners will perform hands on tasks as if like a real time scenario with different situation based tasksAll the parameters will be used in the practical box for different oracle versions Oracle machine is built in virtual box for simulation of the tasksLearners can be able to confidently face a request from application team after completing the courseDatabase administration job is the core of this course. So you will learn common situations faced in your jobs.Hope the learner who applies for this course has a prior understanding of what oracle database is.You will be practicing in oracle 19c which is the widely used version all over the world.You will learn the administration concepts from a DBA point of view rather than full presentations.Prerequisites:Oracle Database Administration fundamentalsLinux operating system basicsPC with atleast 16 GB, 60 GB HDD, Windows 7,8,or 10 64-bit CPU core(minimum) - 2Student category:Oracle DBAFor any questions, reach out to me at oracle communityProfile name- Kishan-Oracle

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Database installation using DBCA

Lecture 2 Database installation

Section 3: Database Basic healthchecks

Lecture 3 Database health checks

Section 4: Diagnostics practice

Lecture 4 Identify the alertlog and tracefiles

Section 5: Create a sample table with million rows for practice

Lecture 5 Create sample table

Section 6: Monitoring database generally as a DBA

Lecture 6 Monitor a session

Lecture 7 Identify Long sessions

Lecture 8 Map OS process to database

Lecture 9 Identify session that i am connected to

Lecture 10 Project scenario - Kill sessions

Lecture 11 Who has blocked my session?

Section 7: FRA housekeeping

Lecture 12 FRA space issues

Section 8: Managing processes, sessions and transactions effectively

Lecture 13 Calculate optimal processes, sessions and transactions

Lecture 14 Simulate processes exceed error

Section 9: Undo management

Lecture 15 Undo management demonstration

Lecture 16 Undo errors and face them

Section 10: Project scenario - Basic database down and start during OS patching

Lecture 17 DBA coordination for OS patching

Section 11: Project scenario - Ensure backup during application activity

Lecture 18 Ensure backups

Section 12: Mount point full

Lecture 19 Database mount point full scenario

Section 13: Statistics collection basics

Lecture 20 Optimizer statistics for table

Lecture 21 Statistics issues scenario

Section 14: User access scenarios

Lecture 22 Grant access for existing user

Section 15: Temporary tablespace scenario

Lecture 23 Temp tablespace growth

Section 16: Tablespace issues when disk is full

Lecture 24 Tablespace issues when disk is full

Section 17: Database decommission request

Lecture 25 Decommission a database

Section 18: PDB scenarios

Lecture 26 PDB connection scenario

Lecture 27 Connect to PDB and identify current connected container

Lecture 28 Application connectivity issues to PDB after activity

Lecture 29 Save PDB states

Section 19: Diagnose ORA-00600/7445 internal errors

Lecture 30 Oracle internal error scenario

Section 20: Simulate corruption

Lecture 31 Simulate logical corruption

Section 21: Data refresh activities

Lecture 32 Table refresh 1

Lecture 33 Table refresh 2

Oracle DBA