TUNING URGENT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: TUNING URGENT

  1. #1
    Join Date
    May 2002
    Posts
    232
    Hiii,friends i am very worrying about my db performance,
    I was migrate the 8i database to 9i database by using dblinks.
    Now My db performance is very worrest,like cach hit ratio 69%,every thing is worriest,even i compared extents in both dbases.

    ex--
    tablename ABC
    in 8iphysical structure
    TABLESPACE TOOLS
    PCTFREE 10
    PCTUSED 40
    INITRANS 1
    MAXTRANS 255
    STORAGE (
    INITIAL 74618880
    NEXT 37285888
    PCTINCREASE 50
    MINEXTENTS 1
    MAXEXTENTS 121
    FREELISTS 1 FREELIST GROUPS 1 )
    NOCACHE;

    same table in 9i ABC
    TABLESPACE TOOLS
    PCTFREE 10
    PCTUSED 40
    INITRANS 1
    MAXTRANS 255
    STORAGE (
    INITIAL 65536
    MINEXTENTS 1
    MAXEXTENTS 2147483645
    FREELISTS 1 FREELIST GROUPS 1 )
    NOCACHE;

    IN 9I there is no next extent ,
    each table is look like above.
    So how to overcome this problem?
    any one give good suggestion to adjust the extents and tuning.
    thanks
    kavitha
    kavitha

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    kavithared, it really looks like you've either

    a). Being thrown in the deep end of Oracle DB administration and told to "learn it"

    or

    b). Simply want everyone else to do your job for you without actually learning for yourself.

    You really need to read some 9i documentation.

    Sorry,
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    May 2002
    Posts
    232
    Hiii,I know man,
    just i was asked regading extents.
    thanks
    kavitha

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hello

    I suggest you read about Locally Managed Tablespaces and make your extent sizes uniform .

    Well its very difficult to say why your hit ratio has gone down drastically.I think you should be using statspack to gather statistics to come to a find the problem first.


    Just a sugesstion did you analyze all your tables and indexes after moving to 9i ?why dont you do an analyze first and check ?

    regards
    Hrishy

  5. #5
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Your Cache hit ratio could be down early if you've recently added alot more new tables etc. It becasue they've not been cached before. Alternatively, it could be becasue you cache is to small. Or, maybe you've just restarted the instance and the stats haven't average out yet (again, re-caching blocks)
    OCP 8i, 9i DBA
    Brisbane Australia

  6. #6
    Join Date
    May 2002
    Posts
    232
    ok many thanks for all
    if any advisees give me
    kavitha

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi Kavitha

    I think you should gather some statistics and paste them here before any one of us here comes up with some worthwhile advice ;-D

    regards
    Hrishy


  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Hi Kavitha

    I think you should gather some statistics and paste them here before any one of us here comes up with some worthwhile advice ;-D

    regards
    Hrishy
    Be ready with the answer.. "How to gather statistics?"

    Take it easy..

    Sanjay





  9. #9
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi SanjayG

    I am off to read the oRacle manuals on how to gather statistics maybe i could impress Kavitha with the answer ;-D


    Hope Kavitha comesback with the question and the trick works LOL ;-D

    regards
    Hrishy

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