oracle9i database performance
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: oracle9i database performance

  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    3

    Post oracle9i database performance

    Hi all,
    we are having oracle9i on linux 7.o OS
    we are also running apache server on same system.

    we are having around 10 schemas ...which are configured for websites.

    Oracle database hangs after some hits are reached on web sites...
    and forces administrator to restart the machine..

    all the database initial settings are by default as available when 9i is initially installed.

    we have not modified any init.ora parameters..

    can anyone throw me light regarding performance settings which are to be configured..

    Thanks & regards
    Prakash

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You problem is too vague, performance tuning to too big a topic to discuss unless you can give specifics.

    How big are you databases?
    What is the confiuration of the hardware?
    What is the application tier, how are users connecting?
    How many users are hitting the database?
    What sort of queries are being performed?
    Is the problem a hardware/software resource problem?
    Etc, Etc, Etc...

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Jim's suggestions +
    I will suggest to change OPEN_CURSOR parameter from its default value and increase it.
    Last edited by Sameer; 01-08-2003 at 06:30 AM.

  4. #4
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    The first issue, IMHO, is the "freezening" of the database : is it REALLY stoped OR it is waiting for something ? Check the wait and stats v$ view to know. And the OS stats (vmstat, top, sar, iostat), is the machine pagining ? Any hot disks ? And about the free mem ?

    []s

    Chiappa

  5. #5
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    3
    Hi
    Following are some details regarding databases

    How big are you databases?------Total database size is -- 350 MB
    What is the confiuration of the hardware?-----512 Mb ram, PIII 500Mhz
    What is the application tier, how are users connecting?---users access from web server thru Pure Java Driver
    How many users are hitting the database?----Nearly 100 users
    What sort of queries are being performed?---normal select, update queries, insert and a few subqueries
    Is the problem a hardware/software resource problem?--we are not sure whether it is hardware or software resourece problem, but we suspect it is software resource.

    do let me know any hints.

    Thanks & Regards
    Prakash

  6. #6
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    3

    Post configuration details

    Following are detials

    Total database size is -- 350 MB
    Confiuration of the hardware?-----512 Mb ram, PIII 500Mhz
    How are users connecting?---users access from web server thru Pure Java Driver
    Number of users hitting the database----Nearly 100 users
    Sort of queries are being performed?---normal select, update queries, insert and a few subqueries
    Is the problem a hardware/software resource problem?--we are not sure whether it is hardware or software resourece problem, but we suspect it is software resource.

    Also on the same machine we running apache server ...

    If anyone has hints about this do suggest.

    Regards
    Prakash

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