Home
Videos uploaded by user “Ramkumar Swaminathan”
DML Processing in an Oracle Database -  DBArch Video 8
 
09:07
This video explains the steps involved in processing a DML statement in an Oracle Database Server
Views: 38448 Ramkumar Swaminathan
SELECT statement Processing in an Oracle Database - DBArch  Video 7
 
06:22
You will learn from this video how a SELECT statement is processed in an Oracle Database. You will learn about the a Parse, Execute and Fetch phases in a select statement.
Views: 13254 Ramkumar Swaminathan
AWS vs Oracle Cloud  - IaaS comparison - CloudCompare 01
 
05:58
In this video you will get a comparison of the important services on IaaS from Amazon and Oracle.
Views: 12383 Ramkumar Swaminathan
Instance Recovery in an Oracle Database - DBArch Video 10
 
06:00
This video explains how Instance recovery happens in an Oracle Database.
Views: 7189 Ramkumar Swaminathan
Concept of VIP in Oracle RAC - SCAN part 1 - RAC 03
 
04:08
In this video you will understand about VIP/ VIPNAME which are used in Oracle RAC. This understanding is necessary to understand about SCAN in Oracle RAC/ GI
Views: 4823 Ramkumar Swaminathan
Oracle Database  - Listener Process - DBArch Video 6
 
07:33
You will learn about the Oracle Listener, The purpose of Listener and what is the impact if its down...
Views: 8293 Ramkumar Swaminathan
Relationships of Physical and Logical Storage structures in an Oracle Database - DBArch Video 22
 
06:14
In this video you will understand the Relationships between the Physical files and Logical Components - Tablespace, Segments, Extents and Oracle Blocks in an Oracle Database
Views: 7106 Ramkumar Swaminathan
Redo Logs in an Oracle Database - DBArch Video 11
 
08:54
This video explains the concepts of Redo Log Groups and Files in an Oracle Database. You will understand how Oracle Instance uses Redo Buffers and Logwriter to keep the redo in Redo Logs
Views: 8504 Ramkumar Swaminathan
Oracle Grid Infrastructure and Real Application Clusters - Introduction - RAC 01
 
10:00
This is an introduction video that introduces concepts of Clusters and the important terms in Oracle Real Application Clustering...
Views: 5879 Ramkumar Swaminathan
Introduction to Oracle Real Application Clusters - DBArch Video 15
 
05:02
In this video , you will understand how an Oracle RAC ( Real Application Cluster) works. You will know the benefits of setting up a RAC Cluster.
Views: 9475 Ramkumar Swaminathan
Oracle Data Guard - Standby Databases Overview - DG Video 2
 
07:10
In this video you will learn about the different types of Standby Databases in an Oracle Data Guard environment. You will get to know the typical use cases in which you would use each type of Standby Database.
Views: 4680 Ramkumar Swaminathan
Oracle Instance Startup - DBArch Video 13
 
03:38
In this video you will learn the various steps involved in starting an Oracle Database Instance. You get introduced to the different states of an Instance - IDLE, NOMOUNT, MOUNT and OPEN and what happens in each of these states.
Views: 4428 Ramkumar Swaminathan
Oracle Database and Instance Components - DBArch Video 3
 
10:09
In this video you will learn about the Relationship between and Oracle Instance and an Oracle Database. You will know about the various components of an Instance ( SGA and Background Processes) and the various files of the Database and how they interact.
Views: 15091 Ramkumar Swaminathan
Why Data Guard - DG Video 1
 
03:55
In this video you will learn the purpose and benefits of using Oracle Data Guard
Views: 3600 Ramkumar Swaminathan
Oracle Data Guard - Active Data Guard - Overview - DG Video 5
 
04:32
In this video you will learn about the benefits/features of using Active Data Guard in an Oracle Database. The features include Real Time Query, Fast Incremental Backups at the Standby site and Automatic Block recovery...
Views: 3780 Ramkumar Swaminathan
Introduction to Oracle Database Architecture - DBArch Video 2
 
