Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

v$resources limit

Mohammed AghiourlySep 30 2024

I have oracle database 12c installed on oci linux with 1 OCPU

I checked the v$resources parameters, they are as below:

processes: 200

sessions: 322

transactions: 354

My questions is, if I want to increase above numbers according to the equation: sessions - processes 1.5 + 22, transactions = sessions 1.1

According to my db version and number of OCPU, what is the maximum number of processes parameter can I use? meaning, is there any limitation If I want to increase processes parameters?

Added on Sep 30 2024

#db12c, #resources

1 comment

35 views