Skip to Main Content

Oracle Database Discussions

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!

Changing CPU_COUNT

MoonlightNov 24 2022 — edited Nov 24 2022

Hi,
I changed cpu_count parameter:
sql> Alter system set cpu_count=16 scope=spfile
sql> Alter system set parallel_threads_per_cpu = 2 scope=spfile
when I check the spfile, the parameters are realy changed... but when I check form database
sql> show parameter cpu_count
12 (the old number)

I understand that cpu_count and parallel_threads_per_cpu are dynamic parameter ... don't need to restart the instance... so what's wrong ?
My database version is :
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 -Version 19.13.0.0.0

This post has been answered by JohnWatson2 on Nov 24 2022
Jump to Answer
Comments
Post Details
Added on Nov 24 2022
14 comments
8,973 views