obclient(rd_read@woqu)[cprint]> SELECT DBMS_XPLAN.DISPLAY_CURSOR('0','ADVANCED','172.17.172.84','2882','1002'); +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | DBMS_XPLAN.DISPLAY_CURSOR('0','ADVANCED','172.17.172.84','2882','1002') | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | =========================================================================================== |ID|OPERATOR |NAME|EST.ROWS|EST.TIME(us)|REAL.ROWS|REAL.TIME(us)|IO TIME(us)|CPU TIME(us)| ------------------------------------------------------------------------------------------- |0 |EXPRESSION| |1 |1 |1 |0 |0 |0 | =========================================================================================== Outputs & filters: ------------------------------------- 0 - output([user()]), filter(nil) values({user()}) Used Hint: ------------------------------------- /*+ */ Qb name trace: ------------------------------------- stmt_id:0, SEL$1 Outline Data: ------------------------------------- /*+ BEGIN_OUTLINE_DATA OPTIMIZER_FEATURES_ENABLE('4.3.5.3') END_OUTLINE_DATA */ Optimization Info: ------------------------------------- Plan Type: LOCAL Note: Degree of Parallelisim is 1 because of table property | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.002 sec) obclient(rd_read@woqu)[cprint]>