ORACLE SQL & PLSQL QNS2

ORACLE SOME IMPORTANT QUSTIONS 

1:How to track concurrent program while running the program?
select sql_text from v$sqlareawhere sql_id=(select sql_id from v$session where action ='Concurrent Request' and module='Concurren program short_name');
2: How to Cancel the COncurrent Program though backend?
SQL> update fnd_concurrent_requestsset status_code='D' , phase_code='C'where request_id=;
3: How to refresh the materialized views?
BEGINDBMS_MVIEW.REFRESH ('apps.MATERIALIZED VIEW NAME');END;
4: How to compile the Invalid Views?
If any views became invalid due to the used tables are dropped and re-create.
For VIEWS
ALTER VIEW INSTANCE_ NAME.VIEWNAME compile;
For MAterialized views
alter Materialized view INSTANCE_ NAME.MV_NAME compile;
5: How to Check the TEMP table space in the instance?
select tablespace_name,block_size from dba_tablespaces where tablespace_name like '%TEMP%';