Месяц: Февраль 2016

for check i use nmap and Nmap script to test Oracle DB for «TNS poison vulnerability» check : solution is described by MOS: Valid Node Checking For Registration (VNCR) (Doc ID 1600630.1) How to Enable VNCR on RAC Database to Register only Local Instances (Doc ID 1914282.1) fixup: add to grid listener.ora REGISTRATION_INVITED_NODES_LISTENER_SCAN*=( list of … Читать далее

we can update whole column of big table with no downtime with dbms_redefinition and col_mapping there is an example: find table with lots of rows for test and make a copy: create interim table for redefinition and add column to remap data need to be updated, also set default value for column we need to … Читать далее

found at community.oracle.com

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