No question at this time
DBA Top 10
1 M. Cadot 20800
2 A. Kavsek 14900
3 M. Hidayathullah ... 10800
4 B. Vroman 7900
5 P. Wisse 5300
6 T. Boles 4200
7 J. Schnackenberg 3800
8 K. Van Nieuwenhov... 2100
9 G. Van Cauter 1600
10 A. Hudspith 1500
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48052
Total active users1733
Act. users last 24h10
Act. users last hour1
Registered user hits last week395
Registered user hits last month1204
Go up

fixed objects stats
Next thread: enq:tm contention
Prev thread: Querying with CONTAINS is giving error

Message Score Author Date
Hi Guys I am trying to gather fixed objects sta...... Tso P Mar 15, 2017, 08:31
https://www.google.fr/?q=DBMS_STATS+"Approximate...... Michel Cadot Mar 15, 2017, 08:42
Thanks Michel I will google again... ... Tso P Mar 15, 2017, 09:29
Hi Tso, please check below mos notes for these ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Mirza Hidayathullah Baig Mar 15, 2017, 10:35

Follow up by mail Click here


Subject: fixed objects stats
Author: Tso P, South Africa
Date: Mar 15, 2017, 08:31, 216 days ago
Os info: rhel5
Oracle info: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Message: Hi Guys

I am trying to gather fixed objects stats on my database but I get an error:

ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-01455: converting column overflows
integer datatype
ORA-06512: at "SYS.DBMS_STATS", line 18566
ORA-06512: at "SYS.DBMS_STATS", line 19009
ORA-06512: at "SYS.DBMS_STATS", line 19552
ORA-06512: at line 2

Yet, I am not using ASM. I do have an ASM instance running but I am not using it with this instance...

What might be an issue here...?

Please help !!!

Thanks in adavance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: fixed objects stats
Author: Michel Cadot, France
Date: Mar 15, 2017, 08:42, 216 days ago
Message:
https://www.google.fr/?q=DBMS_STATS+"Approximate+NDV+failed"

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: fixed objects stats
Author: Tso P, South Africa
Date: Mar 15, 2017, 09:29, 216 days ago
Message: Thanks Michel

I will google again...

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: fixed objects stats
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Mar 15, 2017, 10:35, 216 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

please check below mos notes for these errors and there are chances of bug

OERR: ORA-1455 "converting column overflows integer datatype" Reference Note (Doc ID 18858.1)

Bug 13037524 - ora-1455 querying x$kfkid / ORA-20011 from GATHER_FIXED_OBJECTS_STATS (Doc ID 13037524.8)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here