HELP, HELP, HELP !!! Oracle 8.1.7
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: HELP, HELP, HELP !!! Oracle 8.1.7

  1. #1
    Join Date
    Nov 2005
    Posts
    7

    HELP, HELP, HELP !!! Oracle 8.1.7

    hello
    I have "the small" problem with the base in oracle 8 version. We had on our server installed 2 GB RAM and init.ora parameters are:
    db_block_buffers = 95000
    shared_pool_size = 400000000
    open_cursors = 1300
    processes = 350
    area_size sort = 5000000

    Total area of the memory: 1199564828 bytes
    fixed: 75804
    variable: 42110976
    database: 778240000

    We have added RAM up today and we have 4 GB now.
    First I increased the shared_pool parameter. The application, is operating more slowly effects of the change are terrible. When I changed shared_pool parameters much and db_block_size even the instance didn't want to start:
    ORA-27102: out of memory
    When I reduced a little bit both parameters the error appeared:
    ORA-00443: PRMON didnt take-off
    When I still more reduced both parameters the instance gets up however users aren't able to do nothing , aplication works very slowly and the attempt at logging sometimes ends in information:
    ORA-12500: TNS. the process of the monitoring didn't manage to start the dedicated process of the server

    Perhaps somebody from you will help me in the question of the configuration of these parameters. The matter is urgent.
    Thanks very much !!! by, by

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    What OS? if Unix and 32 bit you can only use 1.75Gb of memory. What are your kernel parameters.

    You cant change db_block_size, that is not allowed

    Why dont you put things back to how things were before you screwed it up?

  3. #3
    Join Date
    Nov 2005
    Posts
    7
    so dave ...

    now I turned back all parameters and oracle works, but very very slowly , all users are very irritated.
    My OS is MS Windows 2000 server - I think that in this version it can easy use 4 GB of ram memory. Server has 5 GB ( in BIOS is 5 ), but system can use only 4 GB.
    my parameters are now:

    open_cursors = 1300
    db_block_buffers = 95000
    shared_pool_size = 400000000
    large_pool_size = 614400
    processes = 350
    log_buffer = 131072
    db_block_size = 8192
    sort_area_size = 5000000
    sort_area_retained_size = 65536

    and everything works but .... very bad !!!

  4. #4
    Join Date
    Nov 2005
    Posts
    7
    hmmmm ....
    now I know that 1.75 GB is for SGA and PGA. But how should I adjust parameters in init.ora to make work in our aplication more comfortable.

    please, I'm waiting for your help

  5. #5
    Join Date
    Mar 2002
    Location
    Manchester, England
    Posts
    202
    Couple of metalink notes for you

    Note.156797.1 - What Is The Maximum Memory (RAM) Size Oracle Can Use on MS Windows 2000
    Note.225349.1 - Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms
    Note.231159.1 - How to configure Windows to improve performance database oracle
    Note.46001.1 - Oracle Database and the Windows NT memory architecture.
    Note:46053.1 - Windows NT Memory Architecture Overview
    Note:1036312.6 - Utilizing Up to 3GB Virtual Memory on Windows NT

  6. #6
    Join Date
    Nov 2005
    Posts
    7
    yes...thanks ... I also found something in internet :
    http://support.microsoft.com/default...roduct=win2000



    but more interesting for me is how to change parameters on my oracle for his better work. maybe I should change shared_pool_size, or db_block_buffers ???
    The seller of my aplications says that this parameters should be changed. But how ... now is:
    db_block_buffers = 95000
    sharedPool_size = 400000000

    If I change this oracle and aplications works badly.

  7. #7
    Join Date
    Nov 2005
    Posts
    7
    halooo, it's me again
    I found some scripts on dbasupport.com and ...
    script:
    select parameter, gets, Getmisses , (getmisses/(gets+getmisses))*100 "miss ratio",
    (1-(sum(getmisses)/ (sum(gets)+sum(getmisses))))*100 "Hit ratio"
    from v$rowcache
    where gets+getmisses <> 0
    group by parameter, gets, getmisses ;

    I have following results:

    "dc_files" 2 1 33,3333333333333 66,6666666666667
    "dc_free_extents" 4488 295 6,16767719004809 93,8323228099519
    "dc_histogram_defs" 173260 3916 2,21023163408137 97,7897683659186
    "dc_object_ids" 11658527 2022 0,0173405214454311 99,9826594785546
    "dc_objects" 125661 5650 4,30276214483174 95,6972378551683
    "dc_profiles" 782 1 0,127713920817369 99,8722860791826
    "dc_rollback_segments" 3303 30 0,9000900090009 99,0999099909991
    "dc_segments" 537724 2040 0,377942952846059 99,6220570471539
    "dc_sequence_grants" 15 8 34,7826086956522 65,2173913043478
    "dc_sequences" 1855 45 2,36842105263158 97,6315789473684
    "dc_synonyms" 39904 291 0,723970643114815 99,2760293568852
    "dc_tablespace_quotas" 63 9 12,5 87,5
    "dc_tablespaces" 18143 14 0,0771052486644269 99,9228947513356
    "dc_used_extents" 265 265 50 50
    "dc_user_grants" 9142 39 0,424790327850997 99,575209672149
    "dc_usernames" 48313 50 0,103384818973182 99,8966151810268
    "dc_users" 109016 41 0,0375950191184426 99,9624049808816


    it is quite good I think ... am I right ?

  8. #8
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    This is a result for your dictionary cache. It really doesnt address your performance problems. If the end-user is unhappy these statistics represent absolutely nothing.

    Do some more Oracle reading on tuning a database
    Able was I ere I saw Elba

  9. #9
    Join Date
    Nov 2005
    Posts
    7
    ok, so where I can find some interesting things about tuning database ?? You think that after tuning my database should work much better.
    Somebody told me that perhaps I have to do export and then import of the data. Perhaps this operation help me - defragmentation or something like that.

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    You havent done any tuning, all you did was add some memory, changed some random parameters and hoped things would go further.

    Run a statspack report to see what you are waiting on, then find a DBA to help you

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