Problem setting up Large_pool_size and Java_pool_size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Problem setting up Large_pool_size and Java_pool_size

  1. #1
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39

    Problem setting up Large_pool_size and Java_pool_size

    Hi, i'am changing the init.ora of my Oracle 9i database and this is what i saw :

    When i change the value of "Large_Pool_Size" to be greater than zero it always runs with the value "16MB" no matter what value i write in the init.ora, the same happens with "Java_pool_size" and the "db_keep_cache_size" and "db_recycle_cache_size".

    somebody knowns anything?

    thanks
    Gustavo Villaran

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Check spfile
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    this database doesnt use spfile
    Gustavo Villaran

  4. #4
    Join Date
    Jun 2000
    Posts
    295
    search for: granule,
    which is a unit of contiguous virtual memory allocation,

    The size of granule depends on the stimated total SGA size.
    It could be 4M if SGA size is < 128M or 16M otherwise.

  5. #5
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    what's that?

    somebody can explain me a little please?

    thanks
    Gustavo Villaran

  6. #6
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  7. #7
    Join Date
    Feb 2003
    Location
    Peru
    Posts
    39
    i cant access that because i dont have a password..

    please if someone could post that notes will be great.

    thanks
    Gustavo Villaran

  8. #8
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    How about going to tahiti.oracle.com (or whatever web site with Oracle's online documentation available) and explore osme serch functionalities there?

    RTFM and/or STFW.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by gvillaran
    i cant access that because i dont have a password..

    please if someone could post that notes will be great.

    thanks
    Get your username/password for metalink by submitting your CSI no. Contact your Oracle Rep.
    Register with OTN and access the online docs here..
    http://otn.oracle.com/documentation/oracle9i.html
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

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