Friday, July 28, 2006


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.


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.


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.


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

Anonymous said...

black mold exposure,
black mold symptoms of exposure,

wrought iron garden gates,
your next iron garden gates, here,

hair styles for fine thin hair,
search hair styles for fine thin hair,

night vision binoculars,
buy, night vision binoculars,

lipitor reactions,
lipitor reactions,

luxury beach resort in the philippines,
beach resort in the philippines,

homeopathy for baby eczema.,
homeopathy for baby eczema.,

save big with great mineral makeup bargains,
companies marketing mineral makeups,

prodam iphone praha,
Apple prodam iphone praha,

iphone clone cect manual,
manual for iphone clone cect,

fero 52 binoculars night vision,
fero 52 night vision,

best night vision binoculars,
buy, best night vision binoculars,

computer programs to make photo albums,
computer programs, make photo albums,

Unknown said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.