Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Monday 10-08-2007

Sunday 10-07-2007

  • 07:00 (Patrick) I've rebuilt the TA tables with current data and the synonyms now point there. The job completed at 7am.
  • 12:20 (Prabhu) I disable monitor when tables dropped and enable when new ones created as below. 
    • ---Enable monitoring
SQL> alter index sakai_external.CM_INST_TA_PERSON_IDX monitoring usage;
Index altered.
SQL> alter index sakai_external.CM_SECTION_TA_EID_IDX monitoring usage;
Index altered.
SQL> select index_name, table_name, monitoring, used, end_monitoring from v$object_usage;
no rows selected

---Disable monitoring
alter index sakai_external.CM_INST_TB_PERSON_IDX nomonitoring usage;
alter index sakai_external.CM_SECTION_TB_EID_IDX nomonitoring usage;

Saturday 10-06-2007

  • 06:58 (Patrick) I switched to the recreated TB tables. The job started at 6:58am and completed at 7:06.
    • I checked the problem query on both the TA and TB tables and it looks like the indexes are still being used.
    • I noticed that there are 151 pairs of duplicate EID's in the SECTION table. Have we considered changing the view to weed those out?
  • 24:00 (Oracle) run stats

Friday 10-05-2007

  • 22:00 (Oracle) run stats

Thursday 10-04-2007

  • 15:20 (Patrick) Run coursemanagement_merge_procs.sql
    • coursemanagement_merge_procs.sql
    • Script run fine for:
      • coursemanagement_section
      • coursemanagement_offering
    • coursemanagement_enrollment
    • Script hung during the delete records process for:
      • coursemanagement_instructors
      • coursemanagement_membership

Wednesday 10-03-2007

  • ... ?

Tuesday 10-02-2007

  • ... ?

Monday 10-01-2007

  • ... ?

Sunday 09-30-2007

  • ... ?

Saturday 09-29-2007

  • ... ?
  • No labels