Oracle SQL Trace and TKPROF Event # Level Description 8186 – ALTER SESSION SET EVENTS ‘8186 trace name context OFF’ – VERSIONS BETWEEN query 10005 – Trace latch operations for debugging 10013 1 Monitor Transaction Recovery 10015 1 Dump Undo Segment Headers 10015 3 Identify corrupt undo segments 10021 – KST event to trace control […]
okrem ineho sa da aj takto zistit fuser -V -d
Tento chlapik ma velmi zauimavy Oracle Blog https://blog.tanelpoder.com
execute sys.dbms_backup_restore.resetCfileSection( sectionid); sekcia 11 je pre archlogy
select ksppinm, ksppdesc from x$ksppi where subsur(ksppinm,1,1) = ‘_’ order by 1,2;
root@dm1dbsp02b:/var/crash# mdb 9 cannot open compressed dump; decompress using savecore -f vmdump.9 root@dm1dbsp02b:/var/crash# savecore -f vmdump.9 savecore: System dump time: Mon Jul 27 02:48:06 2015 savecore: saving system crash dump in /var/crash/{unix,vmcore}.9 Constructing namelist /var/crash/unix.9 Constructing corefile /var/crash/vmcore.9 root@dm1dbsp02b:/var/crash# mdb 9 Loading modules: [ unix genunix specfs dtrace mac cpu.generic uppc apix scsi_vhci zfs mr_sas […]
Od Oracle 11g existuje sql hint OPT_PARAM ktorym sa da ohintovat SQL prikaz, funguje podobne ako alter session s tym ze je platny len do dobehnutia danej query /*+ opt_param(<parameter_name> [,] <parameter_value>) */ parameter_name is the name of a parameter parameter_value is its value. napriklad select /*+ opt_param(‘hash_join_enabled’,’false’) */ dept_no, emp_name, empno from […]
Zapnutie —— $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk part_on ioracle Vypnutie ——- $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk part_off ioracle Mozne opcie su: Product/Component Enable Switch Disable Switch Automated Storage Management asm_on asm_off Oracle Data Mining dm_on dm_off Database Vault dv_on dv_off Oracle OLAP olap_on olap_off Oracle Label Security lbac_on lbac_off Oracle […]
column dummy noprint column pct_used format 999.9 heading “%|Used” column name format a19 heading “Tablespace Name” column Kbytes format 999,999,999 heading “KBytes” column used format 999,999,999 heading “Used” column free format 999,999,999 heading “Free” column largest format 999,999,999 heading “Largest” column max_size format 999,999,999 heading “MaxPoss|Kbytes” column pct_max_used format 999.9 heading “%|Max|Used” break on report […]
HealthCheck HealthCheck scripts run from /usr/oracle/healthcheck healthcheck binaries can be copied from Frame to Frame by tar’ing all the files up and scp to new location. Change all Cell/DBNode passwords at once PASSWORD=<value> dcli -l root -g ~/all_group “echo ${PASSWORD} | passwd –stdin root” Status of Cluster /usr/oracle/grid/product/ora11gR2/bin/crsctl stat res -t Hardware sensors Status or […]