Oracle - Root Fan

October 31, 2020April 4, 2022

How to Change Processes Parameter in Oracle 19c RAC

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.

October 24, 2020April 4, 2022

How to Kill a Session in Oracle RAC Database

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

select sid,serial#,inst_id 
from gv$session 
where sid='1195';

Now let’s suppose that you have the serial# then use this query

select sid,serial#,inst_id, sql_id 
from gv$session 
where serial#='15148';

In case you have the username, use this query, you could add the logon_time to the query

select sid,serial#,inst_id 
from gv$session 
where USERNAME='username';