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_STATS

Line 144: tmp_str:='BEGIN dbms_stats.ALTER_DATABASE_TAB_MONITORING(monitoring=>'

140: ) THEN
141: -- 8i does not have the ALTER_SCHEMA_TAB_MONITORING function,
142: -- therefore 9i specific function calls have to be dynamic sql.
143: IF schemaname ='ALL' THEN
144: tmp_str:='BEGIN dbms_stats.ALTER_DATABASE_TAB_MONITORING(monitoring=>'
145: ||modbool
146: ||',sysobjs=>FALSE); END;';
147: EXECUTE IMMEDIATE tmp_str;
148: ELSE

Line 149: tmp_str:='BEGIN dbms_stats.ALTER_SCHEMA_TAB_MONITORING(ownname=>:SCHEMANAME,monitoring=>'

145: ||modbool
146: ||',sysobjs=>FALSE); END;';
147: EXECUTE IMMEDIATE tmp_str;
148: ELSE
149: tmp_str:='BEGIN dbms_stats.ALTER_SCHEMA_TAB_MONITORING(ownname=>:SCHEMANAME,monitoring=>'
150: ||modbool
151: ||'); END;';
152: EXECUTE IMMEDIATE tmp_str USING schemaname;
153: END IF;

Line 261: DBMS_STATS.CREATE_STAT_TABLE(fnd_statown,fnd_stattab);

257: IF dummy1 ='Y' THEN
258: stat_tab_exist := true;
259: END IF;
260: IF stat_tab_exist = false THEN
261: DBMS_STATS.CREATE_STAT_TABLE(fnd_statown,fnd_stattab);
262: stat_tab_exist := true;
263: END IF;
264: EXCEPTION
265: WHEN OTHERS THEN

Line 280: DBMS_STATS.CREATE_STAT_TABLE(schemaname,tabname,tblspcname);

276: tblspcname IN VARCHAR2 DEFAULT NULL)
277: IS
278: PRAGMA AUTONOMOUS_TRANSACTION;
279: BEGIN
280: DBMS_STATS.CREATE_STAT_TABLE(schemaname,tabname,tblspcname);
281: EXCEPTION
282: WHEN OTHERS THEN
283: raise;
284: END;

Line 356: DBMS_STATS.EXPORT_SCHEMA_STATS(schemaname, fnd_stattab, statid, fnd_statown);

352: WHEN exist_insufficient THEN
353: NULL;
354: END;
355: IF (upper(schemaname) <> 'ALL') THEN
356: DBMS_STATS.EXPORT_SCHEMA_STATS(schemaname, fnd_stattab, statid, fnd_statown);
357: ELSE
358: FOR c_schema IN schema_cur
359: LOOP
360: DBMS_STATS.EXPORT_SCHEMA_STATS(c_schema.sname, fnd_stattab, statid, fnd_statown);

Line 360: DBMS_STATS.EXPORT_SCHEMA_STATS(c_schema.sname, fnd_stattab, statid, fnd_statown);

356: DBMS_STATS.EXPORT_SCHEMA_STATS(schemaname, fnd_stattab, statid, fnd_statown);
357: ELSE
358: FOR c_schema IN schema_cur
359: LOOP
360: DBMS_STATS.EXPORT_SCHEMA_STATS(c_schema.sname, fnd_stattab, statid, fnd_statown);
361: END LOOP;
362: /* schema_cur */
363: END IF;
364: END;

Line 423: DBMS_STATS.EXPORT_TABLE_STATS(schemaname, tabname, partname, fnd_stattab, statid, CASCADE, fnd_statown) ;

419: EXCEPTION
420: WHEN exist_insufficient THEN
421: NULL;
422: END;
423: DBMS_STATS.EXPORT_TABLE_STATS(schemaname, tabname, partname, fnd_stattab, statid, CASCADE, fnd_statown) ;
424: END;
425: /* BACKUP_TABLE_STATS() */
426: /************************************************************************/
427: /* Procedure: RESTORE_SCHEMA_STATS */

Line 437: DBMS_STATS.IMPORT_SCHEMA_STATS(schemaname, fnd_stattab, statid, fnd_statown);

