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 ...
Jun 27, 2020•20 min•Ep. 49
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 proce...
Jun 26, 2020•21 min•Ep. 48
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 ...
Jun 24, 2020•21 min•Ep. 47
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 qu...
Jun 23, 2020•16 min•Ep. 46
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 ...
Jun 18, 2020•13 min•Ep. 45
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...
Jun 17, 2020•17 min•Ep. 44
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 s...
Jun 16, 2020•20 min•Ep. 43
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...
Jun 15, 2020•18 min•Ep. 42
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 Ora...
Jun 14, 2020•17 min•Ep. 41
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 project...
Jun 13, 2020•3 min•Ep. 40
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...
Jun 12, 2020•15 min•Ep. 39
#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:...
Mar 14, 2020•20 min•Ep. 38
#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? - #daily...
Mar 14, 2020•17 min•Ep. 37
#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 le...
Mar 13, 2020•20 min•Ep. 36
#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...
Mar 13, 2020•14 min•Ep. 35
#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 Ora...
Mar 12, 2020•19 min•Ep. 34
#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 loca...
Mar 12, 2020•13 min•Ep. 33
#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 p...
Mar 02, 2020•19 min•Ep. 32
#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...
Feb 29, 2020•18 min•Ep. 31
#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 course...
Feb 28, 2020•6 min•Ep. 30
#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 ...
Feb 28, 2020•21 min•Ep. 29
#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 #...
Feb 17, 2020•19 min•Ep. 28
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 ...
Feb 08, 2020•16 min•Ep. 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. 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 ...
Feb 07, 2020•31 min•Ep. 26
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 ...
Feb 05, 2020•27 min•Ep. 25
In this episode of daily DBA, I pick up 5 important DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video! - Questions Picked-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 ins...
Feb 04, 2020•19 min•Ep. 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. 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 ...
Feb 03, 2020•19 min•Ep. 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. 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?...
Jan 31, 2020•15 min•Ep. 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 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 fro...
Jan 29, 2020•34 min•Ep. 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. 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 ...
Jan 28, 2020•31 min•Ep. 20
