cpu_count value in v$parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: cpu_count value in v$parameter

Hybrid View

  1. #1
    Join Date
    May 2000
    Location
    Richardson, Texas, USA
    Posts
    39
    The cpu_count column shows the number of cpu's available
    for an instance when the instance started. If number of cpu
    changes while the instance is running then the column is not
    updated on the fly. Is the latest cpu_count value available
    from some other V$ table?

    Thanks.

    Syed

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    AFAIK cpu_count is not modifiable with alter system or alter session, it can only be modified by restarting instance with new value in v$parameter.

    Check the isses_modifiable, issys_modifiable columns in v$parameter. These tell you whether or not the value can be modified with an alter session/alter system command.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width