Insert statement has high LIO
From: Krishnaprasad Yadav <chrishna0007_at_gmail.com>
Date: Fri, 17 Jun 2022 17:44:19 +0530
Message-ID: <CAO8FHeXVetbWRO8OXyQ63mG_mdQ4Ui3G9HnLw7vfYGfA9moHLg_at_mail.gmail.com>
Hi Experts ,
buffer get *
Date: Fri, 17 Jun 2022 17:44:19 +0530
Message-ID: <CAO8FHeXVetbWRO8OXyQ63mG_mdQ4Ui3G9HnLw7vfYGfA9moHLg_at_mail.gmail.com>
Hi Experts ,
Below is insert statement has high LIO
INSERT INTO "A1" ( "MOD", "k1", "K2", "VALUE1", "DES", "STATUS", "MID",
"MDATE", "AUT", "ADATE", "ACTIVE_FLAG")
VALUES (:B11, :B10, :B9, :B8, :B7, :B6, :B5, :B4, :B3, :B2, :B1)
*STATS : *
*=======*
Stat Name Statement Per Execution % Snap ---------------------------------------- ---------- -------------- ------- Elapsed Time (ms) 6.7031E+07 612.0 5.3 CPU Time (ms) 6.6711E+07 609.0 6.0 Executions 109,536 N/A N/A
*Buffer Gets 2.6882E+09 24,541.9 3.4*
Disk Reads 952,253 8.7 0.0 Parse Calls 109,535 1.0 0.1 Rows 109,393 1.0 N/A User I/O Wait Time (ms) 428,156 N/A N/A Cluster Wait Time (ms) 6,212 N/A N/A Application Wait Time (ms) 0 N/A N/A Concurrency Wait Time (ms) 18 N/A N/A Invalidations 0 N/A N/A Version Count 95 N/A N/A Sharable Mem(KB) 2,629 N/A N/A
Currently it is being called from remote database via dblink and on local server for single execution buffer *gets 24.5K *
*Request to show some path since its a plan insert it should not cause huge
buffer get *
*Regards,*
*Krishna *
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 17 2022 - 14:14:19 CEST