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

Thread: query running slow..

  1. 01-28-2008, 05:05 PM #1
    rayan
    rayan is offline Junior Member
    Join Date
    Jan 2008
    Posts
    6

    query running slow..

    Hi Gurus,
    query is running fast in pre-production(20 sec) but takes 22 min in production , data is almost same in both env.What are the things to be i should looked into?Please any repps would be very helpful.

    oracle 10202,hpux-11.2

    Regards
    Reply With Quote Reply With Quote
  2. 01-28-2008, 05:09 PM #2
    sanju_dba
    sanju_dba is offline Junior Member
    Join Date
    Jan 2002
    Posts
    59
    Both systems have
    same config?
    same init ?
    stats ?
    idling ?
    run trace and compare.
    Reply With Quote Reply With Quote
  3. 02-05-2008, 07:33 AM #3
    Kailash Chandra
    Kailash Chandra is offline Junior Member
    Join Date
    Aug 2007
    Posts
    14
    check the explain plan of both query then comapre to each other . You will find the clue that in production database there is some problem of index . second you have to gather the statistics .
    Reply With Quote Reply With Quote
  4. 02-06-2008, 08:21 AM #4
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    And compare the workloads. A process run in isolation in Pre-Prod might have to wait for locked resources in a Live environment. Is it just a query? As stated above, EXPLAIN the query in both environments would be the first step. Compare the stats generated.
    Reply With Quote Reply With Quote
  5. 02-07-2008, 10:40 AM #5
    fescofet
    fescofet is offline Junior Member
    Join Date
    Feb 2008
    Posts
    1
    maybe is I/O problem have you the same filesystem in both enviroments.
    XFS in both???
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width