ACL lists

All you need to know is  here

http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_networkacl_adm.htm

INTERFACE  FAILURE CALL

OdiStartScen "-SCEN_NAME=INTERFACE_FAILURE_DW_ACTION" "-GLOBAL.g_mod_name=<%=odiRef.getPrevStepLog("STEP_NAME")%>" "-GLOBAL.g_session_no=<%=odiRef.getPrevStepLog("SESS_NO")%>" "-GLOBAL.g_step_no=<%=odiRef.getPrevStepLog("NNO")%>" "-GLOBAL.g_extract_start_date=<%=odiRef.getSysDate("dd/MM/yyyy" )%>" "-GLOBAL.g_extract_end_date=<%=odiRef.getSysDate("dd/MM/yyyy" )%>"

11g incremental stats


BEGIN
  DBMS_STATS.SET_TABLE_PREFS ('SCHEMA', 'TABLE_NAME, 'INCREMENTAL','TRUE');

 --Gather Stats.
   DBMS_STATS.
   gather_table_stats (
      ownname            => 'SCHEMA',
      tabname            => 'TABLE_NAME',
      estimate_percent   => DBMS_STATS.AUTO_SAMPLE_SIZE,
      method_opt         => 'for all indexed columns size auto',
      DEGREE             => 4,
      CASCADE            => TRUE);

END;

INTERFACE FAILURE CALL
OdiStartScen "-SCEN_NAME=INTERFACE_FAILURE_DW_ACTION" "-GLOBAL.g_mod_name=<%=odiRef.getPrevStepLog("STEP_NAME")%>" "-GLOBAL.g_session_no=<%=odiRef.getPrevStepLog("SESS_NO")%>" "-GLOBAL.g_step_no=<%=odiRef.getPrevStepLog("NNO")%>" "-GLOBAL.g_extract_start_date=<%=odiRef.getSysDate("dd/MM/yyyy")%>" "-GLOBAL.g_extract_end_date=<%=odiRef.getSysDate("dd/MM/yyyy")%>"

The default Tablespace for an index is held in  sys.dba_part_indexes

Tom kyte on caching

caching

Export using an external table


unloading data using external tables

Functions prevent queries going parallel , in-built functions do not.

select is_number(col1) from table;

Will NOTgo parallel is the is_number function is a user written function, whereas

select regexp_like(col1, '^-?[[:digit:],.]*$') then 'Numeric' else 'Non-Numeric' ed

from table

WILL GO Parallel

Linux 32 bit or 64 bit?

file /usr/bin/file