03:24
You will learn from this video how a computer is used by an Oracle Database. You will learn about how Memory , CPU and Storage are used by an Oracle Database. This is the fundamental Architecture of an Oracle Database.
Views: 13348 Ramkumar Swaminathan
Oracle Database Files -  DBArch Video 5
 
09:07
In this video you learn about the storage components in an Oracle Database. You learn about the different files , Data files, Control Files and Redo log files and their purpose in an Oracle Database Architecture. learn Oracle, learn Oracle database,
Views: 8069 Ramkumar Swaminathan
Oracle Database Backup and Recovery Introduction - Backup&Reco Video 1
 
06:25
In this video you will get introduced to the Backup and Recovery options available with an Oracle Database.
Views: 4579 Ramkumar Swaminathan
Crash Recovery in Oracle RAC - DBArch Video 16
 
06:37
In this video you will understand how an Oracle RAC cluster recovers from an Instance Crash which is also called Crash Recovery. The video will use the whiteboard to show you what happens when one of the nodes crashes in a Cluster and how the surviving node recovers the failed node related transactions.
Views: 6991 Ramkumar Swaminathan
Storage Concepts - Hard Disks Vs Flash/SSD , LUN and Tiered Storage concepts - ASM Video 3
 
11:10
In this video you will learn about performance of Hard Disks and compare them with Flash/SSD Disks. You will also learn about how a LUN is created. At a high level you will learn what is a LUN and how tiered storage is created.
Views: 3963 Ramkumar Swaminathan
DDL statement processing in an Oracle Database - DBArch Video 9
 
02:10
In this video you learn about what happens when you run a DDL ( data definition language) command in the Oracle Database
Views: 7010 Ramkumar Swaminathan
Introduction to Oracle GoldenGate - GG Video 1
 
02:23
In this video you are introduced to the tool Oracle GoldenGate.
Views: 5223 Ramkumar Swaminathan
User and Schema - DbArch Video 33
 
04:31
In this video you will understand whats the difference between an Oracle User and Schema. You will also get to know about some of the most frequently created objects in a Schema.
Views: 2487 Ramkumar Swaminathan
What are the different types of Tablespaces in an Oracle Database - DBArch Video 23
 
08:22
In this video you will understand about the different types of tablespaces and their use/purpose.
Views: 5925 Ramkumar Swaminathan
What are failure groups in Oracle ASM - ASM Video 09
 
06:37
In this video you will learn about Failure Groups in ASM disk groups
Views: 1856 Ramkumar Swaminathan
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it.
Views: 2473 Ramkumar Swaminathan
What is Fast Recovery Area and how to configure it- Backup&Reco Video 6
 
03:28
In this video you will learn about FRA - Fast Recovery Area, what is used for and how to configure it
Views: 1645 Ramkumar Swaminathan
Oracle Database Shutdown - DBArch Video 14
 
06:36
In this video you learn what happens when an Oracle Database is Shutdown. You will learn about the different types of Shutdown and the intricate details of what happens in each of the types.
Views: 3391 Ramkumar Swaminathan
Space Management in Extents and Segments - DBArch Video 31 / DBPerf Video 13
 
13:00
In this video you will understand about the following - Dictionary managed Vs Locally Managed Tablespaces - Manual Vs Automatic Segment Space Management - PCTFREE and PCTUSED - Row Migration and Row Chaining
Views: 3814 Ramkumar Swaminathan
What are Database Services - RAC 02
 
05:52
In this video you will understand the concept of Services in Oracle Database. This is the underlying framework with which High Availability and Failover is implemented in RAC
Views: 3549 Ramkumar Swaminathan
Connection Pool with an Oracle Database - DBArch  Video 19
 
08:06
In this video you will learn the concept of a Connection pool an application uses with a Database. You will learn the need for connection pool and how it helps in optimizing resource utilzation on the Database Server. You will learn that Logon and Logoff are the most resource intensive tasks in a database, and hence both tasks should be avoided during normal operations of the application and database.
Views: 4144 Ramkumar Swaminathan
Parameters for Archiving in an Oracle database - Backup&Reco Video 7
 
