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 717: FROM v$parameter v

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

Line 1271: FROM v$parameter v

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