CODEWITHSUNDEEP
oracle-database
Sachiko
Sachiko

Reputation: 924

Oracle 12c RAC : How to check the load balancing status

With multiple SCAN VIP, we’d like to check if DB sessions are sure to be balanced or not. I’d be so grateful if you give me any useful commands.

Thanks in advance.

Upvotes: 0

Views: 2678

Answers (1)

EdwardKirk
EdwardKirk

Reputation: 455

You can just use this simple query:

select inst_id, count(*) from gv$session group by inst_id;

It will return the number of sessions per instance.

To narrow your results you can also add some where conditions, like:

where username is not null or where type not like 'BACKGROUND'

Hope this helps.

Upvotes: 1

Related Questions