oracle中查找執(zhí)行效率低下的sql-文庫(kù)吧資料
2025-07-02 11:49本頁(yè)面
【正文】 y of the child cursors openFETCHESNUMBERNumber of fetches associated with the SQL statementEXECUTIONSNUMBERTotal number of executions, totalled over all the child cursorsEND_OF_FETCH_COUNTNUMBERNumber of times this cursor was fully executed since the cursor was brought into the library cache. The value of this statistic is not incremented when the cursor is partially executed, either because it failed during the execution or because only the first few rows produced by this cursor are fetched before the cursor is closed or reexecuted. By definition, the value of the END_OF_FETCH_COUNT column should be less or equal to the value of the EXECUTIONS column.USERS_EXECUTINGNUMBERTotal number of users executing the statement over all child cursorsLOADSNUMBERNumber of times the object was loaded or reloadedFIRST_LOAD_TIMEVARCHAR2(19)Timestamp of the parent creation timeINVALIDATIONSNUMBERTotal number of invalidations over all the child cursorsPARSE_CALLSNUMBERSum of all parse calls to all the child cursors under this parentDISK_READSNUMBERSum of the number of disk reads over all child cursorsDIRECT_WRITESNUMBERSum of the number of di
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1