| Database running slowly - URGENT help needed [message #286473] |
Fri, 07 December 2007 09:59  |
kudur_kv
Messages: 75
Registered: February 2005
|
Member |
|
|
I am getting a lot of trace files generated as below.
SGA initialization / DB open not complete even after 5 minutes, QMN0exiting
error 604 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only
The users are able to login and see all the objects required. but the response is very slow according to the users.
I would greatly appreciate urgent help on this.
Thank you
KV
|
|
|
|
|
|
|
|
| Re: Database running slowly - URGENT help needed [message #287131 is a reply to message #286473] |
Tue, 11 December 2007 02:55  |
kudur_kv
Messages: 75
Registered: February 2005
|
Member |
|
|
Hello,
thank you for your time,
I did managed to crack the issue over the weekend.
This extract of the trace file was not the true indication of the problem with the DB performance. the performance issue was due to the fact that while importing data from the live DB's dump, somehow a lot of the objects like functions, triggers, procedures had gone missing.
After dropping all the objects for the schema and re-importing, the performance issues have been resolved.
Thank you for your inputs. Much appreciate it!
KV
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
