(1 - 16 von 16
)
SQL to find objects on which Full table scan is being performed -...
askdba.org
This is very straight forward SQL which can be used to identify objects on which Full Table Scan (FTS) is being performed. select object_owner,object_name from V$SQL_PLAN where. operation='TABLE ACCESS' and. options='FULL' and. object_owner<>'SYS';. Please note that this will work with queries ...
sortiert nach Relevanz / Datum