DBA Genesis Audio Experience

DBA Genesis Audio Experience

dbagenesis.com
DBA Genesis is the leading platform for Database Administrators which provides Courses, Online Trainings and Real-Time DBA projects. In addition to above, DBA Genesis also provides remote DBA support and remote cloud DBA support to clients across the globe. DBA Genesis is a highly sought after corporate training platform. With over 50,000+ followers and a vision to provide simplified database learning, our goal is to reach every single DBA on this planet by 2025!


INACTIVE Session Blocking ACTIVE Session | dailyDBA 49
Jun 27 • 20 min
Questions Picked for the Episode What is the use of Locks inside database? Why can’t we use the database without locks? Our reporting team directly works on production database and my client is insisting to give a dedicated database which will act as copy…
Benefits of RAID Storage | #dailyDBA 48
Jun 26 • 20 min
Questions picked for the episode: I am always confused between Oracle RAC, Oracle Grid, Oracle Clusterware & Oracle ASM. Could you clarify same? What are the benefits and drawbacks of using RAID storage? Which is the fastest way to delete millions of…
Remote DBA Support Services | #dailyDBA 47
Jun 24 • 20 min
Questions Picked for the show I build a custom application and want to connect it to Oracle database. What are my options? What causes slow connection between two data centres? Which Oracle technology will be in demand - Oracle RAC or Oracle Data Guard? I…
Oracle Multi-tenant Lockdown Profiles | #dailyDBA 46
Jun 23 • 16 min
Questions picked for the episode: Whats your recommendations on when to use Indexes in a query? Under Multi-Tenant architecture, do you recommend Global temporary tablespace or dedicated local temporary tablespace for each PDB? How to solve ORA-00018:…
Secure RMAN Backups | #dailyDBA 45
Jun 18 • 13 min
Questions picked-up for the episode: What is LRU list inside Oracle instance? What is the process to secure an Oracle RMAN-generated backup? What is the difference between Oracle RAC and Active Data Guard? Can I run Data Pump in GUI mode? How can I update…
Before You Migrate Database to Another OS | #dailyDBA 44
Jun 17 • 16 min
Questions picked up for this show: How To Restore Rman Backups On A Different Node When The Directory Structures Are Different? We have a dblink that connects to production server. What will happen to dblink if there is a failover or switchover? What are…
Recover Data Block Using Flashback | dailyDBA 43
Jun 16 • 19 min
Questions picked up for the show: Can I use flashback to recover a data block? How can we significantly reduce the backup size? Can a user change their own password in Oracle? If we rollback to a savepoint, are the UNDO blocks generated after the…
Flashback Impact On Database Performance | dailyDBA 42
Jun 15 • 18 min
Questions picked up for this episode: We have a requirement - my client wants us to setup materialized view over DB Links with FAST REFRESH. What are your thoughts? If I execute select statement multiple times, does it guarantee that the order of records…
Oracle Wait Events | #dailyDBA 41
Jun 14 • 17 min
0:00 #dbaChallenge: what changes you will make inside Oracle database to avoid ORA-1555 error? - Questions Picked-up For This Episode: ============================ When is the best time to gather table / schema stats? What is your recommendations on DB…
Grant User Challenge | #daily DBA 40
Jun 13 • 2 min
In this episode of daily DBA, I speak about Grant User DBAChallenge! - #oracle #dailyDBA #dbaGenesis - Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of…
How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39
Jun 12 • 15 min
0:01#dbaChallenge: One table had more number of indexes that columns? - Questions Picked-up For This Episode: ============================ What basic stats are gathered when we run DBMS_STATS package? #dba Challenge! What sample size should I use? What…
Why CBO is better than RBO? | #dailyDBA 38
Mar 14 • 20 min
#dbaChallenge: In Oracle RAC, will one node query execution check execution plan with another node? - Questions Picked-up For This Episode: ============================ What recommendations do you have when it comes to indexes? How to write better queries…
Is Oracle RDBMS loosing edge over NoSQL | #dailyDBA 37
Mar 14 • 17 min
#dbaChallenge: How to handle interview rejection? - Questions Picked-up For This Episode: ============================ How can I setup primary database so that if I delete rows on primary, the rows must not be deleted on standby? How can I generate a…
Convert CDB into Non-CDB | #dailyDBA 36
Mar 13 • 20 min
#dbaChallenge: Can we trigger RMAN backups via OEM? - Questions Picked-up For This Episode: ============================ I’m unable to install Oracle Database after uninstalling it on windows system. What could be the issue? When I mount database, why it…
RMAN Obsolete VS Expired Backup | #dailyDBA 35
Mar 13 • 14 min
#dbaChallenge: Read about Oracle SAVEPOINT! - Questions Picked-up For This Episode: ============================ Can we perform any transactions in physical standby mode? What is the difference between obsolete and expired backup? What is SAVEPOINT in…
What is Oracle Exadata? | #dailyDBA 34
Mar 12 • 18 min
#dbaChallenge: Why Oracle RAC has only 3 SCAN listener? - Questions Picked-up For This Episode: ============================ I feel our production database is running slow, can I increase SGA by 5 GB? What is the difference between Oracle Database and…
Fixing Corrupted Undo Tablespace | #dailyDBA 33
Mar 12 • 12 min
#dbaChallenge: Which cases sql plan hash value will change? - Questions Picked-up For This Episode: ============================ If RMNA backups are residing on different DISK GROUPS then can we restore the rman backup? If yes then is there any specific…
Gather Stale Stats Oracle | #dailyDBA 32
Mar 2 • 18 min
#dbaChallenge: What are the different user roles inside Oracle Multi-tenant architecture? - Questions Picked-up For This Episode: ============================ 1. How oracle SQL engine re-writes the query? 2. Could you please explain what is the difference…
Autonomous Databases Impact on DBA | #dailyDBA 31
Feb 29 • 17 min
#dbaChallenge: What is the simplest way to enable all the triggers owned by a schema? - Questions Picked-up For This Episode: ============================ 1. With the cloud transition, is the DBA job getting more difficult or more easy? 2. There are two…
Data Guard Cloud Migration Challenge | #dailyDBA 30
Feb 28 • 6 min
#dbaChallenge: How can you connect application to new primary, previously standby, without any downtime to application? #dailyDBA #oracle #cloudDBA #dbaGenesis - Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in…
How Secure is Cloud? | #dailyDBA 29
Feb 28 • 20 min
#dbaChallenge: What is the difference between soft parsing and hard parsing? - Questions Picked-up For This Episode: ============================ 1. What are the contents of oracle inventory file and in which format does it exists? 2. How will you…
Oracle AutoUpgrade Tool | #dailyDBA 28
Feb 17 • 19 min
#dbaChallenge: What will happen if you loose one of the control files while Oracle database is up and running? - Questions Picked-up For This Episode: ============================ 1. Can you speak about Oracle Database AutoUpgrade tool? 2. How many…
Slow Running Query Tips | #dailyDBA 27
Feb 8 • 15 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. I want to know about…
Oracle Optimizer Cost | #dailyDBA 26
Feb 7 • 30 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. Does select statement…
What is Cloud? | #dailyDBA 25
Feb 5 • 26 min
In this silver jubilee episode of daily DBA, I pick up the most important confusion of DBAs across the globe and that is “What is cloud?” - Questions Picked-up For This Episode: ============================ 1. What is cloud computing? 2. Is cloud secure?…
Oracle Triggers Execution Order | #dailyDBA 24
Feb 4 • 19 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. I want to copy table…
db_file_sequential_read | #dailyDBA 23
Feb 3 • 18 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. Can data exists above…
What is Virtual IP (VIP) | #dailyDBA 22
Jan 31 • 14 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. What would you…
SQL Profile vs SQL Plan Management | #dailyDBA 21
Jan 29 • 33 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. What is materilized…
Why Rebuild Indexes? | #dailyDBA 20
Jan 28 • 30 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. How to open database…
How to Become Cloud DBA | #dailyDBA 19
Jan 27 • 22 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. I would like to…
Calculate FRA Size in Oracle | #dailyDBA 18
Jan 25 • 21 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. How to choose…
How SCAN Works in RAC? | #dailyDBA 17
Jan 23 • 14 min
In this episode of daily DBA, I would like to present you with SCAN listener concept inside Oracle RAC and how it functions! - How SCAN works inside Oracle RAC? - #dailyDBA #oracleDatabase #cloudDBA #dbaGenesis #dbaChallenge - Your comments encourage us…
DBMS Gather Table Stats | #dailyDBA 16
Jan 22 • 25 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. How to avoid row lock…
Avoid Hard Parsing in Oracle | #dailyDBA 15
Jan 21 • 30 min
In this episode of daily DBA, I pick up 6 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. How flashback works…
Oracle Fusion vs Oracle Cloud | #dailyDBA 14
Jan 20 • 15 min
In this episode of daily DBA, I pick up 6 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. Does sorting happens…
What Mistake DBAs are Making? | #dailyDBA 13
Jan 18 • 25 min
In this episode of daily DBA, I speak about what mistakes DBA are making these days? - #dailyDBA #oracleDatabase #cloudDBA #dbaGenesis - Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me…
Define Oracle Instance Size | #dailyDBA 12
Jan 17 • 29 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. What are the…
Fix SQL Plan in Oracle | #dailyDBA 11
Jan 16 • 30 min
In this episode of daily DBA, I pick up 6 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. Client is upgrading OS…
Three SCAN IPs Resolving 8 Node RAC | #dailyDBA 10
Jan 14 • 26 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. By mistake someone…
When to go for Full Table Scan? | #dailyDBA 9
Jan 11 • 27 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. Can we directly move…
Improve EXPDP Performance | #dailyDBA 8
Jan 9 • 22 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-up For This Episode: ============================ 1. When must a DBA plan…
Row Chaining in Oracle | #dailyDBA 7
Jan 8 • 35 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - Your comments encourage us to produce quality content,…
How to Add Diskgroup in ASM | #dailyDBA 6
Jan 7 • 28 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - Your comments encourage us to produce quality content,…
Which Cloud Platform is Best | #dailyDBA 5
Jan 6 • 24 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! #oracle #dba #cloud #dailyDBA Your comments encourage us to produce quality content, please…
Rebuild Indexes Faster in Oracle | #dailyDBA 4
Jan 4 • 24 min
In this episode of daily DBA, I pick up 7 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - Your comments encourage us to produce quality content,…
DBAs Losing Job due to Cloud | #dailyDBA 3
Jan 2 • 24 min
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - Your comments encourage us to produce quality content,…
Load 5 million rows into Oracle | #dailyDBA 2
Jan 2 • 31 min
In this episode of daily DBA, I pick up 10 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - #oracle #dba #cloud #dailyDBA - Your comments encourage us to produce quality content,…
Query is running slow! #dailyDBA 1
Jan 1 • 31 min
Welcome to the #dailyDBA show, I am your host Arun Kumar and my goal with this show is to help you become an Oracle Database expert. I personally get so many emails, messages, comments that made me think like what can we do to create a place where I…