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

Thread: tunning

  1. #1
    Join Date
    Jan 2001
    Posts
    4
    Hi,

    The Oracle SQL Tunning is not done for a Module Which in turn results in Poor performance.

    Action Taken by the Customer:

    They did the SQL Monitoring using some tools that is available in Enterprise Manager & found some of the request made by the application (the module) is not having any Where Clause while Querying tables. So they feel that this slowing down the server if three or more person runs the module at the same time.


    Can any one please give me a solution.

    devigan

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If there is no where clause on the table, it is better KEEP that table's data in to BUFFER POOL KEEP area.

  3. #3
    Join Date
    Jan 2001
    Posts
    4
    Thank you very much. Any specific method to do so. Send me some ref if any.

    Thanks.
    Devigan

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