query on Development versus production instances
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: query on Development versus production instances

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    query on Development versus production instances

    I have the same query, and same instance. one is on Development and one is on production.

    For some reason, the query was running very fast on development. On the production instance, the query ran very slow and it maxed out my temp tablespace even I set it to 4G, the data never come back

    what could be the reason and How can I attack this problems???

    thanks

  2. #2
    Join Date
    Nov 2000
    Posts
    440
    show your query plz.

  3. #3
    Join Date
    Jul 2000
    Posts
    521
    Same query, same instance. Fine.

    Same volume of data ?
    Same query execution plan ?
    Same stats available ?
    svk

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    Does the explain plan change from development to production? Is it possible that because your have less test data that your development machine has better stats than production? It there a difference in versions of Oracle? You don't mention hardware or OS versions for either production or development. These are all factors that could make a difference. Without more information I can only guess.

    You must be doing a lot of sorting in production when you run this query. I think that that is the only conclusion that I can make. but I can't tell you why.

  5. #5
    Join Date
    Jun 2000
    Posts
    295
    Besides what suggested:

    * compare the ratios of data valume and
    the size of temp tablespace of your dev and prod databases

    * compare temporary tablespace type: temp or perm tablespace

    * OS level monitoring

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