Daily Archives: March 31, 2015

How many different type of wait event parameters in Oracle 12c (12.1.0.2)


PARAMETER1 COUNT(*) —————————————————————- ———- name|mode 463 456 type|mode 200 address 50 file# 40 sleeptime/senderid 40 cellhash# 22 location 19 count 18 17 driver id 16 group 16 group# 14 Session ID 13 2=>GoldenGate 1=>XStream 0=>Streams 12 session_id 8 where 8 idn 7 sleep time 7 function_id 7 waittime 6 blkno 5 p1 5 filectx 5 […]

Database link with SSL SQL*Net encryption


SQL> connect anar/password Connected. SQL> select instance_name from v$instance; INSTANCE_NAME —————- KBAZER2 SQL> create database link KBAZER1 connect to anar identified by password using ‘KBAZER1_tcps’; Database link created. SQL> select instance_name from v$instance@KBAZER1; INSTANCE_NAME —————- KBAZER1 From listener.log: 2015-03-15 18:30:47.2801020 +10:00 2015-03-15 18:30:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=KBAZER1)(CID=(PROGRAM=oracle)(HOST=SONUNW)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcps)(HOST=x.x.9.27)(PORT=2854)) * establish * KBAZER1 * 0