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

Thread: Performance Issue

  1. #1
    Join Date
    Nov 2006
    Posts
    2

    Performance Issue

    Hi,

    I have one oracle database,which is used by 50 users at a time.
    Server mode is DEDICATED and available virtual memory is 5129MB.


    Please suggest me the parameter values as the current database is slow.
    Parameters like


    1)Shared Pool
    2)Buffer Cache
    3)Large Pool
    4)Java Pool
    5)Aggregate PGA Target etc.


    Thanks and Regards,
    Jitendra

  2. #2
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    No data provided.
    Do you run statspack?
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    totally dependant on your application

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