Automate Oracle DB Health Checks | glogin.sql in Oracle

[@mansighadge9589]

Thank you for always sharing your professional knowledge and expertise.

[@dbagenesis]

My pleasure!

[@rajatsanwal9919]

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

[@dbagenesis]

Thanks a ton

[@kirankumar-np7tc]

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

[@dbagenesis]

My pleasure

[@amangoyal8265]

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

[@dbagenesis]

Thanks and welcome

[@yatheeshkumar294]

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

[@dbagenesis]

Keep watching

[@Habbtom]

alwasys getting lots of knwledge from you. Many thanks

[@dbagenesis]

My pleasure!

[@reaganpaul1392]

Thanks for this Arun. Helps a lot

[@dbagenesis]

Glad it helped

[@okaily7263]

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

[@dbagenesis]

Thank you too!

[@sainandakuruba9579]

Wow super sir please do more videos in DBA ❤️

[@dbagenesis]

Thanks and sure

[@nisaldeelaka8115]

Very helpful. Thanks for sharing the knowledge.

[@dbagenesis]

My pleasure!

[@karthik6930]

Its greattttt...Thanks

[@dbagenesis]

Welcome, Keep watching!

[@phanioracledba5249]

It's very interesting.. 👌👍

[@dbagenesis]

Thanks a lot 😊

[@JohnBagabe]

Very Interesting, Thanks for sharing.

[@dbagenesis]

Glad you enjoyed it

[@sibeshbiswal8665]

Nice info Arun 👍

[@dbagenesis]

Thank you 🙂

[@devilsgaming5915]

Good information,Thanks

[@dbagenesis]

Welcome

[@utkarshpatil5157]

Good one sirji 😄

[@dbagenesis]

Thank you

[@vigneshchinna358]

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.

[@VineetPundir-humble]

Really want this type of stuff.. thank you 👍

[@immi8272]

Helpfull as always!!!

[@dbagenesis]

Happy to help!

[@sanjaybabar5671]

nice hairstyle 💇 sir 😊😊

[@dbagenesis]

Thanks 😊

[@kalyanpattem]

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

[@sohailnawaz1091]

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

[@kranthikumar5193]

HI Arun , we are waiting for OCI training from u

[@Chitikireddyramesh]

👍

[@shayansarkar7570]

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

[@ramnim9673]

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

[@viralmody6316]

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

[@sanranu143]

What if I have multiple instances on a single server.

[@RAJMOHAN-od7fi]

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?

[@vikstar5544]

Tharun we need class about rubrick backup

[@oms8385]

Ms sql dba ?

[@statusexpress2252]

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

[@ka10k]

Imagine you have 40 tablespaces with 1000 datafiles each