This article explains what likely happend: http://asktom.oracle.com/pls/ask/f?p=4950:8:7550689886422531643::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:6601312252730
-- Jarl On 7/22/06, Rick Cook <[EMAIL PROTECTED]> wrote:
Ask your DBA what the Analyze function did. I wonder if it reset some indexes or page sizes or something. ____________________________________________________________________________________ Rick Cook * Remedy Approved Consultant * Denali Advanced Integration * (253) 278-4112 ________________________________ From: Action Request System discussion list(ARSList) on behalf of Sanford, Claire Sent: Sat 7/22/2006 12:11 AM To: arslist@ARSLIST.ORG Subject: Oracle Analyze My DBA performed an Oracle Analyze on the remedy database. Since then we have had weird query timeout issues. Is doing this to a Remedy database a bad thing? ARS 4.5.2 Oracle 8.x I think Claire "who has been working since 8:00am" Sanford _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org