433: statid IN VARCHAR2 DEFAULT NULL)
434: IS
435: BEGIN
436: IF (upper(schemaname) <> 'ALL') THEN
437: DBMS_STATS.IMPORT_SCHEMA_STATS(schemaname, fnd_stattab, statid, fnd_statown);
438: ELSE
439: FOR c_schema IN schema_cur
440: LOOP
441: DBMS_STATS.IMPORT_SCHEMA_STATS(c_schema.sname, fnd_stattab, statid, fnd_statown);

Line 441: DBMS_STATS.IMPORT_SCHEMA_STATS(c_schema.sname, fnd_stattab, statid, fnd_statown);

437: DBMS_STATS.IMPORT_SCHEMA_STATS(schemaname, fnd_stattab, statid, fnd_statown);
438: ELSE
439: FOR c_schema IN schema_cur
440: LOOP
441: DBMS_STATS.IMPORT_SCHEMA_STATS(c_schema.sname, fnd_stattab, statid, fnd_statown);
442: END LOOP;
443: /* schema_cur */
444: END IF;
445: END;

Line 506: DBMS_STATS.IMPORT_TABLE_STATS(ownname,tabname,partname, fnd_stattab,statid,CASCADE,fnd_statown);

502: partname IN VARCHAR2 DEFAULT NULL,
503: CASCADE IN BOOLEAN DEFAULT true )
504: IS
505: BEGIN
506: DBMS_STATS.IMPORT_TABLE_STATS(ownname,tabname,partname, fnd_stattab,statid,CASCADE,fnd_statown);
507: END;
508: /* RESTORE_TABLE_STATS */
509: /************************************************************************/
510: /* Procedure: RESTORE_INDEX_STATS */

Line 520: DBMS_STATS.IMPORT_INDEX_STATS(ownname,indname,partname,fnd_stattab, statid,fnd_statown) ;

516: statid IN VARCHAR2 DEFAULT NULL,
517: partname IN VARCHAR2 DEFAULT NULL)
518: IS
519: BEGIN
520: DBMS_STATS.IMPORT_INDEX_STATS(ownname,indname,partname,fnd_stattab, statid,fnd_statown) ;
521: END;
522: /* RESTORE_INDEX_STATS */
523: /************************************************************************/
524: /* Procedure: RESTORE_COLUMN_STATS */

Line 535: DBMS_STATS.IMPORT_COLUMN_STATS(ownname, tabname, colname, partname, fnd_stattab, statid, fnd_statown) ;

531: partname IN VARCHAR2 DEFAULT NULL,
532: statid IN VARCHAR2 DEFAULT NULL)
533: IS
534: BEGIN
535: DBMS_STATS.IMPORT_COLUMN_STATS(ownname, tabname, colname, partname, fnd_stattab, statid, fnd_statown) ;
536: END;
537: /* RESTORE_COLUMN_STATS() */
538: /************************************************************************/
539: /* Procedure: RESTORE_COLUMN_STATS */

Line 575: DBMS_STATS.IMPORT_COLUMN_STATS(c_rec.ownname,c_rec.tabname, c_rec.colname,c_rec.partname, fnd_stattab,statid,fnd_statown);

571:
572: BEGIN
573: FOR c_rec IN col_cursor
574: LOOP
575: DBMS_STATS.IMPORT_COLUMN_STATS(c_rec.ownname,c_rec.tabname, c_rec.colname,c_rec.partname, fnd_stattab,statid,fnd_statown);
576: END LOOP;
577: END;
578: /* RESTORE_COLUMN_STATS */
579: /************************************************************************/

Line 591: /* Desciption: Private package that now calls dbms_stats dynamically */

587: FND_FILE.put_line(FND_FILE.log,p_str);
588: END dlog;
589: /************************************************************************/
590: /* Procedure: GATHER_TABLE_STATS_PVT */
591: /* Desciption: Private package that now calls dbms_stats dynamically */
592: /* depending upon the version of the database. For 8i, */
593: /* dbms_stats is called as before, for higher versions, it */
594: /* is called with the no_invalidate flag. */
595: /************************************************************************/

Line 593: /* dbms_stats is called as before, for higher versions, it */

