postgres=#
SELECT COUNT(1) AS session_count,
SUM( CASE WHEN state = 'active' THEN 1 ELSE 0 END) AS active,
SUM( CASE WHEN state LIKE 'idle in%' THEN 1 ELSE 0 END) AS idle_in_transaction,
SUM( CASE WHEN now()-query_start > INTERVAL '1s' AND state = 'active' THEN 1 ELSE 0 END) AS slow_query_1s,
SUM( CASE WHEN now()-query_start > INTERVAL '600s' AND state = 'active' THEN 1 ELSE 0 END) AS slow_query_600s,
SUM(waiting::INT) AS waiting_query,
CASE pg_is_in_recovery() WHEN true THEN 1 ELSE 0 END AS is_in_recovery,
CASE pg_is_in_recovery() WHEN true THEN extract(epoch FROM now() - COALESCE(pg_last_xact_replay_timestamp(),now())) ELSE 0 END AS replication_delay
FROM pg_stat_activity ;
session_count | active | idle_in_transaction | slow_query_1s | slow_query_600s | waiting_query | is_in_recovery | replication_delay
---------------+--------+---------------------+---------------+-----------------+---------------+----------------+-------------------
177 | 3 | 0 | 2 | 1 | 0 | 0 | 0
Posts authored by Bushmelev Anton
enable Oracle Label Security
Oracle Database 12c: Security 13 – 3
Enabling and Managing OLS
•Register and enable OLS:
– Using DBCA or
– Executing the LBACSYS.CONFIGURE_OLS and LBACSYS.OLS_ENFORCEMENT.ENABLE_OLS procedures
•The The LBACSYS schema owns all OLS objects.
•Use Enterprise Manager Cloud Control (EMCC) SQL*Plus to manage the Label Security policies.
•In PDBs, which canhttp://bushmelev-aa.ru/wp-admin/edit-tags.php?taxonomy=post_tag be plugged in and out of CDBs:
– Manage OLS components on a subset of PDBs in a CDB:
— Policies (no policies in the root)
— Data labels
— User authorizations
– The LBACSYS schema is a common user schema.
– LBACSYS objects are automatically available to any PDB.
OLS: Features
OLS provides:
• Row-level security based on Virtual Private Database (VPD) technology
– All required packages for access mediation
– Complete data dictionary for managing OLS components
•A complete infrastructure for managing label security policies, sensitivity labels, and user security clearances
• Enterprise Manager pages containing a graphical user interface for managing OLS
• Integration with Oracle Identity Management starting Oracle Database 10g Release 1
OLS is built on the fine-grained access control technology of VPD. The major advantage of using OLS is that OLS is a complete system. It is a ready-to-use VPD. OLS provides sophisticated functions and procedures for evaluating and comparing sensitivity labels. It provides a sophisticated infrastructure for storing and managing sensitivity labels and user security clearances.
SELECT status FROM DBA_OLS_STATUS WHERE name = 'OLS_CONFIGURE_STATUS'; 22:34:47 (1)[PDB1]c##bushmelev_aa@p00db1> SELECT status FROM DBA_OLS_STATUS WHERE name = 'OLS_CONFIGURE_STATUS'; STATUS ------ FALSE
Register OLS.
22:39:02 (1)[PDB1]sys@p00db1> EXEC LBACSYS.CONFIGURE_OLS PL/SQL procedure successfully completed. 22:39:06 (1)[PDB1]sys@p00db1> SELECT status FROM DBA_OLS_STATUS WHERE name = 'OLS_CONFIGURE_STATUS'; STATU ----- TRUE
Check whether OLS is enabled.
22:40:33 (1)[PDB1]sys@p00db1> SELECT value FROM V$OPTION WHERE parameter = 'Oracle Label Security'; VALUE ---------------------------------------------------------------- FALSE
Enable OLS
22:48:46 (1)[PDB1]sys@p00db1> EXEC LBACSYS.OLS_ENFORCEMENT.ENABLE_OLS; PL/SQL procedure successfully completed. Elapsed: 00:00:00.53 22:49:45 (1)[PDB1]sys@p00db1> SELECT value FROM V$OPTION WHERE parameter = 'Oracle Label Security'; VALUE ---------------------------------------------------------------- TRUE
ps: Registration and enabling execute at the container level.
pps:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Automatic Storage Management, Oracle Label Security, OLAP,
Advanced Analytics, Real Application Testing and Unified Auditing options
Implementing an OLS Solution
check OLS:
http://www.oracle.com/technetwork/articles/idm/ls-093349.html
create user myco_emp identified by 1; create user myco_mgr identified by 1; create user myco_planning identified by 1; GRANT CREATE SESSION to MYCO_EMP ; GRANT CREATE SESSION to MYCO_MGR; GRANT CREATE SESSION to MYCO_PLANNING ; grant select on hr.job_history to MYCO_PLANNING; grant select on hr.job_history to MYCO_emp; grant select on hr.job_history to MYCO_mgr; GRANT SELECT ON hr.LOCATIONS TO MYCO_EMP; GRANT SELECT ON hr.LOCATIONS TO MYCO_mgr; GRANT SELECT ON hr.LOCATIONS TO MYCO_PLANNING; GRANT SELECT, INSERT, UPDATE, DELETE ON HR.LOCATIONS TO MYCO_PLANNING;
connect as sysdba or unlock LBACSYS and connect by it
-- ****************************************************
-- Creating FACILITY Policy
-- ****************************************************
BEGIN
SA_SYSDBA.CREATE_POLICY('FACILITY','FACLAB',
'READ_CONTROL,CHECK_CONTROL,LABEL_DEFAULT,HIDE');
END;
/
-- ****************************************************
-- Adding sensitivity levels to FACILITY policy:
-- ****************************************************
BEGIN
SA_COMPONENTS.CREATE_LEVEL('FACILITY', 1000,'P','PUBLIC');
SA_COMPONENTS.CREATE_LEVEL('FACILITY',2000,'S','SENSITIVE');
SA_COMPONENTS.CREATE_LEVEL('FACILITY',3000,'HS','HIGHLY_SENSITIVE');
END;
/
-- ****************************************************
-- Adding groups to FACILITY policy:
-- ****************************************************
BEGIN
SA_COMPONENTS.CREATE_GROUP('FACILITY', 1000,'Global','Global');
SA_COMPONENTS.CREATE_GROUP('FACILITY',101,'US','United States','GLOBAL');
SA_COMPONENTS.CREATE_GROUP('FACILITY',102,'EU','Europe','GLOBAL');
SA_COMPONENTS.CREATE_GROUP('FACILITY',103,'Asia','Asia','GLOBAL');
END;
/
-- ****************************************************
-- Creating Labels for FACILITY policy
-- ****************************************************
EXECUTE SA_LABEL_ADMIN.CREATE_LABEL('FACILITY', 1000,'P');
EXECUTE SA_LABEL_ADMIN.CREATE_LABEL('FACILITY',2101,'S::US');
EXECUTE SA_LABEL_ADMIN.CREATE_LABEL('FACILITY',3101,'HS::US');
EXECUTE SA_LABEL_ADMIN.CREATE_LABEL('FACILITY', 2103,'S::ASIA');
EXECUTE SA_LABEL_ADMIN.CREATE_LABEL('FACILITY',3103,'HS::ASIA');
-- **************************************************
-- Setting MYCO_EMP user label authorizations
-- Setting MYCO_MGR user label authorizations
-- Setting MYCO_PLANNING user label authorizations
-- **************************************************
exec SA_USER_ADMIN.SET_USER_LABELS ('PRIVACY', 'MYCO_MGR','C');
exec SA_USER_ADMIN.SET_USER_LABELS ('FACILITY','MYCO_EMP','P');
exec SA_USER_ADMIN.SET_USER_LABELS ('FACILITY','MYCO_MGR','S::US,EU,ASIA');
exec SA_USER_ADMIN.SET_USER_LABELS ('FACILITY','MYCO_PLANNING','HS::GLOBAL');
-- Applying FACILITY policy to hr.locations table.
-- *************************************************
Begin
sa_policy_admin.apply_table_policy (
POLICY_NAME => 'FACILITY',
SCHEMA_NAME => 'HR',
TABLE_NAME => 'LOCATIONS',
TABLE_OPTIONS => NULL,
LABEL_FUNCTION => NULL);
END;
/
-- ****************************************************
-- Update Labels for Sites In ASIA
-- ****************************************************
update hr.locations set faclab = char_to_label('FACILITY','S::ASIA') where upper(city) in ('BEIJING','TOKYO','SINGAPORE');
-- ****************************************************
-- Update Labels for Sites In US
-- ****************************************************
update hr.locations set faclab = char_to_label('FACILITY','HS::US') where upper(city) in ('SOUTH SAN FRANCISCO');
-- ****************************************************
-- Update Labels for all remaining locations
-- ****************************************************
update hr.locations set faclab = char_to_label('FACILITY','P') where faclab is NULL;
commit;
where upper(city) in ('BEIJING','TOKYO','SINGAPORE');
-- ****************************************************
-- SETTING LABELS FOR PRIVACY POLICY
-- ****************************************************
connect hr/oracle_4U@localhost:1521/pdb1
last piece of code failed with error :
update hr.job_history set privlab = char_to_label('PRIVACY','S') where ((to_char(sysdate,'YYYY') - to_char(end_date,'YYYY')) > 10);
update hr.job_history set privlab = char_to_label('PRIVACY','C') where ((to_char(sysdate,'YYYY')- to_char(end_date,'YYYY')) <= 10);
now lets check emp:
01:13:40 not connected> select l.*,label_to_char(faclab) label from hr.locations l;
LOCATION_ID | STREET_ADDRESS | POSTAL_CODE | CITY | STATE_PROVINCE | CO | LABEL
----------- | ---------------------------------------- | ------------ | ------------------------------ | ------------------------- | -- | ----------
1000 | 1297 Via Cola di Rie | 00989 | Roma | <NULL> | IT | P
1100 | 93091 Calle della Testa | 10934 | Venice | <NULL> | IT | P
1300 | 9450 Kamiya-cho | 6823 | Hiroshima | <NULL> | JP | P
1400 | 2014 Jabberwocky Rd | 26192 | Southlake | Texas | US | P
1600 | 2007 Zagora St | 50090 | South Brunswick | New Jersey | US | P
1700 | 2004 Charade Rd | 98199 | Seattle | Washington | US | P
1800 | 147 Spadina Ave | M5V 2L7 | Toronto | Ontario | CA | P
1900 | 6092 Boxwood St | YSW 9T2 | Whitehorse | Yukon | CA | P
2100 | 1298 Vileparle (E) | 490231 | Bombay | Maharashtra | IN | P
2200 | 12-98 Victoria Street | 2901 | Sydney | New South Wales | AU | P
2400 | 8204 Arthur St | <NULL> | London | <NULL> | UK | P
2500 | Magdalen Centre, The Oxford Science Park | OX9 9ZB | Oxford | Oxford | UK | P
2600 | 9702 Chester Road | 09629850293 | Stretford | Manchester | UK | P
2700 | Schwanthalerstr. 7031 | 80925 | Munich | Bavaria | DE | P
2800 | Rua Frei Caneca 1360 | 01307-002 | Sao Paulo | Sao Paulo | BR | P
2900 | 20 Rue des Corps-Saints | 1730 | Geneva | Geneve | CH | P
3000 | Murtenstrasse 921 | 3095 | Bern | BE | CH | P
3100 | Pieter Breughelstraat 837 | 3029SK | Utrecht | Utrecht | NL | P
3200 | Mariano Escobedo 9991 | 11932 | Mexico City | Distrito Federal, | MX | P
19 rows selected.
01:13:42 not connected> sho user
USER is "MYCO_EMP"
check mgr
01:16:10 not connected> sho user
USER is "MYCO_MGR"
01:16:12 not connected> select l.*,label_to_char(faclab) label from hr.locations l;
LOCATION_ID | STREET_ADDRESS | POSTAL_CODE | CITY | STATE_PROVINCE | CO | LABEL
----------- | ---------------------------------------- | ------------ | ------------------------------ | ------------------------- | -- | ----------
1000 | 1297 Via Cola di Rie | 00989 | Roma | <NULL> | IT | P
1100 | 93091 Calle della Testa | 10934 | Venice | <NULL> | IT | P
1200 | 2017 Shinjuku-ku | 1689 | Tokyo | Tokyo Prefecture | JP | S::ASIA
1300 | 9450 Kamiya-cho | 6823 | Hiroshima | <NULL> | JP | P
1400 | 2014 Jabberwocky Rd | 26192 | Southlake | Texas | US | P
1600 | 2007 Zagora St | 50090 | South Brunswick | New Jersey | US | P
1700 | 2004 Charade Rd | 98199 | Seattle | Washington | US | P
1800 | 147 Spadina Ave | M5V 2L7 | Toronto | Ontario | CA | P
1900 | 6092 Boxwood St | YSW 9T2 | Whitehorse | Yukon | CA | P
2000 | 40-5-12 Laogianggen | 190518 | Beijing | <NULL> | CN | S::ASIA
2100 | 1298 Vileparle (E) | 490231 | Bombay | Maharashtra | IN | P
2200 | 12-98 Victoria Street | 2901 | Sydney | New South Wales | AU | P
2300 | 198 Clementi North | 540198 | Singapore | <NULL> | SG | S::ASIA
2400 | 8204 Arthur St | <NULL> | London | <NULL> | UK | P
2500 | Magdalen Centre, The Oxford Science Park | OX9 9ZB | Oxford | Oxford | UK | P
2600 | 9702 Chester Road | 09629850293 | Stretford | Manchester | UK | P
2700 | Schwanthalerstr. 7031 | 80925 | Munich | Bavaria | DE | P
2800 | Rua Frei Caneca 1360 | 01307-002 | Sao Paulo | Sao Paulo | BR | P
2900 | 20 Rue des Corps-Saints | 1730 | Geneva | Geneve | CH | P
3000 | Murtenstrasse 921 | 3095 | Bern | BE | CH | P
3100 | Pieter Breughelstraat 837 | 3029SK | Utrecht | Utrecht | NL | P
3200 | Mariano Escobedo 9991 | 11932 | Mexico City | Distrito Federal, | MX | P
22 rows selected.
now check myco_planning:
USER is "MYCO_PLANNING"
01:17:57 not connected> select l.*,label_to_char(faclab) label from hr.locations l;
LOCATION_ID | STREET_ADDRESS | POSTAL_CODE | CITY | STATE_PROVINCE | CO | LABEL
----------- | ---------------------------------------- | ------------ | ------------------------------ | ------------------------- | -- | ----------
1000 | 1297 Via Cola di Rie | 00989 | Roma | <NULL> | IT | P
1100 | 93091 Calle della Testa | 10934 | Venice | <NULL> | IT | P
1200 | 2017 Shinjuku-ku | 1689 | Tokyo | Tokyo Prefecture | JP | S::ASIA
1300 | 9450 Kamiya-cho | 6823 | Hiroshima | <NULL> | JP | P
1400 | 2014 Jabberwocky Rd | 26192 | Southlake | Texas | US | P
1500 | 2011 Interiors Blvd | 99236 | South San Francisco | California | US | HS::US
1600 | 2007 Zagora St | 50090 | South Brunswick | New Jersey | US | P
1700 | 2004 Charade Rd | 98199 | Seattle | Washington | US | P
1800 | 147 Spadina Ave | M5V 2L7 | Toronto | Ontario | CA | P
1900 | 6092 Boxwood St | YSW 9T2 | Whitehorse | Yukon | CA | P
2000 | 40-5-12 Laogianggen | 190518 | Beijing | <NULL> | CN | S::ASIA
2100 | 1298 Vileparle (E) | 490231 | Bombay | Maharashtra | IN | P
2200 | 12-98 Victoria Street | 2901 | Sydney | New South Wales | AU | P
2300 | 198 Clementi North | 540198 | Singapore | <NULL> | SG | S::ASIA
2400 | 8204 Arthur St | <NULL> | London | <NULL> | UK | P
2500 | Magdalen Centre, The Oxford Science Park | OX9 9ZB | Oxford | Oxford | UK | P
2600 | 9702 Chester Road | 09629850293 | Stretford | Manchester | UK | P
2700 | Schwanthalerstr. 7031 | 80925 | Munich | Bavaria | DE | P
2800 | Rua Frei Caneca 1360 | 01307-002 | Sao Paulo | Sao Paulo | BR | P
2900 | 20 Rue des Corps-Saints | 1730 | Geneva | Geneve | CH | P
3000 | Murtenstrasse 921 | 3095 | Bern | BE | CH | P
3100 | Pieter Breughelstraat 837 | 3029SK | Utrecht | Utrecht | NL | P
3200 | Mariano Escobedo 9991 | 11932 | Mexico City | Distrito Federal, | MX | P
23 rows selected.
Enable unified auditing option
https://blogs.oracle.com/imc/entry/oracle_database_12c_new_unified
Enalbe unified audit
1.Stop all Oracle processes: databases, listener and Enterprise Manager.
2.Relink Oracle with the uniaud_on option.
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk uniaud_on ioracle
[root@oel7-2 ~]# . oraenv ORACLE_SID = [root] ? +ASM [root@oel7-2 ~]# srvctl stop database -d orcl [root@oel7-2 ~]# srvctl stop asm -f [root@oel7-2 ~]# su - oracle [oracle@oel7-2 ~]$ cd $ORACLE_HOME/rdbms/lib [oracle@oel7-2 lib]$ make -f ins_rdbms.mk uniaud_on ioracle .. [oracle@oel7-2 lib]$ logout [root@oel7-2 ~]# srvctl start database -d orcl
check that option is enabled:
23:07:24 (1)[PDBORCL]c##bushmelev_aa@orcl> select * from v$option where PARAMETER = 'Unified Auditing' 23:07:29 2 ; PARAMETER | VALUE | CON_ID -------------------------------------------------- | ---------- | ---------- Unified Auditing | TRUE | 0
Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server
Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server published on Read more posts by the author of Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server, Bushmelev AntonКомментариев к записи Duplicate ORA-17628: Oracle error 19505 returned by remote Oracle server нет
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:25<br />
ORA-17628: Oracle error 19505 returned by remote Oracle server
[code language=”bash” highlight=”398-400″]
RMAN> run { allocate channel ch1 device type disk; allocate auxiliary channel ch2 device type disk; duplicate target database for standby from active database;}
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=10534 device type=DISK
allocated channel: ch2
channel ch2: SID=1506 device type=DISK
Starting Duplicate Db at 02-11-2015 10:45:42
contents of Memory Script:
{
backup as copy reuse
targetfile ‘/oracle/app/base/db/11.2.0/dbs/orapws00somedb’ auxiliary format
‘/oracle/app/base/db/11.2.0.4/dbs/orapwu00somedb1’ ;
}
executing Memory Script
Starting backup at 02-11-2015 10:45:42
Finished backup at 02-11-2015 10:45:44
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format ‘/home/oracle/control1.ctl’;
}
executing Memory Script
Starting backup at 02-11-2015 10:45:44
channel ch1: starting datafile copy
copying standby control file
output file name=/oracle/app/base/db/11.2.0/dbs/snapcf_s00somedb.f tag=TAG20151102T104544 RECID=27 STAMP=894710744
channel ch1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 02-11-2015 10:45:47
contents of Memory Script:
{
sql clone ‘alter database mount standby database’;
}
executing Memory Script
sql statement: alter database mount standby database
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
contents of Memory Script:
{
set newname for tempfile 1 to
"+data";
set newname for tempfile 2 to
"+data";
set newname for tempfile 3 to
"+data";
switch clone tempfile all;
set newname for datafile 1 to
"+data";
set newname for datafile 2 to
"+data";
set newname for datafile 3 to
"+data";
set newname for datafile 4 to
"+data";
set newname for datafile 5 to
"+data";
set newname for datafile 6 to
"+data";
set newname for datafile 7 to
"+data";
set newname for datafile 8 to
"+data";
set newname for datafile 9 to
"+data";
set newname for datafile 10 to
"+data";
set newname for datafile 11 to
"+data";
set newname for datafile 12 to
"+data";
set newname for datafile 13 to
"+data";
set newname for datafile 14 to
"+data";
set newname for datafile 15 to
"+data";
set newname for datafile 16 to
"+data";
set newname for datafile 17 to
"+data";
set newname for datafile 18 to
"+data";
set newname for datafile 19 to
"+data";
set newname for datafile 20 to
"+data";
set newname for datafile 21 to
"+data";
set newname for datafile 22 to
"+data";
set newname for datafile 23 to
"+data";
set newname for datafile 24 to
"+data";
set newname for datafile 25 to
"+data";
set newname for datafile 26 to
"+data";
set newname for datafile 27 to
"+data";
set newname for datafile 28 to
"+data";
backup as copy reuse
datafile 1 auxiliary format
"+data" datafile
2 auxiliary format
"+data" datafile
3 auxiliary format
"+data" datafile
4 auxiliary format
"+data" datafile
5 auxiliary format
"+data" datafile
6 auxiliary format
"+data" datafile
7 auxiliary format
"+data" datafile
8 auxiliary format
"+data" datafile
9 auxiliary format
"+data" datafile
10 auxiliary format
"+data" datafile
11 auxiliary format
"+data" datafile
12 auxiliary format
"+data" datafile
13 auxiliary format
"+data" datafile
14 auxiliary format
"+data" datafile
15 auxiliary format
"+data" datafile
16 auxiliary format
"+data" datafile
17 auxiliary format
"+data" datafile
18 auxiliary format
"+data" datafile
19 auxiliary format
"+data" datafile
20 auxiliary format
"+data" datafile
21 auxiliary format
"+data" datafile
22 auxiliary format
"+data" datafile
23 auxiliary format
"+data" datafile
24 auxiliary format
"+data" datafile
25 auxiliary format
"+data" datafile
26 auxiliary format
"+data" datafile
27 auxiliary format
"+data" datafile
28 auxiliary format
"+data" ;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to +data in control file
renamed tempfile 2 to +data in control file
renamed tempfile 3 to +data in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 02-11-2015 10:45:55
channel ch1: starting datafile copy
input datafile file number=00008 name=+DATA/s00somedb/datafile/somedb.272.848695139
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:45:56
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00017 name=+DATA/s00somedb/datafile/aud_evt_04.280.864489643
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:45:58
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00014 name=+DATA/s00somedb/datafile/aud_evt_01.264.864489545
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:45:59
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00015 name=+DATA/s00somedb/datafile/aud_evt_02.258.864489637
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:00
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00016 name=+DATA/s00somedb/datafile/aud_evt_03.257.864489641
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:01
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00018 name=+DATA/s00somedb/datafile/aud_evt_05.279.864489647
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:02
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00019 name=+DATA/s00somedb/datafile/aud_evt_06.278.864489649
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:03
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00006 name=+DATA/s00somedb/datafile/sia_db.273.843746737
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:04
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00011 name=+DATA/s00somedb/datafile/somedb_arch.290.849349975
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:05
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00013 name=+DATA/s00somedb/datafile/somedb_arch.259.859243111
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:06
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00021 name=+DATA/s00somedb/datafile/somedb_arch_emergency.302.868721455
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:07
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00020 name=+DATA/s00somedb/datafile/somedb_arch.275.868719829
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:09
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00003 name=+DATA/s00somedb/datafile/undotbs1.268.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:10
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00004 name=+DATA/s00somedb/datafile/undotbs2.266.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:11
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00002 name=+DATA/s00somedb/datafile/sysaux.269.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:12
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00026 name=+DATA/s00somedb/datafile/somedb_arch_emergency.308.888666289
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:13
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00025 name=+DATA/s00somedb/datafile/somedb_arch_02.307.888665401
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:14
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00022 name=+DATA/s00somedb/datafile/egs_db.303.870185105
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:15
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00005 name=+DATA/s00somedb/datafile/users.271.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:16
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00023 name=+DATA/s00somedb/datafile/egs_sia_db.304.870185511
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:17
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00001 name=+DATA/s00somedb/datafile/system.267.843746741
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:18
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00007 name=+DATA/s00somedb/datafile/somedb_tech.270.848695135
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:20
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00009 name=+DATA/s00somedb/datafile/somedb_adm.286.846186103
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:21
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00010 name=+DATA/s00somedb/datafile/somedb_pds.287.846186119
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:22
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00012 name=+DATA/s00somedb/datafile/somedb_cpp.291.848604621
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:23
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00024 name=+DATA/s00somedb/datafile/somedb_support.305.876591437
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:24
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00027 name=+DATA/s00somedb/datafile/somedb_arch_03.309.888669979
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:25
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
channel ch1: starting datafile copy
input datafile file number=00028 name=+DATA/s00somedb/datafile/somedb_arch_04_big.310.892636427
released channel: ch1
released channel: ch2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/02/2015 10:46:26
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ch1 channel at 11/02/2015 10:46:26
ORA-17628: Oracle error 19505 returned by remote Oracle server
RMAN> exit
Recovery Manager complete.
[oracle@u00somedb12db-01 /home/oracle]$cd $ORACLE_HOME
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4]$cd bin
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all ora
orabase oracg oracle oracleO oradism oraenv orajaxb orapipe orapki orapwd orapwdO oraxml oraxsl
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all orac
oracg oracle oracleO
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all orac
oracg oracle oracleO
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$ls -all orac*
-rwxr-xr-x 1 oracle oinstall 46 Nov 7 2000 oracg
-rwsr-s–x 1 oracle oinstall 239768932 Oct 23 17:36 oracle
-rwsr-s–x 1 oracle oinstall 239768900 Oct 23 17:36 oracleO
[oracle@u00somedb12db-01 /oracle/app/base/db/11.2.0.4/bin]$
[/code]
[свернуть]
after check oracle binary group solution will be :
[root@u00somedb12db-01 ~]# /oracle/grid/12.1.0.2/bin/setasmgid -o=/oracle/app/base/db/11.2.0.4/bin/oracle [root@u00somedb12db-01 ~]#
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
How To Configure SSH for a RAC Installation [ID 300548.1]
How To Configure SSH for a RAC Installation [ID 300548.1]
cd $HOME rm -rf .ssh mkdir .ssh chmod 700 .ssh cd .ssh ssh-keygen -t rsa ssh-keygen -t dsa cat $HOME/.ssh/*.pub >> $HOME/.ssh/authorized_keys.$HOSTNAME cd $HOME/.ssh scp rac[1-4]:$HOME/.ssh/authorized_keys.oel6* $HOME/.ssh scp $HOME/.ssh/authorized_keys.oel6* oel6-[1-4]:$HOME/.ssh cat $HOME/.ssh/*oel6* >> $HOME/.ssh/authorized_keys chmod 600 authorized_keys
qick config bash profile for oracle and grid user
Grid
export PS1='\[\e[1;31m\][\u@\h \W]\$\[\e[0m\] '
export ORACLE_SID=$(cat /etc/oratab| grep -i asm | grep -v "^#" |awk -F: '{print $1}' )
export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES
alias sqlplus='rlwrap sqlplus'
alias lsnrctl='rlwrap lsnrctl'
alias rman='rlwrap rman'
alias asmcmd='rlwrap asmcmd'
alias adrci='rlwrap adrci'
alias dgmgrl='rlwrap dgmgrl'
Oracle:
export PS1='\[\e[1;32m\][\u@\h \W]\$\[\e[0m\] '
export EDITOR=vim
export ORACLE_SID=$(cat /etc/oratab | grep -v "^#" | grep -iv asm |grep -v -e '^$' | awk -F: '{print $1}' )
export ORAENV_ASK=NO
. oraenv
export ORAENV_ASK=YES
alias sqlplus='rlwrap sqlplus'
alias lsnrctl='rlwrap lsnrctl'
alias rman='rlwrap rman'
alias asmcmd='rlwrap asmcmd'
alias adrci='rlwrap adrci'
alias dgmgrl='rlwrap dgmgrl'
mac os x virtual box issue on oracle install
original at Can’t Compile GI 12.1.0.2 and Segmentation Fault
quick fix
cp $ORACLE_HOME/javavm/jdk/jdk7/lib/libjavavm12.a $ORACLE_HOME/lib
cd ~ rm -rf perl mkdir perl cd perl/ curl -O http://www.cpan.org/src/5.0/perl-5.14.1.tar.gz tar -xvzf perl-5.14.1.tar.gz cd perl-5.14.1 cd $ORACLE_HOME mv perl/ perl.OLD mkdir perl cd $HOME/perl/perl-5.14.1 ./Configure -des -Dprefix=$ORACLE_HOME/perl -Doptimize=-O3 -Dusethreads -Duseithreads -Duserelocatableinc && make clean && make && make install cd $ORACLE_HOME/perl rm -rf lib/ man/ cp -r ../perl.OLD/lib/ . cp -r ../perl.OLD/man/ .
wait events with discriptions
db file sequential reads
Possible Causes :
· Use of an unselective index
· Fragmented Indexes
· High I/O on a particular disk or mount point
· Bad application design
· Index reads performance can be affected by slow I/O subsystem and/or poor database files layout, which result in a higher average wait time
Actions :
· Check indexes on the table to ensure that the right index is being used
· Check the column order of the index with the WHERE clause of the Top SQL statements
· Rebuild indexes with a high clustering factor
· Use partitioning to reduce the amount of blocks being visited
· Make sure optimizer statistics are up to date
· Relocate ‘hot’ datafiles
· Consider the usage of multiple buffer pools and cache frequently used indexes/tables in the KEEP pool
· Inspect the execution plans of the SQL statements that access data through indexes
· Is it appropriate for the SQL statements to access data through index lookups?
· Would full table scans be more efficient?
· Do the statements use the right driving table?
· The optimization goal is to minimize both the number of logical and physical I/Os.
Remarks:
· The Oracle process wants a block that is currently not in the SGA, and it is waiting for the database block to be read into the SGA from disk.
· Significant db file sequential read wait time is most likely an application issue.
· If the DBA_INDEXES.CLUSTERING_FACTOR of the index approaches the number of blocks in the table, then most of the rows in the table are ordered. This is desirable.
· However, if the clustering factor approaches the number of rows in the table, it means the rows in the table are randomly ordered and thus it requires more I/Os to complete the operation. You can improve the index’s clustering factor by rebuilding the table so that rows are ordered according to the index key and rebuilding the index thereafter.
· The OPTIMIZER_INDEX_COST_ADJ and OPTIMIZER_INDEX_CACHING initialization parameters can influence the optimizer to favour the nested loops operation and choose an index access path over a full table scan.
db file scattered reads
Possible Causes :
· The Oracle session has requested and is waiting for multiple contiguous database blocks (up to DB_FILE_MULTIBLOCK_READ_COUNT) to be read into the SGA from disk.
· Full Table scans
· Fast Full Index Scans
Actions :
· Optimize multi-block I/O by setting the parameter DB_FILE_MULTIBLOCK_READ_COUNT
· Partition pruning to reduce number of blocks visited
· Consider the usage of multiple buffer pools and cache frequently used indexes/tables in the KEEP pool
· Optimize the SQL statement that initiated most of the waits. The goal is to minimize the number of physical
and logical reads.
· Should the statement access the data by a full table scan or index FFS? Would an index range or unique scan be more efficient? Does the query use the right driving table?
· Are the SQL predicates appropriate for hash or merge join?
· If full scans are appropriate, can parallel query improve the response time?
· The objective is to reduce the demands for both the logical and physical I/Os, and this is best
achieved through SQL and application tuning.
· Make sure all statistics are representative of the actual data. Check the LAST_ANALYZED date
Remarks:
· If an application that has been running fine for a while suddenly clocks a lot of time on the db file scattered read event and there hasn’t been a code change, you might want to check to see if one or more indexes has been dropped or become unusable.
· Or whether the stats has been stale.
log file parallel write
Possible Causes :
· LGWR waits while writing contents of the redo log buffer cache to the online log files on disk
· I/O wait on sub system holding the online redo log files
Actions :
· Reduce the amount of redo being generated
· Do not leave tablespaces in hot backup mode for longer than necessary
· Do not use RAID 5 for redo log files
· Use faster disks for redo log files
· Ensure that the disks holding the archived redo log files and the online redo log files are separate so as to avoid contention
· Consider using NOLOGGING or UNRECOVERABLE options in SQL statements
log file sync:
Possible Causes :
· Oracle foreground processes are waiting for a COMMIT or ROLLBACK to complete
Actions :
· Tune LGWR to get good throughput to disk eg: Do not put redo logs on RAID5
· Reduce overall number of commits by batching transactions so that there are fewer distinct COMMIT operations
Actions :
Tune LGWR to get good throughput to disk eg: Do not put redo logs on RAID5
Reduce overall number of commits by batching transactions so that there are fewer distinct COMMIT operations
buffer busy waits:
Possible Causes :
· Buffer busy waits are common in an I/O-bound Oracle system.
· The two main cases where this can occur are:
· Another session is reading the block into the buffer
· Another session holds the buffer in an incompatible mode to our request
· These waits indicate read/read, read/write, or write/write contention.
· The Oracle session is waiting to pin a buffer .A buffer must be pinned before it can be read or modified. Only one process can pin a
buffer at any one time.
· This wait can be intensified by a large block size as more rows can be contained within the block
· This wait happens when a session wants to access a database block in the buffer cache but it cannot as the buffer is “busy
· It is also often due to several processes repeatedly reading the same blocks (eg: i lots of people scan the same index or data block)
Actions :
· The main way to reduce buffer busy waits is to reduce the total I/O on the system
· Depending on the block type, the actions will differ
Data Blocks
· Eliminate HOT blocks from the application. Check for repeatedly scanned / unselective indexes.
· Try rebuilding the object with a higher PCTFREE so that you reduce the number of rows per block.
· Check for ‘right- hand-indexes’ (indexes that get inserted into at the same point by many processes).
· Increase INITRANS and MAXTRANS and reduce PCTUSED This will make the table less dense .
· Reduce the number of rows per block
Segment Header
· Increase of number of FREELISTs and FREELIST GROUPs
Undo Header
· Increase the number of Rollback Segments
free buffer waits:
Possible Causes :
· This means we are waiting for a free buffer but there are none available in the cache because there are too many dirty buffers in the cache
· Either the buffer cache is too small or the DBWR is slow in writing modified buffers to disk
· DBWR is unable to keep up to the write requests
· Checkpoints happening too fast – maybe due to high database activity and under-sized online redo log files
· Large sorts and full table scans are filling the cache with modified blocks faster than the DBWR is able to write to disk
· If the number of dirty buffers that need to be written to disk is larger than the number that DBWR can write per batch, then these waits can be observed
Actions :
Reduce checkpoint frequency – increase the size of the online redo log files
Examine the size of the buffer cache – consider increasing the size of the buffer cache in the SGA
Set disk_asynch_io = true set
If not using asynchronous I/O increase the number of db writer processes or dbwr slaves
Ensure hot spots do not exist by spreading datafiles over disks and disk controllers
Pre-sorting or reorganizing data can help
enqueue waits
Possible Causes :
· This wait event indicates a wait for a lock that is held by another session (or sessions) in an incompatible mode to the requested mode.
TX Transaction Lock
· Generally due to table or application set up issues
· This indicates contention for row-level lock. This wait occurs when a transaction tries to update or delete rows that are currently
locked by another transaction.
· This usually is an application issue.
TM DML enqueue lock
· Generally due to application issues, particularly if foreign key constraints have not been indexed.
ST lock
· Database actions that modify the UET$ (used extent) and FET$ (free extent) tables require the ST lock, which includes actions such as drop, truncate, and coalesce.
· Contention for the ST lock indicates there are multiple sessions actively performing
· dynamic disk space allocation or deallocation
· in dictionary managed tablespaces
Actions :
· Reduce waits and wait times
· The action to take depends on the lock type which is causing the most problems
· Whenever you see an enqueue wait event for the TX enqueue, the first step is to find out who the blocker is and if there are multiple waiters for the same resource
· Waits for TM enqueue in Mode 3 are primarily due to unindexed foreign key columns.
· Create indexes on foreign keys 10g
· Following are some of the things you can do to minimize ST lock contention in your database:
· Use locally managed tablespaces
· Recreate all temporary tablespaces using the CREATE TEMPORARY TABLESPACE TEMPFILE… command. Cache
buffer chain latch Possible Causes :
· Processes need to get this latch when they need to move buffers based on the LRU block replacement policy in the buffer cache
· The cache buffer lru chain latch is acquired in order to introduce a new block into the buffer cache and when writing a buffer back to disk, specifically when trying to scan the LRU (least recently used) chain containing all the dirty blocks in the buffer cache. Competition for the cache buffers lru chain . · latch is symptomatic of intense buffer cache activity caused by inefficient SQL statements. Statements that repeatedly scan
· large unselective indexes or perform full table scans are the prime culprits.
· Heavy contention for this latch is generally due to heavy buffer cache activity which can be caused, for example, by:
Repeatedly scanning large unselective indexes Actions : Contention in this latch can be avoided implementing multiple buffer pools or increasing the number of LRU latches with the parameter DB_BLOCK_LRU_LATCHES (The default value is generally sufficient for most systems). Its possible to reduce contention for the cache buffer lru chain latch by increasing the size of the buffer cache and thereby reducing the rate at which new blocks are introduced into the buffer cache.
Direct Path Reads Possible Causes :
· These waits are associated with direct read operations which read data directly into the sessions PGA bypassing the SGA
· The “direct path read” and “direct path write” wait events are related to operations that are performed in PGA like sorting, group by operation, hash join
· In DSS type systems, or during heavy batch periods, waits on “direct path read” are quite normal However, for an OLTP system these waits are significant
· These wait events can occur during sorting operations which is not surprising as direct path reads and writes usually occur in connection with temporary tsegments
· SQL statements with functions that require sorts, such as ORDER BY, GROUP BY, UNION, DISTINCT, and ROLLUP, write sort runs to the temporary tablespace when the input size is larger than the work area in the PGA Actions :
Ensure the OS asynchronous IO is configured correctly. Check for IO heavy sessions / SQL and see if the amount of IO can be reduced. Ensure no disks are IO bound. Set your PGA_AGGREGATE_TARGET to appropriate value (if the parameter WORKAREA_SIZE_POLICY = AUTO) Or set *_area_size manually (like sort_area_size and then you have to set WORKAREA_SIZE_POLICY = MANUAL Whenever possible use UNION ALL instead of UNION, and where applicable use HASH JOIN instead of SORT MERGE and NESTED LOOPS instead of HASH JOIN. Make sure the optimizer selects the right driving table. Check to see if the composite index’s columns can be rearranged to match the ORDER BY clause to avoid sort entirely. Also, consider automating the SQL work areas using PGA_AGGREGATE_TARGET in Oracle9i Database. Query V$SESSTAT to identify sessions with high “physical reads direct”
Remark:
· Default size of HASH_AREA_SIZE is twice that of SORT_AREA_SIZE
· Larger HASH_AREA_SIZE will influence optimizer to go for hash joins instead of nested loops
· Hidden parameter DB_FILE_DIRECT_IO_COUNT can impact the direct path read performance.It sets the maximum I/O buffer size of direct read and write operations. Default is 1M in 9i
Direct Path Writes:
Possible Causes :
· These are waits that are associated with direct write operations that write data from users’ PGAs to data files or temporary tablespaces
· Direct load operations (eg: Create Table as Select (CTAS) may use this)
· Parallel DML operations
· Sort IO (when a sort does not fit in memory
Actions :
If the file indicates a temporary tablespace check for unexpected disk sort operations.
Ensure
is TRUE . This is unlikely to reduce wait times from the wait event timings but
may reduce sessions elapsed times (as synchronous direct IO is not accounted for in wait event timings).
Ensure the OS asynchronous IO is configured correctly.
Ensure no disks are IO bound
Latch Free Waits
Possible Causes :
· This wait indicates that the process is waiting for a latch that is currently busy (held by another process).
· When you see a latch free wait event in the V$SESSION_WAIT view, it means the process failed to obtain the latch in the
willing-to-wait mode after spinning _SPIN_COUNT times and went to sleep. When processes compete heavily for latches, they will also consume more CPU resources because of spinning. The result is a higher response time
Actions :
· If the TIME spent waiting for latches is significant then it is best to determine which latches are suffering from contention.
Remark:
· A latch is a kind of low level lock. Latches apply only to memory structures in the SGA. They do not apply to database objects. An Oracle SGA has many latches, and they exist to protect various memory structures from potential corruption by concurrent access.
· The time spent on latch waits is an effect, not a cause; the cause is that you are doing too many block gets, and block gets require cache buffer chain latching
Library cache latch
Possible Causes :
· The library cache latches protect the cached SQL statements and objects definitions held in the library cache within the shared pool. The library cache latch must be acquired in order to add a new statement to the library cache.
· Application is making heavy use of literal SQL- use of bind variables will reduce this latch considerably
Actions :
· Latch is to ensure that the application is reusing as much as possible SQL statement representation. Use bind variables whenever ossible in the application.
· You can reduce the library cache latch hold time by properly setting the SESSION_CACHED_CURSORS parameter.
· Consider increasing shared pool.
Remark:
· Larger shared pools tend to have long free lists and processes that need to allocate space in them must spend extra time scanning the long free lists while holding the shared pool latch
· if your database is not yet on Oracle9i Database, an oversized shared pool can increase the contention for the shared pool latch..
Shared pool latch
Possible Causes :
The shared pool latch is used to protect critical operations when allocating and freeing memory in the shared pool
Contentions for the shared pool and library cache latches are mainly due to intense hard parsing. A hard parse applies to new cursors and cursors that are aged out and must be re-executed
The cost of parsing a new SQL statement is expensive both in terms of CPU requirements and the number of times the library cache and shared pool latches may need to be acquired and released.
Actions :
· Ways to reduce the shared pool latch are, avoid hard parses when possible, parse once, execute many.
· Eliminating literal SQL is also useful to avoid the shared pool latch. The size of the shared_pool and use of MTS (shared server option) also greatly influences the shared pool latch.
· The workaround is to set the initialization parameter CURSOR_SHARING to FORCE. This allows statements that differ in literal
values but are otherwise identical to share a cursor and therefore reduce latch contention, memory usage, and hard parse.
Row cache objects latch
Possible Causes :
This latch comes into play when user processes are attempting to access the cached data dictionary values.
Actions :
· It is not common to have contention in this latch and the only way to reduce contention for this latch is by increasing the size of the shared pool (SHARED_POOL_SIZE).
· Use Locally Managed tablespaces for your application objects especially indexes
· Review and amend your database logical design , a good example is to merge or decrease the number of indexes on tables with heavy inserts
Remark:
· Configuring the library cache to an acceptable size usually ensures that the data dictionary cache is also properly sized. So tuning Library Cache will tune Row Cache indirectly.
trace trigger
grant execute on dbms_monitor to some_user
db username:
CREATE OR REPLACE TRIGGER trace_some_user
AFTER LOGON ON some_user.SCHEMA
BEGIN
execute immediate 'alter session set timed_statistics = true';
execute immediate 'alter session set max_dump_file_size = unlimited';
execute immediate 'alter session set tracefile_identifier = ''some_user''';
dbms_monitor.session_trace_enable (null,null,true,true);
END;
Os username:
CREATE OR REPLACE TRIGGER trace_some_user
AFTER LOGON ON database
declare
v_user varchar2(100);
begin
SELECT SYS_CONTEXT ('USERENV', 'OS_USER') into v_user from dual;
if v_user='some_user' then
execute immediate 'alter session set timed_statistics = true';
execute immediate 'alter session set max_dump_file_size = unlimited';
execute immediate 'alter session set tracefile_identifier = ''some_user''';
dbms_monitor.session_trace_enable (null,null,true,true);
end if;
END;