SQL> set lines  100 
SQL> set pages  9999 
SQL> desc v$sqlarea
 Name				       Null?	Type
  ------------------------------------- -------- --------------
 
 SQL_TEXT					VARCHAR2( 1000 )
 SHARABLE_MEM					NUMBER
...

SQL> col sql_text format a60 WORD
SQL> select executions, sql_text from v$sqlarea where rownum <  5 ;
EXECUTIONS SQL_TEXT
 ---------- ------------------------------------------------------------
 
	 23  select substr(ts.name, 1 , 20 )	 ts,
	   substr(i.name, 1 , 40 )	  name, 	 ROUND(i.bytes/ 1048576 )
	   mb_size,	     x.phyrds		    pyr,
	   x.phywrts		  pyw,		x.phyblkrd
	   pbr, 	 x.phyblkwrt		pbw   from   v$filestat
	   x,	       sys.ts$ ts,	    v$datafile i,
	   sys.file$ f	where i.file#=f.file#	 and ts.ts#=f.ts#
	   and x.file#=f.file#

	  1  analyze table a_tree compute statistics
	  2  select * from a_tree
	  1  select * from not_ORD_TABLE where rownum <  20 

SQL>