eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_STATS dependencies on DBMS_OUTPUT

Line 131: dbms_output.put_line(tmp_str);

127: ||names(i)
128: ||' NOMONITORING';
129: END IF;
130: EXECUTE IMMEDIATE tmp_str;
131: dbms_output.put_line(tmp_str);
132: END LOOP;
133: END IF; -- if schemaname ='ALL'
134: elsif ((db_versn > 90 ) AND
135: (

Line 227: -- dbms_output.put_line('Request_id is '||request_id);

223: INTO request_id_l
224: FROM dual;
225:
226: END IF;
227: -- dbms_output.put_line('Request_id is '||request_id);
228: -- dbms_output.put_line('Effective Request_id is '||request_id_l);
229: -- l_message := 'Request_id is '||cur_request_id|| 'Effective Request_id is '||request_id_l;
230: -- FND_FILE.put_line(FND_FILE.log,l_message);
231: RETURN request_id_l;

Line 228: -- dbms_output.put_line('Effective Request_id is '||request_id_l);

224: FROM dual;
225:
226: END IF;
227: -- dbms_output.put_line('Request_id is '||request_id);
228: -- dbms_output.put_line('Effective Request_id is '||request_id_l);
229: -- l_message := 'Request_id is '||cur_request_id|| 'Effective Request_id is '||request_id_l;
230: -- FND_FILE.put_line(FND_FILE.log,l_message);
231: RETURN request_id_l;
232: END;

Line 584: dbms_output.put_line(SUBSTR(p_str,1,250));

580: /************************************************************************/
581: PROCEDURE dlog(p_str IN VARCHAR2)
582: IS
583: BEGIN
584: dbms_output.put_line(SUBSTR(p_str,1,250));
585: FND_FILE.put_line(FND_FILE.log,p_str);
586: END dlog;
587: /************************************************************************/
588: /* Procedure: GATHER_TABLE_STATS_PVT */

Line 1036: dbms_output.put_line('stats on table '

1032: END LOOP;
1033: /* end of individual tables */
1034: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1035: LOOP
1036: dbms_output.put_line('stats on table '
1037: || rec_cur.table_name
1038: || 'is locked ');
1039: dlog('stats on table '
1040: || rec_cur.table_name

Line 1147: dbms_output.put_line('stats on table '

1143: END LOOP;
1144: /* end of individual tables */
1145: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1146: LOOP
1147: dbms_output.put_line('stats on table '
1148: || rec_cur.table_name
1149: || 'is locked ');
1150: dlog('stats on table '
1151: || rec_cur.table_name

Line 1244: dbms_output.put_line('stats on table '

1240: END IF;
1241: END LOOP;
1242: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1243: LOOP
1244: dbms_output.put_line('stats on table '
1245: || rec_cur.table_name
1246: || ' is locked ');
1247: dlog('stats on table '
1248: || rec_cur.table_name

Line 1264: --dbms_output.put_line('start of schema = '|| c_schema.sname);

1260: ELSE
1261: /* This is for ALL schema */
1262: FOR c_schema IN schema_cur
1263: LOOP
1264: --dbms_output.put_line('start of schema = '|| c_schema.sname);
1265: -- make a recursive call to gather_schema_stats
1266: GATHER_SCHEMA_STATS_SQLPLUS(schemaname=>c_schema.sname , estimate_percent=>estimate_percent ,
1267: degree=>degree , internal_flag=>internal_flag , Errors=> Errors , request_id=>request_id , hmode=>stathist ,
1268: OPTIONS=>OPTIONS , modpercent=>modpercent , invalidate=> invalidate );

Line 1271: dbms_output.put_line('stats on table ' || rec_cur.table_name || 'is locked ');

1267: degree=>degree , internal_flag=>internal_flag , Errors=> Errors , request_id=>request_id , hmode=>stathist ,
1268: OPTIONS=>OPTIONS , modpercent=>modpercent , invalidate=> invalidate );
1269: /* for rec_cur in lock_stats_tab -- added by saleem
1270: loop
1271: dbms_output.put_line('stats on table ' || rec_cur.table_name || 'is locked ');
1272: dlog('stats on table ' || rec_cur.table_name || 'is locked ');
1273: s_message := 'stats on table ' || rec_cur.table_name || ' is locked ' ;
1274: fnd_file.put_line(FND_FILE.log,s_message);
1275: end loop; */

Line 1524: dbms_output.put_line('stats on table '

1520: END LOOP;
1521: /* end of individual tables */
1522: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1523: LOOP
1524: dbms_output.put_line('stats on table '
1525: || rec_cur.table_name
1526: || 'is locked ');
1527: dlog('stats on table '
1528: || rec_cur.table_name

Line 1635: dbms_output.put_line('stats on table '

1631: END LOOP;
1632: /* end of individual tables */
1633: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1634: LOOP
1635: dbms_output.put_line('stats on table '
1636: || rec_cur.table_name
1637: || ' is locked ');
1638: dlog('stats on table '
1639: || rec_cur.table_name

Line 1712: dbms_output.put_line('stats on table '

1708: END IF;
1709: END LOOP;
1710: FOR rec_cur IN lock_stats_tab(upper(schemaname)) -- added by saleem to display warning for tables with locked stats
1711: LOOP
1712: dbms_output.put_line('stats on table '
1713: || rec_cur.table_name
1714: || ' is locked ');
1715: dlog('stats on table '
1716: || rec_cur.table_name

Line 1733: --dbms_output.put_line('start of schema = '|| c_schema.sname);

1729: ELSE
1730: /* This is for ALL schema */
1731: FOR c_schema IN schema_cur
1732: LOOP
1733: --dbms_output.put_line('start of schema = '|| c_schema.sname);
1734: -- make a recursive call to gather_schema_stats
1735: GATHER_SCHEMA_STATS(schemaname=>c_schema.sname , estimate_percent=>estimate_percent , degree=>degree , internal_flag=>internal_flag ,
1736: --Errors=> Errors ,-- commented for error handling
1737: request_id=>request_id , hmode=>stathist , OPTIONS=>OPTIONS , modpercent=>modpercent , invalidate=> invalidate );

Line 1987: --dbms_output.put_line('SINGLE:'||method||'granularity='||granularity);

1983: method := 'FOR ALL COLUMNS SIZE 1' ;
1984: END IF;
1985: IF (method = 'FOR ALL COLUMNS SIZE 1') THEN
1986: BEGIN
1987: --dbms_output.put_line('SINGLE:'||method||'granularity='||granularity);
1988: FND_STATS.GATHER_TABLE_STATS_PVT(ownname => ownname, tabname => tabname,
1989: partname => partname, method_opt => method, estimate_percent => NVL(adj_percent,10), degree => degree_parallel,
1990: CASCADE => CASCADE, granularity => granularity, invalidate=> invalidate );
1991: EXCEPTION

Line 1993: -- dbms_output.put_line('about to raise'||sqlcode||' --- '||sqlerrm);

1989: partname => partname, method_opt => method, estimate_percent => NVL(adj_percent,10), degree => degree_parallel,
1990: CASCADE => CASCADE, granularity => granularity, invalidate=> invalidate );
1991: EXCEPTION
1992: WHEN OTHERS THEN
1993: -- dbms_output.put_line('about to raise'||sqlcode||' --- '||sqlerrm);
1994: -- Error code for external table error is ora-20000 which is the same as the code
1995: -- for exist_insufficient error. Because of that, we have to resort to the following
1996: -- if check on the error message.
1997: IF(SUBSTR(sqlerrm,instr(sqlerrm,',')+2)= 'sampling on external table is not supported') THEN

Line 2005: -- dbms_output.put_line('FOR ALL COLUMNS SIZE 1 '||method);

2001: END IF;
2002: END;
2003: ELSE -- call it with histogram cols.
2004: BEGIN
2005: -- dbms_output.put_line('FOR ALL COLUMNS SIZE 1 '||method);
2006: FND_STATS.GATHER_TABLE_STATS_PVT(ownname => ownname, tabname => tabname, partname => partname, method_opt => 'FOR ALL COLUMNS SIZE 1 '
2007: ||method, estimate_percent => NVL(adj_percent,10), degree => degree_parallel, CASCADE => CASCADE, granularity => granularity, invalidate=> invalidate );
2008: EXCEPTION
2009: WHEN OTHERS THEN

Line 2037: --dbms_output.put_line('SINGLE:'||method||'granularity='||granularity);

2033: -- FND_STATS.GATHER_TABLE_STATS twice, once for histogram
2034: -- and once for just the table stats.
2035: IF (method = 'FOR ALL COLUMNS SIZE 1') THEN
2036: BEGIN
2037: --dbms_output.put_line('SINGLE:'||method||'granularity='||granularity);
2038: FND_STATS.GATHER_TABLE_STATS_PVT(ownname => ownname, tabname => tabname,
2039: partname => partname, method_opt => method, estimate_percent => NVL(adj_percent,10), degree => degree_parallel,
2040: CASCADE => CASCADE, granularity => granularity, invalidate=> invalidate );
2041: EXCEPTION

Line 2047: --dbms_output.put_line('DOUBLE 1:'||method||'granularity='||granularity);

2043: raise;
2044: END;
2045: ELSE -- call it twice
2046: BEGIN
2047: --dbms_output.put_line('DOUBLE 1:'||method||'granularity='||granularity);
2048: FND_STATS.GATHER_TABLE_STATS_PVT(ownname => ownname, tabname => tabname,
2049: partname => partname, method_opt => 'FOR ALL COLUMNS SIZE 1', estimate_percent => NVL(adj_percent,10),
2050: degree => degree_parallel, CASCADE => CASCADE, granularity => granularity, invalidate=> invalidate );
2051: EXCEPTION

Line 2056: --dbms_output.put_line('DOUBLE 2:'||method||'granularity='||granularity);

2052: WHEN OTHERS THEN
2053: raise;
2054: END;
2055: BEGIN
2056: --dbms_output.put_line('DOUBLE 2:'||method||'granularity='||granularity);
2057: FND_STATS.GATHER_TABLE_STATS_PVT(ownname => ownname, tabname => tabname,
2058: partname => partname, method_opt => method, estimate_percent => NVL(adj_percent,10), degree => degree_parallel,
2059: CASCADE => FALSE, granularity => granularity, invalidate=> invalidate );
2060: EXCEPTION

Line 2273: --dbms_output.put_line('appl_id = '||t_rec.application_id||',table='||t_rec.table_name);

2269: -- get the tables for the given schema
2270: FOR t_rec IN tab_cursor(ownname)
2271: LOOP
2272: -- Insert/update the fnd_stats_hist table
2273: --dbms_output.put_line('appl_id = '||t_rec.application_id||',table='||t_rec.table_name);
2274: IF(upper(stathist) <> 'NONE') THEN
2275: BEGIN
2276: FND_STATS.UPDATE_HIST(schemaname=>ownname, objectname=>ownname, objecttype=>'HIST', partname=>NULL, columntablename=>NULL, degree=>degree_parallel, upd_ins_flag=>'S' );
2277: END;

Line 2294: --dbms_output.put_line(' method = '|| method);

2290: ||' SIZE '
2291: || c_rec.hsize;
2292: END LOOP ;
2293: /* c_rec */
2294: --dbms_output.put_line(' method = '|| method);
2295: BEGIN
2296: FND_STATS.GATHER_TABLE_STATS_PVT ( ownname => ownname, tabname => t_rec.table_name, estimate_percent => NVL(percent,10), method_opt => method, degree => degree_parallel, CASCADE => FALSE, invalidate => invalidate );
2297: EXCEPTION
2298: WHEN OTHERS THEN

Line 2314: --dbms_output.put_line('start of schema = '|| s_rec.sname);

2310: ELSE
2311: /* ownname = 'ALL' */
2312: FOR s_rec IN schema_cur
2313: LOOP
2314: --dbms_output.put_line('start of schema = '|| s_rec.sname);
2315: -- get the tables for the given schema
2316: FOR t_rec IN tab_cursor(s_rec.sname)
2317: LOOP
2318: -- Insert/update the fnd_stat_hist table

Line 2319: --dbms_output.put_line('appl_id = '||t_rec.application_id||',table='||t_rec.table_name);

2315: -- get the tables for the given schema
2316: FOR t_rec IN tab_cursor(s_rec.sname)
2317: LOOP
2318: -- Insert/update the fnd_stat_hist table
2319: --dbms_output.put_line('appl_id = '||t_rec.application_id||',table='||t_rec.table_name);
2320: IF(upper(stathist) <> 'NONE') THEN
2321: BEGIN
2322: FND_STATS.UPDATE_HIST(schemaname=>s_rec.sname, objectname=>s_rec.sname, objecttype=>'HIST', partname=>NULL, columntablename=>NULL, degree=>degree_parallel, upd_ins_flag=>'S' );
2323: END;

Line 2340: --dbms_output.put_line(' method = '|| method);

2336: ||' SIZE '
2337: || c_rec.hsize;
2338: END LOOP ;
2339: /* c_rec */
2340: --dbms_output.put_line(' method = '|| method);
2341: BEGIN
2342: FND_STATS.GATHER_TABLE_STATS_PVT ( ownname => s_rec.sname,
2343: tabname => t_rec.table_name, estimate_percent => NVL(percent,10), method_opt => method,
2344: degree => degree_parallel, CASCADE => FALSE, invalidate => invalidate );

Line 2964: dbms_output.put_line('Table-Name Column-Name Histogram Tot-Count Max-Count');

2960: mytablelist := REPLACE(tablelist,' ','');
2961: IF (percent < 0 OR percent > 100) THEN
2962: raise_application_error(-20001,'percent must be between 0 and 100');
2963: END IF;
2964: dbms_output.put_line('Table-Name Column-Name Histogram Tot-Count Max-Count');
2965: dbms_output.put_line('==========================================================================================================');
2966: WHILE (instr(mytablelist,',') > 0)
2967: LOOP
2968: Table_List(table_counter) := SUBSTR(mytablelist,1,instr(mytablelist,',') - 1) ;

Line 2965: dbms_output.put_line('==========================================================================================================');

2961: IF (percent < 0 OR percent > 100) THEN
2962: raise_application_error(-20001,'percent must be between 0 and 100');
2963: END IF;
2964: dbms_output.put_line('Table-Name Column-Name Histogram Tot-Count Max-Count');
2965: dbms_output.put_line('==========================================================================================================');
2966: WHILE (instr(mytablelist,',') > 0)
2967: LOOP
2968: Table_List(table_counter) := SUBSTR(mytablelist,1,instr(mytablelist,',') - 1) ;
2969: Table_List(table_counter+1) := NULL;

Line 3020: dbms_output.put_line(rpad(upper(abs_tablename),40,' ')

3016: END;
3017: abs_tablename := c_rec.own
3018: ||'.'
3019: ||c_rec.tab;
3020: dbms_output.put_line(rpad(upper(abs_tablename),40,' ')
3021: ||rpad(c_rec.col,30,' ')
3022: || rpad(hist,10,' ')
3023: ||lpad(TO_CHAR(total_cnt),9,' ')
3024: ||lpad(TO_CHAR(max_cnt),9,' '));

Line 3369: dbms_output.put_line('===================================================================================================');

3365: FROM dba_tables
3366: WHERE table_name = tableName
3367: AND owner = schema;
3368:
3369: dbms_output.put_line('===================================================================================================');
3370: dbms_output.put_line(' Table '
3371: || tableName);
3372: dbms_output.put_line('===================================================================================================');
3373: dbms_output.put_line(rpad('last analyzed', 18, ' ')

Line 3370: dbms_output.put_line(' Table '

3366: WHERE table_name = tableName
3367: AND owner = schema;
3368:
3369: dbms_output.put_line('===================================================================================================');
3370: dbms_output.put_line(' Table '
3371: || tableName);
3372: dbms_output.put_line('===================================================================================================');
3373: dbms_output.put_line(rpad('last analyzed', 18, ' ')
3374: || rpad('sample_size', 12, ' ')

Line 3372: dbms_output.put_line('===================================================================================================');

3368:
3369: dbms_output.put_line('===================================================================================================');
3370: dbms_output.put_line(' Table '
3371: || tableName);
3372: dbms_output.put_line('===================================================================================================');
3373: dbms_output.put_line(rpad('last analyzed', 18, ' ')
3374: || rpad('sample_size', 12, ' ')
3375: ||rpad('num_rows', 20, ' ')
3376: ||rpad('blocks', 10, ' '));

Line 3373: dbms_output.put_line(rpad('last analyzed', 18, ' ')

3369: dbms_output.put_line('===================================================================================================');
3370: dbms_output.put_line(' Table '
3371: || tableName);
3372: dbms_output.put_line('===================================================================================================');
3373: dbms_output.put_line(rpad('last analyzed', 18, ' ')
3374: || rpad('sample_size', 12, ' ')
3375: ||rpad('num_rows', 20, ' ')
3376: ||rpad('blocks', 10, ' '));
3377: dbms_output.put_line(rpad(TO_CHAR(last_analyzed, 'MM-DD-YYYY hh24:mi'), 18, ' ')

Line 3377: dbms_output.put_line(rpad(TO_CHAR(last_analyzed, 'MM-DD-YYYY hh24:mi'), 18, ' ')

3373: dbms_output.put_line(rpad('last analyzed', 18, ' ')
3374: || rpad('sample_size', 12, ' ')
3375: ||rpad('num_rows', 20, ' ')
3376: ||rpad('blocks', 10, ' '));
3377: dbms_output.put_line(rpad(TO_CHAR(last_analyzed, 'MM-DD-YYYY hh24:mi'), 18, ' ')
3378: || rpad(sample_size, 12, ' ')
3379: || rpad(num_rows, 20, ' ')
3380: ||blocks);
3381: dbms_output.put_line(' ');

Line 3381: dbms_output.put_line(' ');

3377: dbms_output.put_line(rpad(TO_CHAR(last_analyzed, 'MM-DD-YYYY hh24:mi'), 18, ' ')
3378: || rpad(sample_size, 12, ' ')
3379: || rpad(num_rows, 20, ' ')
3380: ||blocks);
3381: dbms_output.put_line(' ');
3382: EXCEPTION
3383: WHEN no_data_found THEN
3384: dbms_output.put_line('=================================================================================================');
3385: dbms_output.put_line('Table not found; Owner: '

Line 3384: dbms_output.put_line('=================================================================================================');

3380: ||blocks);
3381: dbms_output.put_line(' ');
3382: EXCEPTION
3383: WHEN no_data_found THEN
3384: dbms_output.put_line('=================================================================================================');
3385: dbms_output.put_line('Table not found; Owner: '
3386: || schema
3387: ||', name: '
3388: || tableName);

Line 3385: dbms_output.put_line('Table not found; Owner: '

3381: dbms_output.put_line(' ');
3382: EXCEPTION
3383: WHEN no_data_found THEN
3384: dbms_output.put_line('=================================================================================================');
3385: dbms_output.put_line('Table not found; Owner: '
3386: || schema
3387: ||', name: '
3388: || tableName);
3389: dbms_output.put_line('=================================================================================================');

Line 3389: dbms_output.put_line('=================================================================================================');

3385: dbms_output.put_line('Table not found; Owner: '
3386: || schema
3387: ||', name: '
3388: || tableName);
3389: dbms_output.put_line('=================================================================================================');
3390: END table_stats;
3391: /************************************************************************/
3392: /* Procedure: index_stats */
3393: /* Desciption: Internal procedures used by verify_stats. Gets info about*/

Line 3440: dbms_output.put_line(val1

3436: val3:= rpad(distinct_keys, 9, ' ')
3437: || rpad(avg_leaf_blocks_per_key, 8, ' ');
3438: val4:= rpad(avg_data_blocks_per_key, 8, ' ')
3439: || rpad(clustering_factor, 9, ' ');
3440: dbms_output.put_line(val1
3441: || val2
3442: || val3
3443: || val4);
3444: END index_stats;

Line 3453: dbms_output.put_line('----------------------------------------------------------------------------------------------------');

3449: /************************************************************************/
3450: PROCEDURE histo_header
3451: IS
3452: BEGIN
3453: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3454: dbms_output.put_line(' Histogram Stats');
3455: dbms_output.put_line(rpad('Schema', 15, ' ')
3456: ||rpad('Table Name', 31, ' ')
3457: ||rpad('Status', 12, ' ')

Line 3454: dbms_output.put_line(' Histogram Stats');

3450: PROCEDURE histo_header
3451: IS
3452: BEGIN
3453: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3454: dbms_output.put_line(' Histogram Stats');
3455: dbms_output.put_line(rpad('Schema', 15, ' ')
3456: ||rpad('Table Name', 31, ' ')
3457: ||rpad('Status', 12, ' ')
3458: ||rpad('last analyzed', 18, ' ')

Line 3455: dbms_output.put_line(rpad('Schema', 15, ' ')

3451: IS
3452: BEGIN
3453: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3454: dbms_output.put_line(' Histogram Stats');
3455: dbms_output.put_line(rpad('Schema', 15, ' ')
3456: ||rpad('Table Name', 31, ' ')
3457: ||rpad('Status', 12, ' ')
3458: ||rpad('last analyzed', 18, ' ')
3459: || 'Column Name');

Line 3460: dbms_output.put_line('----------------------------------------------------------------------------------------------------');

3456: ||rpad('Table Name', 31, ' ')
3457: ||rpad('Status', 12, ' ')
3458: ||rpad('last analyzed', 18, ' ')
3459: || 'Column Name');
3460: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3461: END;
3462: /************************************************************************/
3463: /* Procedure: index_header */
3464: /* Desciption: Internal procedures used by verify_stats. Prints header */

Line 3482: dbms_output.put_line(val1

3478: val3 := rpad('DK', 9, ' ')
3479: || rpad('LB/key', 8, ' ');
3480: val4 := rpad('DB/key', 8, ' ')
3481: ||rpad('CF', 9, ' ');
3482: dbms_output.put_line(val1
3483: || val2
3484: || val3
3485: || val4);
3486: dbms_output.put_line('----------------------------------------------------------------------------------------------------');

Line 3486: dbms_output.put_line('----------------------------------------------------------------------------------------------------');

3482: dbms_output.put_line(val1
3483: || val2
3484: || val3
3485: || val4);
3486: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3487: END;
3488: /************************************************************************/
3489: /* Procedure: histo_stats */
3490: /* Desciption: Internal procedures used by verify_stats. Gets info about*/

Line 3523: dbms_output.put_line(rpad(schema, 15, ' ')

3519: last_analyzed := each_histo.last_analyzed;
3520: status := 'present';
3521: EXIT;
3522: END LOOP;
3523: dbms_output.put_line(rpad(schema, 15, ' ')
3524: || rpad(tableName, 31, ' ')
3525: || rpad(status, 12, ' ')
3526: || rpad(TO_CHAR(last_analyzed, 'DD-MM-YYYY hh24:mi'), 18, ' ')
3527: || columnName);

Line 3530: dbms_output.put_line('=================================================================================================');

3526: || rpad(TO_CHAR(last_analyzed, 'DD-MM-YYYY hh24:mi'), 18, ' ')
3527: || columnName);
3528: EXCEPTION
3529: WHEN no_data_found THEN
3530: dbms_output.put_line('=================================================================================================');
3531: dbms_output.put_line('Histogram not found; Owner: '
3532: || schema
3533: ||', name: '
3534: || tableName

Line 3531: dbms_output.put_line('Histogram not found; Owner: '

3527: || columnName);
3528: EXCEPTION
3529: WHEN no_data_found THEN
3530: dbms_output.put_line('=================================================================================================');
3531: dbms_output.put_line('Histogram not found; Owner: '
3532: || schema
3533: ||', name: '
3534: || tableName
3535: || ', column name: '

Line 3537: dbms_output.put_line('=================================================================================================');

3533: ||', name: '
3534: || tableName
3535: || ', column name: '
3536: || columnName);
3537: dbms_output.put_line('=================================================================================================');
3538: END histo_stats;
3539: /************************************************************************/
3540: /* Procedure: file_tail */
3541: /* Desciption: Internal procedures used by verify_stats. Prints legend */

Line 3547: dbms_output.put_line(' ');

3543: /************************************************************************/
3544: PROCEDURE file_tail
3545: IS
3546: BEGIN
3547: dbms_output.put_line(' ');
3548: dbms_output.put_line(' ');
3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');

Line 3548: dbms_output.put_line(' ');

3544: PROCEDURE file_tail
3545: IS
3546: BEGIN
3547: dbms_output.put_line(' ');
3548: dbms_output.put_line(' ');
3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');
3552: dbms_output.put_line('DB : Data Blocks');

Line 3549: dbms_output.put_line('Legend:');

3545: IS
3546: BEGIN
3547: dbms_output.put_line(' ');
3548: dbms_output.put_line(' ');
3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');
3552: dbms_output.put_line('DB : Data Blocks');
3553: dbms_output.put_line('CF : Clustering Factor');

Line 3550: dbms_output.put_line('LB : Leaf Blocks');

3546: BEGIN
3547: dbms_output.put_line(' ');
3548: dbms_output.put_line(' ');
3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');
3552: dbms_output.put_line('DB : Data Blocks');
3553: dbms_output.put_line('CF : Clustering Factor');
3554: END;

Line 3551: dbms_output.put_line('DK : Distinct Keys');

3547: dbms_output.put_line(' ');
3548: dbms_output.put_line(' ');
3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');
3552: dbms_output.put_line('DB : Data Blocks');
3553: dbms_output.put_line('CF : Clustering Factor');
3554: END;
3555: /************************************************************************/

Line 3552: dbms_output.put_line('DB : Data Blocks');

3548: dbms_output.put_line(' ');
3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');
3552: dbms_output.put_line('DB : Data Blocks');
3553: dbms_output.put_line('CF : Clustering Factor');
3554: END;
3555: /************************************************************************/
3556: /* Procedure: column_stats */

Line 3553: dbms_output.put_line('CF : Clustering Factor');

3549: dbms_output.put_line('Legend:');
3550: dbms_output.put_line('LB : Leaf Blocks');
3551: dbms_output.put_line('DK : Distinct Keys');
3552: dbms_output.put_line('DB : Data Blocks');
3553: dbms_output.put_line('CF : Clustering Factor');
3554: END;
3555: /************************************************************************/
3556: /* Procedure: column_stats */
3557: /* Desciption: Internal procedures used by verify_stats. Gets info about*/

Line 3573: dbms_output.put_line('----------------------------------------------------------------------------------------------------');

3569: val2 VARCHAR2(255);
3570: val3 VARCHAR2(255);
3571: BEGIN
3572: IF (first_col = true) THEN
3573: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3574: dbms_output.put_line(' Column Stats');
3575: val1 := rpad('Column name', 31, ' ')
3576: || rpad('sample_size', 12, ' ');
3577: val2 := rpad('num_distinct', 14, ' ')

Line 3574: dbms_output.put_line(' Column Stats');

3570: val3 VARCHAR2(255);
3571: BEGIN
3572: IF (first_col = true) THEN
3573: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3574: dbms_output.put_line(' Column Stats');
3575: val1 := rpad('Column name', 31, ' ')
3576: || rpad('sample_size', 12, ' ');
3577: val2 := rpad('num_distinct', 14, ' ')
3578: || rpad('num_nulls', 14, ' ');

Line 3581: dbms_output.put_line(val1

3577: val2 := rpad('num_distinct', 14, ' ')
3578: || rpad('num_nulls', 14, ' ');
3579: val3 := rpad('density', 12, ' ')
3580: || rpad('last analyzed', 18, ' ');
3581: dbms_output.put_line(val1
3582: ||val2
3583: ||val3);
3584: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3585: END IF;

Line 3584: dbms_output.put_line('----------------------------------------------------------------------------------------------------');

3580: || rpad('last analyzed', 18, ' ');
3581: dbms_output.put_line(val1
3582: ||val2
3583: ||val3);
3584: dbms_output.put_line('----------------------------------------------------------------------------------------------------');
3585: END IF;
3586: val1 := rpad(column_name, 31, ' ')
3587: || rpad(sample_size, 12, ' ');
3588: val2 := rpad(num_distinct, 14, ' ')

Line 3592: dbms_output.put_line(val1

3588: val2 := rpad(num_distinct, 14, ' ')
3589: || rpad(TRUNC(num_nulls), 14, ' ');
3590: val3 := rpad(TRUNC(density, 9), 12, ' ')
3591: || rpad(TO_CHAR(last_analyzed, 'MM-DD-YYYY hh24:mi'), 18, ' ');
3592: dbms_output.put_line(val1
3593: || val2
3594: || val3);
3595: END;
3596: /************************************************************************/

Line 3684: dbms_output.enable(1000000);

3680: first_index BOOLEAN;
3681: first_col BOOLEAN;
3682: verify_stats_exception EXCEPTION;
3683: BEGIN
3684: dbms_output.enable(1000000);
3685: -- read all input params into plsql vars
3686: MySchema := upper(schemaName);
3687: MyTableList := REPLACE(upper(TableList), ' ', '');
3688: -- clean up input data

Line 3705: dbms_output.put_line('MyTableList '

3701: IF operation = 'table' THEN
3702: -- initialize Table_list
3703: WHILE (instr(MyTableList,',') > 0)
3704: LOOP
3705: dbms_output.put_line('MyTableList '
3706: || mytableList);
3707: Table_Name(table_counter) := SUBSTR(mytablelist,1,instr(mytablelist,',') - 1) ;
3708: ownerIndex := instr(Table_Name(table_counter), '.');
3709: IF ownerIndex <> 0 THEN

Line 3785: dbms_output.put_line('verify_stats(schema_name varchar2 default null,

3781: END LOOP;
3782: file_tail();
3783: EXCEPTION
3784: WHEN verify_stats_exception THEN
3785: dbms_output.put_line('verify_stats(schema_name varchar2 default null,
3786: table_list varchar2 default null, days_old number default null,
3787: column_stats boolean defualt false)');
3788: END ;
3789: /* end of verify_stats*/

Line 3801: -- dbms_output.put_line('Database version is '||db_versn);

3797: FROM v$instance;
3798:
3799: -- Initialize cur_request_id
3800: cur_request_id:=GET_REQUEST_ID;
3801: -- dbms_output.put_line('Database version is '||db_versn);
3802: EXCEPTION
3803: WHEN OTHERS THEN
3804: db_versn:=81; -- Just in case, default it to 8i
3805: END FND_STATS;