Automate Oracle DB Health Checks | glogin.sql in Oracle
Вставка
- Опубліковано 7 вер 2024
- Imagine #sql*plus running DB health check automatically every-time you login to the database! Check the benefits of #glogin.sql in #Oracle and how you can use it to automate #database health checks.
2:24 first sql script
11:59 reclaim unused space in oracle
13:34 top resource intensive sqls
14:13 table space utilization in oracle
Website: www.dbagenesis...
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis
Thank you for always sharing your professional knowledge and expertise.
My pleasure!
Its always good to hear u sir. U really impart a deep knowledge to ur viewers. ❤️
Thanks a ton
You are awesome Buddy. What you are doing is nothing short of Social Service. Thank you very much
My pleasure
It's really so helpful. thanks sir for making great content for DBA's.🤗
Thanks and welcome
Super video sir it is very useful and help to reduce repetitive task
Thanks a lot
Keep watching
alwasys getting lots of knwledge from you. Many thanks
My pleasure!
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.
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
Thank you too!
Wow super sir please do more videos in DBA ❤️
Thanks and sure
Very Interesting, Thanks for sharing.
Glad you enjoyed it
Very helpful. Thanks for sharing the knowledge.
My pleasure!
Its greattttt...Thanks
Welcome, Keep watching!
Thanks for this Arun. Helps a lot
Glad it helped
Good information,Thanks
Welcome
It's very interesting.. 👌👍
Thanks a lot 😊
Really want this type of stuff.. thank you 👍
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
Nice info Arun 👍
Thank you 🙂
Helpfull as always!!!
Happy to help!
Good one sirji 😄
Thank you
HI Arun , we are waiting for OCI training from u
nice hairstyle 💇 sir 😊😊
Thanks 😊
Tharun we need class about rubrick backup
How could we run on the PDB's on the container if that is the multitenant ?
👍
If DB at lock or performance issue or resource problem, it should not run. How to handle?
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
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?
If we do a DB upgrade, how will it impact?
Means env needs to be set to make that work?
How do we find out which SQLs are consuming or putting load on CPU.
What if I have multiple instances on a single server.
Ms sql dba ?
Imagine you have 40 tablespaces with 1000 datafiles each