Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26

    Question Unanswered: Performance Issue on 10.2.0.1.0

    I am using 10.2.0.1.0 with windows 2003 platform.
    I have dual core 4 cpu (i.e. one cpu contains two cores) so i have set cpu_count=4.
    Facing problem of memory paging, but memory is 16GB out of which sga occupies 6GB (SGA_TARGET=6GB).
    Got to know about memory paging through OEM (Performance Analysis).

    Have following queries:
    1. Do cpu_count parameter is correct?
    2. Why am I facing memory paging?
    3. How can I reduce Paging?
    4. As I have 8 cores, can I set cpu_count=8, what will be the consequence?
    *********************************************
    God Bless You.

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    I presume your using 64 bit windows in which case this should be of use to you.

    http://support.microsoft.com/kb/889654

    I would have though with 8 cores that is what you should set your cpu count to.

    Alan

Posting Permissions

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