Без рубрики

SELECT s.sql_handle,s.* FROM dba_sql_plan_baselines s; SELECT * FROM TABLE (dbms_xplan.display_sql_plan_baseline(‘SQL_0c408547ef15f69d’));

test upgrade to 12c on RedHat 7.2 faced with WA is to set RemoveIPC=no in /etc/systemd/logind.conf ps ( MOS Doc ID 438205.1)

++ redefinition —ALTER USER «XXXXXX» QUOTA UNLIMITED ON XXXXXX; ps: thx to Vladimir Mukin for material

select sname, spare4 from sys.optstat_hist_control$; •gather system stats: – EXEC DBMS_STATS.GATHER_DICTIONARY_STATS; – exec DBMS_STATS.GATHER_FIXED_OBJECTS_STATS; – exec DBMS_STATS.GATHER_SYSTEM_STATS(‘interval’, interval=>60)
; • Switch on incremental statistics for partitioned tables – DBMS_STATS.SET_GLOBAL_PREFS(‘INCREMENTAL’,’TRUE’);

find top space occupants: so if we skip blob field at export, we will save 85% of space database size: do export with remap blob field with funtion that return empty blob: create package\function which return empty blob Export: ps: dump size 52gb found at: http://dba.stackexchange.com/questions/25540/export-table-without-blob-column

on prod system we have query that use FTS instead of IRS this is because developers put in bind variable nvarchar2 ( you may find bind type in v$sql_bind_capture ) instead of varchar2, they say that they can’t change code solved by

and you can grant select on this funtion to every one, without FLASHBACK ANY TABLE\SELECT_CATALOG_ROLE\SELECT ANY grants:

http://www.datadisk.co.uk/html_docs/oracle/memory.htm copy to my blog     Oracle Memory Architecture Oracle uses three kinds of memory structures SGA (System Global Area) is a large part of memory that all the oracle background processes access. PGA (Process Global Area) This is memory that is private to a single process or thread and is not accessible by … Читать далее

replace dba_hist_active_sess_history with v$active_session_history to get ash info