Performance Tuning

[ramesh_1600]

The following 2 issues heavily affect our database performance
(according to Statspack Reports )

1) db file scattered read ( 89% of the total wait time )
2) Recursive Call % ( 69% )

The surprising point is both of these issues arised after we converted our tablespaces into Locally Managed with a uniform extent size.

What database parameters I can tune to reduce the time spent because of these 2 issues ?

[slimdave]

My instinctive reply is, "so what?". The real question you need to answer is whether the database performance is worse than required, and ni what area? Are there particular times of day, or types of operation (overnight batch processing for example) for which performance has degraded?

Moving on, the recursive calls may be associated with excessive hard parsing -- check that you are using bind variables.