To create an heterogenous database link (to another database):1) set an odbc connection named testdb and in advanced put username/password (admin/admin)2) put inittestdb.ora in D:\oracle\product\10.2.0\db_1\hs\admin (* see below)3) put tnsnames.ora…
The statement below clears the cache, so you can run benchmarks against SQL execution: alter system flush buffer_cache
SELECT * FROM NLS_SESSION_PARAMETERSALTER SESSION SET NLS_LANGUAGE=Greek;alter session set nls_lang=GREEK_GREECE.EL8MSWIN1253
How to retrieve session information: select S.LOGON_TIME ,sid, serial#, username, command, lockwait, status, osuser, sql_text, machinefrom v$session s, v$sqlarea q where s.sql_hash_value = q.hash_valueand s.sql_address = q.addressand osuser = 'zzz'and…
How to create a pivot query: with t as ( select 1 GRP_NR, 'A' val from dual union allselect 1 ,'B' val from dual union allselect 2 ,'A' val from…