v$sqlarea 和v$sql 多版本子游标

select nvl(max(to_number(mingxibh)), 0) as lMaxXuhao from klnl_dkkhmx where dkjiejuh=:1   and farendma=:2           and trim(translate(mingxibh,'0123456789',' ')) is null



       SQL_TEXT    SQL_FULLTEXT    SQL_ID    SHARABLE_MEM    PERSISTENT_MEM    RUNTIME_MEM    SORTS    LOADED_VERSIONS    OPEN_VERSIONS    USERS_OPENING    FETCHES    EXECUTIONS    PX_SERVERS_EXECUTIONS    END_OF_FETCH_COUNT    USERS_EXECUTING    LOADS    FIRST_LOAD_TIME    INVALIDATIONS    PARSE_CALLS    DISK_READS    DIRECT_WRITES    BUFFER_GETS    APPLICATION_WAIT_TIME    CONCURRENCY_WAIT_TIME    CLUSTER_WAIT_TIME    USER_IO_WAIT_TIME    PLSQL_EXEC_TIME    JAVA_EXEC_TIME    ROWS_PROCESSED    COMMAND_TYPE    OPTIMIZER_MODE    OPTIMIZER_COST    OPTIMIZER_ENV    OPTIMIZER_ENV_HASH_VALUE    PARSING_USER_ID    PARSING_SCHEMA_ID    PARSING_SCHEMA_NAME    KEPT_VERSIONS    ADDRESS    TYPE_CHK_HEAP    HASH_VALUE    OLD_HASH_VALUE    PLAN_HASH_VALUE    FULL_PLAN_HASH_VALUE