DBA Genesis Audio Experience

DBA Genesis Audio Experience

By Arun Kumar
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!
Where to listen
Breaker Logo
Google Podcasts Logo
Overcast Logo
Pocket Casts Logo
RadioPublic Logo
Spotify Logo
Currently playing episode

INACTIVE Session Blocking ACTIVE Session | dailyDBA 49

DBA Genesis Audio Experience

Go to next audioGo to next audio
Go to prev audioGo to prev audio
1x
INACTIVE Session Blocking ACTIVE Session | dailyDBA 49
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 of production database. What are my options? In one of the interviews, I was asked "In what scenario an INACTIVE session will BLOCK an active session". I really don't know the answer. Every-time my team performs export and import, they have to drop the constraints and indexes. Post import is done, we re-create the constraints and indexes. Is there any simple method for same? How to find performance bottleneck of a query? - #oracle #dbagenesis #performanceTuning - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
20:28
June 27, 2020
Benefits of RAID Storage | #dailyDBA 48
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 records from the database? If I purchase Oracle Enterprise Edition, do I need to take separate license for Oracle Enterprise Manager 13c? There is no Level 0 backup taken till now, and if I start incremental Level 1 backup, will it fail or proceed? If it proceeds, can i use it to restore the DB without level 0 backup? - #oracle #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
20:52
June 26, 2020
Remote DBA Support Services | #dailyDBA 47
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 want to provide remote DBA support services. Where should I start? What is your one technique to be safe and not to be sorry as Oracle DBA? - #oracle #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
20:59
June 24, 2020
Oracle Multi-tenant Lockdown Profiles | #dailyDBA 46
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: maximum number of sessions exceeded? What are lockdown profiles in multi-tenant architecture? When do you recommend to go for Oracle Autonomous Database? - #oracle #dbagenesis #oracle12c #oracleMultiTenant - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
16:10
June 23, 2020
Secure RMAN Backups | #dailyDBA 45
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 ROWID in Oracle? - #oracle #dbagenesis #rman - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
13:12
June 18, 2020
Before You Migrate Database to Another OS | #dailyDBA 44
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 your recommendations on migrating a database from one OS to another OS? I would like to rebuild standby database. Can I rebuild standby anytime or it has to be created only during primary database creation? What is the frequency at which standby is synced with primary database? - #oracle #dbagenesis #goldenGate #database #dataGuard - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
16:53
June 17, 2020
Recover Data Block Using Flashback | dailyDBA 43
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 savepoint released right away? 13:18 Does the RESOURCE Role already have UNLIMITED TABLESPACE privilege or I have to grant it separately? - #oracle #dbagenesis #database - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
19:48
June 16, 2020
Flashback Impact On Database Performance | dailyDBA 42
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 will be same every-time?  Could you let us know if enabling FLASHBACK has impact on the performance of the database ? My client wants me to upload 72 million rows from an external table into Oracle. The table to which I have to perform import has INSERT triggers. What are your recommendations on the load? Can you give me one simple example that causes row movement inside Oracle? - #oracle #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: https://dbagenesis.com/p/contact - Start your DBA Journey Today !!
18:01
June 15, 2020
Oracle Wait Events | #dailyDBA 41
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 block size for OLTP and data warehouse systems? Difference between Oracle 10g and 11g? My database archive space gets full every week. I have to remove archives manually "RMAN delete archivelog all;" Any workaround? What are wait events inside Oracle Database? -- Bonus Question:  How ORACLE DBA interviews are conducted?  -- #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
17:18
June 14, 2020
Grant User Challenge | #daily DBA 40
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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
02:58
June 13, 2020
How Does AUTO_SAMPLE_SIZE work? | #dailyDBA 39
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 types of stats are considered by Optimizer? I want to consolidate data from multiple production databases into one oracle staging database. How can I achieve it? How can I restore indexes while restoring dropped table? -- Bonus Question How to say NO in an interview? -- #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
15:07
June 12, 2020
Why CBO is better than RBO? | #dailyDBA 38
#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 so that if there is any change at application end, no changes must be done at db end? Why CBO is better than RBO? What is the impact of Exadata, Cloud and SAAS products on DBA jobs? How to define which column to create index on? Bonus Question: How to identify fake dba vs experienced dba? - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
20:16
March 14, 2020
Is Oracle RDBMS loosing edge over NoSQL | #dailyDBA 37
#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 report of every SQL statement executed by every session? Is Oracle RDBMS loosing edge over NoSQL? How can I reduce Concurrency wait event? Can we create PDB from an existing PDB via DBLINK? Bonus Question: How to handle interview rejection? - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
17:06
March 14, 2020
Convert CDB into Non-CDB | #dailyDBA 36
#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 hangs indefinitely? How come two session are running same sql_id inside Oracle database? What is the best way to upgrade from 9i to 12c when DB size is 52 GB? How can I convert from Oracle multi-tenant (CDB) to NON-CDB? Bonus Question: How to learn things faster - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
20:19
March 13, 2020
RMAN Obsolete VS Expired Backup | #dailyDBA 35
#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 Oracle SQL? How can I kill all sessions inside Oracle at once? Which is the best way to upload excel sheet into Oracle? Bonus Question: Low confidence DBAs - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
14:07
March 13, 2020
What is Oracle Exadata? | #dailyDBA 34
#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 Oracle Exadata? How to load data into another database from oracle database? How can I get username of the user that inserted a record in a table? Query running slow post upgrade to 18c? Bonus Question: What's your recommendation for setting up Oracle practice lab at home! - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
18:42
March 12, 2020
Fixing Corrupted Undo Tablespace | #dailyDBA 33
#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 change is needed in restore syntax? How to fix when undo tablespace get corrupted? Is optimizer smart enough to choose between index scan and table scan? What is the difference between using table_name and schema.table_name in a query? cdump location is growing faster and filling up entire /data mount point. What to do? Bonus Question: Must have tools for Oracle DBAs. - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
12:55
March 12, 2020
Gather Stale Stats Oracle | #dailyDBA 32
#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 between SGA_Target, PGA_Target and Memory_Target? 3. What is meant by stale stats on a table? How to resolve it? 4. Why I can't grant DBA privilege to a user inside PDB while connected to CDB as sys user? 5. How can I export schema using data pump from last full backup taken via RMAN? Bonus Question: Oracle query running slow. Earlier it was taking 9 min and now taking 48 min. - #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
18:56
March 2, 2020
Autonomous Databases Impact on DBA | #dailyDBA 31
#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 queries - Q1 and Q2. Optimizer cost for Q1 is less than Q2. But Q2 executes faster. Why? 3. I would like to know more about Autonomous Databases and how will it change the current roles we DBAs have now? 4. Difference between srvctl start scan vs srvctl start scan_listener? 5. What is the difference between ASM Striping and ASM Rebalancing? Bonus Question: Application team is trying to populate 52,000 names in their application interface. Workaround! - #dailyDBA #oracle #cloudDBA #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
17:46
February 29, 2020
Data Guard Cloud Migration Challenge | #dailyDBA 30
#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 the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
06:00
February 28, 2020
How Secure is Cloud? | #dailyDBA 29
#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 calculate the initial size of the database?  How would you recommend the storage of datafiles, control files, redo log files etc? 3. How will cloud put the DBA role into a better position? 4. How secure my data is in the cloud? 5. Why do I see multiple values under FAL_SERVER? Bonus Question: Who should be nervous about cloud? - #dailyDBA #oracle #cloudDBA #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !! Become an exclusive DBA Genesis member: https://www.youtube.com/channel/UCUHHRiLeH7sO46GJBRGweag/join
20:58
February 28, 2020
Oracle AutoUpgrade Tool | #dailyDBA 28
#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 connections can listener handle? 3. Why data blocks are always 80% used and not 100%? 4. Can I have redo log groups with different size? 5. I lost redo log file and have no multiplexed copy or archive log. How can I recover the database? - #dailyDBA #oracle #cloudDBA #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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
19:21
February 17, 2020
Slow Running Query Tips | #dailyDBA 27
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 redolog status for following scenario. We have 3 redolog groups(1,2 and 3) each group having 2 members(a andb). Q:When we are executing some DML operations by that time how the LGWR will write changes to online redologs? whether it is writing to 1a, 1b, 2a, 2b.... or will it write 1a and 1b simultaneously ? 2. How to find most fragmented tables and indexes that are caused of high I/O and how to get rid of them? 3. What is better to use when creating a new database: Automatic Shared memory Management or Automatic Memory Management. 4. Difference between temporary table and global temporary table? 5. Can you pls give us some tips on what steps to perform when a query is slow? - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
15:36
February 8, 2020
Oracle Optimizer Cost | #dailyDBA 26
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 use UNDO? If so why? 2. If there is high I/O, does that mean its a problem with the hardware? 3. Our company has a lab practice database. At the end of each day, we would like to revert back all the changes made to the database as it was at the beginning of the day. How can we achieve it? 4. What is cost inside optimizer? 5. Are Fragmentations and High Water Mark same? - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
30:38
February 7, 2020
What is Cloud? | #dailyDBA 25
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? 3. What is hybrid cloud? 4. Can you talk about cloud certifications? 5. What are the downside of cloud? 6. Public cloud vs private cloud. 7. Which cloud is best? 8. Oracle cloud vs aws cloud 9. What are the services provided by cloud? 10. Where to learn cloud? - #dailyDBA #oracle #cloudDBA #dbaGenesis #cloud - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
26:33
February 5, 2020
Oracle Triggers Execution Order | #dailyDBA 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-up For This Episode: ============================ 1. I want to copy table structures (owned by single schema) from one database to another database without the table rows. How can I achieve it? 2. How can I count total records from a table faster? 3. In your experience, what is a GOOD NUMBER of database connections inside the database? 4. One query takes few seconds in MS SQL Server and same query takes few minutes in Oracle. Why? 5. Is there a way I can define the execution order of Oracle triggers? - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
19:02
February 4, 2020
db_file_sequential_read | #dailyDBA 23
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 High Water Mark? 2. I have two tables: TABLE_A and TABLE_B. Table_B structure is same as TABLE_A except that it has one extra column. How can I copy records from table_A into table_B even though Table_B is having one extra column? 3. Difference between db_file_sequential_read and db_file_scattered_read. 4. How can I upgrade from Oracle 9.2.0.1 32bit to 11g 32bit version? 5. Can I create DB link between databases hosted on different OS platforms? Bonus: I created a user inside the database and gave all necessary permissions. But I am still not able to connect via SQL Developer? - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
18:40
February 3, 2020
What is Virtual IP (VIP) | #dailyDBA 22
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 recommend as a DBA either to use sql profiles by sql tuning set or fixing plan by using sql plan management? 2. Why we put database in MOUNT RESTRICT mode before dropping database? 3. Can you explain SQL tuning advisor how to run and how to analyze it? 4. Difference between integrated capture and classic capture in golden gate? In integrated capture do we need to create the logminer database in source database or Oracle uses logminer mechanism? 5. What is virtual IP (HAIP) and how it is different from normal IP? Bonus: I created a user inside the database and gave all necessary permissions. But I am still not able to connect via SQL Developer? - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
14:46
January 31, 2020
SQL Profile vs SQL Plan Management | #dailyDBA 21
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 view and how can I purge the MV logs? 2. If locks are coming and releasing itself within 2-3 seconds, in this situation what we can do in oracle so locks does not occur even for few seconds. 3. Hi Arun, what happens if password file is deleted from the standby server? Will there be an impact on standby sync with primary? How will we fix the issue? 4. Scenario: we get complaint that one sql is taking long time for execution. When investigated and found that sql is using full table scan where it is fetching only 20% records. So we ran sql tuning advisory and fix sql profiles forcing optimizer to choose index. Finally issue got resolved query performance increased. Later, one user runs the same sql modifying the WHERE clause which fetches 80% of the records associated in the same table. Now what will optimizer do? Will it still use the same sql profiles which is fixed to it or it will skip sql profiles and chooses different plan? 5. What is better option for sql performance: SQL Plan Management or SQL Profiles or Hint to improvise performance of a particular sql? Or, do you advice the application team to modify their SQLs and use logical operator instead of BETWEEN, AND, OR instead of IN? Bonus: Hi Arun, I wanted to know from your personal experience, what is one of the rarest of rare crisis situation a DBA can experience in real-time like site crash or anything that hardly any DBA sees in their entire career which most of the DBA's are scared of or the situation is very challenging. - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
33:55
January 29, 2020
Why Rebuild Indexes? | #dailyDBA 20
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 when archive log is missing? 2. Could you also explain about high water mark please? 3. Why we need to rebuild the indexes? 4. When you issue SELECT * FROM EMP; does it use Indexes on the table? 5. What is the difference between data file header and data block header? What it contains? - #dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
30:49
January 28, 2020
How to Become Cloud DBA | #dailyDBA 19
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 replicate one table from DB1 to DB2 and both the DBs reside on same server. How can I achieve it? 2. My database stats gathering job was automatically stopped. What could be the reason behind it? 3. Lets say PRIMARY db size is 500gb and target db size is 200 gb. can we clone it? 4. What is the difference between log_wait and log_gap? 5. If there is a huge gap between PRIMARY and standby. What's the approach? - #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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
22:33
January 27, 2020
Calculate FRA Size in Oracle | #dailyDBA 18
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 protection modes in Dataguard environment? 2. What is the difference between count(*) and count(column_name)? 3. Could you please explain cpu tuning parameter on database? 4. My database size is 500 GB and what's the recommended size for FRA ? 5. Does virtual column inside Oracle make query faster? - #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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
21:19
January 25, 2020
How SCAN Works in RAC? | #dailyDBA 17
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 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
14:29
January 23, 2020
DBMS Gather Table Stats | #dailyDBA 16
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 contention? 2. What is Oracle Read consistency? 3. Could you please explain about FRA and the errors we usually see while initiating backup through FRA? 4. What is buffer cache hit ratio and use of it? 5. What will happen internally while gathering table statistics when we execute dbms_stats.gather_table_stats? - #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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
25:19
January 22, 2020
Avoid Hard Parsing in Oracle | #dailyDBA 15
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 for multi-tenant architecture? Like if I have 2 pdbs named HR and Sales inside a single CDB and I am performing any change/release in either of pdb and due to some failure I need to revert changes to original state, before changes. How will it work? 2. How to avoid hard parsing? 3. After installing 11gR2 for RAC Configuration, why we have compatible.asm=11.2.0.0.0 & compatible.rdbms=10.1.0.0.0? 4. What is FAL_CLIENT and FAL_SERVER? What's their purpose? 5. Can you please help me understand the use of swap? - #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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
30:17
January 21, 2020
Oracle Fusion vs Oracle Cloud | #dailyDBA 14
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 in the DB Buffer cache or PGA in Oracle? 2. How to grant select on all tables of a schema to a user? https://support.dbagenesis.com/knowledge-base/grant-select-on-all-tables-in-a-schema/ 3. What is the difference between Oracle Fusion and Oracle cloud? 4. All my database scheduler jobs are running 1 hour earlier? What could be the issue? 5. Can I put Password File on ASM? 6. Can I move the expdp dump files while the export is in progress? I am using parallel in the export command? - #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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
15:48
January 20, 2020
What Mistake DBAs are Making? | #dailyDBA 13
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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
25:31
January 18, 2020
Define Oracle Instance Size | #dailyDBA 12
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 differences between flashback database and guaranteed restore point? 2. Why do we need to set semaphore setting? How semaphore parameter value is calculated? on what basis it's calculated whether it's based on RAM or what? If it's based on RAM then at each time of RAM upgrade will the semaphore settings will be changed? --> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwaix/tuning-semaphore-parameters.html 3. You have fresh server with 64GB of RAM and you are asked to install 4 db’s in that server how will u allocate the ram for each DB. How is this calculation done? 4. If your not using active dataguard configuration if Block corrupted on standby how will recover corrupted block on standby 5. While recovering corrupted block manually i.e BLOCKRECOVER DATAFILE 2 BLOCK 13; could you please help on what happens internally, like from where oracle gets the original block? - #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 and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
29:42
January 17, 2020
Fix SQL Plan in Oracle | #dailyDBA 11
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 from OEL 6 to OEL 7. They want us to upgrade the DB also from 11g to 12c. How should I proceed further? 2. How to fix the plan for an sql in database? 3. How to mining data using redo log files? 4. I generally see ORA-19804: cannot reclaim 67108864 bytes disk space from 10737418240 bytes limit. Error in all the production database backups. What to do? 5. What is use of snapshot controlfile. How rman uses snapshot controlfile with recovery catalog and without recovery catalog. 6. Can you please explain about types of protection modes in dataguard and their purpose? - #oracle #dba #cloud #dailyDBA - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
30:01
January 16, 2020
Three SCAN IPs Resolving 8 Node RAC | #dailyDBA 10
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 removed online redo logs and cleanup job has cleaned archives and we do not have any database backup scheduled at the server. What are ways to recover database again ? 2. What is the difference between checkpoint and SCN? 3. What is the difference between local and dictionary tablespace? 4. I want to clone database from source to Target but there is no connectivity between servers. How will clone happen with out connectivity and could you please share high level steps? 5. Can you explain how 3 scan IPs resolve 8 node RAC in Oracle because we have 8 nodes in the cluster and only 3 scan IPs. How is it possible to resolve these 8 nodes? 6. Oracle DB has OMF. someone deleted all the control files. OS -Oracle Linux 7, DB 12c and OS already restarted. Archive log mode is not enabled. Without using the RMAN how to recover the database? - #oracle #dba #cloud #dailyDBA - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
26:08
January 14, 2020
When to go for Full Table Scan? | #dailyDBA 9
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 from 12c to 19c or we have to firstly move to 18c and then 19c. 2. What is the impact of IMPDP parameter transform=disable_archive_logging on physical standby? 3. Can we change the redundancy level of asm diskgroup if yes then how? 4. What is the meaning of resolving gap using primary incremental backup? 5. Some of the DBAs say full table scan is better than index scan. Could you please clarify in which situations its better? 6. Why I'm missing AWR snapshot? Once I restarted the DB its started to generate the AWR snapshot? - #oracle #dba #cloud #dailyDBA - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
27:48
January 11, 2020
Improve EXPDP Performance | #dailyDBA 8
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 for performing upgrade of database? 2. Do we need to take separate license for Real time apply. 3. How to improve performance of EXPDP apart from parallel option? 4. User has mistakenly dropped a master table which has millions of records. You have only few minutes say 15 to 30 min left for the database to go public. In this scenario, how to bring back the table? Flashback is disabled. 5. Which is the most stable version in Oracle for upgrade? 6. What will happen if we upgrade from 11.2.0.4 to 18c and keep compatible parameter still 11.2.0.4? Bonus: In your experience, I would like to know what are the disadvantages of Oracle database! - #oracle #dba #cloud #dailyDBA - 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 the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
22:23
January 9, 2020
Row Chaining in Oracle | #dailyDBA 7
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 take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
35:25
January 8, 2020
How to Add Diskgroup in ASM | #dailyDBA 6
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 take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
28:31
January 7, 2020
Which Cloud Platform is Best | #dailyDBA 5
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 take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com Start your DBA Journey Today !!
24:10
January 6, 2020
Rebuild Indexes Faster in Oracle | #dailyDBA 4
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 take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
24:20
January 4, 2020
DBAs Losing Job due to Cloud | #dailyDBA 3
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, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)  -  Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration  Link to all DBA courses: https://dbagenesis.com/courses  Link to real-time projects: https://dbagenesis.com/p/projects  Link to support articles: https://support.dbagenesis.com  -  DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!  DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
24:25
January 3, 2020
Load 5 million rows into Oracle | #dailyDBA 2
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, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;) - Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration Link to all DBA courses: https://dbagenesis.com/courses Link to real-time projects: https://dbagenesis.com/p/projects Link to support articles: https://support.dbagenesis.com - DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!! DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course. - Facebook: https://www.facebook.com/dbagenesis/ Instagram: https://www.instagram.com/dbagenesis/ Twitter: https://twitter.com/DbaGenesis Website: https://dbagenesis.com/ Contact us: support@dbagenesis.com - Start your DBA Journey Today !!
31:42
January 2, 2020
Query is running slow! #dailyDBA 1
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 answer all the questions and provide more value that benefits every single DBA. Hence, this show! In this very first episode of #dailyDBA, I will be picking up top 10 questions that I received in Dec 2019 and answering it for you!
31:39
January 1, 2020