Change: -------- OLAP AW----------------------- SQL_ID------- SQL_TEXT-------------------- -------------------- ------------- ----------------------------------------OLAPTRAIN(128,23945) SYS.EXPRESS--------- c2t583nkt79m3 select count(product) from cb$sales_cubeOLAPTRAIN(128,23945) OLAPTRAIN.SALESTRACK c2t583nkt79m3 select count(product) from cb$sales_cube For Real Application Clustersset pages 500 lines 110 col usn format a20 heading "USER (SID,SERIAL#)" col awn format   View changes from previous version. (Word count: 336)

Change: OLAPTRAIN(128,23945) OLAPTRAIN.SALESTRACK c2t583nkt79m3 select count(product) from cb$sales_cube For Real Application Clusters set pages 500 lines 110 col usn format a23 heading "USER (SID,SERIAL#)" col awn format a15 hea "AW"col sql_id format a15col sql_text format a30 wrapcol inst format a15 hea "INSTANCE (#)"select username||' ('||sid||','||serial#||')'   View changes from previous version. (Word count: 318)

Change: from dba_aws daws,gv$aw_olap gvawo, gv$aw_calc gvawc, gv$session gvses, gv$sql gvsql, gv$instance gvinstwhere daws.aw_number=gvawo.aw_number and sid=gvawo.session_id and gvawc.session_id = sid and gvses.sql_id=gvsql.sql_idgroup by username, gvses.sid, gvses.serial#,gvinst.instance_name,gvses.inst_id, daws.owner,daws.aw_name, gvses.sql_id,sql_textorder by username, sid, daws.aw_name;USER (SID,SERIAL#)----- INSTANCE (#)--- AW------------- SQL_ID--------- SQL_TEXT----------------------- --------------- --------------- --------------- ------------------------------   View changes from previous version. (Word count: 302)

Change: I wrote this one quickly so if it needs some modification or you run into issues please let me know. This script will only return   View changes from previous version. (Word count: 164)