Tuning Self-referencing Inserts
From: MacGregor, Ian A. <"MacGregor,>
Date: Fri, 30 Nov 2018 18:31:26 +0000
Message-ID: <BYAPR07MB4901BA241E009139DEF97F1CE2D30_at_BYAPR07MB4901.namprd07.prod.outlook.com>
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.
Date: Fri, 30 Nov 2018 18:31:26 +0000
Message-ID: <BYAPR07MB4901BA241E009139DEF97F1CE2D30_at_BYAPR07MB4901.namprd07.prod.outlook.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 30 2018 - 19:31:26 CET