DBAs Losing Job due to Cloud |

Подписаться 37 тыс.

Просмотров 19 тыс.

50% 1

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!
00:00 Intro
02:05 How can I check RMAN advance compression license inside Oracle? Any specific query?
04:12 What is the difference between PDB and application PDB?
09:06 A lot of DBA’s are worried about future of what will happen once autonomous DB comes Many thinks they will lose jobs please answer?
14:28 I dropped temp tablespace on primary database and created new temp tablespace but same temp tablespace was not created on standby database?
17:21 My procedure, I am trying to insert data in temporary table by using select statement. How to improve the performance of this select statement. In select statement I am using aggregation function. This insert statement itself taking 30 to 45% of the time in procedure execution?
Bonus Question
20:09 - If I want to learn on more database administration which one I should take up, Right now two database admin revolving on my mind “Oracle Big Data Cloud .or SQL Server” please suggest. Thanx in advance!
Website: www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 50

@alfredkazilimani1501 4 года назад

Immaculate explanation on GG. Beautiful! I have been on two interviews where GG was a requirement. This was in Banks. Replication was their point of concern.

@udaykiran60 4 года назад

Thanks for the videos , I was waiting for today's' video session.

@mvkishore 4 года назад

It was superb session. Loved it

@kumarb2896 4 года назад

Excellent explanation.

@rekhasweety277 4 года назад

Its a great knowledge sir, It would be great help if you could make a video on how to migrate database from a physical server to cloud

@SANDATA764 4 года назад

Thanks alot arun Please try to talk about Golden gate and Exadata on the next series

@dbagenesis 4 года назад

Sure, added to my list ;P

@sra12002 4 года назад

So, Yes is the answer.

@aravindhreturns 4 года назад

1:23 : As a true marvel fan, I always watch anything till the end 😂 since the first episode.

@ramubheesetti6163 4 года назад

What about postgresql opportunities ??

@kojitechs 3 года назад

Hi Arun, Thanks soo much for ur insight, and i have this question for you My database scratch and in an attempt to recover it, it requested for an archive log that a week old. my question is....Why would a database request for an archive log that is a week old??

@tukendrakulkarni3849 2 года назад

Please also include timestamps in video

@allinone.2376 2 года назад

Sir which can I do at age 31? I never worked as DBA ,but I want to get it.o So can I start to become as a Dba

@gpmanoj 4 года назад

Tell us about what is the difference between RMAN backup vs Exp vs and other backups

@dbagenesis 3 года назад

RMAN is designed for backup and recovery, a extension of the Enterprise Backup Utility (EBU). RMAN takes full, physical, consistent backups of your database files where as The export utility is a "logical" backup, usually done by specifying specific tables. If you fail to do a "consistent" export, or if you fail to include related tables and use RESTRICTED and CONSISTENT mode (with referential integrity constraints), you may not be able to recover properly. Export is often used as a supplement to RMAN, usually for the restore of specific tables. Advantages of RMAN: RMAN has block-level media recovery Has a catalog for backup tracking and a report utility Fast - If you dedicate a backup device for each production disk, you can backup terabytes in the time it takes to backup any single disk. Does hot or cold backups Backups and restores can be done in parallel Allows incremental backups (block change tracking)

@KiranKumar-th1bg 3 года назад

Sir, I have done DBA course and I am a fresher. Facing difficulties in getting calls any tips on this .

@TheAIGadgetGuru 2 года назад

Sir what are you doing now ?

@devilsgaming5915 4 года назад

Sir can you say what is meant by PDB database And CDB databases and differences

@dbagenesis 4 года назад

Checkout these videos on PDB and CDB: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0nd6ZtdKxss.html

@dbagenesis 4 года назад

Also this: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-msifGpn2QXo.html

@nayan8966 4 года назад

Thank you sir

@devilsgaming5915 4 года назад

@@dbagenesis Thank u sir

@rudroroy1054 4 года назад

Oracle GG and ODI same thing? Also why should I go for GG and not ODI, I have heard GG is quite expensive?

@dbagenesis 4 года назад

You can say that they are same.. Read this article for your best understanding: www.rittmanmead.com/blog/2013/02/goldengate-and-oracle-data-integrator-a-perfect-match-part-1/

@sanranu143 4 года назад

GG is used in almost all finance projects and other are using it too

@himanshugarg4846 4 года назад

What is clustered N non clustered index and tables?

@dbagenesis 4 года назад

Non-cluster (index & table) are like normal tables. For clustered tables and indexes, watch below video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Kwh8YFC3d60.html

@matheenahamed2692 4 года назад

Initially I was doing a Oracle DBA course for the job. Now one year completed with Oracle DBA experience. Now I want upgrade my skill. Now which course you would recommend me to do?

@ahmedab7756 4 года назад

Matheen Ahamed what course did you do? And why don’t you trying to work in the field first?

@matheenahamed2692 4 года назад

@@ahmedab7756 I did Oracle DBA and I'm not changing my field. Just trying to upgrade my skill from Oracle DBA to another technology like Oracle RAC, Oracle GG, Oracle DG, Oracle cloud etc etc

@kishorekumar-jr6oy 4 года назад

@@matheenahamed2692 u must have to upgrade high availability like DG and RAC

@dbagenesis 4 года назад

If you say you are a DBA, I already expect you to know Oracle Data Guard !! Apart from that, invest in Oracle Golden Gate and immediately switch to a job where you get a chance to work on Golden Gate. Meanwhile, also get Golden Gate certified!

@TheAIGadgetGuru 2 года назад

Hello what are you doing now?

@SaifPathanSimplyIndian 4 года назад

SUGGESTION TO IMPROVE VIDEO: Place the question that you are answering to , on the screen to refer to. Thanks in advance.

@dbagenesis 4 года назад

It just adds to editing time. So we skip it wantedly and try to keep it simple. Also, sometimes the question grammar is not correct!

@dbsql6238 Год назад

My work is worst with the cloud. Vacations: Gone, Weekends: Gone, Early morning: Gone. Evenings: Gone. Business Hours: Meetings and Users. All that automation is BS. Middletier work could be reduced in the cloud with containers and kubernetes but I need vacation time to learn that stuff.