589: /************************************************************************/
590: /* Procedure: GATHER_TABLE_STATS_PVT */
591: /* Desciption: Private package that now calls dbms_stats dynamically */
592: /* depending upon the version of the database. For 8i, */
593: /* dbms_stats is called as before, for higher versions, it */
594: /* is called with the no_invalidate flag. */
595: /************************************************************************/
596: PROCEDURE GATHER_TABLE_STATS_PVT(ownname IN VARCHAR2,
597: tabname IN VARCHAR2,

Line 621: -- and no_inv is true, calls dbms_stats statically, else ...

617: ELSE
618: no_invalidate:='Y';
619: END IF;
620: -- If db version is < 9iR2, OR it is 92 and no_inv is false OR it is > 92
621: -- and no_inv is true, calls dbms_stats statically, else ...
622: IF ( (db_versn <= 92) OR
623: (
624: db_versn=92 AND no_invalidate='N'
625: )

Line 632: DBMS_STATS.GATHER_TABLE_STATS( ownname => ownname ,

628: db_versn>=100 AND no_invalidate='Y'
629: )
630: ) THEN
631: -- changes done for bug 11835452
632: DBMS_STATS.GATHER_TABLE_STATS( ownname => ownname ,
633: tabname => tabname , estimate_percent => nvl(estimate_percent,def_estimate_pcnt) , degree => degree ,
634: method_opt => method_opt , block_sample => FALSE , partname => partname ,
635: CASCADE => CASCADE , granularity => granularity , stattab => stattab , statown => statown );
636: ELSE

Line 637: l_tmp_str:= 'BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname => :ownname ,'

633: tabname => tabname , estimate_percent => nvl(estimate_percent,def_estimate_pcnt) , degree => degree ,
634: method_opt => method_opt , block_sample => FALSE , partname => partname ,
635: CASCADE => CASCADE , granularity => granularity , stattab => stattab , statown => statown );
636: ELSE
637: l_tmp_str:= 'BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname => :ownname ,'
638: || ' tabname => :tabname ,'
639: || ' estimate_percent => :estimate_percent ,'
640: || ' degree => :degree ,'
641: || ' method_opt => :method_opt ,'

Line 672: /* Desciption: Private package that now calls dbms_stats dynamically */

668: END;
669: /* GATHER_TABLE_STATS_PVT */
670: /************************************************************************/
671: /* Procedure: GATHER_INDEX_STATS_PVT */
672: /* Desciption: Private package that now calls dbms_stats dynamically */
673: /* depending upon the version of the database. For 8i, */
674: /* dbms_stats is called as before, for higher versions, it */
675: /* is called with the invalidate flag. */
676: /************************************************************************/

Line 674: /* dbms_stats is called as before, for higher versions, it */

