Automate Oracle DB Health Checks | glogin.sql in Oracle 

Thank you for always sharing your professional knowledge and expertise.

Its always good to hear u sir. U really impart a deep knowledge to ur viewers. ❤️

You are awesome Buddy. What you are doing is nothing short of Social Service. Thank you very much

Really want this type of stuff.. thank you 👍

It's really so helpful. thanks sir for making great content for DBA's.🤗

Very helpful. Thanks for sharing the knowledge.

Thanks for this Arun. Helps a lot

alwasys getting lots of knwledge from you. Many thanks

your are great , and your content very helpful , really thank you for it. Wish u more and more success in ur work. thanks a alot

Helpfull as always!!!

Very Interesting, Thanks for sharing.

Super video sir it is very useful and help to reduce repetitive task Thanks a lot

Its greattttt...Thanks

nice hairstyle 💇 sir 😊😊

Wow super sir please do more videos in DBA ❤️

Good information,Thanks

Whenever user connect the database it's execute automatically that's fine. It will create overhead when we are accessing particular db frequently mean query takes time to generate the report.

It's very interesting.. 👌👍

Nice info Arun 👍

Good one sirji 😄

If we do a DB upgrade, how will it impact? Means env needs to be set to make that work?

glogin.sql Whenever SQL*PLUS starts up, it looks for a file named glogin.sql under the directory $ORACLE_HOME/sqlplus/admin. If such a file is found, it is read and the containing statements executed. New in Oracle 10g: Oracle also reads glogin.sql and login.sql at a connect in sql*plus. login.sql Additionally, after reading glogin.sql, sql*plus also looks for a file named login.sql in the directory from where SQL*PLUS was and in the directory that the environment variable SQLPATH points to and reads it and executes it. Settings from the login.sql take precedence over settings from glogin.sql

How could we run on the PDB's on the container if that is the multitenant ?

👍

How do we find out which SQLs are consuming or putting load on CPU.

HI Arun , we are waiting for OCI training from u

If DB at lock or performance issue or resource problem, it should not run. How to handle?

Tharun we need class about rubrick backup

Whenever I try to run datapump jobs it gets failed with DW00 failed with fatal err=28. And no Oracle errors. No one is killing the session but it happens. Can you put a video to tell how to find what is wrong?

What if I have multiple instances on a single server.

Sir i am new to it..i only know basic python html JavaScript and css..but i want to move to DBA...i want to become a DBA.. kindly tell me roadmap to become a dba..what to learn first and what to learn after that? Plzz sir reply lazmi dena

Ms sql dba ?

Imagine you have 40 tablespaces with 1000 datafiles each