SELECT SESSION_ADDR, SESSION_NUM, SQLADDR, SQLHASH, SQL_ID, TABLESPACE, CONTENTS, SEGTYPE, SEGFILE#, SEGBLK#, EXTENTS, BLOCKS, SEGRFNO# 
FROM v$tempseg_usage

SESSION_ADDR	SESSION_NUM	SQLADDR		  	SQLHASH		SQL_ID		TABLESPACE CONTENTS	SEGTYPE		SEGFILE# SEGBLK# EXTENTS BLOCKS SEGRFNO#
00000000BC83D220	99	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_DATA	201	881280	6	768	1
00000000BC8433E0	55	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_DATA	201	879232	9	1152	1
00000000BC83D220	99	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_INDEX	201	877824	1	128	1
00000000BC8433E0	55	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_INDEX	201	879488	1	128	1
00000000BC81B880	17	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_DATA	201	878208	8	1024	1
00000000BC81B880	17	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_INDEX	201	880384	1	128	1
00000000BC824B20	5	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_DATA	201	885504	7	896	1
00000000BC824B20	5	00000000B2D61660	2100435908	az33m61ym46y4	TEMP	TEMPORARY	LOB_INDEX	201	885888	1	128	1

PARSING IN CURSOR #139733223484496 len=338 dep=0 uid=76 oct=3 lid=76 tim=1513106791714895 hv=2100435908 ad='b2b2eab8' sqlid='az33m61ym46y4'
SELECT NULL AS table_cat,
       o.owner AS table_schem,
       o.object_name AS table_name,
       o.object_type AS table_type,
       NULL AS remarks
  FROM all_objects o
  WHERE o.owner LIKE :1 ESCAPE '/'
    AND o.object_name LIKE :2 ESCAPE '/'
    AND o.object_type IN ('xxx', 'TABLE')
  ORDER BY table_type, table_schem, table_name
END OF STMT
PARSE #139733223484496:c=513,e=145,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2068642610,tim=1513106791714894
BINDS #139733223484496:
 Bind#0
  oacdty=01 mxl=32(04) mxlc=00 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000010 frm=01 csi=873 siz=160 off=0
  kxsbbbfp=7f162d260e00  bln=32  avl=01  flg=05
  value="%"
 Bind#1
  oacdty=01 mxl=128(44) mxlc=00 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000010 frm=01 csi=873 siz=0 off=32
  kxsbbbfp=7f162d260e20  bln=128  avl=11  flg=01
  value="PROBABLYNOT"
EXEC #139733223484496:c=376,e=438,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2068642610,tim=1513106791715551

CREATE OR REPLACE FUNCTION test_clob (some_params IN VARCHAR2)
    RETURN CLOB IS
    internal_clob   CLOB;
BEGIN
    internal_clob   := 'Some value';
    RETURN internal_clob;
END;