670: /************************************************************************/
671: /* Procedure: GATHER_INDEX_STATS_PVT */
672: /* Desciption: Private package that now calls dbms_stats dynamically */
673: /* depending upon the version of the database. For 8i, */
674: /* dbms_stats is called as before, for higher versions, it */
675: /* is called with the invalidate flag. */
676: /************************************************************************/
677: PROCEDURE GATHER_INDEX_STATS_PVT(ownname IN VARCHAR2,
678: indname IN VARCHAR2,

Line 696: -- If db version is < 9iR2, calls dbms_stats statically, else ...

692: no_invalidate:='N';
693: ELSE
694: no_invalidate:='Y';
695: END IF;
696: -- If db version is < 9iR2, calls dbms_stats statically, else ...
697: IF (db_versn <= 92) THEN
698: -- changes done for bug 11835452
699: DBMS_STATS.GATHER_INDEX_STATS( ownname => ownname , indname => indname , estimate_percent => nvl(estimate_percent,def_estimate_pcnt) , partname => partname );
700: ELSE

Line 699: DBMS_STATS.GATHER_INDEX_STATS( ownname => ownname , indname => indname , estimate_percent => nvl(estimate_percent,def_estimate_pcnt) , partname => partname );

695: END IF;
696: -- If db version is < 9iR2, calls dbms_stats statically, else ...
697: IF (db_versn <= 92) THEN
698: -- changes done for bug 11835452
699: DBMS_STATS.GATHER_INDEX_STATS( ownname => ownname , indname => indname , estimate_percent => nvl(estimate_percent,def_estimate_pcnt) , partname => partname );
700: ELSE
701: l_tmp_str:= 'BEGIN DBMS_STATS.GATHER_INDEX_STATS( ownname => :ownname ,'
702: || ' indname => :indname ,'
703: || ' estimate_percent => :estimate_percent ,'

Line 701: l_tmp_str:= 'BEGIN DBMS_STATS.GATHER_INDEX_STATS( ownname => :ownname ,'

697: IF (db_versn <= 92) THEN
698: -- changes done for bug 11835452
699: DBMS_STATS.GATHER_INDEX_STATS( ownname => ownname , indname => indname , estimate_percent => nvl(estimate_percent,def_estimate_pcnt) , partname => partname );
700: ELSE
701: l_tmp_str:= 'BEGIN DBMS_STATS.GATHER_INDEX_STATS( ownname => :ownname ,'
702: || ' indname => :indname ,'
703: || ' estimate_percent => :estimate_percent ,'
704: || ' degree => :degree ,'
705: || ' partname => :partname ,';

Line 827: /* insead of dbms_stats.gather_schema_stats */

823: /* Procedure: GATHER_SCHEMA_STATS_SQLPLUS */
824: /* Desciption: Gather schema statistics. This is called by concurrent */
825: /* manager version of GATHER_SCHEMA_STATS. */
826: /* Notes: internal_flag='INTERNAL' will call dbms_utility.analyze_schema*/
827: /* insead of dbms_stats.gather_schema_stats */
828: /* internal_flag='NOBACKUP' will bypass dbms_stats.export_schema_stats */
829: /************************************************************************/
830: PROCEDURE GATHER_SCHEMA_STATS_SQLPLUS(schemaname IN VARCHAR2,
831: estimate_percent IN NUMBER ,

Line 828: /* internal_flag='NOBACKUP' will bypass dbms_stats.export_schema_stats */

824: /* Desciption: Gather schema statistics. This is called by concurrent */
825: /* manager version of GATHER_SCHEMA_STATS. */
826: /* Notes: internal_flag='INTERNAL' will call dbms_utility.analyze_schema*/
827: /* insead of dbms_stats.gather_schema_stats */
828: /* internal_flag='NOBACKUP' will bypass dbms_stats.export_schema_stats */
829: /************************************************************************/
830: PROCEDURE GATHER_SCHEMA_STATS_SQLPLUS(schemaname IN VARCHAR2,
831: estimate_percent IN NUMBER ,
832: degree IN NUMBER ,

Line 1166: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;

1162: -- if db_versn > 81 then call flush, else use whatever
1163: -- data is available in dtm
1164: IF db_versn > 81 THEN
1165: IF(fm_first_flag) THEN
1166: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;
1167: fm_first_flag := false;
1168: END IF;
1169: END IF;
1170: -- gather stats for stale tables/partitions. Potentially, there

Line 1457: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;

1453: -- if db_versn > 81 then call flush, else use whatever
1454: -- data is available in dtm
1455: IF db_versn > 81 THEN
1456: IF(fm_first_flag) THEN
1457: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;
1458: fm_first_flag := false;
1459: END IF;
1460: END IF;
1461: -- gather stats for stale tables/partitions. Potentially, there

Line 1713: dlog('Please use DBMS_STATS package to gather stats on SYS objects.');

1709: /* schema_cur */
1710: END IF;
1711: ELSE -- schema is SYS, print message in log.
1712: dlog('Gathering statistics on the SYS schema using FND_STATS is not allowed.');
1713: dlog('Please use DBMS_STATS package to gather stats on SYS objects.');
1714: END IF; -- end of schema<> SYS
1715: END;
1716: /* GATHER_SCHEMA_STATS_SQLPLUS */
1717: /************************************************************************/

Line 1722: /* insead of dbms_stats.gather_schema_stats */

1718: /* Procedure: GATHER_SCHEMA_STATS */
1719: /* Desciption: Gather schema statistics. This is called by concurrent */
1720: /* manager version of GATHER_SCHEMA_STATS. */
1721: /* Notes: internal_flag='INTERNAL' will call dbms_utility.analyze_schema*/
1722: /* insead of dbms_stats.gather_schema_stats */
1723: /* internal_flag='NOBACKUP' will bypass dbms_stats.export_schema_stats */
1724: /************************************************************************/
1725: PROCEDURE GATHER_SCHEMA_STATS(schemaname IN VARCHAR2,
1726: estimate_percent IN NUMBER ,

Line 1723: /* internal_flag='NOBACKUP' will bypass dbms_stats.export_schema_stats */

1719: /* Desciption: Gather schema statistics. This is called by concurrent */
1720: /* manager version of GATHER_SCHEMA_STATS. */
1721: /* Notes: internal_flag='INTERNAL' will call dbms_utility.analyze_schema*/
1722: /* insead of dbms_stats.gather_schema_stats */
1723: /* internal_flag='NOBACKUP' will bypass dbms_stats.export_schema_stats */
1724: /************************************************************************/
1725: PROCEDURE GATHER_SCHEMA_STATS(schemaname IN VARCHAR2,
1726: estimate_percent IN NUMBER ,
1727: degree IN NUMBER ,

Line 2076: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;

2072: -- if db_versn > 81 then call flush, else use whatever
2073: -- data is available in dtm
2074: IF db_versn > 81 THEN
2075: IF(fm_first_flag) THEN
2076: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;
2077: fm_first_flag := false;
2078: END IF;
2079: END IF;
2080: -- gather stats for stale tables/partitions. Potentially, there

Line 2341: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;

2337: -- if db_versn > 81 then call flush, else use whatever
2338: -- data is available in dtm
2339: IF db_versn > 81 THEN
2340: IF(fm_first_flag) THEN
2341: EXECUTE IMMEDIATE 'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;' ;
2342: fm_first_flag := false;
2343: END IF;
2344: END IF;
2345: -- gather stats for stale tables/partitions. Potentially, there

Line 2564: dlog('Please use DBMS_STATS package to gather stats on SYS objects.');

2560: /* schema_cur */
2561: END IF;
2562: ELSE -- schema is SYS, print message in log.
2563: dlog('Gathering statistics on the SYS schema using FND_STATS is not allowed.');
2564: dlog('Please use DBMS_STATS package to gather stats on SYS objects.');
2565: END IF; -- end of schema<> SYS
2566: END;
2567: /* GATHER_SCHEMA_STATS */
2568: /************************************************************************/

Line 2632: DBMS_STATS.EXPORT_INDEX_STATS( ownname, indname, NULL, fnd_stattab, NULL, fnd_statown );

2628: EXCEPTION
2629: WHEN exist_insufficient THEN
2630: NULL;
2631: END;
2632: DBMS_STATS.EXPORT_INDEX_STATS( ownname, indname, NULL, fnd_stattab, NULL, fnd_statown );
2633: END IF;
2634: -- changes done for bug 11835452
2635: FND_STATS.GATHER_INDEX_STATS_PVT(ownname => ownname, indname => indname, partname => partname, estimate_percent => NVL(adj_percent,def_estimate_pcnt), degree=>degree_parallel, invalidate => invalidate ) ;
2636: -- End timestamp

Line 2811: DBMS_STATS.EXPORT_TABLE_STATS(ownname, tabname, partname, fnd_stattab,NULL,CASCADE,fnd_statown );

2807: EXCEPTION
2808: WHEN exist_insufficient THEN
2809: NULL;
2810: END;
2811: DBMS_STATS.EXPORT_TABLE_STATS(ownname, tabname, partname, fnd_stattab,NULL,CASCADE,fnd_statown );
2812: EXCEPTION
2813: WHEN OTHERS THEN
2814: raise;
2815: END;

Line 2938: -- Due to the limitations of in DBMS_STATS in 8i we need to call

2934: -- If no histogram cols then nullify method ;
2935: IF method = ' FOR COLUMNS ' THEN
2936: method := 'FOR ALL COLUMNS SIZE 1' ;
2937: END IF;
2938: -- Due to the limitations of in DBMS_STATS in 8i we need to call
2939: -- FND_STATS.GATHER_TABLE_STATS twice, once for histogram
2940: -- and once for just the table stats.
2941: IF (method = 'FOR ALL COLUMNS SIZE 1') THEN
2942: BEGIN

Line 3128: DBMS_STATS.EXPORT_COLUMN_STATS(list_ownname(i), t_rec.table_name, list_column_name(i), t_rec.partition, fnd_stattab, NULL, fnd_statown);

3124: EXCEPTION
3125: WHEN exist_insufficient THEN
3126: NULL;
3127: END;
3128: DBMS_STATS.EXPORT_COLUMN_STATS(list_ownname(i), t_rec.table_name, list_column_name(i), t_rec.partition, fnd_stattab, NULL, fnd_statown);
3129: END;
3130: END IF;
3131: -- Build up the method_opt variable
3132: IF (method <> ' FOR COLUMNS ') THEN

Line 3441: DBMS_STATS.EXPORT_COLUMN_STATS ( ownname, tabname, colname, partname, fnd_stattab, NULL, fnd_statown );

3437: EXCEPTION
3438: WHEN exist_insufficient THEN
3439: NULL;
3440: END;
3441: DBMS_STATS.EXPORT_COLUMN_STATS ( ownname, tabname, colname, partname, fnd_stattab, NULL, fnd_statown );
3442: END;
3443: END IF;
3444: -- Now gather statistics
3445: method := 'FOR COLUMNS SIZE '

Line 3474: DBMS_STATS.SET_TABLE_STATS(ownname, tabname, partname, NULL, NULL, numrows, numblks, avgrlen, NULL, NULL);

3470: partname IN VARCHAR2 DEFAULT NULL )
3471: IS
3472: -- PRAGMA AUTONOMOUS_TRANSACTION ;
3473: BEGIN
3474: DBMS_STATS.SET_TABLE_STATS(ownname, tabname, partname, NULL, NULL, numrows, numblks, avgrlen, NULL, NULL);
3475: END;
3476: /* SET_TABLE_STATS */
3477: /************************************************************************/
3478: /* Procedure: SET_INDEX_STATS */

Line 3508: DBMS_STATS.SET_INDEX_STATS(ownname, indname, partname, NULL, NULL, numrows, numlblks, numdist, avglblk, avgdblk, l_clstfct, indlevel, NULL, NULL);

3504:
3505: IF (l_iot = 'TRUE') THEN
3506: l_clstfct := 0;
3507: END IF;
3508: DBMS_STATS.SET_INDEX_STATS(ownname, indname, partname, NULL, NULL, numrows, numlblks, numdist, avglblk, avgdblk, l_clstfct, indlevel, NULL, NULL);
3509: EXCEPTION
3510: WHEN OTHERS THEN
3511: NULL;
3512: END;

Line 4668: l_cg_name := DBMS_STATS.create_extended_stats(ownname => owner,

4664: extntn :='(' || upper(colname1) || ',' || upper(colname2) || ',' || upper(colname3) || ',' || upper(colname4) ||')' ;
4665: Else
4666: extntn:='(' || upper(colname1) || ',' || upper(colname2) || ')';
4667: END IF ; */
4668: l_cg_name := DBMS_STATS.create_extended_stats(ownname => owner,
4669: tabname => tabname,
4670: extension => extntn);
4671: DBMS_OUTPUT.PUT_LINE(l_cg_name);
4672: EXCEPTION

Line 4692: DBMS_STATS.DROP_EXTENDED_STATS( OWNNAME => owner,

4688: (
4689: partition = upper(partname)
4690: OR partition IS NULL
4691: );
4692: DBMS_STATS.DROP_EXTENDED_STATS( OWNNAME => owner,
4693: TABNAME => tabname,
4694: EXTENSION => extntn);
4695:
4696: END;

Line 4914: def_estimate_pcnt := dbms_stats.auto_sample_size;

4910: -- changes done for bug 11835452
4911: IF db_versn < 111 then
4912: def_estimate_pcnt := 10;
4913: else
4914: def_estimate_pcnt := dbms_stats.auto_sample_size;
4915: end if;
4916:
4917: -- Initialize cur_request_id
4918: cur_request_id:=GET_REQUEST_ID;