Performance [message #50280] |
Fri, 08 March 2002 09:36 |
Eric
Messages: 78 Registered: April 1999
|
Member |
|
|
I am running oracle 734 on an NT 4.0 box. At one point another dba was forced to recreated the database. It's a small database. Since then a queries against our largest table 500 MB has cause either hangs or long waits. The query hasnt changed so I assume it can only be some database setting that is different. I already raised the SGA which was really low. Are there other init parameters or options to change to manipulate the speed of sql statments?
Thanks,
Eric
|
|
|
Re: Performance [message #50281 is a reply to message #50280] |
Fri, 08 March 2002 09:45 |
saleem
Messages: 65 Registered: January 2002
|
Member |
|
|
How the other dba recreated the db seems to be the critical factor here.
check to make sure all the indexes are back up and usable. check to see if all the code compiled properly.
check the tablespace distribution.
are there enough logs (and are they big enough)
did you move to another box with more apps running on it?
is the old/new location physically configured the same way?
|
|
|