OraFAQ Forum: Performance Tuning » Different Timings between 2 Nodes

Home » RDBMS Server » Performance Tuning » Different Timings between 2 Nodes (Oracle 11g Release2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Different Timings between 2 Nodes [message #588600]

Wed, 26 June 2013 16:36

feroze
Messages: 144
Registered: September 2005
Location: chicago

Senior Member

Hi,

A select statement in our Performance environment running through toad/sql developer takes 1 min in NOde1 and same select takes 2 mins in Node2.
I have run multiple times on both the nodes and making it run first on 2 then on 1 and vice versa, timings remains same.. Node2 takes more time.

Configs,parameters,SGA and other settings are same between 2 Nodes,
This is on 2 Node 11g RAC Oracle 11g Release 2. Any idea or suggestions where to look for such scenario.

Thanks in advance for your time and inputs.

Report message to a moderator

Re: Different Timings between 2 Nodes [message #588601 is a reply to message #588600]

Wed, 26 June 2013 16:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

enable SQL_TRACE on both nodes & compare the two trace files.
post EXPLAIN PLAN from both nodes.

Report message to a moderator

Re: Different Timings between 2 Nodes [message #588603 is a reply to message #588601]

Wed, 26 June 2013 16:56

feroze
Messages: 144
Registered: September 2005
Location: chicago

Senior Member

Thanks for your time.
this is the select statement, SQL Trace will provide soon
Sorry if PLAN is not formatted properly.

Explain plan from Both the Nodes are same,
it took 1:02 secs in Node 1 and 1:42 secs in Node2

    Select * from ACHUSNACHAVIEW where TNUM in (SELECT TNUM FROM  VW_ACH_PAYMENTSVIEW WHERE ( payment_type = 'PRENOTE' or Status = 'EP') AND EXTRACT_ID = '20130511164040001' )


PLAN FROM NODE 1

SELECT STATEMENT ALL_ROWSCost  : 134,682  Bytes: 552  Cardinality: 1
91 NESTED LOOPS
89 NESTED LOOPS  Cost: 134,682  Bytes: 552  Cardinality: 1
87 VIEW VIEW SYS.VW_NSO_1 Cost: 134,679  Bytes: 94,198  Cardinality: 7,246
86 HASH UNIQUE  Bytes: 405,776  Cardinality: 1
85 VIEW VIEW WEBSYSTEM.VW_ACH_PAYMENTSVIEW Cost: 134,679  Bytes: 405,776  Cardinality: 7,246
84 SORT UNIQUE  Cost: 134,679  Bytes: 8,072,497  Cardinality: 7,246
83 UNION-ALL
12 SORT UNIQUE  Cost: 14  Bytes: 191  Cardinality: 5
11 UNION-ALL
2 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_NTE Cost: 3  Bytes: 9  Cardinality: 1
1 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_NTE Cost: 2  Cardinality: 1
4 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_DED Cost: 1  Bytes: 60  Cardinality: 1
3 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_DED Cost: 0  Cardinality: 1
6 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_RMT Cost: 0  Bytes: 55  Cardinality: 1
5 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_RMT Cost: 0  Cardinality: 1
8 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_TXP Cost: 2  Bytes: 59  Cardinality: 1
7 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_TXP Cost: 1  Cardinality: 1
10 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_FF Cost: 3  Bytes: 8  Cardinality: 1
9 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_FF Cost: 2  Cardinality: 1
27 VIEW WEBSYSTEM. Cost: 2,362  Bytes: 30,780  Cardinality: 27
26 COUNT
25 FILTER
24 NESTED LOOPS
22 NESTED LOOPS  Cost: 2,362  Bytes: 17,280  Cardinality: 27
20 NESTED LOOPS  Cost: 2,168  Bytes: 94,575  Cardinality: 195
17 NESTED LOOPS  Cost: 204  Bytes: 123,504  Cardinality: 498
14 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
13 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
16 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMON Cost: 202  Bytes: 63,680  Cardinality: 995
15 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_PAYMENTSCOMMONSTATPROD Cost: 4  Cardinality: 995
19 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS Cost: 7  Bytes: 237  Cardinality: 1
18 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHUS_BATCHTNUM Cost: 2  Cardinality: 21
21 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUSHEADER Cost: 0  Cardinality: 1
23 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSHEADER Cost: 1  Bytes: 155  Cardinality: 1
40 VIEW WEBSYSTEM. Cost: 127,608  Bytes: 8,031,940  Cardinality: 7,210
39 COUNT
38 FILTER
37 NESTED LOOPS
35 NESTED LOOPS  Cost: 127,608  Bytes: 4,693,710  Cardinality: 7,210
33 HASH JOIN  Cost: 103,232  Bytes: 7,151,421  Cardinality: 12,183
28 TABLE ACCESS FULL TABLE WEBSYSTEM.ACHUSHEADER Cost: 3,844  Bytes: 30,042,255  Cardinality: 193,821
32 NESTED LOOPS  Cost: 96,042  Bytes: 37,301,472  Cardinality: 86,346
30 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
29 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
31 TABLE ACCESS FULL TABLE WEBSYSTEM.ACHUS Cost: 96,040  Bytes: 42,827,616  Cardinality: 172,692
34 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_PAYMENTSCOMMON Cost: 1  Cardinality: 1
36 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMON Cost: 2  Bytes: 64  Cardinality: 1
52 SORT UNIQUE  Cost: 14  Bytes: 191  Cardinality: 5
51 UNION-ALL
42 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_NTE Cost: 3  Bytes: 9  Cardinality: 1
41 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_NTE Cost: 2  Cardinality: 1
44 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_DED Cost: 1  Bytes: 60  Cardinality: 1
43 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_DED Cost: 0  Cardinality: 1
46 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_RMT Cost: 0  Bytes: 55  Cardinality: 1
45 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_RMT Cost: 0  Cardinality: 1
48 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_TXP Cost: 2  Bytes: 59  Cardinality: 1
47 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_TXP Cost: 1  Cardinality: 1
50 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_FF Cost: 3  Bytes: 8  Cardinality: 1
49 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_FF Cost: 2  Cardinality: 1
67 VIEW WEBSYSTEM. Cost: 2,169  Bytes: 1,145  Cardinality: 1
66 COUNT
65 FILTER
64 NESTED LOOPS
62 NESTED LOOPS  Cost: 2,169  Bytes: 640  Cardinality: 1
60 NESTED LOOPS  Cost: 2,168  Bytes: 485  Cardinality: 1
57 NESTED LOOPS  Cost: 204  Bytes: 123,504  Cardinality: 498
54 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
53 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
56 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMON Cost: 202  Bytes: 63,680  Cardinality: 995
55 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_PAYMENTSCOMMONSTATPROD Cost: 4  Cardinality: 995
59 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS Cost: 7  Bytes: 237  Cardinality: 1
58 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHUS_BATCHTNUM Cost: 2  Cardinality: 21
61 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUSHEADER Cost: 0  Cardinality: 1
63 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSHEADER Cost: 1  Bytes: 155  Cardinality: 1
82 VIEW WEBSYSTEM. Cost: 848  Bytes: 8,632  Cardinality: 8
81 COUNT
80 FILTER
79 NESTED LOOPS
77 NESTED LOOPS  Cost: 848  Bytes: 4,736  Cardinality: 8
75 NESTED LOOPS  Cost: 839  Bytes: 4,490  Cardinality: 10
72 NESTED LOOPS  Cost: 146  Bytes: 268,496  Cardinality: 692
69 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
68 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
71 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSTEMPLATE Cost: 144  Bytes: 282,336  Cardinality: 1,384
70 INDEX RANGE SCAN INDEX WEBSYSTEM.ACHUSTEMP_PRENOTE Cost: 4  Cardinality: 1,384
74 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMONTEMPLATE Cost: 1  Bytes: 61  Cardinality: 1
73 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_PAYMENTSCOMTEMP Cost: 0  Cardinality: 1
76 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUSHEADTEMP Cost: 0  Cardinality: 1
78 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSHEADERTEMPLATE Cost: 1  Bytes: 143  Cardinality: 1
88 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS Cost: 1  Cardinality: 1
90 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS Cost: 2  Bytes: 539  Cardinality: 1

[ALIGN=left]
PLAN  from NODE 2

SELECT STATEMENT ALL_ROWSCost  : 134,682  Bytes: 552  Cardinality: 1
91 NESTED LOOPS
89 NESTED LOOPS  Cost: 134,682  Bytes: 552  Cardinality: 1
87 VIEW VIEW SYS.VW_NSO_1 Cost: 134,679  Bytes: 94,198  Cardinality: 7,246
86 HASH UNIQUE  Bytes: 405,776  Cardinality: 1
85 VIEW VIEW WEBSYSTEM.VW_ACH_PAYMENTSVIEW Cost: 134,679  Bytes: 405,776  Cardinality: 7,246
84 SORT UNIQUE  Cost: 134,679  Bytes: 8,072,497  Cardinality: 7,246
83 UNION-ALL
12 SORT UNIQUE  Cost: 14  Bytes: 191  Cardinality: 5
11 UNION-ALL
2 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_NTE Cost: 3  Bytes: 9  Cardinality: 1
1 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_NTE Cost: 2  Cardinality: 1
4 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_DED Cost: 1  Bytes: 60  Cardinality: 1
3 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_DED Cost: 0  Cardinality: 1
6 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_RMT Cost: 0  Bytes: 55  Cardinality: 1
5 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_RMT Cost: 0  Cardinality: 1
8 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_TXP Cost: 2  Bytes: 59  Cardinality: 1
7 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_TXP Cost: 1  Cardinality: 1
10 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_FF Cost: 3  Bytes: 8  Cardinality: 1
9 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_FF Cost: 2  Cardinality: 1
27 VIEW WEBSYSTEM. Cost: 2,362  Bytes: 30,780  Cardinality: 27
26 COUNT
25 FILTER
24 NESTED LOOPS
22 NESTED LOOPS  Cost: 2,362  Bytes: 17,280  Cardinality: 27
20 NESTED LOOPS  Cost: 2,168  Bytes: 94,575  Cardinality: 195
17 NESTED LOOPS  Cost: 204  Bytes: 123,504  Cardinality: 498
14 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
13 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
16 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMON Cost: 202  Bytes: 63,680  Cardinality: 995
15 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_PAYMENTSCOMMONSTATPROD Cost: 4  Cardinality: 995
19 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS Cost: 7  Bytes: 237  Cardinality: 1
18 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHUS_BATCHTNUM Cost: 2  Cardinality: 21
21 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUSHEADER Cost: 0  Cardinality: 1
23 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSHEADER Cost: 1  Bytes: 155  Cardinality: 1
40 VIEW WEBSYSTEM. Cost: 127,608  Bytes: 8,031,940  Cardinality: 7,210
39 COUNT
38 FILTER
37 NESTED LOOPS
35 NESTED LOOPS  Cost: 127,608  Bytes: 4,693,710  Cardinality: 7,210
33 HASH JOIN  Cost: 103,232  Bytes: 7,151,421  Cardinality: 12,183
28 TABLE ACCESS FULL TABLE WEBSYSTEM.ACHUSHEADER Cost: 3,844  Bytes: 30,042,255  Cardinality: 193,821
32 NESTED LOOPS  Cost: 96,042  Bytes: 37,301,472  Cardinality: 86,346
30 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
29 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
31 TABLE ACCESS FULL TABLE WEBSYSTEM.ACHUS Cost: 96,040  Bytes: 42,827,616  Cardinality: 172,692
34 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_PAYMENTSCOMMON Cost: 1  Cardinality: 1
36 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMON Cost: 2  Bytes: 64  Cardinality: 1
52 SORT UNIQUE  Cost: 14  Bytes: 191  Cardinality: 5
51 UNION-ALL
42 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_NTE Cost: 3  Bytes: 9  Cardinality: 1
41 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_NTE Cost: 2  Cardinality: 1
44 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_DED Cost: 1  Bytes: 60  Cardinality: 1
43 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_DED Cost: 0  Cardinality: 1
46 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_RMT Cost: 0  Bytes: 55  Cardinality: 1
45 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_RMT Cost: 0  Cardinality: 1
48 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_TXP Cost: 2  Bytes: 59  Cardinality: 1
47 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_TXP Cost: 1  Cardinality: 1
50 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS_ADDENDA_FF Cost: 3  Bytes: 8  Cardinality: 1
49 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS_ADDENDA_FF Cost: 2  Cardinality: 1
67 VIEW WEBSYSTEM. Cost: 2,169  Bytes: 1,145  Cardinality: 1
66 COUNT
65 FILTER
64 NESTED LOOPS
62 NESTED LOOPS  Cost: 2,169  Bytes: 640  Cardinality: 1
60 NESTED LOOPS  Cost: 2,168  Bytes: 485  Cardinality: 1
57 NESTED LOOPS  Cost: 204  Bytes: 123,504  Cardinality: 498
54 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
53 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
56 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMON Cost: 202  Bytes: 63,680  Cardinality: 995
55 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_PAYMENTSCOMMONSTATPROD Cost: 4  Cardinality: 995
59 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS Cost: 7  Bytes: 237  Cardinality: 1
58 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHUS_BATCHTNUM Cost: 2  Cardinality: 21
61 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUSHEADER Cost: 0  Cardinality: 1
63 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSHEADER Cost: 1  Bytes: 155  Cardinality: 1
82 VIEW WEBSYSTEM. Cost: 848  Bytes: 8,632  Cardinality: 8
81 COUNT
80 FILTER
79 NESTED LOOPS
77 NESTED LOOPS  Cost: 848  Bytes: 4,736  Cardinality: 8
75 NESTED LOOPS  Cost: 839  Bytes: 4,490  Cardinality: 10
72 NESTED LOOPS  Cost: 146  Bytes: 268,496  Cardinality: 692
69 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACH_EXTRACTFILEINFO Cost: 2  Bytes: 184  Cardinality: 1
68 INDEX RANGE SCAN INDEX WEBSYSTEM.IDX_ACHEFI_ODFICODE Cost: 1  Cardinality: 1
71 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSTEMPLATE Cost: 144  Bytes: 282,336  Cardinality: 1,384
70 INDEX RANGE SCAN INDEX WEBSYSTEM.ACHUSTEMP_PRENOTE Cost: 4  Cardinality: 1,384
74 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.PAYMENTSCOMMONTEMPLATE Cost: 1  Bytes: 61  Cardinality: 1
73 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_PAYMENTSCOMTEMP Cost: 0  Cardinality: 1
76 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUSHEADTEMP Cost: 0  Cardinality: 1
78 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUSHEADERTEMPLATE Cost: 1  Bytes: 143  Cardinality: 1
88 INDEX UNIQUE SCAN INDEX (UNIQUE) WEBSYSTEM.PK_ACHUS Cost: 1  Cardinality: 1
90 TABLE ACCESS BY INDEX ROWID TABLE WEBSYSTEM.ACHUS Cost: 2  Bytes: 539  Cardinality: 1

[Updated on: Thu, 27 June 2013 10:15]

Report message to a moderator

Previous Topic:	Top wait events
Next Topic:	Sql query is slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 09:19:51 CST 2024