Grouper Users - Open Discussion List

[Chris Hyzer <>]

Can you analyze the tables in your database and see if it helps?

 

This will generate the script:

 

select 'ANALYZE TABLE ' || table_name || ' COMPUTE STATISTICS;' as script from user_Tables where table_name like 'GROUPER%'

 

Which will look like this, run the generated script (it will take some time), and see if it helps:

 

 

SCRIPT                                                         

----------------------------------------------------------------

ANALYZE TABLE GROUPER_ATTRIBUTES COMPUTE STATISTICS;           

ANALYZE TABLE GROUPER_ATTRIBUTE_ASSIGN COMPUTE STATISTICS;     

ANALYZE TABLE GROUPER_ATTRIBUTE_ASSIGN_VALUE COMPUTE STATISTICS;

ANALYZE TABLE GROUPER_ATTRIBUTE_DEF COMPUTE STATISTICS;        

ANALYZE TABLE GROUPER_ATTRIBUTE_DEF_NAME COMPUTE STATISTICS;   

ANALYZE TABLE GROUPER_ATTRIBUTE_DEF_NAME_SET COMPUTE STATISTICS;

ANALYZE TABLE GROUPER_ATTRIBUTE_DEF_SCOPE COMPUTE STATISTICS;  

ANALYZE TABLE GROUPER_ATTR_ASSIGN_ACTION COMPUTE STATISTICS;    

ANALYZE TABLE GROUPER_ATTR_ASSIGN_ACTION_SET COMPUTE STATISTICS;

ANALYZE TABLE GROUPER_AUDIT_ENTRY COMPUTE STATISTICS;          

ANALYZE TABLE GROUPER_AUDIT_TYPE COMPUTE STATISTICS;           

ANALYZE TABLE GROUPER_CHANGE_LOG_CONSUMER COMPUTE STATISTICS;  

ANALYZE TABLE GROUPER_CHANGE_LOG_ENTRY COMPUTE STATISTICS;     

ANALYZE TABLE GROUPER_CHANGE_LOG_ENTRY_TEMP COMPUTE STATISTICS;

ANALYZE TABLE GROUPER_CHANGE_LOG_TYPE COMPUTE STATISTICS;      

ANALYZE TABLE GROUPER_COMPOSITES COMPUTE STATISTICS;            

ANALYZE TABLE GROUPER_DDL COMPUTE STATISTICS;                  

ANALYZE TABLE GROUPER_EXT_SUBJ COMPUTE STATISTICS;             

ANALYZE TABLE GROUPER_EXT_SUBJ_ATTR COMPUTE STATISTICS;        

ANALYZE TABLE GROUPER_FIELDS COMPUTE STATISTICS;               

ANALYZE TABLE GROUPER_GROUPS COMPUTE STATISTICS;               

ANALYZE TABLE GROUPER_GROUPS_TYPES COMPUTE STATISTICS;         

ANALYZE TABLE GROUPER_GROUP_SET COMPUTE STATISTICS;            

ANALYZE TABLE GROUPER_LOADER_LOG COMPUTE STATISTICS;           

ANALYZE TABLE GROUPER_MEMBERS COMPUTE STATISTICS;              

ANALYZE TABLE GROUPER_MEMBERSHIPS COMPUTE STATISTICS;          

ANALYZE TABLE GROUPER_PIT_ATTRIBUTE_ASSIGN COMPUTE STATISTICS; 

ANALYZE TABLE GROUPER_PIT_ATTRIBUTE_DEF COMPUTE STATISTICS;    

ANALYZE TABLE GROUPER_PIT_ATTR_ASSN_ACTN COMPUTE STATISTICS;   

ANALYZE TABLE GROUPER_PIT_ATTR_ASSN_ACTN_SET COMPUTE STATISTICS;

ANALYZE TABLE GROUPER_PIT_ATTR_ASSN_VALUE COMPUTE STATISTICS;  

ANALYZE TABLE GROUPER_PIT_ATTR_DEF_NAME COMPUTE STATISTICS;    

ANALYZE TABLE GROUPER_PIT_ATTR_DEF_NAME_SET COMPUTE STATISTICS;

ANALYZE TABLE GROUPER_PIT_FIELDS COMPUTE STATISTICS;           

ANALYZE TABLE GROUPER_PIT_GROUPS COMPUTE STATISTICS;           

ANALYZE TABLE GROUPER_PIT_GROUP_SET COMPUTE STATISTICS;        

ANALYZE TABLE GROUPER_PIT_MEMBERS COMPUTE STATISTICS;           

ANALYZE TABLE GROUPER_PIT_MEMBERSHIPS COMPUTE STATISTICS;      

ANALYZE TABLE GROUPER_PIT_ROLE_SET COMPUTE STATISTICS;         

ANALYZE TABLE GROUPER_PIT_STEMS COMPUTE STATISTICS;            

ANALYZE TABLE GROUPER_ROLE_SET COMPUTE STATISTICS;             

ANALYZE TABLE GROUPER_STEMS COMPUTE STATISTICS;                

ANALYZE TABLE GROUPER_TYPES COMPUTE STATISTICS;                 

 

 

 

 

From: [mailto:] On Behalf Of Tim Darby
Sent: Wednesday, November 14, 2012 1:36 PM
To:
Subject: [grouper-users] Grouper UI search performance

 

In 2.1.2, when I use the search tool and specify the Group Source Adapter as the data source, the response is very slow and sometimes times out.  This is using an Oracle 11g database as the source.  I have a 1.5.3 instance to compare with and the response there is fine.  I'm only using indexes created by the installer and they appear to be OK. Also, these two instances are pointed to the same database server, but different databases obviously. Can you point me to where I should look for the problem?

Tim Darby
The University of Arizona
Mosaic, Systems Integration and Architecture

UITS, Rm 335, 520-626-3799