DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: oracle.exe memory usage on Win2k

  1. #1
    Join Date
    Apr 2001

    oracle.exe memory usage on Win2k


    I have an instance with the following SGA memory configuration:

    SQL> show sga;

    Total System Global Area 1496967196 bytes
    Fixed Size 75804 bytes
    Variable Size 408711168 bytes
    Database Buffers 1088102400 bytes
    Redo Buffers 77824 bytes

    However, I notice in Task Manager the ORACLE.EXE is using 1,529,160K under Memory Usage. Is there any relationship between the two?

    I heard Win2k processes can only manager memory address space up to 2GB. Does it mean I can't have more than 2GB for Total System Global Area as shown above?


  2. #2
    Hei, your sga_max_size (or actual sga size in 8i) is about 1496M, while from task manager, it should be slightly larger, as oracle executable and other library also takes memory, right?

  3. #3
    Join Date
    Apr 2001
    Thanks for the reply.

    What about Server Processes in Dedicated Server mode and background processes? Are they part of this 1,529,160K Memory usage for ORACLE.EXE? I don't see separate processes listed in the Task Manager for them. It looks like everything is part of the ORACLE.EXE Memory usage.


  4. #4
    Oracle on windows platform is single process multithread archtecture.
    You can use tools like Qslice to see every thread in this process.

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