Месяц: Август 2016

try to make table partitioned: create dummy table: start redef and get error: this is because original table have a timestamp with local timezone format how to fix it:

original

Trying to find out overhead of new Adaptive Query Optimization feature use perf to find out process cpu usage ( eg:perf stat -e task-clock -p 9576 sleep 5 ) to disable adaptive features I used so the result is: 3000 hpares 3000 hpares 3000 hpares 3000 hpares 3000 hpares avg adaptive off 1724,46 1786,04 1696,22 … Читать далее

original from Tanel Poder was looking for source of v$restore point view, helped article from Tanel =) result is : upd: also it can be done with:

need to pass schema name as firs script argument

today faced with ‘enq: TX — index contention’ awr shows helped to make partition index on nonpartition table:

faced with helped solution from: CRS-1153: There was an error setting Oracle Clusterware to rolling patch mode. (Doc ID 1943498.1) CRS-6706: Oracle Clusterware Release patch level (‘nnn’) does not match Software patch level (‘mmm’) (Doc ID 1639285.1) first one: with no luck second is successfull: