First check the space on users tablespace
select file_name,tablespace_name,bytes/1024/1024,autoextensible,maxbytes/1024/1024 from dba_data_files where tablespace_name like 'USERS';
if the max size is less increase it. if the tablespace has enough space. then below workaround to check the processs
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++==
select sysdate from dual@snaptm1;
SYSDATE
---------
22-SEP-15
5
select a.db_link, u.username, logged_on, open_cursors, in_transaction, update_sent
from v$dblink a, all_users u where a.owner_id = u.user_id;
select sql_id, count(1)
from gv$active_session_history
where sample_time between to_date('08112018 18:30:00', 'ddmmyyyy hh24:mi:ss')
and to_date('08112018 18:31:00', 'ddmmyyyy hh24:mi:ss')
group by sql_id
order by 2 desc;
3jshc32f6rvs8
select decode(event,null, 'on cpu', event), count(1)
from gv$active_session_history
where sample_time between to_date('08112018 18:30:00', 'ddmmyyyy hh24:mi:ss')
and to_date('08112018 18:30:02', 'ddmmyyyy hh24:mi:ss')
and sql_id = '3jshc32f6rvs8'
group by event
order by 2 desc;
SELECT
sql_id,
process_name,
status
FROM v$sql_monitor
WHERE sql_id = '4jvqnzq5qhztd'
AND status ='DONE (ERROR)'
ORDER BY process_name ;
SELECT
sql_id,
process_name,
status
FROM v$sql_monitor
WHERE sql_id = '40kv65x5g866q'
AND status ='DONE (ERROR)'
ORDER BY process_name ;
select SQL_HANDLE, PLAN_NAME, ACCEPTED
from dba_sql_plan_baselines
where sql_text like 'INSERT INTO DBMON.TABLE_INDEX_SIZE_INFORMATION%';
select t.*
from (select distinct sql_handle
from dba_sql_plan_baselines
where sql_text like 'insert%') pb,
table(dbms_xplan.display_sql_plan_baseline(pb.sql_handle,
null,'basic')) t;
Explain plan
select plan_table_output from
table(dbms_xplan.display_cursor('g86q58b2xw2r9',null,'basic'));
