-
Try to delete it manually:
spool delete_statistics_tables
select 'analyze table '||table_name||' delete statistics;'
from dba_tables
where owner='OWNER';
spool off
Run delete_statistics_tables
spool delete_statistics_indexes
select 'analyze index '||index_name||' delete statistics;'
from dba_indexes
where owner='OWNER';
spool off
Run delete statistics_indexes
Hope this will help you
Angel
-
Originally posted by PWC
For information :
Delete statistics don't work.
I'll try in few days to set the parameter enable_type_dep_selective in the init.ora when I could restart the DB.
Thx
You don't have to set it. Just run in SQL*Plus "alter session set "_enable_type_dep_selectivity" = true;" and then collect the statistics.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
I've try to set "enable_type_dep_selectivity" = true but nothing is different ....
Other idea ?
-
Originally posted by PWC
I've try to set "enable_type_dep_selectivity" = true but nothing is different ....
Other idea ?
Flush the shared pool.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
As Julian said in his earlier post. This parameter might help you or not, then unique workarround is to delete statistics and try again.
Angel
-
Why don't you try using dbms_stats.gather_schema_stats instead? Check if the gives the same errors.
Also, is optimizer_features_enable set properly?
[Edited by julian on 03-21-2002 at 05:46 AM]
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|