Original from Paul Ramsey Hi all, because English is not my native language, that’s why I will write as little as possible =) here is the case, when we write a query with like and get Seq Scan (full table scan), instead index scan this material can be usefull for you if we create same … Читать далее
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:
from oracle-l@freelists.org Here’s how you may find some of these yourself. In this case you were looking for information on tracing locks, so this grep shows matching info from the messages file (linux assumed here, with Gnu grep) grep -E «^1[0-9]{4}.*\block» $ORACLE_HOME/rdbms/mesg/oraus.msg 10028, 00000, «Dump trace information during lock / resource latch cleanup» 10219, 00000, … Читать далее