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