Friday, July 28, 2006

Performance

Yesterday I visited a customer who is facing performance problems in their Oracle environment. I have to go back next week, because I had to examine some solutions.
Their environment exists of an Oracle 10gR2 database, and they are running discoverer and an a application on the same database. That's what causing the performance problems....Now I have to look for the best options to solve this, and present them to the customer. Together we will have to solve this problem.

4 comments:

fhasweh said...

we are facing the same issue and its becase the discoverer dosnot close sessions it keeps them open on the server and it processor and ram for no thing.

thanks
fadi

Bas Klaassen said...

How did you solve it ?

fhasweh said...

well, till now we are doing the kill manauly we still without a soultion plz if you find any let me know.

thanks
fadi

Atul Kumar said...

Have you identified first whats cause of performance Issue ?

Is it discoverer issue or somthing else ? dic4wb4 processes sometime becomes runaaway if not closed properly or if custom discoverer reports are not tuned properly . So I will suggest if it really discoverer or system is not big enough too much load or regular jobs like Gather Stats or Purge concurrent & WF requests are purged propely .

Check similar at
Become Apps DBA