Oracle Memory Usage
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle Memory Usage

  1. #1
    Join Date
    Dec 2001
    Posts
    221
    Oracle 8i EE / Win NT 4.0

    can anybody have some idea about the Memory Usage shown in Task Manager infront of Oracle.

    i know its the memory currently used by Oracle Instance.

    but i want to confirm it from the dictionary tables. the same figure !!!!!

    any body
    Santosh Jadhav
    8i OCP DBA

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    query v$db_object_cache for colum namespace,sharable_mem and sum up the value got from sharable_mem.

    regards
    anandkl
    anandkl

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