DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: performance problems...

  1. #1
    Join Date
    Aug 2002
    Posts
    3
    Hello all,

    I'm a java developer and have no idea about the database administration. If you can thow some light on this issue it'll be of great help.

    I have a table with around 10 million records of data in it. I have an object mapping to this table and I also have some GUI screens which show up some details from the underlying table.
    My application becomes extremely slow when I run it with so much data in the database. so much so that it takes nearly half an hour to bring up the windows with some list boxes populated .

    Can you advise me to look at some issues like table space sizes and other issues which affect performance. How "Select" is afftected with the verticle increase of table?

    Thanks in advance

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    most probably is you are full scanning the whole table to bring some tiny results to your GUI?

  3. #3
    Join Date
    Aug 2002
    Posts
    3

    please advise me what to do....

    Please advise me what to do... I do not have any expertise in DBA.

    thanks in advance

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you have to tune the SQL, it´s developer´s job writing SQL statements so... you dont need any dba expertise to do that!

  5. #5
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    create proper indexes in your table and see if your query is hitting the index or not. Tune it that way...hope you know about indexing...and how to test the same...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  6. #6
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    If all else fails start up Oracle Enterprise Manager and use Oracle Expert to give you some advice about tuning. It will pick up commonly used statements and suggest indexes that may help you out.

    Remember, automated tuning products are only as good as the people who wrote them and the data sample you give them to work on.

    Good luck.
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: oracle-base.com
    My blog: oracle-base.com/blog

  7. #7
    Join Date
    Aug 2002
    Posts
    3
    Thanx a lot for your kind suggestions.

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