Podcasts by DBA Genesis Audio Experience

INACTIVE Session Blocking ACTIVE Session | dailyDBA 49 from 2020-06-27T14:30

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...

Benefits of RAID Storage | #dailyDBA 48 from 2020-06-26T13:30

Questions picked for the episode:

I am always confused between Oracle RAC, Oracle Grid, Oracle Clusterware & Oracle ASM. Could you clarify same?

What ar...

Remote DBA Support Services | #dailyDBA 47 from 2020-06-24T11:30

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 betwe...

Oracle Multi-tenant Lockdown Profiles | #dailyDBA 46 from 2020-06-23T10:30

Questions picked for the episode:

Whats your recommendations on when to use Indexes in a query?

Under Multi-Tenant architecture, do you recommend Global tem...

Secure RMAN Backups | #dailyDBA 45 from 2020-06-18T04:30

Questions picked-up for the episode:

What is LRU list inside Oracle instance?

What is the process to secure an Oracle RMAN-generated backup?

Before You Migrate Database to Another OS | #dailyDBA 44 from 2020-06-17T12:30

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 connec...

Recover Data Block Using Flashback | dailyDBA 43 from 2020-06-16T11:30

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 use...

Flashback Impact On Database Performance | dailyDBA 42 from 2020-06-15T10:30

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?

Listen

Oracle Wait Events | #dailyDBA 41 from 2020-06-14T08:30

0:00 #dbaChallenge: what changes you will make inside Oracle database to avoid ORA-1555 error?

-

Questions Picked-up For This Episode:

============================

Wh...

Grant User Challenge | #daily DBA 40 from 2020-06-13T07:30

In this episode of daily DBA, I speak about Grant User DBAChallenge!

-

#oracle #dailyDBA #dbaGenesis

-

Your comments encourage us to produce quality content, please t...

How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39 from 2020-06-12T05:16:12

0:01#dbaChallenge: One table had more number of indexes that columns?

-

Questions Picked-up For This Episode:

============================

What basic stats are gather...

Why CBO is better than RBO? | #dailyDBA 38 from 2020-03-14T16:30

#dbaChallenge: In Oracle RAC, will one node query execution check execution plan with another node?

-

Questions Picked-up For This Episode:

============================

Is Oracle RDBMS loosing edge over NoSQL | #dailyDBA 37 from 2020-03-14T04:30

#dbaChallenge: How to handle interview rejection?

-

Questions Picked-up For This Episode:

============================

How can I setup primary database so that if I d...

Convert CDB into Non-CDB | #dailyDBA 36 from 2020-03-13T16:30

#dbaChallenge: Can we trigger RMAN backups via OEM?

-

Questions Picked-up For This Episode:

============================

I'm unable to install Oracle Database after u...

RMAN Obsolete VS Expired Backup | #dailyDBA 35 from 2020-03-13T04:30

#dbaChallenge: Read about Oracle SAVEPOINT!

-

Questions Picked-up For This Episode:

============================

Can we perform any transactions in physical standby m...

What is Oracle Exadata? | #dailyDBA 34 from 2020-03-12T17:30

#dbaChallenge: Why Oracle RAC has only 3 SCAN listener?

-

Questions Picked-up For This Episode:

============================

I feel our production database is running...

Fixing Corrupted Undo Tablespace | #dailyDBA 33 from 2020-03-12T10:30

#dbaChallenge: Which cases sql plan hash value will change?

-

Questions Picked-up For This Episode:

============================

If RMNA backups are residing on diffe...

Gather Stale Stats Oracle | #dailyDBA 32 from 2020-03-02T11:30

#dbaChallenge: What are the different user roles inside Oracle Multi-tenant architecture?

-

Questions Picked-up For This Episode:

============================

1. How ...

Autonomous Databases Impact on DBA | #dailyDBA 31 from 2020-02-29T11:30

#dbaChallenge: What is the simplest way to enable all the triggers owned by a schema?

-

Questions Picked-up For This Episode:

============================

1. With the...

Data Guard Cloud Migration Challenge | #dailyDBA 30 from 2020-02-28T10:37:04

#dbaChallenge: How can you connect application to new primary, previously standby, without any downtime to application?

#dailyDBA #oracle #cloudDBA #dbaGenesis

-

How Secure is Cloud? | #dailyDBA 29 from 2020-02-28T10:23:37

#dbaChallenge: What is the difference between soft parsing and hard parsing?

-

Questions Picked-up For This Episode:

============================

1. What are the cont...

Oracle AutoUpgrade Tool | #dailyDBA 28 from 2020-02-17T11:30

#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:

======================...

Slow Running Query Tips | #dailyDBA 27 from 2020-02-08T10:43:59

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-...

Oracle Optimizer Cost | #dailyDBA 26 from 2020-02-07T05:46:24

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-...

What is Cloud? | #dailyDBA 25 from 2020-02-05T10:00:39

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: Listen

Oracle Triggers Execution Order | #dailyDBA 24 from 2020-02-04T07:55:05

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-...

db_file_sequential_read | #dailyDBA 23 from 2020-02-03T11:48:55

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-...

What is Virtual IP (VIP) | #dailyDBA 22 from 2020-01-31T05:35:11

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-...

SQL Profile vs SQL Plan Management | #dailyDBA 21 from 2020-01-29T10:00:06

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-...

Why Rebuild Indexes? | #dailyDBA 20 from 2020-01-28T07:14:17

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-...

How to Become Cloud DBA | #dailyDBA 19 from 2020-01-27T15:01:25

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-...

Calculate FRA Size in Oracle | #dailyDBA 18 from 2020-01-25T12:08:17

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-...

How SCAN Works in RAC? | #dailyDBA 17 from 2020-01-23T14:21:48

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?

-

#da...

DBMS Gather Table Stats | #dailyDBA 16 from 2020-01-22T16:03:41

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-...

Avoid Hard Parsing in Oracle | #dailyDBA 15 from 2020-01-21T15:45:44

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-...

Oracle Fusion vs Oracle Cloud | #dailyDBA 14 from 2020-01-20T14:10:10

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-...

What Mistake DBAs are Making? | #dailyDBA 13 from 2020-01-18T14:24:38

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...

Define Oracle Instance Size | #dailyDBA 12 from 2020-01-17T10:11:14

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-...

Fix SQL Plan in Oracle | #dailyDBA 11 from 2020-01-16T11:00:38

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-...

Three SCAN IPs Resolving 8 Node RAC | #dailyDBA 10 from 2020-01-14T14:05:21

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-...

When to go for Full Table Scan? | #dailyDBA 9 from 2020-01-11T12:36:55

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-...

Improve EXPDP Performance | #dailyDBA 8 from 2020-01-09T11:54:21

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-...

Row Chaining in Oracle | #dailyDBA 7 from 2020-01-08T07:29:26

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 #clo...

How to Add Diskgroup in ASM | #dailyDBA 6 from 2020-01-07T10:11:38

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 #clo...

Which Cloud Platform is Best | #dailyDBA 5 from 2020-01-06T13:00:34

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 #daily...

Rebuild Indexes Faster in Oracle | #dailyDBA 4 from 2020-01-04T12:07:05

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 #clo...

DBAs Losing Job due to Cloud | #dailyDBA 3 from 2020-01-03T03:30

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! 

- 

#orac...

Load 5 million rows into Oracle | #dailyDBA 2 from 2020-01-02T13:58:17

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!

-

Query is running slow! #dailyDBA 1 from 2020-01-01T08:30

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, mess...