quickest way to get info about statistics gathering:
select * from sys.optstat_hist_control$
Posts categoriezed as oracle
how to find pid which spam to alert log
if u dont know who is spamming to alert log there is the way to figure out this
col cnt format a20
col host_id format a20
col message_text format a40
col process_id format a10
select count(*) cnt,host_id,message_text,process_id from X$DBGALERTEXT where message_text like '%Turning off busy%' group by host_id,message_text,process_id;
CNT | HOST_ID | MESSAGE_TEXT | PROCESS_ID
---------- | -------------------- | ---------------------------------------- | ----------
28857 | xxxxxxxxxxxxxxxxxxxx | Turning off busy | 28518
[xxxxxxxxxxxxxxxxxxxx ]# ps -ef | grep 28518 | grep -v "grep"
oracle 28518 1 25 Oct16 ? 10:23:42 ora_fbda_xxxxxx2
and it’s Flasback process =)
ps:oracle 12.1
Oracle, find query witch runs more than &1 sec
with stats as ( select /*+ materialize */ * from ( select parsing_schema_name,t.start#,t.end#,t.sql_id,t.plan_hash_value,t.execs,t.avg_sec,s.sql_text from ( select s.parsing_schema_name,min(begin_interval_time) start#,max(begin_interval_time) end#, sql_id, plan_hash_value, sum(nvl(executions_delta,0)) execs, round ((sum(elapsed_time_delta)/(sum(executions_delta)))/1000000) avg_sec from DBA_HIST_SQLSTAT S, DBA_HIST_SNAPSHOT SS where 1=1 and ss.begin_interval_time > trunc(sysdate-4,'iw') and ss.snap_id = S.snap_id and ss.instance_number = S.instance_number and executions_delta > 0 and (elapsed_time_delta/decode(nvl(executions_delta,0),0,1,executions_delta))/1000000 > &1 group by sql_id, plan_hash_value,parsing_schema_name )t join dba_hist_sqltext s on s.sql_id=t.sql_id order by execs*avg_sec desc ) tt where rownum <= 50 ) select * from stats s where parsing_schema_name not like 'SYS%' and s.sql_text not like '%/* DS_SVC */%' and s.sql_text not like '%_job_proc%' and s.sql_text not like '%SQL Analyze%' and lower(s.sql_text) not like '%dbms_feature%' and s.sql_text not like '%SYS_DBA_SEGS%' and lower(s.sql_text) not like '%v$sys%' and lower(s.sql_text) not like '%dba_audit_trail%' and lower(s.sql_text) not like '%no_index(mytab)%';
oracle12c how-to get detailed info about gather stat job
from oracle 12c it is possible to find out detailed information about gather stats job
in em you may find it at 
or use dbms_stats.report_* to get info
detailed at https://docs.oracle.com/database/121/TGSQL/tgsql_astat.htm#TGSQL95102
I use it this way:
variable mystatsreport clob
declare
begin
:mystatsreport := dbms_stats.report_stats_operations(
since=>SYSTIMESTAMP-3,
until=>SYSTIMESTAMP,
detail_level=>'ALL',
format=>'TEXT');
end;
/
print mystatsreport
variable mystatsreport clob
declare
begin
:mystatsreport := dbms_stats.report_single_stats_operation ( opid => 11898,detail_level => 'TYPICAL', format =>'TEXT' );
end;
/
print mystatsreport
variable mystatsreport clob
declare
begin
:mystatsreport := dbms_stats.report_single_stats_operation ( opid => 11898,detail_level => 'TYPICAL', format =>'TEXT' );
end;
/
print mystatsreport
how to copy schema statistics from prod to dev stand
hello, dev team ask me to look at their stand under load testing and advice how-to improve results. So first thing that I found was statistics locked for last 3 years =)
So fist thing that I have done it’s to copy stats from prod database.
To archive this I’ve done this:
create stats table and export schema stats to it:
exec dbms_stats.create_stat_table ( ownname => 'XXXX' , stattab => 'XXXX_STATS_TABLE' ) ; exec dbms_stats.export_schema_stats ( ownname => 'XXXX' , stattab => 'XXXX_STATS_TABLE') ;
next thing was transfering dump file to destination host:
[oracle@p00XXXXdb01 ~]$ expdp \'/ as sysdba\' tables=XXXX.XXXX_STATS_TABLE directory=temp_dump dumpfile=XXXX_STATS_TABLE.dmp logfile=XXXX_STATS_TABLE.log reuse_dumpfiles=y
on destination (dev stand) host I’ve prepared scripts for lock and unlock statistics:
select distinct(' exec dbms_stats.lock_table_stats(''XXXX'',''' || table_name ||''');' ) from dba_tab_statistics where owner='XXXX' and STATTYPE_LOCKED='ALL' ;
exec dbms_stats.unlock_table_stats('XXXX','BKG_CFG');
exec dbms_stats.unlock_table_stats('XXXX','PSO');
exec dbms_stats.unlock_table_stats('XXXX','OBJ');
exec dbms_stats.unlock_table_stats('XXXX','AUT_PAR');
exec dbms_stats.unlock_table_stats('XXXX','IT_RES');
exec dbms_stats.unlock_table_stats('XXXX','CTY');
exec dbms_stats.unlock_table_stats('XXXX','SRV_PVI');
exec dbms_stats.unlock_table_stats('XXXX','ADR');
exec dbms_stats.unlock_table_stats('XXXX','ACC_AUT_PAR');
exec dbms_stats.unlock_table_stats('XXXX','REG_AUT');
exec dbms_stats.unlock_table_stats('XXXX','CFM_COD');
exec dbms_stats.unlock_table_stats('XXXX','CTT');
exec dbms_stats.unlock_table_stats('XXXX','CTZ_SHP');
exec dbms_stats.unlock_table_stats('XXXX','APV');
exec dbms_stats.unlock_table_stats('XXXX','CRL');
exec dbms_stats.unlock_table_stats('XXXX','AUT');
exec dbms_stats.unlock_table_stats('XXXX','ACC_BKP');
exec dbms_stats.unlock_table_stats('XXXX','ACC_AUT');
exec dbms_stats.unlock_table_stats('XXXX','SAG');
exec dbms_stats.unlock_table_stats('XXXX','OPN_HIS');
exec dbms_stats.unlock_table_stats('XXXX','OBJ_TEC');
exec dbms_stats.unlock_table_stats('XXXX','ACS_TKN');
exec dbms_stats.unlock_table_stats('XXXX','SES_CXT');
exec dbms_stats.unlock_table_stats('XXXX','LGN_BKG');
exec dbms_stats.unlock_table_stats('XXXX','RSP');
exec dbms_stats.unlock_table_stats('XXXX','GRP');
exec dbms_stats.unlock_table_stats('XXXX','ORG');
exec dbms_stats.unlock_table_stats('XXXX','REQ');
exec dbms_stats.unlock_table_stats('XXXX','TAS');
exec dbms_stats.unlock_table_stats('XXXX','ACT_SES');
exec dbms_stats.unlock_table_stats('XXXX','CTT_TEC');
exec dbms_stats.unlock_table_stats('XXXX','ACS_LST');
exec dbms_stats.unlock_table_stats('XXXX','STF_UNT');
exec dbms_stats.unlock_table_stats('XXXX','OPN_HIS_PAR');
exec dbms_stats.unlock_table_stats('XXXX','BKG_LOG');
exec dbms_stats.unlock_table_stats('XXXX','DOC');
exec dbms_stats.unlock_table_stats('XXXX','IT_SYS');
select distinct('exec dbms_stats.unlock_table_stats(''XXXX'',''' || table_name ||''');' ) from dba_tab_statistics where owner='XXXX' and STATTYPE_LOCKED='ALL' ;
exec dbms_stats.lock_table_stats('XXXX','CTT');
exec dbms_stats.lock_table_stats('XXXX','AUT_PAR');
exec dbms_stats.lock_table_stats('XXXX','ACT_SES');
exec dbms_stats.lock_table_stats('XXXX','BKG_LOG');
exec dbms_stats.lock_table_stats('XXXX','TAS');
exec dbms_stats.lock_table_stats('XXXX','CTZ_SHP');
exec dbms_stats.lock_table_stats('XXXX','CTT_TEC');
exec dbms_stats.lock_table_stats('XXXX','REG_AUT');
exec dbms_stats.lock_table_stats('XXXX','ACS_TKN');
exec dbms_stats.lock_table_stats('XXXX','CFM_COD');
exec dbms_stats.lock_table_stats('XXXX','ORG');
exec dbms_stats.lock_table_stats('XXXX','ACS_LST');
exec dbms_stats.lock_table_stats('XXXX','OPN_HIS');
exec dbms_stats.lock_table_stats('XXXX','OBJ');
exec dbms_stats.lock_table_stats('XXXX','REQ');
exec dbms_stats.lock_table_stats('XXXX','AUT');
exec dbms_stats.lock_table_stats('XXXX','ACC_BKP');
exec dbms_stats.lock_table_stats('XXXX','IT_RES');
exec dbms_stats.lock_table_stats('XXXX','CTY');
exec dbms_stats.lock_table_stats('XXXX','GRP');
exec dbms_stats.lock_table_stats('XXXX','SAG');
exec dbms_stats.lock_table_stats('XXXX','ADR');
exec dbms_stats.lock_table_stats('XXXX','RSP');
exec dbms_stats.lock_table_stats('XXXX','STF_UNT');
exec dbms_stats.lock_table_stats('XXXX','OPN_HIS_PAR');
exec dbms_stats.lock_table_stats('XXXX','OBJ_TEC');
exec dbms_stats.lock_table_stats('XXXX','CRL');
exec dbms_stats.lock_table_stats('XXXX','LGN_BKG');
exec dbms_stats.lock_table_stats('XXXX','ACC_AUT_PAR');
exec dbms_stats.lock_table_stats('XXXX','BKG_CFG');
exec dbms_stats.lock_table_stats('XXXX','PSO');
exec dbms_stats.lock_table_stats('XXXX','APV');
exec dbms_stats.lock_table_stats('XXXX','DOC');
exec dbms_stats.lock_table_stats('XXXX','ACC_AUT');
exec dbms_stats.lock_table_stats('XXXX','SRV_PVI');
exec dbms_stats.lock_table_stats('XXXX','SES_CXT');
exec dbms_stats.lock_table_stats('XXXX','IT_SYS');
after unlocking stats run:
[oracle@u00XXXXdb01 ~]$impdp \'/ as sysdba\' directory=dump dumpfile=XXXX_STATS_TABLE.dmp logfile=imp.log
check stats:
14:14:12 (1)[u00XXXX]system@u00XXXX> @table_stats XXXX.acc %
OWNER | TABLE_NAME | NUM_ROWS | BLOCKS | S_LOCK | S_STALE | AVG_SPACE | AVG_ROW_LEN
--------------- | ------------------------------ | ---------- | ---------- | -------------------- | -------------------- | ---------- | -----------
XXXX | ACC | 7189756 | 139407 | ALL | YES | 0 | 129
1 row selected.
Elapsed: 00:00:00.06
OWNER | TABLE_NAME | COLUMN_ID | COLUMN_NAME | DENSITY | NUM_DISTINCT | NUM_NULLS | HISTOGRAM | LAST_ANALYZED
--------------- | ------------------------------ | ---------- | ------------------------------ | ---------- | ------------ | ---------- | --------------- | -------------------
XXXX | ACC | 1 | ID_OBJ | 1.3909E-07 | 7189756 | 0 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 2 | LGN | 1.3862E-07 | 7189756 | 0 | HEIGHT BALANCED | 10.01.2014 22.02.18
XXXX | ACC | 3 | STU | 6.9311E-08 | 2 | 0 | FREQUENCY | 10.01.2014 22.02.18
XXXX | ACC | 4 | SCT_QSN | 2.8562E-06 | 350112 | 348895 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 5 | SCT_ANR | 6.7852E-07 | 1473792 | 350288 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 6 | CRT_ON | 1.3909E-07 | 7189756 | 0 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 7 | UPD_ON | 1.3862E-07 | 7120896 | 0 | HEIGHT BALANCED | 10.01.2014 22.02.18
XXXX | ACC | 8 | DSC | 1 | 1 | 294329 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 9 | SBJ_TYP | 6.9299E-08 | 2 | 0 | FREQUENCY | 10.01.2014 22.02.18
XXXX | ACC | 10 | PSV | 7.2131E-08 | 1 | 294329 | FREQUENCY | 10.01.2014 22.02.18
XXXX | ACC | 11 | OTP_AUT | .5 | 2 | 1643025 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 12 | OTP_MTD | 1 | 1 | 7181747 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 13 | OTP_DVC_ID | .000125203 | 7987 | 7181747 | NONE | 10.01.2014 22.02.18
XXXX | ACC | 14 | NO_PWD | 1 | 1 | 7187683 | NONE | 10.01.2014 22.02.18
14 rows selected.
Elapsed: 00:00:00.93
OWNER | TABLE_NAME | EXTENSION_NAME | EXTENSION | CREATO | DRO
--------------- | ------------------------------ | ----------------------------------- | ------------------------------------------------------------------------------------------ | ------ | ---
XXXX | ACC | SYS_NC00017$ | (UPPER("LGN")) | SYSTEM | NO
import stats ^
14:42:48 (1)[u00XXXX]system@u00XXXX> EXEC DBMS_STATS.import_schema_stats ('XXXX','XXXX_STATS_TABLE',null,'XXXX');
check results:
14:51:41 (1)[u00XXXX]system@u00XXXX> @table_stats XXXX.acc %
OWNER | TABLE_NAME | NUM_ROWS | BLOCKS | S_LOCK | S_STALE | AVG_SPACE | AVG_ROW_LEN
--------------- | ------------------------------ | ---------- | ---------- | -------------------- | -------------------- | ---------- | -----------
XXXX | ACC | 48444484 | 518959 | <NULL> | NO | 0 | 86
1 row selected.
Elapsed: 00:00:00.12
OWNER | TABLE_NAME | COLUMN_ID | COLUMN_NAME | DENSITY | NUM_DISTINCT | NUM_NULLS | HISTOGRAM | LAST_ANALYZED
--------------- | ------------------------------ | ---------- | ------------------------------ | ---------- | ------------ | ---------- | --------------- | -------------------
XXXX | ACC | 1 | ID_OBJ | 2.0642E-08 | 48444484 | 0 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 2 | LGN | 0 | 48444484 | 0 | HYBRID | 27.05.2017 13.01.50
XXXX | ACC | 3 | STU | 1.0321E-08 | 3 | 0 | FREQUENCY | 27.05.2017 13.01.50
XXXX | ACC | 4 | SCT_QSN | 5.9769E-06 | 167312 | 47750066 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 5 | SCT_ANR | 3.6648E-06 | 272864 | 47750066 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 6 | CRT_ON | 2.0642E-08 | 48444484 | 0 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 7 | UPD_ON | 0 | 47513600 | 0 | HYBRID | 27.05.2017 13.01.50
XXXX | ACC | 8 | DSC | 1 | 1 | 48413684 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 9 | SBJ_TYP | 1.0321E-08 | 2 | 0 | FREQUENCY | 27.05.2017 13.01.50
XXXX | ACC | 10 | PSV | 1 | 1 | 48413684 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 11 | OTP_AUT | .5 | 2 | 0 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 12 | OTP_MTD | 1 | 1 | 8911005 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 13 | OTP_DVC_ID | 2.6103E-08 | 38309888 | 8911005 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 14 | NO_PWD | 1 | 1 | 48441875 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 15 | LOGIN_BY_DS_ALLOWED | .5 | 2 | 47807130 | NONE | 27.05.2017 13.01.50
XXXX | ACC | 16 | FRST_LGN | 1 | 1 | 47951901 | NONE | 27.05.2017 13.01.50
XXXX | <NULL> | <NULL> | SYS_NC00017$ | 2.0642E-08 | 48444484 | 0 | NONE | 27.05.2017 13.01.50
17 rows selected.
Elapsed: 00:00:01.35
OWNER | TABLE_NAME | EXTENSION_NAME | EXTENSION | CREATO | DRO
--------------- | ------------------------------ | ----------------------------------- | ------------------------------------------------------------------------------------------ | ------ | ---
XXXX | ACC | SYS_NC00017$ | (UPPER("LGN")) | SYSTEM | NO
and lock stats using scripts we generate before
How-to restore dropped flashback archive or dropped table
Hello, it’s happened that my college instead of disassociating flashback archive disabled it ( so all archive was lost ) and I had to restore it, here is what I have done to fix it:
1) restore controlfile:
SET DBID xxxxxxxx
run {
allocate channel t1 DEVICE TYPE 'SBT_TAPE' PARMS='ENV=(NB_ORA_POLICY=Oracle-DB-xxxx2,NB_ORA_SERV=xxxxxx.xxxx.local,NB_ORA_CLIENT=xxxxx.00.xxxx.local)';
restore controlfile from autobackup;
}
2) find out tablespaces that must be restored:
select distinct tablespace_name from dba_segments where owner in ('SYS', 'SYSTEM');
SYSAUX
UNDOTBS1
USERS
SYSTEM
UNDOTBS2
3) some fixes
SQL> alter database flashback off; SQL> alter database disable BLOCK CHANGE TRACKING;
4) Generate restore list ( list of tablespaces with flashback archives )
select listagg (name,',') WITHIN GROUP (order by name) from v$tablespace where name like '%ARCH%' or name in ('SYSAUX','UNDOTBS1','USERS','SYSTEM','UNDOTBS2','SLOW_FRA');
xxxx_ARCH,xxxx_ARCH_02,xxxx_ARCH_03,xxxx_ARCH_04_BIG,xxxx_ARCH_05,xxxx_ARCH_EMERGENCY,SYSAUX,SYSTEM,UNDOTBS1,UNDOTBS2,USERS
5)Generate skip list
select listagg (name,',') WITHIN GROUP (order by name) from v$tablespace where name not like 'PRE_DM_%' and name not in ( 'xxxx_ARCH','xxxx_ARCH_02','xxxx_ARCH_03','xxxx_ARCH_04_BIG','xxxx_ARCH_05','xxxx_ARCH_EMERGENCY','SYSAUX','SYSTEM','UNDOTBS1','UNDOTBS2','USERS'); AUD_EVT_01,AUD_EVT_02,AUD_EVT_03,AUD_EVT_04,AUD_EVT_05,AUD_EVT_06,EGS_DB,EGS_SIA_DB,xxxx,xxxx_ADM,xxxx_CPP,xxxx_PDS,xxxx_SUPPORT,xxxx_TECH,xxxx_TEMP,SIA_DB,SIA_TEMP,SLOW_DATA,SLOW_FDA,TEMP
6) rman script look that way
run {
allocate channel t1 DEVICE TYPE 'SBT_TAPE' PARMS='ENV=(NB_ORA_POLICY=Oracle-DB-xxxx2,NB_ORA_SERV=xxxxxx.xxx.local,NB_ORA_CLIENT=xxxxxx.xx.local)';
allocate channel t2 DEVICE TYPE 'SBT_TAPE' PARMS='ENV=(NB_ORA_POLICY=Oracle-DB-xxxx2,NB_ORA_SERV=xxxxx.xxx.local,NB_ORA_CLIENT=xxxxx.xx.local)';
allocate channel t3 DEVICE TYPE 'SBT_TAPE' PARMS='ENV=(NB_ORA_POLICY=Oracle-DB-xxxx2,NB_ORA_SERV=xxxxx.xxx.local,NB_ORA_CLIENT=xxxxx.xx.local)';
allocate channel t4 DEVICE TYPE 'SBT_TAPE' PARMS='ENV=(NB_ORA_POLICY=Oracle-DB-xxxx2,NB_ORA_SERV=xxxxx.xxx.local,NB_ORA_CLIENT=xxxx.xx.local)';
set until scn 1142308665621;
set newname for datafile 39 to '+DATA';
restore tablespace xxxx_ARCH,xxxx_ARCH_02,xxxx_ARCH_03,xxxx_ARCH_04_BIG,xxxx_ARCH_05,xxxx_ARCH_EMERGENCY,SYSAUX,SYSTEM,UNDOTBS1,UNDOTBS2,USERS,SLOW_FDA;
switch datafile all;
recover database skip forever tablespace AUD_EVT_01,AUD_EVT_02,AUD_EVT_03,AUD_EVT_04,AUD_EVT_05,AUD_EVT_06,xxx_DB,xxx_xxxxx_DB,xxxx,xxxx_ADM,xxxx_CPP,xxxx_PDS,xxxx_SUPPORT,xxxx_TECH,xxxx_TEMP,xxx_DB,xxx_TEMP,SLOW_DATA;
}
7) alter database backup controlfile to trace as ‘/home/oracle/control.ctl’;
then I’ve removed all non restored datafiles and got this script:
controlfile
CREATE CONTROLFILE REUSE DATABASE “P00xxxx” RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 37376
LOGFILE
GROUP 1 ‘+DATA/s00xxxx/onlinelog/group_1.263.857911649’ SIZE 500M BLOCKSIZE 512,
GROUP 2 ‘+DATA/s00xxxx/onlinelog/group_2.256.857911657’ SIZE 500M BLOCKSIZE 512,
GROUP 3 ‘+DATA/s00xxxx/onlinelog/group_3.265.857911663’ SIZE 500M BLOCKSIZE 512,
GROUP 4 ‘+DATA/s00xxxx/onlinelog/group_4.284.857911669’ SIZE 500M BLOCKSIZE 512,
GROUP 5 ‘+DATA/s00xxxx/onlinelog/group_5.283.857911675’ SIZE 500M BLOCKSIZE 512
— STANDBY LOGFILE
— GROUP 101 ‘+DATA/S00xxxx/ONLINELOG/group_101.267.936536737’ SIZE 500M BLOCKSIZE 512,
— GROUP 102 ‘+DATA/s00xxxx/onlinelog/group_102.293.851280253’ SIZE 500M BLOCKSIZE 512,
— GROUP 103 ‘+DATA/s00xxxx/onlinelog/group_103.294.851280265’ SIZE 500M BLOCKSIZE 512,
— GROUP 104 ‘+DATA/s00xxxx/onlinelog/group_104.295.851280275’ SIZE 500M BLOCKSIZE 512,
— GROUP 105 ‘+DATA/s00xxxx/onlinelog/group_105.296.851280285’ SIZE 500M BLOCKSIZE 512,
— GROUP 106 ‘+DATA/s00xxxx/onlinelog/group_106.277.867109841’ SIZE 500M BLOCKSIZE 512
DATAFILE
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.259.936581479’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.262.936580465’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.263.936580465’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.264.936580465’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.288.936583713’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.289.936583745’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch.306.936581753’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_02.278.936583949’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_02.293.936583947’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_02.294.936583949’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_03.302.936582809’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_03.304.936581961’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_04_big.276.936584015’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_05.305.936581923’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_emergency.277.936584001’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_emergency.291.936583867’,
‘+DATA/S00xxxx/DATAFILE/xxxx_arch_emergency.292.936583931’,
‘+DATA/S00xxxx/DATAFILE/slow_fda.298.936582809’,
‘+DATA/S00xxxx/DATAFILE/sysaux.258.936581503’,
‘+DATA/S00xxxx/DATAFILE/system.290.936583843’,
‘+DATA/S00xxxx/DATAFILE/undotbs1.261.936581223’,
‘+DATA/S00xxxx/DATAFILE/undotbs1.299.936582325’,
‘+DATA/S00xxxx/DATAFILE/undotbs1.312.936583685’,
‘+DATA/S00xxxx/DATAFILE/undotbs2.260.936581325’,
‘+DATA/S00xxxx/DATAFILE/undotbs2.310.936582849’,
‘+DATA/S00xxxx/DATAFILE/undotbs2.311.936582849’,
‘+DATA/S00xxxx/DATAFILE/users.287.936583685’
CHARACTER SET AL32UTF8
;
[свернуть]
ALTER TABLESPACE TEMP ADD TEMPFILE ;
ALTER TABLESPACE SIA_TEMP ADD TEMPFILE ;
ALTER TABLESPACE xxxx_TEMP ADD TEMPFILE ;
8) after that database is opened and query work like a charm:
create table xxxx.reg_ctx_flashback tablespace xxxx_fbda parallel (degree 4) unrecoverable as select * from xxxx.SYS_FBA_HIST_112683; SQL> select /*+ parallel 4*/ count (*) from xxxx.SYS_FBA_HIST_112683; COUNT(*) ---------- 84774720
9) CTAS all flashback data and export it, then move to target host:
SQL> create table xxxx.reg_ctx_flashback tablespace xxxx parallel (degree 4) unrecoverable as select * from xxxx.SYS_FBA_HIST_112683;
expdp \'/ as sysdba\' directory=dump dumpfile=reg_cxt_fbda.dmp logfile=DROP_ME:export.log tables=xxxx.reg_ctx_flashback;
10) restore flashback
alter table xxxx.reg_cxt FLASHBACK ARCHIVE xxxx_ARCH_FL;
BEGIN
DBMS_FLASHBACK_ARCHIVE.import_history (
owner_name1 => 'xxxx',
table_name1 => 'REG_CXT',
temp_history_name => 'REG_CTX_FLASHBACK',
options => DBMS_FLASHBACK_ARCHIVE.NODELETE); END;
/
ORA-25152: TEMPFILE cannot be dropped at this time
hello, here how I dropped tempfile :
start with:
ALTER TABLESPACE temp DROP TEMPFILE '+DATADG/p00pgp/tempfile/temp.340.882540285'; ALTER TABLESPACE temp DROP TEMPFILE '+DATADG/p00pgp/tempfile/temp.339.882540283';
but when I try to drop datafiles I’ve got this error:
ORA-25152: TEMPFILE cannot be dropped at this time
helped this sript
SELECT b.TABLESPACE
, b.segfile#
, b.segblk#
, ROUND ( ( ( b.blocks * p.VALUE ) / 1024 / 1024 ), 2 ) size_mb
, a.SID
, a.serial#
, a.username
, a.osuser
, a.program
, a.status
FROM v$session a
, v$sort_usage b
, v$process c
, v$parameter p
WHERE p.NAME = 'db_block_size'
AND a.saddr = b.session_addr
AND a.paddr = c.addr
and b.segfile# in ( 205,206)
ORDER BY b.TABLESPACE
, b.segfile#
, b.segblk#
, b.blocks;
which helped me to find sessions using tempfile
sessions was idle, so I kill them, after that this command have no errors:
ALTER DATABASE TEMPFILE '+DATADG/p00pgp/tempfile/temp.339.882540283' DROP INCLUDING DATAFILES; ALTER DATABASE TEMPFILE '+DATADG/p00pgp/tempfile/temp.340.882540285' DROP INCLUDING DATAFILES;
how to get ash report from sqlplus
Select *
from table(dbms_workload_repository.ASH_report_html(
l_dbid => 2316837477,
l_inst_num => 1,
l_btime => TIMESTAMP'2016-11-14 14:36:00' ,
l_etime => TIMESTAMP'2016-11-14 14:41:00' ,
l_options => 0,
l_slot_width => 0,
l_sid => null,
l_sql_id => null,
l_wait_class => null,
l_service_hash => null,
l_module => null,
l_action => null,
l_client_id => null,
l_plsql_entry => null))
;
script to find locks in awr
select cast(min (ash.SAMPLE_TIME) as date) as start#
,round (24*60*(cast (max(ash.SAMPLE_TIME) as date) - cast(min (ash.SAMPLE_TIME) as date) ),2) as duration#
,ash.sql_id,ash.top_level_sql_id,ash.BLOCKING_SESSION as B_SID,ash.BLOCKING_SESSION_SERIAL# as b_serial#
,ash2.SQL_EXEC_ID b_sql_exec_id
,ash.event,do.object_name
,sum(decode(ash.session_state,'ON CPU',1,0)) "CPU"
,sum(decode(ash.session_state,'WAITING',1,0)) - sum(decode(ash.session_state,'WAITING', decode(ash.wait_class, 'User I/O',1,0),0)) "WAIT"
,sum(decode(ash.session_state,'WAITING', decode(ash.wait_class, 'User I/O',1,0),0)) "IO"
,sum(decode(ash.session_state,'ON CPU',1,1)) "TOTAL"
,du.username,ash2.SQL_EXEC_ID,
dp.owner||nvl2(dp.object_name,'.'||dp.object_name,null) ||nvl2(dp.procedure_name,'.'||dp.procedure_name,null) as pl_sql_obj
,ash2.machine as blocking_machine
from dba_hist_active_sess_history ash
left join dba_objects do on do.object_id=ash.CURRENT_OBJ#
join dba_hist_active_sess_history ash2 on ash.BLOCKING_SESSION=ash2.session_id and ash.BLOCKING_SESSION_SERIAL#=ash2.session_serial# and ash.SNAP_ID=ash2.SNAP_ID
join dba_users du on du.USER_ID=ash2.USER_ID
left join dba_procedures dp on dp.object_id=ash2.PLSQL_ENTRY_OBJECT_ID and dp.subprogram_id=ash.PLSQL_ENTRY_SUBPROGRAM_ID
where ash.SQL_ID is not NULL
and ash.SAMPLE_TIME > trunc(sysdate)
group by ash.SQL_EXEC_ID,ash2.SQL_EXEC_ID, ash2.machine, ash.session_id,ash.session_serial#,ash.event,ash.sql_id,ash.top_level_sql_id,ash.BLOCKING_SESSION,ash.BLOCKING_SESSION_SERIAL#, ash2.sql_id ,du.username,
dp.owner||nvl2(dp.object_name,'.'||dp.object_name,null) ||nvl2(dp.procedure_name,'.'||dp.procedure_name,null)
,do.object_name
having sum(decode(ash.session_state,'WAITING',1,0)) - sum(decode(ash.session_state,'WAITING', decode(ash.wait_class, 'User I/O',1,0),0)) >0
and max(ash.SAMPLE_TIME) - min (ash.SAMPLE_TIME) > interval '3' minute
order by 1,ash2.sql_exec_id;
result
START# | DURATION# | SQL_ID | TOP_LEVEL_SQL | B_SID | B_SERIAL# | B_SQL_EXEC_ID | EVENT | OBJECT_NAME | CPU | WAIT | IO | TOTAL | USERNAME | PL_SQL_OBJ | BLOCKING_MACHINE ------------------------- | ---------- | ------------- | ------------- | ---------- | ---------- | ------------- | ------------------------------ | -------------------- | ---------- | ---------- | ---------- | ---------- | ---------- | ---------- | -------------------------- 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 21 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1832 | 38589 | 16777230 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 15876 | 0 | 15876 | EOS | <NULL> | xxxxxxxapp11.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777232 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2500 | 0 | 2500 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777232 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2500 | 0 | 2500 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777263 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777263 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777483 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777483 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777991 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16777991 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16778307 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16778307 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16779789 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 08.34.21 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 955 | 30987 | 16779789 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 50 | 0 | 50 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 1638 | 0 | 1638 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 1638 | 0 | 1638 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 1638 | 0 | 1638 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777326 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777326 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777326 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16779119 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16779119 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16779119 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16780460 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16780460 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.33 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16780460 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 26 | 0 | 26 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.40 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 1575 | 0 | 1575 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.40 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16777326 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.40 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16779119 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.40.40 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1520 | 40745 | 16780460 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp10.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | 16777216 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | 16777282 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3150 | 0 | 3150 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | 16780480 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | 16780498 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | 25502663 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | 28318376 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 09.51.05 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 9 | 28281 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 10.04.18 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 448 | 52711 | 16777231 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.04.18 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 448 | 52711 | 16777298 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 1444 | 0 | 1444 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16777300 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 650 | 0 | 650 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16777300 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 650 | 0 | 650 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16777311 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16777311 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16777313 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16777313 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16779344 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16779344 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16782095 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16782095 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 448 | 52711 | 16782272 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16794081 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | 16794081 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.04.18 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1019 | 6185 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp09.xxxx.local 24.11.2015 10.10.39 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 766 | 15691 | 16777299 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2812 | 0 | 2812 | EOS | <NULL> | xxxxxxxapp11.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777322 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2331 | 0 | 2331 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777322 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2331 | 0 | 2331 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777322 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2331 | 0 | 2331 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777322 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2331 | 0 | 2331 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16779690 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16779690 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16779690 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16779690 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16781164 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16781164 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16781164 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16781164 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 74 | 0 | 74 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 74 | 0 | 74 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 74 | 0 | 74 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.34 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 74 | 0 | 74 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.39 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777279 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.39 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16777322 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2394 | 0 | 2394 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.39 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16779690 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.39 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | 16781164 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.38.39 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1074 | 21737 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 76 | 0 | 76 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 10.44.45 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1902 | 33545 | 16777324 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3800 | 0 | 3800 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.44.45 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1902 | 33545 | 16777324 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3800 | 0 | 3800 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.44.45 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1902 | 33545 | 16779227 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.44.45 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1902 | 33545 | 16779227 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.44.45 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1902 | 33545 | 16782940 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.44.45 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1902 | 33545 | 16782940 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 38 | 0 | 38 | EOS | <NULL> | xxxxxxxapp07.xxxx.local 24.11.2015 10.45.00 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1705 | 47971 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 49 | 0 | 49 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 10.45.00 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1705 | 47971 | 16777323 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 5537 | 0 | 5537 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 10.45.00 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1705 | 47971 | 16778606 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 49 | 0 | 49 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 10.45.00 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1705 | 47971 | 16779700 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 49 | 0 | 49 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 10.45.00 | 8 | by5pctpk8t9f6 | by5pctpk8t9f6 | 1705 | 47971 | 16781227 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 49 | 0 | 49 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 11.10.40 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2846 | 53187 | 16777344 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2812 | 0 | 2812 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 11.10.40 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2846 | 53187 | 16777723 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 11.10.40 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2846 | 53187 | 16778841 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 11.10.40 | 6 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2846 | 53187 | <NULL> | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 37 | 0 | 37 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 11.19.02 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2521 | 48929 | 16777348 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 2850 | 0 | 2850 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 11.19.02 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2521 | 48929 | 16777366 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 11.19.02 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2521 | 48929 | 16781519 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp04.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777226 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777226 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777226 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777226 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777364 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3969 | 0 | 3969 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777364 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3969 | 0 | 3969 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777364 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3969 | 0 | 3969 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777364 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3969 | 0 | 3969 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16779386 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16779386 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16779386 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.14 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16779386 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.18 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777221 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.18 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777226 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.18 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16777364 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3969 | 0 | 3969 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.34.18 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 10 | 3747 | 16779386 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp01.xxxx.local 24.11.2015 11.51.07 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2905 | 49181 | 33554433 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 11.51.07 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2905 | 49181 | 33554434 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 11.51.07 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2905 | 49181 | 33554435 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 25 | 0 | 25 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 11.51.07 | 4 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2905 | 49181 | 33554443 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3150 | 0 | 3150 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16777277 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16777308 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16777384 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 3969 | 0 | 3969 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16777431 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16780048 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16782367 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.04.20 | 10 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2147 | 47127 | 16813229 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 63 | 0 | 63 | EOS | <NULL> | xxxxxxxapp03.xxxx.local 24.11.2015 12.06.20 | 17 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2533 | 57525 | 16777257 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 101 | 0 | 101 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 12.06.20 | 17 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2533 | 57525 | 16777260 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 101 | 0 | 101 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 12.06.20 | 17 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2533 | 57525 | 16777390 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 11413 | 0 | 11413 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 12.06.20 | 17 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2533 | 57525 | 16778344 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 101 | 0 | 101 | EOS | <NULL> | xxxxxxxapp06.xxxx.local 24.11.2015 12.06.20 | 17 | by5pctpk8t9f6 | by5pctpk8t9f6 | 2533 | 57525 | 16779246 | enq: TX - row lock contention | FDC_ROSIM_TICKETS | 0 | 101 | 0 | 101 | EOS | <NULL> | xxxxxxxapp06.xxxx.local