Hi All,
I am having the below alert getting alerted. Can some help me in finding which user is running this query and what for? After the alert I don't see anything in
v$sql and v$sqlarea. UNDO size is 950 MB and UNDO retention is 900. Any option to diagnose the query from Toad. I don't have much experience using Toad.
I expect increasing UNDO is option but before that I would like to investigate who is running this query.
Any help is appreciated. Thanks.
Alert:
ORA-01555 caused by SQL statement below (SQL ID: xxxxxxx, Query Duration: 369634 sec ..........
select owner,
segment_name,
substr(segment_type,1,2) st,
extents,
bytes,
tablespace_name
from dba_segments
where owner||segment_name in
(
select owner||segment_name from dba_segments
where segment_type not in ('CACHE','ROLLBACK','TEMPORARY')
minus
select owner||segment_name from system.segment_changes
where segment_type not in ('CACHE','ROLLBACK','TEMPORARY')
)
order by tablespace_name, owner, segment_name
Regards
Ranganadh.