Possible CPU Bottleneck

[Charles McCary]

Hai,

the log files are not really helpful - these processes are basically reading data from a large file and loading the data from these files into an oracle db. The logs basically show the progress (number of records cumulatively completed).

Before you ask we have looked into Oracle tuning as well.

tx,

c

[Trond Haugen]

Sandip/Charles; on this system the buffer cache IS tuned with dbc_max/min_pct (7/5). You have to be aware of that sysdef WILL report bufpages and nbuf with their current (dynamic) values. This is verified with the SAM output. As this is a database system and the dynamic in the dbc is rather small, it might be a good idea it make it static at say 6%. That way you eliminate the overhead of sizing it. But in this case I don't think it will do any difference.
As it seems the problem is not HP-UX but the application have you put the question to the application vendor?

Regards,
Trond