Results 1 to 14 of 14

Thread: Shared Memory

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Post Unanswered: Shared Memory

    Hello there !!!

    I'm trying to increase the shared memory using dba studio and I get the error that I show in the attached picture, What do I have to do ? What problems could I have If I increase the shared memory modifing this parameter?

    Thanks !!!
    Attached Thumbnails Attached Thumbnails Error.jpg  

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    The problem is hidden within your screen shot - there is a max size specified for the SGA, and you are trying to increase the Shared Pool to a size that takes it over this limit. As well as increasing the Shared Pool you will also have to decrease something else or increase the max limit. Two of the boxes on the screen should tell you what the SGA max limit is, & how big the SGA is with current settings.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2003
    Posts
    294
    But the new Shared Pool size doesn't take it over the max size specified for the SGA.

  4. #4
    Join Date
    Jun 2003
    Posts
    294

    Post See the pic

    Se the pic
    Attached Thumbnails Attached Thumbnails Error.jpg  

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Hmm, puzzling! I agree, it looks as though it should work

    Just as a thought, then, try decreasing the java pool & increasing the shared pool by the same amount. If it accepts that change then the problem is with the overall size of the SGA. It may be that DBA Studio is mis-reading the settings/sizes.

    Have you tried increasing the size of the SGA at the same time as increasing the size of the large pool to see if that works?

    Do you have Enterprise Manager installed? You can achieve what you're trying to do in the 'memory' tab on the database/instance/configuration screen.


    Let us know how it goes...
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  6. #6
    Join Date
    Jun 2003
    Posts
    294

    Lightbulb Rules Db

    Hello, I have an Oracle 9i database, with choose optimizer, and I want to set It in rules. How do I do It with commands and Using DB studio !!

    Thanks !!!

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    YOu do NOT want to use rule based optimizer in Oracle 9i. Cost based results in much faster access assuming that you frequenly analyze).
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Jun 2003
    Posts
    294
    I really want It, is just for testing

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can achieve the same thing by simply deleting alll statistics.
    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.

  10. #10
    Join Date
    Jun 2003
    Posts
    294
    How do I do It?

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >How do I do It?
    Google is your friend.
    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.

  12. #12
    Join Date
    Jun 2003
    Posts
    294
    How do I set It? which parameters do I have to change? and what values do I have to Put ?

  13. #13
    Join Date
    Jun 2003
    Posts
    294
    How do I delete statistics ?

  14. #14
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.

Posting Permissions

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