SetOwner Speed

Alexey G Misyurenko wrote:

Ruslan Zakirov wrote:

Ruslan Zakirov wrote:

Ok, I think index on CachedGroupMembers(MemberId, GroupId, Disabled)
should help you with query 4, but to help you with other queries I
need to see EXPLAINs…

Sorry for the pause with answer - second oracle installation take a
time…

Please, make explains before you’ll add index and after.

WITH INDEX

SQL Statement from editor:

SQL Tunning toolkit for oracle just finish analise what can be done with
original
SQL request generated by RT .

SELECT *

[skip]

which is run 9,353s, and propose next SQL edition

SELECT /*+ PARALLEL(, 2) */

[skip]

   *

What version of Oracle?

Linux, 9.2.0.6

When did you last run: ?

If be onest I don’t know because DBA is unaccesseble right now.
So I start next one sql right now, and currently it’s run

BEGIN
SYS.DBMS_STATS.GATHER_SCHEMA_STATS (
OwnName => ‘RT_USER’
,Granularity => ‘DEFAULT’
,Options => ‘GATHER’
,Gather_Temp => FALSE
,Method_Opt => 'FOR ALL INDEXED COLUMNS SIZE 1 '
,Degree => 4
,Cascade => TRUE
,No_Invalidate => FALSE);
END;

I ask because our Oracle instance takes 80msec for this query. Explain
plan looks the same, for the first query. adding parallel does nothing
for timing albeit it does for the cost of the query.
Version Oracle10g (Oracle XE).

I use SQL Navigator from Quest Software for develop SQL code
and tune it so explain ouput format can diff with original oracle output
format.

Alexey G Misyurenko wrote:

Linux, 9.2.0.6

When did you last run: ?

If be onest I don’t know because DBA is unaccesseble right now.
So I start next one sql right now, and currently it’s run

BEGIN SYS.DBMS_STATS.GATHER_SCHEMA_STATS ( OwnName
=> ‘RT_USER’ ,Granularity => ‘DEFAULT’
,Options => ‘GATHER’ ,Gather_Temp => FALSE
,Method_Opt => 'FOR ALL INDEXED COLUMNS SIZE 1 '
,Degree => 4 ,Cascade => TRUE
,No_Invalidate => FALSE); END;

Request finished but without speedup system %(

I think the problmes is more complex.
For example, wheh I open queue (
http://www.rt.inside.caravan.ru/Search/Results.html?Query=Queue%20=%20’NOC’%20AND%20(Status%20=%20’open’%20OR%20Status%20=%20’new’%20OR%20Status%20=%20’stalled’)
)
Ticket list is format quickly.
But when it “published” to the web
/Elements/CollectionAsTable/Row
take from 0.5 to 8 second to generate and output all row.

May bee somethink must be done also to correct upgrade from 3.4.4 to 3.6.0 ?
And is exist diffs from 3.6.0rc3 and 3.6.0 ?