APPS.JTF_TAE_INDEX_CREATION_PVT dependencies on V$PARAMETER

Line 59: FROM v$parameter v

55:
56: /* get default Degree of Parallelism */
57: SELECT MIN(TO_NUMBER(v.value))
58: INTO l_dop
59: FROM v$parameter v
60: WHERE v.name = 'parallel_max_servers'
61: OR v.name = 'cpu_count';
62:
63: v_statement := 'SELECT /*+ PARALLEL(JTF_TAE_TRANS_OBJS_GROUP, ' || l_dop ||') */ stddev(x) ';

Line 191: FROM v$parameter v

187:
188: /* get default Degree of Parallelism */
189: SELECT MIN(TO_NUMBER(v.value))
190: INTO l_dop
191: FROM v$parameter v
192: WHERE v.name = 'parallel_max_servers'
193: OR v.name = 'cpu_count';
194:
195: -- cardinality

Line 718: FROM v$parameter v

714:
715: /* get default Degree of Parallelism */
716: SELECT MIN(TO_NUMBER(v.value))
717: INTO l_dop
718: FROM v$parameter v
719: WHERE v.name = 'parallel_max_servers'
720: OR v.name = 'cpu_count';
721:
722: SELECT i.tablespace, i.index_tablespace, u.oracle_username

Line 1272: FROM v$parameter v

1268:
1269: /* get default Degree of Parallelism */
1270: SELECT MIN(TO_NUMBER(v.value))
1271: INTO l_dop
1272: FROM v$parameter v
1273: WHERE v.name = 'parallel_max_servers'
1274: OR v.name = 'cpu_count';
1275:
1276: --dbms_output.put_line('Degree of Parallelism = '||TO_CHAR(l_dop));