dbms_comp_advisor
From: <TESTAJ3_at_nationwide.com>
Date: Thu, 12 May 2011 12:58:23 -0400
Message-ID: <OFE739B9AC.60A6A921-ON8525788E.005D07DC-8525788E.005D3CA0_at_lnotes-gw.ent.nwie.net>
I was using this to see if we would gain any from compression, ctrl-c out of one processing and then could never run anymore due to BUG: 9151921 , INVALID COMPRESSION ...COMPAT SETTING. If you run into this(and I caused it by CTRL-C out of one already running, drop table sys.dbms_compression_temp_cmp; will fix it and then you can give it another whirl.
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
Date: Thu, 12 May 2011 12:58:23 -0400
Message-ID: <OFE739B9AC.60A6A921-ON8525788E.005D07DC-8525788E.005D3CA0_at_lnotes-gw.ent.nwie.net>
I was using this to see if we would gain any from compression, ctrl-c out of one processing and then could never run anymore due to BUG: 9151921 , INVALID COMPRESSION ...COMPAT SETTING. If you run into this(and I caused it by CTRL-C out of one already running, drop table sys.dbms_compression_temp_cmp; will fix it and then you can give it another whirl.
joe
Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 12 2011 - 11:58:23 CDT