DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on AD_CTX_DDL

Line 377: AD_CTX_DDL.sync_index( l_index_name );

373: l_index_name VARCHAR2(300) := g_cs_short_name||'.'||index1;
374:
375: BEGIN
376: IF bmode = 'S' THEN
377: AD_CTX_DDL.sync_index( l_index_name );
378: ELSIF bmode = 'OFAST' THEN
379: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
380: ELSIF bmode = 'OFULL' THEN
381: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

Line 379: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );

375: BEGIN
376: IF bmode = 'S' THEN
377: AD_CTX_DDL.sync_index( l_index_name );
378: ELSIF bmode = 'OFAST' THEN
379: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
380: ELSIF bmode = 'OFULL' THEN
381: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
382: ELSIF bmode = 'R' THEN
383: -- 4321268: rebuild in parallel mode always. Serial online mode,

Line 381: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );

377: AD_CTX_DDL.sync_index( l_index_name );
378: ELSIF bmode = 'OFAST' THEN
379: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FAST, NULL, NULL );
380: ELSIF bmode = 'OFULL' THEN
381: AD_CTX_DDL.OPTIMIZE_INDEX( l_index_name, CTX_DDL.OPTLEVEL_FULL, NULL, NULL );
382: ELSIF bmode = 'R' THEN
383: -- 4321268: rebuild in parallel mode always. Serial online mode,
384: -- is taking care in the individual index program.
385: IF pworker IS NOT NULL AND pworker > 0 THEN