How can I view the number of connection pools in Oracle?

12 months ago

Liam

1 minute

To determine the number of connection pools, you can use the following SQL query to check the total number of connection pools in the current database:

SELECT count(*) FROM v$resource_limit WHERE resource_name = 'sessions';

This will return the current number of connection pools in the database. You can also use tools such as Oracle Enterprise Manager (OEM) or SQL Developer to view the number of connection pools.