Home » RDBMS Server » Server Administration » Database running slowly - URGENT help needed
Database running slowly - URGENT help needed [message #286473] Fri, 07 December 2007 09:59 Go to next message
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 #286484 is a reply to message #286473] Fri, 07 December 2007 10:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
What is Operating System name & version?
What is Oracle's version to 4 decimal places?

What is content at the end of the alert_SID.log file (last 30 lines or so)?
Re: Database running slowly - URGENT help needed [message #286494 is a reply to message #286473] Fri, 07 December 2007 10:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, have a look at the trace file listed in the alert.log.
And are you in RAC or do you have any special option?

Regards
Michel

[Updated on: Fri, 07 December 2007 10:45]

Report message to a moderator

Re: Database running slowly - URGENT help needed [message #287131 is a reply to message #286473] Tue, 11 December 2007 02:55 Go to previous message
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
Previous Topic: ASM files and log location (merged)
Next Topic: Batch file for del old backup files
Goto Forum:
  


Current Time: Sun Dec 11 02:32:56 CST 2016

Total time taken to generate the page: 0.24761 seconds