Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2013
    Posts
    4

    Question Unanswered: Let's map all the SGA components

    Hi guys,
    I've been trying to obtain ALL the components in the SGA, I want to create a complete map of it and a way to look how much memory each component consume, I want to share this once I have it done....BUT...I can't find a way to see the amount of memory the REDO BUFFER is consuming....

    I attached a couple of docs if you are interested, they are my first attempt to create a map of the SGA, they need more work...obviously

    I expect we all can work on this!!
    Attached Thumbnails Attached Thumbnails SGAv0.1.png  
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    what problem could only be solved using your map that could not be solved without it?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2013
    Posts
    4
    Hi anacedent,
    I want to create a this map to register the status of each component in a period of time; with this info we can identify which ones are those who impact more in memory consumption, what its behaviour is and maybe identify deeper tuning solution ...I'm doing an small investigation on the SGA behaviour because I think that we can go a little deeper in terms of tuning.....Now I'm not going to lie to you, it might help or not, but that's what I'm trying to find out...

    Thanks for your question.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    map away!
    Code:
    SELECT * FROM V$SGASTAT;
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2013
    Posts
    4
    Hey, thank you very much, I was so busy checking that table that I forgot thanking you...I'll continue my small research and as soon I finish it I'll publish my results....I have a lot of questions but I'lll check the internet before ask something else, just as the manual of this forum says....

    Thank you, Anacedent !!

Tags for this Thread

Posting Permissions

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