1. Да
2. В моём INIT.ORA такого параметра нет вообще.
3. Что такое хинты? В "Explain Plan" пишет на V_ECONOPRS "GOAL = HINT: RULE", на V_OPRSPECS_SHADOW "GOAL = CHOOSE"
4. Statistics
----------------------------------------------------------
28 recursive calls
0 db block gets
164273 consistent gets
164266 physical reads
60 redo size
1754 bytes sent via SQL*Net to client
314 bytes received via SQL*Net from client
1 SQL*Net roundtrips to/from client
2 sorts (memory)
0 sorts (disk)
0 rows processed