Oracle Analyze

2006-07-22 Thread Sanford, Claire
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

Re: Oracle Analyze

2006-07-22 Thread Frank Caruso
** Ensure that you have appropriate indexes for the long running queries. Running statistics should be a good thing. Maybe they had not been run in a long time and now your current indexes do not support your bigger queries. Also, fund out exactly what the DBA did. I can remember having problems

Re: Oracle Analyze

2006-07-22 Thread Jarl Grøneng
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

COM ActiveLink example

2006-07-22 Thread Angus Comber
Hello I have a COM object which can dial a number. So I will click a button on a form and it will dial a number in a field. But COM object needs to be initialised before I can do anything. So if you were programming in say Visual Basic you would do something like this: Create object - eg Set