Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

How do I tune an Oracle database running RequestCenter?

How do I tune an Oracle database running RequestCenter?

The details in the following discussion apply to RequestCenter/AlignmentCenter versions 2006 and prior.

For most efficient operation of ServiceManger, several of the RequestCenter tables must have statistics collected which include histograms.  You can use the SQL commands below to collect the required statistics:

 

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS StateID SIZE 45;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS PerformerShared, IsBusy, TicketObjectID SIZE 2;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS Waiting, FlagID, EscalationLevel SIZE 3;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS PerformerOfficeID SIZE 75;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS PerformerID SIZE 185;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS CustomerID SIZE 200;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS ActivityFormID, ActivityTypeID SIZE 3;
ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS ClientOUID SIZE 45;

ANALYZE TABLE TxActivity COMPUTE STATISTICS
    FOR COLUMNS NextActionID SIZE 6;


ANALYZE TABLE TxProcess COMPUTE STATISTICS
    FOR COLUMNS TicketObjectID, EscalationLevel SIZE 3;


ANALYZE TABLE TxRequisition COMPUTE STATISTICS
    FOR COLUMNS BeingProcessed SIZE 2;

ANALYZE TABLE TxRequisition COMPUTE STATISTICS
    FOR COLUMNS OrganizationalUnitID SIZE 16;

ANALYZE TABLE TxRequisition COMPUTE STATISTICS
    FOR COLUMNS StatusID SIZE 6;


ANALYZE TABLE TxRequisitionEntry COMPUTE STATISTICS
    FOR COLUMNS ServiceID SIZE 32;

ANALYZE TABLE TxRequisitionEntry COMPUTE STATISTICS
    FOR COLUMNS StatusID SIZE 6;


ANALYZE TABLE DirPerson COMPUTE STATISTICS
    FOR COLUMNS isOffice SIZE 2;

ANALYZE TABLE DirPerson COMPUTE STATISTICS
    FOR COLUMNS IsInactive SIZE 2;

ANALYZE TABLE DirPerson COMPUTE STATISTICS
    FOR COLUMNS TimeZoneID SIZE 6;

ANALYZE TABLE DirPerson COMPUTE STATISTICS
    FOR COLUMNS SupervisorID SIZE 3;


ANALYZE TABLE DirPermission[LW1]  COMPUTE STATISTICS
    FOR COLUMNS TargetObjectID SIZE 12;

ANALYZE TABLE DirPermission COMPUTE STATISTICS
    FOR COLUMNS OwnerObjectID SIZE 4;


ANALYZE TABLE DirOrganizationalUnit COMPUTE STATISTICS
    FOR COLUMNS OrganizationalUnitTypeID SIZE 4;


ANALYZE TABLE DefJavascript COMPUTE STATISTICS
    FOR COLUMNS IsGlobalOnLoad, IsGlobalOnSubmit, IsGlobalOnUnload
    SIZE 2;


ANALYZE TABLE UIEntry COMPUTE STATISTICS
    FOR COLUMNS ObjectID SIZE 7;
ANALYZE TABLE UIEntry COMPUTE STATISTICS
    FOR COLUMNS UserInterfaceID SIZE 16;


Everyone's tags (1)
160
Views
0
Helpful
0
Replies
CreatePlease to create content