The problem is with a PeopleSoft statement which is based on a select
statement which references the table being inserted. The problem stems from
having to read and build the indexes of the table which is not that large.
The buffer gets are extremely high.
Is there generic answer to this problem. Would it help to rebuild with a
higher percent free in an attempt to have few rows per block so as to lessen
contention.
Also for library cache pins I don't understand how to reads the p3raw value. I
think the problem primarily lies with the maintenance m of the unique index
bit I am. not 100% confident.
Ian A. MacGregor
SLAC National Accelerator Laboratory
Computing Division
To offer the best IT service at the lab and be the IT provider of choice.
