mm

I am Layadhar Duppati, having 12 Years of experience in Database Administration. I love to travel, learn new things. I love to learn new technologies. Have exposure on various domains Automotive, Retail, Banking. Always on Production Critical Mission.

Share this post

Tags

To Compare Parameters on all nodes in RAC Environment

in 11gR2 RAC
Share via:
Post Views: 0

Dear Readers,

In this article we will see To Compare Parameters on all nodes in RAC Environment.

col name for a20 trunc
col value for a40 trunc
set pagesize 140

select name,value,inst_id from gv$parameter where inst_id in (1,2) order by 1,3;

Herewith the sample output for a 2 Node RAC.

You can see the different value for two nodes highlighted in RED.

 

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (17 votes, average: 5.00 out of 5)
Loading...

You might also like...

4 thoughts on “To Compare Parameters on all nodes in RAC Environment”

Add Comment