In this post I’m going to show you how to change the processes parameter in an Oracle RAC database.
You can use this same method for any RAC parameter that requires instances to be rebooted for the change to take effect.
In an ideal situation, you would just alter system the parameters and then you would stop and start each instance.
But this did not work as expected because some services were only available in one node and not in the other, so I had to relocate them and try again.
I will show you all the details in this post.Continue reading “How to Change Processes Parameter in Oracle 19c RAC”
If you need to kill a session in Oracle RAC database then first you need to know the SID, Serial# and the instance where the session is running.
You can get that info depending on what you are given, let’s see some options.
If you know the SID, then you can get the other values with this query
Now let’s suppose that you have the serial# then use this query
select sid,serial#,inst_id, sql_id
In case you have the username, use this query, you could add the logon_time to the query
Continue reading “How to Kill a Session in Oracle RAC Database”