ORACLE: How to check INSTANCE restart history?
This is an easy one that will save you going through alert logs.
ORA-27106: system pages not available to allocate memory
If you have set use_large_pages=ONLY, server need to have enough huge pages to allocate the SGA in the number of pages available, if not, you might get this error while trying to start instance: In this system you have only enough pages to allocate 17G and you require 28G, not good.How do you fix? You... » read more
Who is generating Invalid logins on your DB?
If AUDIT_TRAIT is set to DB: If AUDIT_TRAIT is set to XML: In this case, this is the agent configured with a invalid password.
How to check how much archive logs DB is generating
You have been requested to check how much a DB is generating on archive logs, it can be for FRA size planing, standby lag analysis…. you name it. We can see here DB has the higher load during 1am to 3am. Here you can get the size it is generating per day:
SQL: How to kill sessions in bulk
For this first post, lets start with something easy that everyone that manages a DB should know. You have been requested to kill everything that RMAN is running for whatever reason. It can be backup is no longer valid or it is generating impact in performance, which needs to be resolved right away. Do you... » read more