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
**
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
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
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
4 matches
Mail list logo