Home » RDBMS Server » Performance Tuning » Execution time differences between Devl and Test (Oracle 10g/Windows2000)
Execution time differences between Devl and Test [message #302693] Tue, 26 February 2008 11:34 Go to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
Hi,
I'm running this below query in Devl and Test environments. Number of records, execution plan are same and statistics are upto date. But in Test, query takes more time to execute than Devl.
SELECT /* my column list */ 1
        FROM    table1 a, --18164 rows
                table2 b, --667689
                table3 c  --2144800 
        WHERE   a.client_id     = '6334'
        AND     a.portfolio_id  = c.subacct_id
        AND     c.sec_id = b.sec_id
        AND     c.tran_cd     IN ('A','D')
        AND     b.asset_typ     = 'A1'
        AND     c.trn_tran_type = 'AT';


What could be the possible reasons?

//Thangam

[Updated on: Tue, 26 February 2008 11:36]

Report message to a moderator

Re: Execution time differences between Devl and Test [message #302695 is a reply to message #302693] Tue, 26 February 2008 11:57 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
post EXPLAIN_PLANs from both systems
Re: Execution time differences between Devl and Test [message #302699 is a reply to message #302693] Tue, 26 February 2008 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
IO subsystem are same?
CPU are same?
Workload are same?
...

Regards
Michel
Re: Execution time differences between Devl and Test [message #302720 is a reply to message #302695] Tue, 26 February 2008 16:56 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
anacedent wrote on Wed, 27 February 2008 04:57
post EXPLAIN_PLANs from both systems

And the run times for each
Previous Topic: Index
Next Topic: >>>Wired SQL Tuning issue, maybe Oracle's bug<<<<
Goto Forum:
  


Current Time: Tue Dec 06 06:23:15 CST 2016

Total time taken to generate the page: 0.17520 seconds