V$SQL

Columns
   ___________________________
 
   SQL_TEXT
   COMMAND_TYPE
   SQLTYPE
   CHILD_LATCH
   SHARABLE_MEM
   PERSISTENT_MEM
   RUNTIME_MEM
   SORTS
   LOADED_VERSIONS
   OPEN_VERSIONS
   KEPT_VERSIONS
   USERS_OPENING
   FETCHES
   EXECUTIONS
   USERS_EXECUTING
   LOADS
   FIRST_LOAD_TIME
   INVALIDATIONS
   PARSE_CALLS
   DISK_READS
   BUFFER_GETS
   ROWS_PROCESSED

   OPTIMIZER_MODE
   OPTIMIZER_COST
   PARSING_USER_ID
   PARSING_SCHEMA_ID

   ADDRESS
   TYPE_CHK_HEAP
   HASH_VALUE
   PLAN_HASH_VALUE
   CHILD_NUMBER
   MODULE
   MODULE_HASH
   ACTION
   ACTION_HASH
   SERIALIZABLE_ABORTS
   OUTLINE_CATEGORY
   CPU_TIME
   ELAPSED_TIME
   OUTLINE_SID
   CHILD_ADDRESS

   REMOTE
   OBJECT_STATUS
   LITERAL_HASH_VALUE
   LAST_LOAD_TIME
   IS_OBSOLETE

Examples

Select 
  substr(sql_text,0,80),
  decode(command_type,2,'INSERT'),
  executions

From V$SQL
Where command_type = 2
Order By executions;

Select 
  substr(sql_text,0,80), 
  decode(command_type,3,'SELECT'),
  executions

From V$SQL
Where command_type = 3
Order By executions;

List of command_type values with meaning:

Insert 2
Select 3
Update 6
Delete 7
Lock Table 26
Alter Database 35
Alter Session 42
Commit 44
Rollback 45
Savepoint 46
Begin/Declare 47

Related:

V$OPEN_CURSOR 
V$SQLAREA 
V$SQLTEXT 
V$SQLTEXT_WITH_NEWLINES 
V$SQL_BIND_DATA 
V$SQL_BIND_METADATA 
V$SQL_CURSOR 
V$SQL_SHARED_MEMORY