Database Administration (MOSC)

MOSC Banner

How to set db_writer_processes in oracl 19c Vs CPU count

How to set db_writer_processes in oracl 19c

machinfo is :

CPU info:

  Intel(R) Itanium(R) Processor 9740 (2.13 GHz, 24 MB)

  8 cores, 16 logical processors per socket

  6.38 GT/s QPI, CPU version E0

     Active processor count:

     4 sockets

     32 cores (8 per socket)

     64 logical processors (16 per socket)

     LCPU attribute is enabled


Memory: 523974 MB (511.69 GB)


Firmware info:

  Firmware revision: 02.68

  FP SWA driver revision: 1.23

  IPMI is supported on this system.

  BMC firmware revision: 2.00


Platform info:

  Model:         "ia64 hp Integrity BL890c i6"

  Machine ID number:   e8d9d60e-4f95-440f-8aeb-f3bb8c21091a

  Machine serial number: VCX0000N04


OS info:

  Nodename: DRDBSRV1

  Release:  HP-UX B.11.31

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center