09:39
In this video you will learn about the various parameters available to configure archiving of redo log files in an Oracle Database.
Views: 1920 Ramkumar Swaminathan
Oracle GoldenGate Processes Overview - GG Video 6
 
04:13
This video gives you an overview of the processes ( Extract, Pump and Replicat) used by GoldenGate to replicate data between databases
Views: 7496 Ramkumar Swaminathan
Server Pools in Oracle Grid Infrastructure - SCAN part 2 - RAC 04
 
15:58
In this video you will understand the concept of Server pools, how you configure them... and how nodes automatically move between sever pool based on your configuration parameters for the server pools.
Views: 4091 Ramkumar Swaminathan
User Managed Backup - Backup&Reco Video 2
 
05:19
In this video you will learn how to do Oracle Database backups with OS commands.
Views: 2479 Ramkumar Swaminathan
ASM Redundancy - ASM Video 08
 
05:50
In this video you will learn what is Redundancy in ASM. You will understand the 3 types of Redundancy - External, Normal and High, when you should use them and what is the benefit of using Redundancy.
Views: 1707 Ramkumar Swaminathan
Storage Concepts - ASM Video 02
 
07:42
In this video you will learn about Basic Storage concepts in Storage Arrays, such as Striping and Mirroring. This is how storage vendors found a way to catch up with performance improvements CPU and Memory vendors were delivering.
Views: 3688 Ramkumar Swaminathan
GNS Explained - RAC 08
 
04:30
In this video you will understand what is GNS - Grid Naming Service in Oracle Grid Infrastructure
Views: 1151 Ramkumar Swaminathan
Structure of Data Blocks - DBArch Video 29
 
05:35
In this video you will understand about the contents of a Data Block. You will learn about Block Header, Transaction slots, Row Directory and space for Data / rows.
Views: 2146 Ramkumar Swaminathan
Shared Server Configuration in Oracle Database - DBArch Video 18
 
08:06
You will learn about the concept of Shared Servers and Dispatchers in an Oracle Database. This is a method of optimizing resources on the Database Server side when a user is connecting from a Thick Client ( application installed on a desktop).
Views: 3650 Ramkumar Swaminathan
ASM Striping and ASM Templates - ASM Video 07
 
04:49
In this video you will learn about how Striping works in ASM. You will understand the concept of Coarse and Fine striping along with the concepts of Templates
Views: 1603 Ramkumar Swaminathan
Read Consistency -  Introduction - DBArch Video 24
 
03:29
In this video you will understand how Oracle Database implements Concurrency and Consistency when Multiple users access the data.
Views: 2301 Ramkumar Swaminathan
Key Capabilities of Oracle GoldenGate - GG Video 2
 
03:20
This Video will list the key capabilities of Oracle GoldenGate
Views: 4594 Ramkumar Swaminathan
Managing Data Guard and Data Guard Services - Overview - DG Video 3
 
03:50
In this video you will learn about how to manage an Oracle Data Guard configuration and what are the core services that enable Data Guard to work.
Views: 2317 Ramkumar Swaminathan
ROWID - DBArch Video 32
 
05:20
In this video you will understand what is ROWID in an Oracle Database, where is it stored and what are its components.
Views: 1803 Ramkumar Swaminathan
Creating a Physical Standby database using RMAN - DG Video 4
 
08:10
In this video you will learn about creating a Physical Standby Database using RMAN in an Oracle Data Guard environment. This video explains about the pre-requisites that are to be done before you run the RMAN command to create a standby database.
Views: 3791 Ramkumar Swaminathan
What should be the Database block size? - DBPerf Video 15
 
07:44
In this video you will learn about the different block sizes and how it impacts an Oracle database performance. Note: You cannot change the block size after a database is created.... Stay subscribed for updates....
Views: 1290 Ramkumar Swaminathan
Fault Tolerance - ASM Video 04
 
06:34
In this video you will understand the concept of Fault Tolerance.
Views: 1660 Ramkumar Swaminathan