H_OBJECT_ID"="D"."DEVICE_ID")
53 - filter("F"."SITE_ID"=1021)
54 - access("F"."FUNCTION_LOCATION_ID"="D"."FUNCTION_LOCATION_ID")
55 - filter("C"."ALIAS_NAME"='A176')
56 - access("D"."CLASSIFY_ID"="C"."CLASSIFY_ID")
57 - access("N"."TECH_OBJECT_ID"="D"."DEVICE_ID" AND "N"."NODE_TYPE"=2)
58 - access("N"."TECH_OBJECT_ID"="F"."FUNCTION_LOCATION_ID")
统计信息
----------------------------------------------------------
8 recursive calls
0 db block gets
863 consistent gets
0 physical reads
0 redo size
2890 bytes sent via SQL*Net to client
10807 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
76 sorts (memory)
0 sorts (disk)
1 rows processed
|