Oracle Database - Log Switches Per hour
This script is used to find out log switches per hour in Oracle Database ROWNUM < 31 tells to display data for last 30 days SET PAGESIZE 90SET LINESIZE 150set...
Popular Posts
-
In this blog I will be telling you how to install Oracle 19c RAC in Silent Mode. Remember the key thing with RAC is that it requires a lo...
-
In this blog I am going to discuss an issue which I faced during my maintenance on cluster. One of the votedisk became unavailable and wa...
-
In this blog I will discuss on how to create a database after your installation. My previous blog discussed on database binaries install... -
One of the repetitive things I have seen and been asked for as DBA is to do a quick health check for the database. Well, it has can com...
-
I was getting a lot of error messages/incidents and alerts stating 'Internal error detected: oracle.sysman.gcagent.task.TaskZombieExcep...
-
When you check status of database using dgmgrl and you get the error message in alert log - 'Process RSM0, PID = 1524144984, will be ...
-
In this Post I am going to post on few Handy Scripts for Database verification which can be / are used on day to day basis by DBA s for ...
-
User Logged on can be really pain as it makes a lot of noise, It is one of the collected metrics without any threshold and will generate a ...
-
Oracle has released Image 19 and AIDE, however what they really missed is the platinum / advanced support gateway the advanced support ga...
-
Let's say you are trying to merge 2 branches using git pull <remote> <branch> or example $ git pull --allo...
