Select "SQL _TEXT ",
"SQL _FULLTEXT ",
"SQL _ID ",
"Sharable_mem ",
"Persistent_men ",
"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_cils ",
"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 ",
"CHILD_NUMBER ",
"SERVICE ",
"SERVICE_HASH ",
"MODULE ",
"MODULE_HASH ",
"ACTION ",
"ACTION_HASH ",
"SERIALIZABLE_ABORTS ",
"OUTLINE_CATEGORY ",
"CPU_TIME ",
"ELAPSED_TIME ",
"OUTLINE_SID ",
"CHILD_ADDRESS ",
"SQLTYPE ",
"REMOTE ",
"OBJECT_STATUS ",
"LITERAL_HASH_VALUE ",
"LAST_LOAD_TIME ",
"IS_OBSOLETE ",
"IS_BIND_SENSITIVE ",
"IS_BIND_AWARE ",
"Is_retriable ",
"CHILD_LATCH ",
"SQL _PROFILE ",
"SQL _PATCH ",
"SQL _PLAN_BASELINE ",
"PROGRAM_ID ",
"PROGRAM_LINE #",
"EXACT_MATCHING_SIGNATURE ",
"FORCE_MATCHING_SIGNATURE ",
"LAST_ACTIVE_TIME ",
"BIND_DATA ",
"TYPECHECK_MEM ",
"IO_CELL_OFFLOAD_ELIGIBLE_BYTES ",
"IO_INTERCONNECT_BYTES ",
"PHYSICAL_READ_REQUESTS ",
"PHYSICAL_READ_BYTES ",
"PHYSICAL_WRITE_REQUESTS ",
"PHYSICAL_WRITE_BYTES ",
"OPTIMIZED_PHY_READ_REQUESTS ",
"LOCKED_TOTAL ",
"PINNED_TOTAL ",
"IO_CELL_UNCOMPRESSED_BYTES ",
"IO_CELL_OFFLOAD_RETURNED_BYTES"
From v $ SQL order by last_load_time desc;
V $ SQL view.