Oracle: A complete guide - From beginner to Master
Oracle Database: Lec-2:- Architecture - PGA & UGA
Oracle: A complete guide - From beginner to Master
0%
Completed
Architecture : Overview
Oracle Database: Lec - 1: Architecture Introduction
Video - 00:00:00 mins
Oracle Database: Lec-2:- Architecture - PGA & UGA
Video - 00:00:00 mins
Oracle Database: Lec - 3 :- Architecture- System Global Area
Video - 00:00:00 mins
Oracle Database: Lec - 4 : Architecture:- Database Buffer Cache
Video - 00:00:00 mins
Oracle Database: Lec - 5 :- Architecture : Redo log buffer
Video - 00:00:00 mins
Oracle Database: Lec - 6 :- Architecture : Shared Pool Buffer
Video - 00:00:00 mins
PGA and UGA
Quiz
PGA and UGA
Quiz
PGA and UGA
Quiz
Database Buffer Cache
Quiz
Database Buffer Cache
Quiz
Database Buffer Cache
Quiz
Architecture: Background Processes
Oracle Database: Lec - 7:- Architecture: Background processes: Log Writer process
Video - 00:00:00 mins
Oracle Database: Lec - 8 :- Architecture: Background processes: Database Writer process
Video - 00:00:00 mins
Oracle Database: Lec - 9 :- Architecture: Background processes: Checkpoint process
Video - 00:00:00 mins
Oracle Database: Lec - 10 :- Architecture: Background processes: Process monitor process(PMON)
Video - 00:00:00 mins
Oracle Database: Lec - 11 :- Architecture: Background processes: System monitor process(SMON)
Video - 00:00:00 mins
Oracle Database: Lec - 12 :- Architecture: Background processes: Some other Background processes
Video - 00:00:00 mins
Log writer process
Quiz
Log writer process
Quiz
Log writer process
Quiz
Database Writer process
Quiz
Database Writer process
Quiz
Database Writer process
Quiz
Checkpoint process
Quiz
Checkpoint process
Quiz
Checkpoint process
Quiz
PMON & SMON process
Quiz
PMON & SMON process
Quiz
PMON & SMON process
Quiz
Fundamentals
Oracle Database: Lec - 13:- Check Oracle home variable
Video - 00:00:00 mins
Oracle Database: Lec - 14:- Data Dictionary views
Video - 00:00:00 mins
Oracle Database: Lec - 15:- Parameter files
Video - 00:00:00 mins
Oracle Database: Lec - 16:- Configuration files:- Spfile, control files, Datafiles - LAB
Video - 00:00:00 mins
Oracle Database: Lec - 17:- Rename a datafile
Video - 00:00:00 mins
Oracle Database: Lec - 17a:- Startup & Shutdown sequence
Video - 00:00:00 mins
Oracle Database: Lec - 17b:- Database Mount mode
Video - 00:00:00 mins
Oracle Database: Lec - 18:- Shutdown modes in Oracle
Video - 00:00:00 mins
Oracle Database: Lec - 19:- Materialized View
Video - 00:00:00 mins
Fundamentals
Quiz
Fundamentals
Quiz
Fundamentals
Quiz
Configuration files
Quiz
Configuration files
Quiz
Configuration files
Quiz
Basic Tasks and Understanding
Oracle Database: Lec - 20:- Account Lock
Video - 00:00:00 mins
Oracle Database: Lec - 21:-Error while dropping a user in container database
Video - 00:00:00 mins
Oracle Database: Lec - 22:- Clear screen in Oracle
Video - 00:00:00 mins
Oracle Database: Lec - 23:-Execute script from another location
Video - 00:00:00 mins
Oracle Database: Lec - 24:- Getting error for quota while insert on a tablespace in Oracle
Video - 00:00:00 mins
Oracle Database: Lec - 25:- Handling services : Oracle
Video - 00:00:00 mins
Oracle Database: Lec - 26:-Handling services: Oracle RAC
Video - 00:00:00 mins
Oracle Database: Lec - 27:-SET Keyword
Video - 00:00:00 mins
Tablespaces
Oracle Database: Lec - 28:- TableSpaces Introduction
Video - 00:00:00 mins
Oracle Database: Lec - 29:-Undo Tablespace Part1 Overview
Video - 00:00:00 mins
Oracle Database: Lec - 30:-Undo Tablespace - Part2: Read Consistency
Video - 00:00:00 mins
Oracle Database: Lec - 31:-Undo Tablespace Part3 - "Ora 01555-Snapshot too old error"
Video - 00:00:00 mins
Oracle Database: Lec - 32:-Undo Tablespace Part4 - Automatic Undo Management
Video - 00:00:00 mins
Oracle Database: Lec - 33:-Undo Tablespace Part5 - Reuse keyword
Video - 00:00:00 mins
Oracle Database: Lec - 34:-Undo Tablespace Part6 - Retention Guarantee
Video - 00:00:00 mins
Tablespaces
Quiz
Tablespaces
Quiz
Tablespaces
Quiz
UNDO tablespaces
Quiz
UNDO tablespaces
Quiz
UNDO tablespaces
Quiz
Redo Log files
Oracle Database: Lec - 35:- Redo log files - Overview
Video - 00:00:00 mins
Oracle Database: Lec - 36:-Redo log files - Archive log mode
Video - 00:00:00 mins
Oracle Database: Lec - 37:-Redo log files - Enable archive log mode
Video - 00:00:00 mins
Oracle Database: Lec - 38:- Redo log files Disable archive log mode
Video - 00:00:00 mins
Redo log files
Quiz
Redo log files
Quiz
Redo log files
Quiz
Trace Files
Oracle Database: Lec - 39:- Trace files 1 - Introduction
Video - 00:00:00 mins
Oracle Database: Lec - 40:- Trace files 2 - Purpose & use
Video - 00:00:00 mins
Oracle Database: Lec - 41:- Trace files 3 - Diff b/w Trace & Archive logs
Video - 00:00:00 mins
Oracle Database: Lec - 42:-Trace files-4 - Types
Video - 00:00:00 mins
Oracle Database: Lec - 43:- Trace files-5 - Location & Enable/Disable trace
Video - 00:00:00 mins
Oracle Database: Lec - 44:-Trace files-6 - View & Common Trace file issues
Video - 00:00:00 mins
Oracle Database: Lec - 45:- Trace Files- 7 - ADRCI
Video - 00:00:00 mins
Oracle Database: Lec - 46:- Trace Files - 8 - ADRCI - LAB
Video - 00:00:00 mins
Trace files
Quiz
Trace files
Quiz
Trace files
Quiz
Backup & Restore
Oracle Database: Lec - 47:- Backup & Restore;1- Introduction
Video - 00:00:00 mins
Oracle Database: Lec - 48:-Backup & Restore:2 - Backup Types
Video - 00:00:00 mins
Oracle Database: Lec - 49:-Backup & Restore:3 - Consistent & Inconsistent backups
Video - 00:00:00 mins
Oracle Database: Lec - 50:-Backup & Restore: 4 - RMAN - Introduction
Video - 00:00:00 mins
Oracle Database: Lec - 51:-Backup & Restore:5 - RMAN - Backup formats
Video - 00:00:00 mins
Oracle Database: Lec - 52:- Backup & Restore: 6 - Schedule RMAN backups
Video - 00:00:00 mins
Oracle Database: Lec - 54:- Backup & Restore: Oracle DataPump
Video - 00:00:00 mins
Backup & Restore
Quiz
Backup & Restore
Quiz
Backup & Restore
Quiz
RMAN backups
Quiz
RMAN backups
Quiz
RMAN backups
Quiz
Bonus Lecture
Oracle Database - Lec 54:- Bonus - Oracle Smartwork - Access local database scripts from a server
Video - 00:00:00 mins
More
Announcements
Reviews
Course Info
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway
