The information about query execution plan is not getting captured in sysxplain_* tables in the XPLAIN-only mode . But the statistics are captured perfectly if the queries are executed . I need to get the query execution plan without actually executing it . Please help .
Error shown when I give a query in XPLAIN-only mode is select * from physicsmarks where P_Id = 34567 ; ERROR XCL16: ResultSet not open. Operation 'getMetaData' not permitted. Verify that autocommit is OFF. I tried with autocommit OFF , but still giving same results . The sysxaplain_* tables are empty after this . Please help .
