Без рубрики

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, … Читать далее

Oracle 11g – How to force a sql_id to use a plan_hash_value using SQL Baselines | rmoff rmoff June 28, 2011 Oracle 11g – How to force a sql_id to use a plan_hash_value using SQL Baselines Filed under: etl, oracle, performance, plan management, sql plan baseline — rmoff @ 14:13 Here’s a scenario that’ll be depressingly … Читать далее

generate pivot script: use info in awr to build a graph result :

https://bushmelev-aa.ru/owncloud/index.php/s/vdqNlAqNqIPLxil materials 12c SPM