ITL related question
From: Hameed, Amir <amir.hameed_at_sleepnumber.com>
Date: Fri, 6 Aug 2021 13:58:23 +0000
Message-ID: <CH0PR14MB5012563A250684863D5B04E0E0F39_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi,
When Oracle runs a DML statement that contains a subquery, does Oracle grab an ITL entry immediately at the start of the statement or does it wait until row-set from the subquery/subqueries are returned? The reason I am asking is that if it is the former then depending on the efficiency of the subquery, it could occupy the ITL for a while?
Date: Fri, 6 Aug 2021 13:58:23 +0000
Message-ID: <CH0PR14MB5012563A250684863D5B04E0E0F39_at_CH0PR14MB5012.namprd14.prod.outlook.com>
Hi,
When Oracle runs a DML statement that contains a subquery, does Oracle grab an ITL entry immediately at the start of the statement or does it wait until row-set from the subquery/subqueries are returned? The reason I am asking is that if it is the former then depending on the efficiency of the subquery, it could occupy the ITL for a while?
Thanks,
Amir
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 06 2021 - 15:58:23 CEST