Skip to content

how to find pid which spam to alert log

how to find pid which spam to alert log published on Комментариев к записи 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

Oracle, find query witch runs more than &1 sec published on Комментариев к записи 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

oracle12c how-to get detailed info about gather stat job published on Комментариев к записи 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

how to copy schema statistics from prod to dev stand published on Комментариев к записи 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

How-to restore dropped flashback archive or dropped table published on Комментариев к записи 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

ORA-25152: TEMPFILE cannot be dropped at this time published on Комментариев к записи 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

how to get ash report from sqlplus published on Комментариев к записи 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

script to find locks in awr published on 1 комментарий к записи 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

Primary Sidebar

Яндекс.Метрика