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: [email protected] 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
